SQL Server

SQL Server Security Updates

SQL Server Security Updates (November)

SQL Server Security Updates Newsletter October/November November 2024 Security Update of SQL Server 2022 RTM CU16 KB Article:  KB5048033 Security Update of SQL Server 2022 RTM GDR KB Article: KB5046861 Security Update of SQL Server 2019 RTM CU KB Article: KB5046860 Security Update of SQL Server 2019 RTM GDR KB Article: KB5046859 Security…

Microsoft’s Secure Future Initiative

Microsoft’s Secure Future Initiative

A year ago, Microsoft launched the Secure Future Initiative (SFI) to prepare for the increasing scale and high stakes of cyberattacks. SFI brings together every part of Microsoft to advance cybersecurity protection across our company and products. This initiative represents a significant step forward in safeguarding your digital assets and…

SQL Server Security Updates

SQL Server and Azure SQL Updates

Upcoming changes for SQL Server Management Studio (SSMS). This is the first of three blog posts about the next releases of SQL Server Management Studio (SSMS), and the roadmap for 2024! Learn more: SSMS 20 connection changes (microsoft.com) Get started planning SQL Server 2014 end of support. Did you know that…

Accelerated Database Recovery in SQL Server 2019

Accelerated Database Recovery in SQL Server

Accelerated Database Recovery (ADR) is one of the most impactful engine changes introduced with SQL Server 2019. The goal of ADR is to dramatically reduce database recovery and rollback time, even in the presence of long‑running transactions.  What Is Database Recovery?  In a previous post, I discussed the SQL Server Restore and Recovery…

Query Optimizer Phases

Query Optimizer Phases

The SQL Server Query Optimizer uses cost-based optimization to create an execution plan with the least cost.