In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...

Automatically identifying queries that are now running more slowly (i.e. regressed), and changing these to use a previously faster query plan, could prove to be a very useful feature. The chapter ...

If you've just started writing SQL Server queries, there's a good chance you probably wrote a query, saw it return the right ...

Build a lightweight SQL regression detector that tracks latency, detects anomalies, analyzes plans, and catches slowdowns ...