Finding and Fixing a Plan Regression with Query Store
A plan regression reproduced on SQL Server 2019 and 2025: finding it in Query Store, forcing the good plan, automatic plan correction and PSP.
Year-Suffixed System Views in SQL Server 2025
SQL Server 2025 adds year-suffixed sys views for Query Store, external tables, principals and columns. They may be compatibility layers.
Reads Are Part of the Contract: A DBA’s Guide to ORM-Generated SQL
In I argued that the database is a published interface, and that the way to keep it changeable is to draw a boundary: a small, deliberate set of views and procedures is the contract, and…