Mirroring Azure SQL MI into Microsoft Fabric OneLake - Demo

In this tutorial, we dive into the near real-time data integration capabilities of Microsoft Fabric by mirroring an Azure SQL Managed Instance (MI) into the Fabric OneLake.

Mirroring is a low-latency, zero-ETL solution that allows you to keep your operational data in sync with your analytics environment without the need for complex pipelines. I’ll guide you through the mandatory prerequisites, the creation of a SQL MI instance with the correct update policies, and the hands-on implementation within the Fabric portal.

🚀 In This Video, We Cover:

Prerequisites: SQL authentication, Managed Identity, and the "Always up to date" policy.

Azure SQL MI Setup: A step-by-step guide to provisioning a SQL Managed Instance (including using the free tier offer).

Connectivity: Resolving common connection errors in Azure Data Studio using Public Endpoints and Connection Strings.

Database Preparation: Creating sample schemas and data to test the mirroring process.

Fabric Implementation: Setting up the Mirrored SQL MI item and establishing the source connection.

Real-time Sync Test: Demonstrating how changes (like truncating a table) in SQL MI reflect in Fabric OneLake.

Vsit the Cloud Nerchuko blog:
👉 https://cloudnerchuko.in

🔗 Resources Mentioned:

Microsoft Fabric Documentation on Mirroring SQL MI: https://learn.microsoft.com/en-us/fabric/database/mirrored-database/azure-sql-managed-instance-overview

Azure Data Studio Download: https://aka.ms/azuredatastudio

Video Timeline
[00:00] Introduction to Mirroring Azure SQL MI in Microsoft Fabric
[00:39] Essential Prerequisites: Authentication, Identity, and Update Policies
[01:53] Step-by-Step: Creating an Azure SQL Managed Instance
[02:40] Configuring Compute, Storage, and Hardware Tier (Gen 5)
[03:17] Choosing Authentication Methods (SQL & Entra)
[04:41] Networking: Enabling Public Endpoints for connectivity
[05:17] Applying the Azure SQL MI Free Offer
[05:39] Critical Step: Setting the "Always up to date" policy
[06:26] Enabling System Assigned Managed Identity
[08:10] Connecting via Azure Data Studio & Troubleshooting Connection Errors
[10:34] Why Connection Strings are safer for Public Endpoints
[14:57] Database Preparation: Creating Sample Tables and Sales Data
[17:22] Microsoft Fabric Demo: Creating the Mirrored SQL MI Item
[18:24] Establishing the Source Connection with Admin Credentials
[19:23] Why Login/User Mapping is optional for Admin accounts
[20:44] Reviewing Mirroring Status and SQL Analytics Endpoint
[21:42] Running First T-SQL Queries in Fabric OneLake
[22:56] Testing Sync Latency: Truncating Source Data and Verification
[25:13] Final Summary and Troubleshooting Recap

If this tutorial helped you simplify your data synchronization to the cloud, please hit the LIKE button and SUBSCRIBE for more cloud and data engineering content!

#MicrosoftFabric #AzureSQLMI #OneLake #DataEngineering #CloudNerchuko #AzureTutorial #DatabaseMirroring #DataIntegration #SQLManagedInstance

Видео Mirroring Azure SQL MI into Microsoft Fabric OneLake - Demo канала Cloud Nerchuko