Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Next Level Availability Improvements in SQL Server 2022

SQLBits via YouTube

Overview

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

Reviews

Start your review of Next Level Availability Improvements in SQL Server 2022

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.