Finding the root cause of slow queries starts by separating work from waits, then testing theories against plans and history.
Using Historical Data to Confirm Performance Improvements
Using historical data to confirm performance improvements turns a fast test into evidence the business can defend.
Single-Query Tuning Versus Workload Tuning
Single-query tuning versus workload tuning decides whether one fast victory becomes a durable performance improvement.
Validating AI-Generated Index Recommendations
Validating AI-generated index recommendations is the step between a persuasive script and a change you can defend in production.
Cost Optimization That Never Reaches the Invoice
SQL Server cost optimization has a problem nobody puts on the slide. The savings are real, the dollars are real, and none of it reaches the invoice. This is the story of how I found that out in front of people. I want to tell you about the best week…
Read More
SQL Server Monitoring Across Cloud, Hybrid, and On-Prem
Let us talk about SQL Server Monitoring Across Cloud, Hybrid, and On-Prem. This is not a tooling problem.
Real-Time Performance Views That Make Troubleshooting Easier
Let us talk about Real-Time Performance Views That Make Troubleshooting Easier. And it is more common than it should be.