Collecting Server Performance Metrics: Performance Monitor

Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or looking to make a move to the cloud there are a few key performance metrics...

Introduction to SQL Server Execution Plans

Watch this week’s episode on YouTube! I nearly always use execution plans as the starting point for SQL query performance troubleshooting. In this multi-part series, I plan to review...

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

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