Implementing Zero-ETL with Microsoft Fabric Mirroring

Zenler Player

Your course is loading. Hang tight.

Who is this course for? Preview
Who is Greg? Preview
What will I learn in this course? Preview
Overview of online lab setup

Module introduction
What is Microsoft Fabric ?
Key Fabric workloads
What is Mirroring in Fabric ?
How mirroring differs from traditional pipelines
How mirrored data lands in OneLake
Fabric mirroring types
Currently supported data sources
Licensing and capacity requirements
When mirroring is and is not the correct choice
Quiz 1

Module introduction
How Fabric Mirroring works under the hood
OneLake and mirrored database items
Delta-parquet and open data formats
Replication concepts
Replicator backoff
Mirrored data retention
Read-only mirrored copies and analytics endpoints
Mirroring vs shortcuts vs dataflows
Schema handling and table selection
Permissions, workspaces, data access, and identity
Cost and capacity considerations
Common limitations and constraints
Quiz 2

Module introduction
Fabric capacity, workspace, and source database configuration
Enabling system-assigned managed identity
Firewall and network rules for source access
Creating a Fabric workspace and assigning capacity
Required tenant settings
Lab 3 video walkthroughs
Lab 3
Quiz 3

Module introduction
General prerequisites
Checking required managed identity
Database principal requirements
Required user database permissions
Source-specific implementation details
Creating a mirrored database
Selecting tables and configuring replication scope
Monitoring replication status
Reseeding mirroring
Database-level limitations
Table-level limitations
Column-level limitations
Troubleshooting
Lab 4 video walkthroughs
Lab 4
Quiz 4

Module introduction
Accessing mirrored data via the SQL analytics endpoint
Querying mirrored data
Using mirrored data in Power BI reports using DirectLake
Joining mirrored data with other Fabric data
Cross-database queries
Consuming mirrored data in data science workflows
Sharing mirrored data
Lab 5 video walkthroughs
Lab 5
Quiz 5

Module introduction
When mirroring is appropriate
Mirroring earlier versions
Mirroring from SQL Server 2025
Azure Arc and other prerequisites
Working with managed identities
Configuration - SQL Server 2016 - 2022
Configuration - SQL Server 2025+
Availability group issues
Limitations
Troubleshooting
Performance control with Resource Governor
Controlling scan performance
Controlling auto-reseed
Lab 6 video walkthroughs
Lab 6
Quiz 6

Module introduction
Monitoring initial seeding
Monitoring replication health
Replication latency and lag metrics
Schema changes and object evolution
Starting, stopping, and restarting mirroring
Handling ownership issues
CI and CD considerations for mirrored databases
Quiz 7

Module introduction
Table-selection strategy
Choosing between mirroring, shortcuts, and pipelines
Partitioning and delta file optimisation in OneLake
Managing costs with capacity units and mirroring overhead
Design patterns for medallion architecture with mirroring
Multi-source mirroring strategies
Cost awareness and operational guardrails
Lab 8 video walkthroughs
Lab 8
Quiz 8

Module introduction
Row-level security and column masking on mirrored data
Microsoft Purview integration for data governance
Auditing mirroring activity
Data residency and compliance considerations
Managing sensitive data during replication
Lab 9 video walkthroughs
Lab 9
Quiz 9

Module introduction
Mirroring Azure Cosmos DB
Mirroring Azure SQL Managed Instance
Mirroring Snowflake
Mirroring Azure Database for PostgreSQL
Open mirroring
Metadata mirroring for Azure Databricks
Mirroring Oracle
Mirroring MySQL
Mirroring SharePoint lists
Mirroring Google BigQuery
Mirroring using the REST API
Quiz 10

Module introduction
Operational reporting without impacting source OLTP systems
Unified analytics across cloud databases
Near real-time dashboards with mirrored + streaming data
Future roadmap for Fabric mirroring
Quiz 11

Summary and further steps