Azure SQL vs Azure SQL Managed Instance

Azure SQL vs Azure SQL Managed Instance
On this episode of the Tech Talk I and my guest (Denny Cherry) compared Azure SQL and Azure Managed Instance.
We discussed when to use one over the other, Migration recommendations and some general Azure SQL best practices. Let's check it out!
⏱ Timestamps ⏱
00:00 - Intro
01:04 - Denny's introduction
02:46 - Azure SQL Vs. Azure SQL Managed Instance - The similarities
4:44 - Azure SQL Vs. Azure SQL Managed Instance - The differences
10:02 - On-prem SQL server to Azure SQL migration recommendation
12:29 - Azure SQL best practices
17:35 - Denny's book
20:36 - Wrap up
20:56 - Last words
21:28 - Outro
WHAT TO WATCH NEXT
🔷Azure Big Data and Analytics Services
• Overview of Azure Big ...
🔷Azure for AWS Professionals (with Peter Pfeiffer)
• Azure for AWS Professi...
🔷How to save Cost and Maximize Performance of your Workload on Azure
• How to save Cost and M...
🔷Unlock the value of Azure Hybrid Using Windows Admin Center
• Unlock the value of Az...
🔷Running Docker Containers on Azure (with Pascal Naber)
• Running Docker Contain...
GET IN TOUCH
Email: [e-mail]
FOLLOW ME ON SOCIAL
Get updates or reach out to get updates on our Social Media platforms
Instagram: @techtalkwithkazeem
Facebook: / techtalkwithkazeem
LinkedIn: / kazeem-adegboyega-a434...
If you want to see more videos, make sure to subscribe:
Links: / techtalkwednednesdaywi...
#azure #azureSQL #TechTalkwithKazeem

[@lampsonn]

Good summary of Azure SQL vs Azure SQL MI. I like the mention of the service tiers as I believe you get high availability and failover as well in case there's some outage in a region. I believe you can set this up in a non business critical tier but probably with some effort. Danny did mention the secondary read-only database which can be useful. I purchased the book Denny mentioned as it covers the security concepts well in plain language. So thanks Kazeem / Danny for the video and book!

[@henryleme185]

What a class from Denny!
I already knew it about most of the things he explained, but the way he explained was so good that feels like I'm a specialist now hahaha

[@TechTalkwithKazeem]

Glad you enjoyed it!

[@imanIy]

I am glad the guest mentioned the B2B apps. If the number of clients you have will grow( that require one database per client), Azure sql db is the way to go.