SQL Server DB Migration – Cloning a database to another collation

Database migration is a vital task in any environment, complex or otherwise. Seamless migrations are the goal but the efforts...

Azure, PowerShell, Databases and the PASS Summit

I am quite honored to say that I am speaking at the single largest and most important Microsoft Data Platform...

SQL Server Tracking Suspect Pages

Did you know that SQL Server tracks suspect pages and puts the details into the msdb database in a table...

Power BI Custom Visuals Class (Module 69 – Heatmap)

In this module you will learn how to use the Heatmap Custom Visual.  The Heatmap is useful for show data...

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