Scripts – A Living History

As a DBA, I have a collection of scripts that I use for anything from auto-fixing logins to seeing who...

Aggregation Design is Back!

If you use SQL Server Data Tools (SSDT) and SQL Server Data Tools – BI (SSDT-BI) for your SQL Server 2012...

Create a Whitelist for SQL Server

UPDATED - May 16, 2017 - Please review the updated code here.

In my previous post, Configuring the Azure SQL Database Firewall, I discussed...

Get All Referenced Tables and Columns

I was always challenged when my customers asked me what tables and columns are referenced by a stored procedure which was written many years ago by the guy who...

Get All Referenced Tables and Columns

I was always challenged when my customers asked me what tables and columns are referenced by a stored procedure which...

Job & Process Documentation Tips

Three big things I look for in documentation:
Who to call when it goes wrongWhere to find it the code, especially...

MVP of The Month

If you follow Grant Fritchey (B|T) at all, you know that every month he picks a “Speaker of the Month”....

Print Long String

Quite often, I output information through PRINT command. It works well only when message is shorter than 8000 bytes. When the message is greater than 8000 bytes, extra-characters will...

SQL New Blogger Challenge November 2015 Edition - Week 3 Digest

This week’s #sqlnewblogger posts!
Author Post @eleightondick [[T-SQL Tuesday] Data modeling: The trouble with prefixes @tomsql Adventures With TomSQL, aka Tom Staab @EdDebug [Automatically name primary key constraints in SSDT...

The Power of Data in the Cloud

Today we had a full-day event in Microsoft about the data offerings and possibilities in the Microsoft cloud platform – Azure....