Fabric Mirroring for SQL Server
2025TL; DR
Fabric Mirroring offers a game-changing way to bring your operational SQL Server data into Microsoft Fabric for near real-time analytics—without complex ETL pipelines. In this session, we’ll focus on mirroring from SQL Server 2016 through SQL Server 2022, with a look ahead to what's coming for SQL Server 2025.
We’ll explore why mirroring matters, what problems it solves, and how it fits into a modern data architecture. Expect practical demos showing exactly how to set up mirroring from SQL Server into Fabric—covering prerequisites, permissions, deployment steps, and tips to avoid common pitfalls.
While the spotlight is on SQL Server, we’ll briefly touch on mirroring for Azure SQL Database, Azure SQL Managed Instance, and Fabric SQL DB, to help you understand where each fits in the broader picture.
Whether you're dealing with on-premises SQL Server or planning future upgrades, this session will equip you with the knowledge to unlock the full potential of Fabric Mirroring and simplify your data estate.
Session Details
Fabric Mirroring offers a game-changing way to bring your operational SQL Server data into Microsoft Fabric for near real-time analytics—without complex ETL pipelines. In this session, we’ll focus on mirroring from SQL Server 2016 through SQL Server 2022, with a look ahead to what's coming for SQL Server 2025.
We’ll explore why mirroring matters, what problems it solves, and how it fits into a modern data architecture. Expect practical demos showing exactly how to set up mirroring from SQL Server into Fabric—covering prerequisites, permissions, deployment steps, and tips to avoid common pitfalls.
While the spotlight is on SQL Server, we’ll briefly touch on mirroring for Azure SQL Database, Azure SQL Managed Instance, and Fabric SQL DB, to help you understand where each fits in the broader picture.
Whether you're dealing with on-premises SQL Server or planning future upgrades, this session will equip you with the knowledge to unlock the full potential of Fabric Mirroring and simplify your data estate.
We’ll explore why mirroring matters, what problems it solves, and how it fits into a modern data architecture. Expect practical demos showing exactly how to set up mirroring from SQL Server into Fabric—covering prerequisites, permissions, deployment steps, and tips to avoid common pitfalls.
While the spotlight is on SQL Server, we’ll briefly touch on mirroring for Azure SQL Database, Azure SQL Managed Instance, and Fabric SQL DB, to help you understand where each fits in the broader picture.
Whether you're dealing with on-premises SQL Server or planning future upgrades, this session will equip you with the knowledge to unlock the full potential of Fabric Mirroring and simplify your data estate.
3 things you'll get out of this session
Speakers
Mark Pryce-Maher's other proposed sessions for 2026
New in Microsoft Fabric: The Warehouse and the SQL Analytics Endpoint - 2026
SQL vs. Fabric? Why Not Both! A Practical and Entertaining Guide for All - 2026
Mark Pryce-Maher's previous sessions
From Beginner to Certified: A Fabric Analytics Engineer Workshop
In this full day workshop, we’ll cover the skills and tasks required for a career as a Microsoft Fabric Analytics Engineer and prepare you for the DP-600 Certification Exam.
Nose-Dive Narratives: Slide Karaoke 2024
Get ready to wrap up a serious day of learning with a dash of humor, spontaneity, and friendly competition! SQLBits presents "Slide Karaoke" where SQLBits speakers reveal their hidden talents while vying for bragging rights. This session promises to be a one-of-a-kind experience that will leave you in stitches and awe, and the speakers scrambling for their non-existent notes!
Fabric Product Group - Ask us Anything
Come and join the Fabric Product Group for one of our fireside chats. Bring your questions because we have all the answers!!
Fabric Power Hour
The famous Power BI Power Hour returns, but this time it has expanded to cover the whole of Fabric!
A Deep Dive into Microsoft Fabric Data Warehouse
Deep Dive into Data Warehousing in Microsoft Fabric. Explore the intricacies of Microsoft Fabric Data Warehouse, unraveling its capabilities and demonstrating effective strategies for its utilization.