Introduction to Microsoft Fabric Database Mirroring with Azure SQL Database!

One of the biggest changes ever in the world of data and analytics is here! With Microsoft Fabric Database Mirroring you no longer need to forklift your data and then spend weeks or months building pipelines for incremental loads. Mirroring will do all of this for you! You can skip straight to using your OLTP real-time data to produce actionable reporting! Join Bradley Ball, aka @SQLBalls , as he walks through a demonstraion of the real-time capabilities of #MicrosoftFabric #Database #Mirroring!

Chapters
00:00 Let's discuss Mirroring
01:49 OLTP Data Logic App Setup
02:24 SSMS Table and Stored Procedure Setup
03:02 Setting up Mirroring
04:00 Monitoring Mirroring replication
04:14 Create a new table
04:53 Connect to the Microsoft Fabric SQL Endpoint
05:22 Connect KQL DB to Mirrored data with no ETL
07:48 Building our real-time Power BI Report

Introducing Mirroring in Microsoft Fabric

Mirroring Azure SQL Database (Preview)

What is Mirroring in Fabric?

/*******************
/CONNECT WITH US!!
/*******************

Tales from the Field

Bradley Ball

Daniel Taylor

Neeraj Jhaveri

Josh Luedeman

Andrés Padilla

#AzureSQL #realtime #ISS #NASA #Space

[knuckleheadmcspazatron]

I think you went by the connection too fast. Spending more time on a proper authenticated method using identity should have been covered because your viewers are working with production workloads and not just setting up a demo. Otherwise, very useful content. Thanks for taking the time.

[mathiassaint]

Thanks for a great demo.
Can u explain why ur not able to use the SQL endpoint directly into PBI?

[fazizov]

Great video, thanks, Bradley. based on my understanding, mirroring doesn't allow cross-tenant connection. I have a trial fabric account, but can't add any other Azure services, like ASQL there (pay as you go option is disabled for some reason). Any ideas on how to overcome that problem?

[totnguyen]

I encountered the following error: "The database cannot be mirrored to Fabric due to below error: User does not have permission to mirror the database." How can resolve this issue?

[winmax]

This is amazing. I am actively looking for something to replace our current approach to simulate real-time data from on-perm SQL database to a storage account. This is a true solution in my opinion. Can’t wait to test it out. Thank yoi

[ThirdwaveItech]

Thanks for the Demo. I investigated mirroring several months ago and saw disclaimers not to use this on production databases. Do you know if it is safe at this point?

[gopalannasundaram]

Great demo! Can we anonymize certain PII fields or select subset of columns in a table while setting up mirroring?

[pawewrona]

Great demo and thanks for adding Power BI into picture. KQL Database so far is not demoed very often, great to see this example as well!