In this video, Anna Hoffman and Jeroen ter Heerdt discuss and show how to create auto-failover groups in Azure SQL using PowerShell notebooks and a Java application.

This video was based on a tutorial, which you can follow here: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-implement-geo-distributed-database?tabs=azure-powershell&WT.mc_id=dataexposed-c9-niner.

To compare geo-replication and auto-failover groups, refer to the table here: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-business-continuity#compare-geo-replication-with-failover-groups&WT.mc_id=dataexposed-c9-niner.

Time Index:

  • [00:30] Background
  • [01:15] Comparing geo-replication and auto-failover groups
  • [02:12] Tutorial for implementing a geo-distributed database
  • [02:45] Demo starts
  • [04:55] Failover initiated
  • [06:21] Fail back and summary

In this video, learn how you can get a better TCO for recommended SQL Server HADR architectures with your Software Assurance benefits.

Outline:

  • Intro
  • Deploying SQL Server in High Availability / Disaster Recovery configuration
  • HA and DR benefits introduced in November 2019
  • Applying HA / DR benefits to typical HA/DR configuration
  • Contrasting licensing before and after November 2019
  • Application to older versions of SQL Server and various architectures
  • Summary

Learn more at https://aka.ms/sqlserver2019licenseguide?WT.mc_id=franksworld and https://techcommunity.microsoft.com/t5/sql-server/optimize-tco-with-new-sql-server-software-assurance-benefits-for/ba-p/1123731?WT.mc_id=franksworld.