Next Level Availability Improvements in SQL Server 2022

Discover the availability enhancements in SQL Server 2022, the most cloud-enabled release to date, in this 47-minute SQLBits conference talk. Explore default improvements and new capabilities that database administrators can enable for a highly available and performant platform. Delve into engine availability improvements, disaster recovery strategies, and the high availability journey. Examine new features like distributed AG failover improvements, AG performance and stability enhancements, and multi-write replication. Address problem statements related to system databases and traditional SQL Server backups, and learn about T-SQL snapshot backups. Gain insights from speaker David Pless, whose expertise is further showcased on the Azure SQL Blog.

Intro
SQL Server 2022 Engine Availability Improvements
Disaster recovery
High Availability Journey
SQL Server 2022 High Availability New Feature Overview
Distributed AG Failover Improvements
AG Perf and Stability improvements
Multi-write replication
Problem Statement
System Databases
Traditional SQL Server backups
T-SQL Snapshot backup