Azure SQL IaaS VM Extension Overview

A look at the Azure SQL IaaS VM Extension as a way to bring some insight and PaaS-like capabilities to your SQL Server instances running in Azure IaaS virtual machines.
👂 I have manually updated the captions to be as accurate as possible. Enable the subtitles and from there you can translate to your native language via the auto-translate feature in settings! • KZbin Captions and A... for a demo of using this feature.
🔎 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 ⏰ ▬▬▬▬▬▬
0:00 - Introduction
0:26 - Azure PaaS SQL offerings
2:50 - SQL Server running in a VM
5:08 - Adding the SQL IaaS VM extension
6:02 - Management modes
6:24 - Lightweight management mode
12:05 - Full management mode
20:25 - Which mode to use
21:44 - Removing the extension
24:54 - How to deploy?
28:20 - Summary and close
▬▬▬▬▬▬ K E Y L I N K S 🔗 ▬▬▬▬▬▬
► Whiteboard:
🔗 github.com/johnthebrit/Random...
► Azure SQL DB vs MI:
🔗learn.microsoft.com/azure/azu...
► SQL Azure IaaS Extension permissions:
🔗learn.microsoft.com/azure/azu...
► Bulk VM registration:
🔗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
❔ Question about my setup?
🔗 • My Setup
👕 Cure Childhood Cancer Charity T-Shirt Channel Store
🔗 johns-t-shirts-store.creator-...
SUBSCRIBE ✅ / @ntfaqguy
#microsoft #azure #johnsavillstechnicaltraining #onboardtoazure #cloud

[@NTFAQGuy]

Bring some PaaSness to your SQL in Azure IaaS VMs 😊! 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 ⚠ 👂 I have manually updated the captions to be as accurate as possible. Enable the subtitles and from there you can translate to your native language via the auto-translate feature in settings! kzbin.info/www/bejne/rGbFZmZjhcx4o6s for a demo of using this feature. 🤔 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. 🔎 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 😇 Thanks for watching! 🤙

[@cma9br]

Simple to install, simple to remove and useful for IaaS SQL VMs. Thanks for your time.

[@typ129]

Right when I needed it! Thank you John!

[@crltech8093]

Thanks John. Timing of this was perfect for a work project I'm doing 👌

[@johnthompson3530]

Thanks John. Great video. (as always)

[@ninamousavifar5172]

You give me a lot of great ideas! keep going John :)

[@sulaimanconainmohammed7795]

Wow! thanks for the explanation.

[@lifechamp007]

I'm learning so much from your videos - Thank you very much John!! #StayBlessednHappy

[@TANVEER991164]

Thank you John , what a timing for the video , we are planning the On-Prem DB movement to Azure . I can certainly pitch the full mode Azure SQL IaaS VM Extension now to our Architects.

[@NTFAQGuy]

Glad it was helpful!

[@christianibiri]

Very informative :)

[@harrichavan789]

explanation was very helpful!

[@NTFAQGuy]

Glad to hear that!

[@hemang81]

Thank you so much, it is very well explained...!!

[@NTFAQGuy]

You are welcome!

[@stevehainestrumpet]

Fantastic explanation! For the backups, does the DB recovery mode of full or simple affect the way managed backups are run?

[@NTFAQGuy]

Yes, if you are in Simple recovery model we can't take log backups so we can only take Full backups

[@stevehainestrumpet]

@@NTFAQGuy Thank you John! I really enjoy your sessions!