Introduction to SQL Server Execution Plans

Watch this week's video on YouTube

Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans

I nearly...

Kubernetes Pipelines

This post continues looking at some of the Kubernetes concepts I’ve been learning with the 50 days of Kubernetes (K8s). Specifically in this post, I’m writing and thinking about...

Find Things Pointing at Production

Step AWAY from the Production servers! Read on...

Top Modern Data Warehouse questions

Below are the top 15 questions I am seeing from customers looking to build a modern data warehouse in the cloud, and the blogs that I have wrote that...

Importance of Testing

I’ve always said if you’re running a script for the first time in a production environment, you’re doing it wrong. Testing is fundamental to technology, yet it is one...

Current database vs database locks

I have a lot of co-workers who use sp_who and sp_who2 to see who’s in a given database. This is ... Continue reading

Last Week Reading (2019-07-21)

Another week passed. Look what did I find during that time. Press British Airways faces record £183m fine for data breach The penalty imposed on BA is the first...

The Data platform has evolved – so too must the DBA.

This blog post is around the changing landscape of both SQL Server and the people who are our trusted guardians of it – DBAs. If you have been involved...

Moving Databases into Azure SQL Elastic Pools

Quite a simple requirement (when I needed it a few months ago). Study my Azure SQL database environment below. As you can see I have a standard elastic pool...

What does the Machine Learning process look like?

This is the second article in the Machine Learning area. I have explained a bit more about the steps the Machine Learning process is built of. You will be...