This article by David Rabb from the June 2001 issue of VBPJ shows you how to build a tool that will build a select, insert, update, and delete stored procedure for each table in a database. It's a great example of how to use DMO and a great tool as well!
Answers to the SQL quiz that Steve Jones used to give to prospective employees.
This article examines the hiring practices of Steve Jones and provides some ideas for how to choose between candidates.
The fifth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with STUFF.
This article describes the ActivityTrace7 job that puts blocking and performance data into a trace file for further analysis.
Like most SQL Server service packs, the latest service pack by Microsoft for SQL Server 2000 is simple to install. Don't let this deceive you though. A step mishap can leave your system in an inconsistent state and cause major problems when users begin to hit it again. This article will provide you a step-by-step guide to installing Service Pack 1 for SQL Server 2000.
Steve Jones provides some notes from the field after installing SP1 on a personal edition of SQL Server
By Steve Jones
Today’s coping tip is to get outside and notice how the weather feels. This...
By SQLBalls
Hello Dear Reader! What an incredible week we had. I started off traveling on...
By Steve Jones
It’s been a good week at SQL Bits. This is my favorite conference, and...
Hi all, I am running the following query in SQL, trying to export some...
Please suggest practice on SQL Server RLS On the database level, defined users with...
Hello, I have 3 SSIS packages having connection manager defined with a userA. These...
Ask SSC