Azure SQL Hyperscale Deep Dive – NOT Just for Massive Databases!

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/RandomStuff/raw/master/Whiteboards/AzureSQLHyperscale.png

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

#Azure #sql #johnsavillstechnicaltraining