Essential Security Updates for SQL Server Versions 2016 to 2022
Microsoft's late-2024 SQL Server GDR updates fix CDC regressions introduced in September 2024, not new vulnerabilities. Here is what that means for your patching strategy.
Read article →
SQL Server 2022 CU14: Key Updates and Enhancements
SQL Server 2022 CU14 addresses six significant defects affecting backup reliability, Availability Groups and Linux memory management. Here is what DBAs need to know.
Read article →
Critical Security Patch: Preventing Remote Code Execution
Microsoft has issued emergency GDR security updates for SQL Server 2022, 2019 and 2017 to address a critical remote code execution vulnerability in the SQL Server connection driver.
Read article →
SQL Server 2019 CU27: Latest Updates and Enhancements
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 →
“Latest Updates: SQL Server 2019 CU21 and 2022 CU5 Released”
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 →
SQL Server Performance: A Developer's Guide to Faster Queries
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 →
“SQL Server 2022: Rapid-Fire Updates Enhance Performance and Security”
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 →
“SQL Server 2022’s First Update and Enhancements for Previous Versions”
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: Unlocking the Power of AI and Machine Learning for Data Management and Analysis
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 →
Update all DB growth parameters to defined increments
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’s Postponement of Patches: Investigating Incorrect Results Bugs in SQL Server 2019 and 2016
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 →
Critical Security Issue in Extended Events Fixed in Latest SQL Server Updates
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 →