Google AI Professional Certificate - Learn AI Skills That Get You Hired
Get 20% off all career paths from fullstack to AI
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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.
Syllabus
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
Taught by
SQLBits