Azure SQL High Availability and Disaster Recovery

Поділитися
Вставка
  • Опубліковано 9 лип 2024
  • 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:
    🔗 github.com/johnthebrit/Random...
    ► Microsoft latency numbers:
    🔗 learn.microsoft.com/azure/net...
    ► Microsoft RPO and RTO numbers:
    🔗 learn.microsoft.com/azure/azu...
    ▬▬▬▬▬▬ Want to learn more? 🚀 ▬▬▬▬▬▬
    📖 Recommended Learning Path for Azure
    🔗 learn.onboardtoazure.com
    🥇 Certification Content Repository
    🔗 github.com/johnthebrit/Certif...
    📅 Weekly Azure Update
    🔗 • Azure Infrastructure U...
    ☁ Azure Master Class
    🔗 • Microsoft Azure Master...
    ⚙ DevOps Master Class
    🔗 • DevOps Master Class
    💻 PowerShell Master Class
    🔗 • PowerShell Master Class
    🎓 Certification Cram Videos
    🔗 • Microsoft Certificatio...
    🧠 Mentoring Content
    🔗 • Virtual Mentoring
    ❔ Questions? Maybe I answered it in my FAQ
    🔗 savilltech.com/faq
    👕 Cure Childhood Cancer Charity T-Shirt Channel Store
    🔗 johns-t-shirts-store.creator-...
    👂 Enable the subtitles and from there you can translate to your native language via the auto-translate feature in settings! • UA-cam Captions and A... for a demo of using this feature.
    SUBSCRIBE ✅ / @ntfaqguy
    #microsoft #azure #johnsavillstechnicaltraining #onboardtoazure #cloud

КОМЕНТАРІ • 30

  • @NTFAQGuy
    @NTFAQGuy  8 місяців тому +6

    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.
    👂 Translate the captions to your native language via the auto-translate feature in settings! ua-cam.com/video/v5b53-PgEmI/v-deo.html for a demo of using this feature.
    Thanks for watching!
    🤙

  • @BuggageandGlitchage
    @BuggageandGlitchage 8 місяців тому +1

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

    • @NTFAQGuy
      @NTFAQGuy  8 місяців тому

      Hehe, happy to help 🤙

  • @Dikimkd
    @Dikimkd 8 місяців тому +3

    Loved this so much! Amazing content. 💯💯💯

    • @NTFAQGuy
      @NTFAQGuy  8 місяців тому

      Glad you enjoyed it!

  • @DavidPazdera
    @DavidPazdera 8 місяців тому

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

    • @NTFAQGuy
      @NTFAQGuy  8 місяців тому

      I appreciate that!

  • @pkutka
    @pkutka 8 місяців тому

    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!!

    • @NTFAQGuy
      @NTFAQGuy  8 місяців тому

      Wow, thank you!

  • @FSX239
    @FSX239 8 місяців тому +1

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

    • @NTFAQGuy
      @NTFAQGuy  8 місяців тому +1

      My pleasure!

  • @christianibiri
    @christianibiri 8 місяців тому

    Another great video from John :)

  • @joergmayer3741
    @joergmayer3741 8 місяців тому +1

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

    • @NTFAQGuy
      @NTFAQGuy  8 місяців тому

      Thanks, you too!

  • @GarnelenGandalf
    @GarnelenGandalf 8 місяців тому

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

    • @NTFAQGuy
      @NTFAQGuy  8 місяців тому

      My pleasure!

  • @iamdedlok
    @iamdedlok 8 місяців тому

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

  • @yulaw3289
    @yulaw3289 2 місяці тому

    enjoying this video for today learning, thanks a lot!

    • @NTFAQGuy
      @NTFAQGuy  2 місяці тому

      You are welcome!

  • @ThorstenSauter
    @ThorstenSauter 8 місяців тому

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

  • @michaelfabunmi2782
    @michaelfabunmi2782 8 місяців тому

    Thank you john, amazing videos❤

    • @NTFAQGuy
      @NTFAQGuy  8 місяців тому

      Glad you enjoyed it

  • @atifshahid9775
    @atifshahid9775 8 місяців тому

    Awesome Explanation 👍👍👍👍👍👍

    • @NTFAQGuy
      @NTFAQGuy  8 місяців тому

      Thanks a lot 😊

  • @Dalamain
    @Dalamain 3 місяці тому

    This was awesome, thank you

  • @robbrinkkemper1702
    @robbrinkkemper1702 7 місяців тому

    🌟 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! 👍