Are you prepared if a tornado filled with sharks destroys your primary data center?

Sure, you may have backed up your databases, but what about logins, agent jobs or extended events?

In this episode of Data Exposed, join Chrissy LeMaire  as she demos how disaster recovery can be simplified using the SQL Community’s SQL Server PowerShell module, dbatools.

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:

To compare geo-replication and auto-failover groups, refer to the table here:

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.


  • 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 and

Humanitarian Toolbox (HTBox) is a charity supporting disaster relief organizations with open source software and services. They are a community of developers, designers, testers, and industry professionals who want to contribute our unique skills in disaster relief aid.

In episode, Bill Wagner (Bill Wagner) joins Rich to discuss the charity, their impact and what they’re working on next. We’ll also find out how to get involved and contribute to the open source projects.

  • [01:25] – What’s the goal of Humanitarian Toolbox?
  • [02:35] – Where has the software been used?
  • [05:38] – What technology is powering the software?
  • [08:38] – How does the project engage with NGOs ?
  • [09:42] – What frameworks and APIs is AllReady using?
  • [11:25] – What are the future plans for the projects?
  • [12:21] – Can these projects be used by organizations other than NGOs?
  • [13:00] – Where can the public learn more about the projects?
  • [14:57] – Can developers and NGOs from outside the US participate?

Useful Links

In this episode, Frank and Andy chat with Stu Ainsworth about service reliability in a chaotic world. Press the play button below to listen here or visit the show page at


Sponsor: – Get a free audio book when you sign up for a free trial!

Notable Quotes

Postmortem: VSTS 4 September 2018 (02:00)
Stuart Ainsworth on Twitter: @CodeGumbo (05:30)
Reliability: Expectations vs. Solutions (06:00)
“Canada is another country.” (11:00)
Serendipitous” (11:55)
TV references: MacGyver and The A-Team (13:40)
Chaos Monkey (00:00)
Brent‘s book review of Database Reliability Engineering (15:00)
Andy cannot count 9’s… (19:15)
The shifting node for “big data.” (23:30)
Service Level Objective (25:00)
The Black Swan (Audible) by Nassim Nicholas Taleb (@nntaleb) (28:00)
Frank’s 9/11 Experience (30:00)
Culture is prime. (35:00)
The hard part is figuring out, “What is the problem we’re trying to solve?” (35:45)
DTU (36:50)
Things are changing. Some folks are threatened (40:30)
Stu works for Jack Henry. (41:40)
Risk cannot be removed by technology. (43:30)
“… it’s kinda like an old girlfriend…” – Stuart Ainsworth (44:30)
Road trips! (47:30)
“We are living in interesting times.” (49:00)
Hoschton, Georgia (50:25)
Stu likes the book Accelerate (52:40)
Find out more about Stu at! (53:45)
Learn more about Azure DataFest by following @AzureDataFest on Twitter! (54:00)