Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.
SQL Server 2019 CU27 brings targeted fixes for Availability Groups and Change Tracking, plus broader stability and security improvements every production DBA should know about.
Read article →Microsoft released SQL Server 2019 CU21 and 2022 CU5 in June 2023, fixing over 30 bugs including memory leaks and query correctness issues affecting production environments.
Read article →The query patterns that quietly cripple SQL Server performance - non-SARGable predicates, parameter sniffing and more - and how developers and DBAs fix them together.
Read article →Microsoft released SQL Server 2022 CU1 and a GDR within two days of each other, addressing critical backup corruption risks, security vulnerabilities, and memory management issues.
Read article →Microsoft's February 2023 security patches addressed four remote code execution vulnerabilities across every supported SQL Server version, while SQL Server 2022 still awaited its first Cumulative Update.
Read article →SQL Server 2022 brings Azure Arc integration, built-in machine learning, and intelligent query processing. Here is what it actually delivers for production environments.
Read article →Default SQL Server auto-growth settings cause VLF fragmentation and autogrowth wait events. This script analyses every database and generates the correct ALTER DATABASE statements automatically.
Read article →Microsoft patched two silent incorrect results bugs in SQL Server 2019 CU9 and 2016 SP2 CU16, affecting CONCAT queries and in-memory tables with columnstore indexes.
Read article →Microsoft has confirmed a critical remote code execution vulnerability in SQL Server's Extended Events feature. Find out if your instance is exposed and how to fix it.
Read article →Microsoft released SQL Server 2019 CU8 after pulling CU7 due to a critical snapshot bug, but the release notes left DBAs without the information needed to make safe patching decisions.
Read article →SQL Server 2017 CU22 addresses real production issues, but Microsoft's sparse documentation makes the install decision harder than it needs to be. Here is what you actually need to know.
Read article →Microsoft released then quickly pulled Cumulative Update 7 for SQL Server 2019 after a critical defect surfaced. Here is what was fixed, what went wrong, and what it means for your patching process.
Read article →Performance tips, security advisories, and industry analysis. No fluff, no spam.