So You're the New DBA

In a new DBA role, Daryl Quadros brings us a list of the first tasks you should perform.

Locate specific columns used in procs

SP to find object and line number that references column(s) of interest.

Featured Blog: CHECKDB From Every Angle: Can CHECKDB repair everything?

What can't be fixed by CHECKDB? Read this great entry from the former SQL Server Storage Engine lead.

SMS Script

This script will modify INI file on destops through SMS push to point server connection from A to B.

Distributing SQL Server Databases

Longtime SQL Server author Raj Vasant brings us a technique for delivering databases along with an application. As more and more systems take advantage of SQL Server or Express, this is a technique that can come in very handy.

Check owners, collations and backups

A script to check the owners, collations and backups on the server.

2005 unused indexes

Shows unused indexes compared to nr of modifications

You need to perform a restore operation as...

usp_ShowOrphanUsers - SQL 2k

Check Orphaned logins ie, not associated with any database on the current instance.

Deadlock Notifications in SQL Server 2005

Deadlocks do not occur too often, but when they do, it can be a time consuming and frustrating endeavor to track them down. In SQL Server 2000, you could alter the message to ensure these were written to the error log and track them down quickly. In SQL Server 2005, it is a little more tricky, but new author Patrick Leblanc brings us a technique for sending out a notification.