When Deadlocks Become Art

We’ve all had to solve deadlock issues. Identify the two conflicting pieces of code, work out an appropriate change to...

Delete all the resources from a resource group using Windows PowerShell

Hello friends, Please find my new post at this link – https://social.technet.microsoft.com/wiki/contents/articles/40141.delete-all-the-resources-from-a-resource-group-using-windows-powershell.aspx

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