Azure SQL High Availability and Disaster Recovery

Thinking about how to leverage the HA and DR options for Azure SQL services.

🔎 Looking for content on a particular topic? Search the channel. If I have something it will be there!

▬▬▬▬▬▬ C H A P T E R S ⏰ ▬▬▬▬▬▬
00:00 - Introduction
00:23 - High availability
07:34 - HA RPO and RTO and client retry
11:16 - Availability Zones
13:48 - Server and databases
15:48 - Disaster Recovery
20:47 - Automatic failover groups
23:05 - Geo-replication
24:11 - Replication technology
26:36 - Forget AUTOMATIC
28:29 - DR RPO and RTO
31:36 - Performing a failover
33:40 - Let DNS do its job
34:30 - Planned and unplanned
37:44 - How to implement DR failover process
42:52 - Listener
47:22 - Summary
49:15 - Close

▬▬▬▬▬▬ K E Y L I N K S 🔗 ▬▬▬▬▬▬
► Whiteboard:
► Microsoft latency numbers:
► Microsoft RPO and RTO numbers:

▬▬▬▬▬▬ Want to learn more? 🚀 ▬▬▬▬▬▬
📖 Recommended Learning Path for Azure
🥇 Certification Content Repository
📅 Weekly Azure Update
☁ Azure Master Class
⚙ DevOps Master Class
💻 PowerShell Master Class
🎓 Certification Cram Videos
🧠 Mentoring Content
❔ Questions? Maybe I answered it in my FAQ
👕 Cure Childhood Cancer Charity T-Shirt Channel Store

#microsoft #azure #johnsavillstechnicaltraining #onboardtoazure #cloud

[NTFAQGuy]

Let's dive into the HA and DR for Azure SQL services! Please make sure to read the description for the chapters and key information about this video and others.

⚠ P L E A S E N O T E ⚠

🔎 If you are looking for content on a particular topic search the channel. If I have something it will be there!
🕰 I don't discuss future content nor take requests for future content so please don't ask 😇
🤔 Due to the channel growth and number of people wanting help I no longer can answer or even read questions and they will just stay in the moderation queue never to be seen so please post questions to other sites like Reddit, Microsoft Community Hub etc.

Thanks for watching!
🤙

[BuggageandGlitchage]

A great refresher for things I thought I already knew but didn't. Thank you for your amazing content.

[pkutka]

Thank you for all the great stuff you post for us sir! Most of my Azure team colleagues watch you regurarly and you became an absolute legend there 👍. Everytime I watch some non-Savill Azure content I realize how gifted you are in presenting and explaining. By far the best technical channel I`ve seen. Wishing you all the best!!

[Dikimkd]

Loved this so much! Amazing content. 💯💯💯

[DavidPazdera]

I love the way you are able to inject humor into such "serious topic", John 😆. Great video, as always.

[FSX]

Whoa this is a deep dive I'm looking forward to. Thanks much.

[iamdedlok]

Thanks for this John! Great coverage of the HA and DR options for the SQL services.

[ThorstenSauter]

Thanks for the great explanation, John! I had a good laugh at "Where did my datacenter go?" 🤣

[joergmayer]

Thx John, great explanation. CU Friday. Have a great week.

[yulaw]

enjoying this video for today learning, thanks a lot!

[GarnelenGandalf]

Great Video and thanks for sharing all your thoughts! Really appreciate all the effort you put into making thinks so easy to understand !

[robbrinkkemper]

🌟 Amazing session! I've learned so much about Disaster Recovery in Microsoft Azure, thanks to John Savill's clear and thorough explanations. 📚 Your videos are not only informative but also engaging, making complex topics easier to grasp. 🚀 Really grateful for the valuable insights and looking forward to more content. Keep up the fantastic work! 👍