How To Make Your Queries Perform Like They Used To

Photo by Chad Kirchoff on Unsplash
Prefer watching on YouTube? 
In the ideal world, you fully test how your SQL Server will handle upgrading to...

How To Make Your Queries Perform Like They Used To

Photo by Chad Kirchoff on Unsplash

Watch this week's video on YouTube
In the ideal world, you fully test how your SQL Server will handle upgrading to the latest version.  You're able to catch...

Clustered Index Uniquifier Existence and Size

In SQL Server, each and every row in a table needs to be accessible by itself, whether or not you...

PowerShell Modules Central - Share with community - What PowerShell modules are you using?

Like the blog post title states this is all about sharing with others! My idea is to share with the community which PowerShell modules you are using.
PowerShellModulesCentral is a...

My Thoughts After Completing a Power BI Report Server POC

Last month I worked on a proof of concept testing Power BI Report Server for self-service BI. The client determined...

Adding Replicas into existing Availability Groups

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...

Experimenting with VSCode instead of the ISE

I’ve been playing with PowerShell here and there, learning a few things. As I use the dbatools project, or
I...

Database Fundamentals #11: Why Learn T-SQL

If you’ve been following along with the previous 10 Database Fundamentals blog posts, you have a SQL Server installed and...

Uniquifier is a rather unique word isn’t it?

tl;dr; The uniquifier is used to make a non-unique key in a clustered index unique.
Uniquifier is a rather funny name,...

dataMinds Connect 2017 (win a ticket!)

Within two weeks the wait is over: the first edition of dataMinds Connect! For those of you wondering what I’m...