Azure SQL MI & Fabric Fusion: A speed-session
summary
Shows how Azure SQL Managed Instance queries external Parquet in OneLake via data virtualization and how CREATE EXTERNAL TABLE AS SELECT (CETAS) writes table extracts as Parquet for Fabric notebooks — demo reads the CETAS output directly. Describes a new near‑real‑time mirroring pipeline (CDC‑based, per‑table selection, initial snapshot then transaction streaming) that auto‑converts to Delta, exposes monitoring, and targets Fabric; mirroring starts with Azure SQL Database next week, with other sources and managed instance support on the roadmap.
AI-written summary · about
chapters (11)
- 0:00Azure SQL MI & Fabric Fusion intro
- 1:14Presenters & overview
- 2:20Long-term Azure SQL modernization
- 5:55Fabric ecosystem integration
- 6:56Understanding OneLake
- 8:24Data virtualization with ADLS
- 11:36Exporting SQL MI to OneLake
- 13:44Data integration limits & future
- 15:55Fabric mirroring intro
- 18:07SQL mirroring to Fabric
- 21:39Q&A
related talks
48mAccelerate insights with real-time Azure SQL data and Microsoft Fabric
46mMicrosoft Fabric Synapse data warehouse Q&A
15mNear real-time analytics on Azure Cosmos DB with Microsoft Fabric mirroring
30mDataEngBytes 2023 - BRI-T1-04 - Mimoune Djouallah
50mMicrosoft Fabric Data Factory Q&A
49mAnalytics in SQL Server and Azure SQL Database
27mModernize your data integration to enable petabyte scale analytics with Microsoft Fabric
19mAzure SQL MI End-to-end Demo Party for DBAs and Devs
