Published On Oct 7, 2024
A deep dive into Azure SQL Hyperscale which, as we will see, betrays the fact this is a great option for almost every SQL workload, not just those that need huge scale.
š Looking for content on a particular topic? Search the channel. If I have something it will be there!
š¤ 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.
ā¬ā¬ā¬ā¬ā¬ā¬ C H A P T E R S ā° ā¬ā¬ā¬ā¬ā¬ā¬
00:00 - Introduction
01:07 - Regular SQL architecture
02:45 - SQL Hyperscale architecture
03:03 - Components
03:45 - Log Service
05:28 - Page Servers
07:54 - Database storage scale
10:04 - Cache
12:08 - Compute scale
13:18 - Provisioned vCores
17:49 - Scaling the vCores
20:37 - Serverless
23:24 - Replicas
27:25 - Named replicas
29:42 - Geo-replication
33:28 - Elastic pool
38:22 - Per DB min and max vCore
40:27 - Isolation
40:40 - Scaling elastic pool
41:16 - You don't need to know any of this
42:24 - Pricing
43:53 - Huge scale flexibility
44:25 - Other names
45:38 - Close
ā¬ā¬ā¬ā¬ā¬ā¬ K E Y L I N K S š ā¬ā¬ā¬ā¬ā¬ā¬
āŗ Whiteboard:
š https://github.com/johnthebrit/Random...
ā¬ā¬ā¬ā¬ā¬ā¬ Want to learn more? š ā¬ā¬ā¬ā¬ā¬ā¬
š Recommended Learning Path for Azure
š https://learn.onboardtoazure.com
š„ Certification Content Repository
š https://github.com/johnthebrit/Certif...
š
Weekly Azure Update
š Ā Ā Ā ā¢Ā AzureĀ InfrastructureĀ UpdatesĀ Ā
ā Azure Master Class
š Ā Ā Ā ā¢Ā MicrosoftĀ AzureĀ MasterĀ ClassĀ v2Ā Ā
ā DevOps Master Class
š Ā Ā Ā ā¢Ā DevOpsĀ MasterĀ ClassĀ Ā
š» PowerShell Master Class
š Ā Ā Ā ā¢Ā PowerShellĀ MasterĀ ClassĀ Ā
š Certification Cram Videos
š Ā Ā Ā ā¢Ā MicrosoftĀ CertificationĀ ExamĀ PrepĀ VideosĀ Ā
š§ Mentoring Content
š Ā Ā Ā ā¢Ā VirtualĀ MentoringĀ Ā
ā 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-...
š Enable the subtitles and from there you can translate to your native language via the auto-translate feature in settings! Ā Ā Ā ā¢Ā YouTubeĀ CaptionsĀ andĀ AutoĀ TranslateĀ Q...Ā Ā for a demo of using this feature.
SUBSCRIBE ā
Ā Ā Ā /Ā @ntfaqguyĀ Ā
#Azure #sql #johnsavillstechnicaltraining