Auto-failover groups in Azure SQL | Data Exposed




Channel 9 show

Summary: 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. [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 Follow Anna Hoffman and Jeroen ter Heerdt on Twitter at https://twitter.com/AnalyticAnna and https://twitter.com/JeroenterHeerdt.