Key Mirroring to Azure SQL Database in Fabric Benefits | Data Exposed

preview_player
Показать описание
Mirroring Azure SQL Database in Fabric is a new, simple, and frictionless way to replicate a snapshot of these source database in Fabric OneLake in Delta tables that keeps the data in sync in near-real time. The key benefits are: 1) Reduced total cost of ownership, 2) Zero code with zero ETL and, 3) Faster time to operational data to derive insights. Learn more in this episode of Data Exposed.

Chapters:
0:00 Introduction
2:00 Mirroring Databases **Now in Public Preview** Supercharge analytics time to value
2:58 How this works
4:15 Demo #1
8:56 Demo #2
14:10 Getting started

✔️Resources:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#AzureSQL #SQL #LearnSQL
Рекомендации по теме
Комментарии
Автор

Great demo, thanks. Looking forward to this being supported for SQL MI.

robcarrol
Автор

This is nice. Perhaps we could do the replication like that from our on-premises SQL Server via the gateway.

RonnySadamHusen
Автор

I want to emphasize that automating the CDC is a significant development. I want to avoid the hassle of implementing the CDC when stakeholders have differing opinions on how it should be done. Implementing efficient, cost-effective, and high-quality CDC pipelines can be a major headache, and that's something many people fail to recognize. However, the explanation of writing the Data on Datalake vs. SQL DB makes it 'Mirroring' is just a super lame justification for not being no longer CDC. But okay, I suppose it is a branding thing trying to get people on board by making the lingo more palatable for acceptance and for spreading the features among the 'lay' people if I may.

joneskiller