Azure Sql DB Managed instance, a different sql server?

on YouTube ↗52m

" summary

Azure SQL Managed Instance behaves like a near‑drop‑in SQL Server: backup‑restore migration works (also Data Migration Service and log‑shipping for online cutover), supports cross‑database queries, SQL Agent, linked servers and extended events, and claims near‑100% compatibility with on‑prem SQL Server. Choose General Purpose (remote storage, IOPS tied to DB size, up to 8 TB; 16 TB private preview) or Business Critical (local attached storage, better IOPS, readable secondaries, ~4 TB). Backups are automated with 35‑day retention and 10‑year LTR preview; creation or vCore scaling takes 3–6 hour instance create/scale and storage expansion 5–10 minutes. Requires recent clients (SSMS/Azure AD) and runs in a VNet by default; Azure Monitor SQL Insights is in preview and needs Log Analytics/Telegraf.

AI-written summary · about

" chapters (21)

1. 0:00Introduction and speaker intro
2. 3:01Azure SQL family overview
3. 5:48Managed Instance features explained
4. 9:39Security and authentication in MI
5. 11:45General purpose vs business critical
6. 17:21Cost and storage considerations
7. 19:28Backup and retention policies
8. 20:32High availability options
9. 21:58Replication and service broker
10. 22:39Scaling and instance pools
11. 24:25Azure Monitor and SQL insights
12. 27:15Migration methods to MI
13. 31:14Portal demo and setup
14. 33:08Hybrid benefit and licensing
15. 34:11Backup and log limits
16. 36:15Networking and TLS settings
17. 38:20Creating and connecting to MI
18. 41:07Database migration steps
19. 43:40Monitoring with Azure Monitor
20. 46:48Pricing and licensing Q&A
21. 50:03Closing remarks and Q&A

" related talks

• 44mSQL Managed Instance: Fully managed SQL Server in AzureMladen Andzic · SQLBits 2020
• 39mModernize your applications on Azure SQL Managed Instance Q&ANiko Neugebauer, Shawndell Elfring, Mikayla Soucie, Mladen Andzic, Eric Hudson, Borko Novakovic · Microsoft Build 2023
• 50mAzure SQL Managed Instance RoadmapNiko Neugebauer · SQLBits 2023
• 50mAdvancing the DBA's Role in the Cloud: In the Cockpit of Azure SQL Managed InstanceNiko Neugebauer, Djordje Jeremic, Dani Ljepava, Bogdan Gavrilovic · SQLBits 2024
• 51mFly at Mach-speed with Azure SQL Managed InstanceNiko Neugebauer, Nevena Nikolic, Uros Milanovic · SQLBits 2024
• 51mFly at Mach-speed with Azure SQL Managed InstanceNiko Neugebauer, Nevena Nikolic, Uros Milanovic · SQLBits 2022
• 50mManaged Instance Link - Seamless migration to AzureHaider Raza, Manish Kumar · SQLBits 2019
• 50mSQL Server to Azure SQL: Performance and AvailabilityBob Ward, Anna Hoffman · SQLBits 2020