DBCC CHECKDB to a table

An enhanced version of a script originally posted by Robert Pearl some time ago. It now takes into account changes in the tabelresults for CHECKDB in latter versions of SQL Server.

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