T-SQL Tuesday #104: Just Can’t Cut That Cord

We all have our favorite scripts, tools or utilities. Those are the things that help make our jobs easier. In this article, I share with you a poor mans...

T-SQL Tuesday 104 – Capture expensive queries with query store

For this month’s T-SQL Tuesday Bert Wagner invites us to share SQL scripts we’ve written that we’d hate to live...

Another MVP Award and a Few Thoughts

I got the news of my MVP award last week. I’m honored that Microsoft feels I do quite a bit...

Apache Hadoop Ozone+HDDs and Kubernetes

As Hadoop is already a great on BIG Data, now as you know hadoop has addition stuff in it with...

Azure SQL Elastic Pools – Moving Databases

If you read official Microsoft documentation about naming conventions for your SQL elastic pools, it is hard to find any...

Does a Primary Key always have stats_id 1?

Back to the SQL Server Basics with Wayne

The Myth
I recently was attending a presentation where the presenter stated that the...

Finding Missing indexes

Situation SQL Server registers every missing index. Here is how you retrieve that information from the missing index DMV’s [crayon-5c335dbc1c266788449988/]...

Finding Unused Indexes

Situation Good index management is key to success. Having too many unused indexes around slows down your system. It is not...

Cloud Backup Comparison

I used to use Crashplan. This was about $150 a year, but I could to 5 machines. I used to...

Configure SQL Server Failover Cluster Instance on Azure Virtual Machines with MSDTC

Configure SQL Server Failover Cluster Instance If you are running a SQL Server Failover Cluster Instance on premises and looking to migrate to Azure, you might be a little...