A Microsoft white paper on SQL Server 2005 Security best practices for the operational and administrative tasks that lead to a more secure system.
SQL SERVER – Restore Database Backup using SQL Script (T-SQL)
Restore Database backups with a T-SQL script: read the logical file names with RESTORE FILELISTONLY, set single user mode, then run RESTORE WITH MOVE.
SQL SERVER – Query Analyzer Short Cut to display the text of Stored Procedure
A quick Query Analyzer shortcut: map sp_helptext to a key, select any SP name and display the text of Stored Procedure right in the result window.
SQL SERVER – Simple Cursor to Select Tables in Database with Static Prefix and Date Created
A simple cursor to select tables in a database by a static prefix like b_ or delete_ and by date created, so you can drop, print or index old tables.