News

Patch Tuesday fixes 137 vulnerabilities, including critical flaws in SQL Server, Netlogon, Office, and the .NET Framework.
Microsoft this month pushed out 133 patches for a broad swatch of software and apps and plugged a zero-day flaw in SQL Server ...
Joey on SQL Server. A Deep Dive into SQL Server 2022's Query Performance Features, Part 1. An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to ...
Improving query performance. SQL Server 2022 has more Intelligent Query Processing features to speed up existing workloads and database applications with what Khan calls “minimal implementation ...
In SQL Server 2017, when the query optimizer encounters code with a multi-statement TVF, the query optimizer will pause optimization, execute the TVF subtree to get a very accurate cardinality ...
Cumulative Update 7 for SQL Server 2019 is plagued by a known reliability issue affecting the database snapshot feature according to a Microsoft blog post spotted by The Register.
Joey on SQL Server. Deep Dive into SQL Server 2022's Query Performance Features, Part 2: PSP Optimization. Reduce workload times with this handy feature that can benefit every database pro.