Backups

When sp_depends fails

sp_depends may not always return accurate information

Delete files older than n-days via T-SQL

Delete files on a fileshare leaving behind files not older than n-days.

Moving System Databases

Verify Last successful CHECKDB on all databases

Creates a resultset that expresses the last time a successful CHECKDB was performed on every database in the instance.

Does not work on SQL 2000.

SQL Server Scalabilty - An Introduction

A brief introduction into the world of scalability, presenting at a high-level the various options

SQL Server DBA Fights a Demon

An interesting tale of David Bird's fight with tempdb.

Compare Different tables from 2 Databases

List tables that have different tables and column

Change SQL Server stored procedures with batch editing

Learn how to change a group of SQL Server stored procedures (SPs) that perform tasks in your databases. Edit SQL Server SPs at one time with these steps.

Determining SQL Server database storage requirements

Determine accurate storage requirements for a SQL Server database with these methods. Calculate how to set storage requirements for a database application.