Category: SQL Server

A handy search procedure

Updated this stored procedure I wrote a decade ago to search for a string in procedure bodies, object names, job steps, and more…

Consolidating links and resources

I made some landing pages here, with simple and easy-to-remember URLs, presenting sets of links to very frequently-discussed topics around SQL Server.

How to USE a Calendar Table – Part 1

It seems a lifetime ago I wrote about creating a calendar table; now I've started a new series showing how to use the calendar table. In the first installment, I deal with business day problems.