Adding Years, Months and Days

Adding Years, Months and Days to Years, Months and Days, with Bonus UK Public Holiday calculation.

Finding Triggers

Fun with Time

Building calendar table using MTVF

This script is a small extension to this excellent article
http://www.sqlservercentral.com/articles/calendar/145206/

Getting resource content from blocked process report

This script serves to display the content of the waiting resource. It is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCRL.

Getting resource name from blocked process report

The Resource name is most important information in the blocked process report.
The purpose of this script is to decode this information.
The script is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCLR.

Which President

Table Privileges

Get the full name

right aligning