SQL Server 2022 - the most Azure-enabled SQL Server yet

on YouTube ↗48m

" summary

Managed Instance Link creates a DR/migration path that seeds on‑prem SQL Server 2022 to Azure Managed Instance, supports read replicas and planned failover/failback (offline today, online in preview), and restores succeed only when database version 957 matches; egress storage fees apply. Synapse Link pushes committed transactions to an ADLS Gen2 landing zone then into a dedicated Synapse SQL pool for near‑real‑time analytics (demo adds 50 on‑prem and 100 cloud rows and reflects in Power BI). Arc installs a lightweight agent enabling 500+ assessment rules, Azure AD auth, Purview governance, Defender protection and pay‑as‑you‑go licensing across clouds.

AI-written summary · about

" chapters (15)

1. 0:00Intro
2. 0:37SQL Server integration with Azure services
3. 4:36Business continuity through Azure SQL Managed Instance
4. 6:21Link feature for Managed Instance
5. 8:16Offline Disaster Recovery with SQL Server 2022
6. 18:34Azure Synapse Link for SQL
7. 26:13Customer environments and application requirements are evolving
8. 27:17Azure extension for SQL Server
9. 28:49Cloud billing model for SQL Server Better cost efficiency when paying only for what you use
10. 30:11How to onboard SQL Server to Azure Arc Range of different onboarding tools
11. 37:16Secure your SQL Server 2022 with Azure
12. 37:36Azure Active Directory for SQL Server
13. 38:30Microsoft Purview integration
14. 39:29Microsoft Purview access policies for SQL Server
15. 45:17Microsoft Defender for Cloud-Databases Protection

" related talks

• 50mManaged Instance Link - Seamless migration to AzureHaider Raza, Manish Kumar · SQLBits 2019
• 50mManaged Instance Link - Seamless migration to AzureHaider Raza, Manish Kumar · SQLBits 2022
• 44mThe Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed InstanceDani Ljepava · SQLBits 2019
• 44mThe Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed InstanceDani Ljepava · SQLBits 2022
• 19mThere and back again: SQL Server 2022 - Managed InstanceDani Ljepava · SQLBits 2022
• 44mSQL Managed Instance: Fully managed SQL Server in AzureMladen Andzic · SQLBits 2020
• 46mBusiness continuity of on-prem SQL Servers using Azure services through ArcDhananjay Mahajan, Raj Pochiraju · SQLBits 2024
• 52mAzure Sql DB Managed instance, a different sql server?Gonzalo Bissio · Global Azure 2021