Allow SQL Server Agent jobs management for non sysadmins

I don’t know about your experience when it comes to SQL Server Agent jobs but often I receive requests to grant permission so that clients can handle their jobs...

When Have You Used MOT Tables? T-SQL Tuesday #117

Steve Jones (b/t) is our host for T-SQL Tuesday and in case you didn’t know has taken over running T-SQL ... Continue reading

SQL Server Execution Plan Operators

Watch this week’s Execution Plan Operators episode on YouTube. SQL Server Execution Plan Operators When examining a query’s execution plan, certain operators tend to crop up over and over...

SQL Server Execution Plan Operators

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

When examining...

SQL Server Execution Plan Operators

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

When examining...

How do we prove our ETL processes are correct? How do we make sure upstream changes don't break our processes and break our beautiful data?

ETL Testing Part 2 - Operational Data Testing
This is the second part of a series on ETL testing, the first part explained about unit testing, and in this part,...

How do we prove our ETL processes are correct? How do we make sure upstream changes don't break our processes and break our beautiful data?

ETL Testing Part 2 - Operational Data Testing
This is the second part of a series on ETL testing, the first part explained about unit testing, and in this part,...

SQL Saturday Boston: I’m Speaking!

It feels like SQL Saturday Albany just wrapped up, but I have another announcement to make. I am proud to announce that I have been selected to speak at...

Production Kubernetes

Still learning more about Kubernetes. I’ve been working through the 50 days of Kubernetes (K8s). Let’s keep exploring The API is the security boundary Everything happens with the Kubernetes...

Announcing a New Book: Query Store for SQL Server 2019

I’m pleased as punch to be able to share with you the fact that I helped Tracy Boggiano write a whole new book on Query Store. It will be...