Brute Force data search tool

searches entire db for a string, number, or date, returns list of results

SQL server Agent - Status

As part of the application to monitor SQL health I created.
The procedure returns status of the SQL server Agent

Pad length

Pad string with a lenght of characters at front or back

Calculate Age (in years)

An inline table valued function (iTVF) that can be used to calculate age in years.

Format Date Time Function

Function do return common datatime formats of a date.
select dbo.[KDT_FN_FORMATDATETIME]('LASTDAY DDDD',getdate())

Determine Easter Sunday

Determine what day easter sunday will be based upon the year you pass the function

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.