YoVDO

Azure SQL Virtual Machines - Simplifying HA and DR Configuration - Episode 5

Offered By: Microsoft via YouTube

Tags

Azure SQL Courses Disaster Recovery Courses Database Management Courses High Availability Courses

Course Description

Overview

Dive deep into High Availability (HA) and Disaster Recovery (DR) technologies for Azure SQL Virtual Machines in this comprehensive live session. Explore how to simplify HA & DR configuration using a multi-subnet approach, eliminating the need for an Azure Load Balancer. Learn about the native support for multi-subnet configuration in SQL Server and Windows Server Failover Cluster, and discover how it streamlines deployment, maintenance, and improves failover time. Watch demonstrations on secondary IP configuration, Windows cluster setup, Availability Group resources, and Zone Redundant Shared disk implementation. Compare various HA DR configurations and gain insights from expert speakers on best practices for Azure SQL VM management.

Syllabus

Stream begins.
Introductions.
SQL VM HA & DR Overview.
Simplify HR & DR configuration.
Demo: Secondary IP, Add Secondary IP.
Multi subnet configuration - steps involved.
Demo: Windows cluster, AG resources in cluster, AG & AG Listener in SSMS, Test connectivity from client, Test failover, Test connectivity from client.
Demo: Zone Redundant Shared disk​, Windows cluster​, SQL FCI resources in cluster​, Test connectivity from client​, Failover in cluster​, Test connectivity from client​.
Comparing available HA DR configurations.


Taught by

Microsoft Developer

Tags

Related Courses

Data Analysis: Essential Skills
Microsoft via edX
Data Science Core
Microsoft via edX
Microsoft Azure Solutions (Exam 70-533) – 9 Course Bundle
Udemy
Azure Architect Technologies
Udemy
Azure PowerShell Playbook: Azure SQL
Pluralsight