Create stub tSQLt tests in SSDT from stored procedures

I have released another tool as part of the ssdt dev pack, what this does is create tSQLt classes and stub tests. If you open a stored procedure in...

Create stub tSQLt tests in SSDT from stored procedures

I have released another tool as part of the ssdt dev pack, what this does is create tSQLt classes and...

Create stub tSQLt tests in SSDT from stored procedures

I have released another tool as part of the ssdt dev pack, what this does is create tSQLt classes and...

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

HADR Virtual Chapter Involvement

I am always looking for ways to get involved within the PASS community. One such way that has become available...

Savepoints and conditional transactions

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

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

How HADR_SYNC_COMMIT waits can wreak havoc

It has been a decade since I have blogged. Or at least it feels like it. Today I would like...

How Client Statistics helps in improving performance in SQL Server

Client Statistics is SQL Server data tool which is very helpful in determining the statistics that how much data received...

New Publications and a Video

The people at Webucator were kind enough to make a video based on my article on dealing with SQL Server...