SSDT DevPack - Highlight expensive queries

When developing stored procedures in SSDT it is important to know when you have written a query that is potentially slow or has a high IO or CPU cost...

Download Analytic Platform System Tools and Books Online

Photo Credit – Mario KlingemannMicrosoft’s Analytic Platform System (APS) has been a favorite platform of mine over the last few years....

Python and Tweepy

One of the projects that’s been on my list lately is to programmatically access Twitter for a few ideas I...

Savepoints and conditional transactions

This is the second in a short series on transactions. In the previous part I discussed nested transactions and showed...

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...