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:
๐ https://github.com/johnthebrit/RandomStuff/raw/master/Whiteboards/AzureSQLDR.png
โบ Microsoft latency numbers:
๐ https://learn.microsoft.com/azure/networking/azure-network-latency?tabs=Americas%2CWestUS
โบ Microsoft RPO and RTO numbers:
๐ https://learn.microsoft.com/azure/azure-sql/database/business-continuity-high-availability-disaster-recover-hadr-overview?view=azuresql#recover-a-database-to-the-existing-server
โฌโฌโฌโฌโฌโฌ Want to learn more? ๐ โฌโฌโฌโฌโฌโฌ
๐ Recommended Learning Path for Azure
๐ https://learn.onboardtoazure.com
๐ฅ Certification Content Repository
๐ https://github.com/johnthebrit/CertificationMaterials
๐
Weekly Azure Update
๐ https://youtube.com/playlist?list=PLlVtbbG169nEv7jSfOVmQGRp9wAoAM0Ks
โ Azure Master Class
๐ https://youtube.com/playlist?list=PLlVtbbG169nGccbp8VSpAozu3w9xSQJoY
โ DevOps Master Class
๐ https://youtube.com/playlist?list=PLlVtbbG169nFr8RzQ4GIxUEznpNR53ERq
๐ป PowerShell Master Class
๐ https://youtube.com/playlist?list=PLlVtbbG169nFq_hR7FcMYg32xsSAObuq8
๐ Certification Cram Videos
๐ https://youtube.com/playlist?list=PLlVtbbG169nHz2qfLvPsAz9CnnXofhmcA
๐ง Mentoring Content
๐ https://youtube.com/playlist?list=PLlVtbbG169nGHxNkSWB0PjzZHwZ0BkXZZ
โ Questions? Maybe I answered it in my FAQ
๐ https://savilltech.com/faq
๐ Cure Childhood Cancer Charity T-Shirt Channel Store
๐ https://johns-t-shirts-store.creator-spring.com/
๐ Enable the subtitles and from there you can translate to your native language via the auto-translate feature in settings! https://youtu.be/v5b53-PgEmI for a demo of using this feature.
SUBSCRIBE โ https://www.youtube.com/channel/UCpIn7ox7j7bH_OFj7tYouOQ?sub_confirmation=1
#microsoft #azure #johnsavillstechnicaltraining #onboardtoazure #cloud
