Open Transaction Alarm to Log to the Event log

If you have job that opens a transaction and hangs too long causing a Prod issue this will be a big help to let you know.

Version independent spGetBackupDateFromFile

This is an version independent stored procedure to get the backup date from a backup file.

It's tested for SQL 2005, 2008(R2), 2012 and 2014.

Consider it a template to which you can add more output parameters from the headerinfo to meet your requirements.

Database File Move Etc

A stored procedure to generate database file moves along with Robocopy script and the attach / detach scripts

Datetime Formats

This stored procedure will show all possible datetime formats when used with the style argument in the CONVERT() function. It also shows sample output from the date part arguments.

Quick snapshot

Script enables a quick creation of snapshots for databases

Script move of DB files from one location to another

Generates Scripts to move DB files from one location to another SQL and powershell scripts

Code For Truncating Table with foreign Key Constraints

This can be used for data warehouses as well as truncating table with foreign key constraints.

Script out all alerts

Sometimes you want to copy all the alerts that you've got set up on one server to add them to another

A new set-based T-SQL solution for Sudoku puzzle

New set-based T-SQL solution for Sudoku puzzle using binary data and bitwise operations.

Counting

A fun, but simple tally table for April 1.