usp_SecurCreation - SQL 2k

Creates statements for securables creation.

usp_ActiveProcesses - SQL 2k5

Returns list of active processes and their buffer contents over a specified time.

usp_IndexesUnused - SQL 2k5

Checks index usage

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.

DBA Morning Check List

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

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.