Accelerate insights with real-time Azure SQL data and Microsoft Fabric

on YouTube ↗48m

" summary

Mirroring copies Azure SQL Database (initial snapshot + incremental changes read from the transaction log) into Microsoft Fabric’s OneLake so analytics run against near real-time data without touching the operational DB, using zero ETL and free replication compute. Latency targets are high single‑digit minutes for change propagation; mirrored storage is free up to your capacity (example: 64 TB free mirrored storage with 64 capacity). DDLs (add/alter/drop columns) are supported while mirroring runs; CDC and mirroring both read the log and can’t run simultaneously.

AI-written summary · about

" chapters (8)

1. 0:00Fabric mirroring for Azure SQL
2. 3:37Fabric mirroring solves sprawl
3. 10:04Setting up mirroring in Azure SQL
4. 14:36Mirroring vs CDC explained
5. 21:16Exploring mirrored data in Fabric
6. 29:22Mirroring benefits and roadmap
7. 37:04Archiving SQL data with Fabric
8. 42:17Q&A on security

" related talks

• 15mNear real-time analytics on Azure Cosmos DB with Microsoft Fabric mirroringAnitha Adusumilli · Azure Cosmos DB Conf 2024
• 25mAzure SQL MI & Fabric Fusion: A speed-sessionNiko Neugebauer · SQLBits 2024
• 51mA Deep Dive into Microsoft Fabric Data WarehouseJerry Nixon, Mark Pryce-Maher · SQLBits 2024
• 50mAzure SQL DB Data Portability : Mirroring, CDC, Export/Import and DataSyncCarlos Robles, Rajesh Setlem · SQLBits 2024
• 47mData analytics for the era of AIPatrick Baumgartner, Amir Netz, Swetha Mannepalli, Miwa Monji, Arun Ulagaratchagan, Justyna Lucznik, Ron Chang, Thasmika Gokal, Nimrod Shalit, Nandini Srinivasan · Microsoft Build 2023
• 19mAccelerate your data potential with FabricSwetha Mannepalli · Microsoft Build 2023
• 27mModernize your data integration to enable petabyte scale analytics with Microsoft FabricWee Hyong Tok, Shireen Bahadur · Microsoft Build 2023
• 30mDataEngBytes 2023 - BRI-T1-04 - Mimoune DjouallahMimoune Djouallah · DataEngBytes Brisbane 2023