DatabaseJournal.com Staff

amar_padhi@hotmail.com Article Series Current Articles:

gregalarsen@msn.com Gregory A. Larsen is a DBA at Washington State Department of Health (DOH). Greg is responsible for maintaining SQL Server and other database management software. Greg works with customers and developers to design and implement database changes, and solve database/application related problems. Greg builds homegrown solutions to simplify and streamline common database management tasks, […]

Being a long time reader, I’m proud to join the crowd of technology gurus gathered here. I have a fair share of Microsoft exams behind me, a couple of acronyms after my name – MCSE, MCSD, and MCT, decent familiarity with majority of MS BackOffice products (SMS, SQL, Exchange, IIS), programming and scripting languages (VB, […]

by Insanely Great Introduction With the combination of PHP and MySQL becoming one of the defacto standards for Web development, the need for a good front end for MySQL is increasing. For many, the task of creating and manipulating MySQL databases is a daunting task. It is often difficult to master the complex commands required […]

Amar Kumar Padhi, amar_padhi@hotmail.com Prior to Oracle 8i releases, the IN OUT parameters in PL/SQL routines were passed using the copy-in and copy-out semantics (call by value). For example: create or replace procedure cpy_chk (pi_val in varchar2, po_dat out date, pio_status in out varchar2) is begin po_dat := sysdate; pio_status := pio_status || ‘amar is […]

From the publisher:Book overview This book assumes that the reader has read Beginning PHP 4 and he does not have much of a clue about databases (almost Zero Database Quotient). So this book should be able to teach the reader how to build robust database driven PHP web applications. Further, this book is kind of […]

CPA, CITP, CMA, CIA, MCSE, MCDBA Microsoft SQL Server MVP Bill has been working with computers since before becoming a “big eight” CPA, after which he carried his growing information systems knowledge into management accounting, internal auditing, and various capacities of controllership. Bill entered the world of databases and financial systems when he became a […]

[From java.sun.com] With SQL Developer, Solyp Informatik GmbH of Nuremberg/Germany is offering a powerful tool for developers to interact with nearly all standardized databank systems. Whether your enterprise uses DB2 or Access under Windows, Oracle or Sybase under Solaris or MySQL under Linux, an often cumbersome and error-prone frontend change is now no longer necessary […]

chigrik@mssqlcity.com I am the owner of MSSQLCity.Com – a site dedicated to providing useful information for IT professionals using Microsoft SQL Server. This site contains SQL Server Articles, FAQs, Scripts, Tips and Test Exams. Current Certifications: Brainbench: Master MS SQL Server 2000 Programming Master MS SQL Server 7 Administration Master MS SQL Server 7 Programming […]

This script from Eli Leiba will attempt to shrink the log file to a specific size. Create PROCEDURE Sp_ShrinkLog (@LogF varchar(200), @NSize INT) AS –BY ELI L. — DATE 08/2002 — DESC: attempt to shrink the log file to a specific size — gets logical file name and attempt size SET NOCOUNT ON DECLARE @MaxMin […]

To prevent databases from running into serious problems, DBAs typically setup alerts for specific errors; for example, the error “table corrupt” could lead to “database corrupted”. The problem is there are a large number of alerts for the “table corrupt” error message (about 40), and while you probably don’t want to set all 40 of […]

Unfortunately, there is no built-in support for arrays in SQL Server’s T-SQL. SQL Server 2000 did add some new datatypes like sql_variant, bigint, etc., but no support for the much needed arrays. There are some situations that require the ability to pass a list of values to a stored procedure. Think about a web page […]