Parameter Sniffing vs. Parameter Sensitive Plan Optimisation: SQL Server's Reality
SQL Server 2022 PSPO reduces parameter sniffing pain, but operational reality means manual tuning is still essential for well-performing databases.
Read article →
SQL Server 2022 CU27 Released - Key Fixes and What You Need to Know
SQL Server 2022 CU27 (build 16.0.4295.3) delivers 41 fixes including critical security hardening, corruption prevention, and HA improvements. Here is what Australian DBAs need to act on.
Read article →
Leverage SQL Server 2022's New Functions for Enhanced Data Analysis and Performance
SQL Server 2022 introduces DATE_BUCKET, DATETRUNC and bit manipulation functions that replace complex workarounds and improve query performance. Here is what DBAs need to know.
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 →
“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 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 →