MEAPSA

Explore IaaS and PaaS solutions for high availability and disaster recovery

Deploy Windows Server Failover Cluster and availability groups in Azure and hybrid environments. Configure temporal tables, geo-replication, and auto-failover groups.

Data Analyst

Data Engineer

Database Administrator

Azure

SQL Server

SQL Database

Module Objectives

After completing this module, you will be able to:

Explore options for deploying a WSFC in Azure
Explore options for deploying an AG in Azure
Implement Temporal Tables
Plan active geo-replication and auto-failover groups

Units

Introduction min
Describe failover clusters in Windows Server min
Configure Always-on availability groups min
Describe temporal tables in Azure SQL Database min
Describe active geo-replication for Azure SQL Database min
Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance min
Exercise: Configure geo replication for Azure SQL Database min
Knowledge check min
Summary min

Prerequisites

Experience creating and configuring resources using the Azure portal.
Basic understanding of SQL Server file storage.