Thoughts on the 2015 PASS Election

We had a decent election this year. Thanks to all four candidates – Argenis Fernandez, Jen Stirrup, Ryan Adams, and Tim...

Assembling a Session

Up to this point, I have taken a lot of time to discuss the various components of Extended Events. There is...

Assembling a Session

With the core concepts in place as a good foundation to Extended Events, we start pushing these things together to help with assembling a session in Extended Events.
Related Posts:

Short...

Database Mirroring Isn’t Going Anywhere

AlwaysOn Availability Groups is a great technology that centralizes the management of High Availability, Disaster Recovery and Scale-Out. However, in...

Excel as a Database Professional

People ask me all the time how to become a DBA.  This is a topic that so many colleagues of
mine...

HammerDB Performance Collection with SQL Server – Updated

A while back, my friend Mike Fal ( b | t ) released a PowerShell script that can sample the counter inside SQL...

How to use SORT control in SSIS ? TIP #115

Dear Friends,
In the series ofLearn SSIS step by step this is the 5th post. Now from this post we are...

I Was Once a Very Crappy Carpenter + SQL Bolts to Buzzwords

Tonight I spoke to Dr. Alkadi's CMPS 411 class, which was hijacked by the Hammond .NET User Group onsite at...

SQL Server Enterprise Edition Advanced Scanning

It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you...

SQL Server Enterprise Edition Advanced Scanning

It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you to perform operations in a more optimal way in...