When performing a security audit of your SQL...

You are about to migrate your SQL Server...

Create Maintenance Job with a Click without using a Wizard

Don't like the blackbox approach of maintenance plans? Like the maintenance plans but need a tweak to suit your needs? New author Robin Back has put together a monster script to allow you to build your own quickly and easily.

You are installing SQL Server 2000 on a...

Script your Data in T-SQL format

SQL Scripter is a tool for SQL Server 7.0/2000 database administrators and developers to script data in a valid T-SQL format which can be executed in Query Analyzer. All types are supported (INSERT, UPDATE, DELETE). It's free in the moment. (Not Reviewed)

Monitoring Disk Space and Sending Alerts with TSQL

Haidong discusses the importance of monitoring disk usage over a period of time and has some great TSQL code to help you do the monitoring!

You recently became a SQL Server administrator at...

You have a Windows 2000 Advanced Edition Server...

What does the 10 represent in the following...

Worst Practice - Bad Connection Strings and Bad Info in Sysprocesses

Andy returns to the Worst Practice series this week with a short article looking at how connection strings in applications affect what you see in sysprocesses. Perhaps less controversial (in our opinion) that some of the other worst practices, this is something easy to fix and definitely worth fixing! Read the article and post a comment - explore other points of view! Readers posting a comment will be entered in a drawing for a copy of the SQL Server 2000 Resource Kit.