usp_ShowOrphanUsers - SQL 2k5

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

Moving Databases

SQL Server trainer and longtime expert, Andy Warren brings us a great article on one basic skill that every DBA should know.

Statistics

SQL agent question

SQL Server Script to Create Windows Directories

An interesting script to handle file tasks from within SQL Server.

Analyze and Correct a large SQL Server MSDB Database

It has come to my attention that some of our MSDB databases are getting what I would consider large for a system database. Some of our MSDB databases are over 2 GB which is a little perplexing because I know we do not create any user defined objects in that database. Can you give me some insight into the issue? I know we have this issue with both SQL Server 2000 and 2005 instances.

DBA Morning Check List

This article helps the DBA find and fix issues quickly by creating a DBA Morning Checklist.

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.