SQL 2025, SSMS 22 and Fabric. And they mirrored happily ever after?
Regular 50 minute session for SQLBits 2026Thursday - 23 Apr 2026 - 15:10 - 16:00 Room 2ATL; DR
SQL Server 2025 and Fabric offer the option to directly mirror your data from the database into Microsoft Fabric. This offloads the analytics from your on-premises environment to the cloud.
Let me show you how this works, what caveats there are and how to setup security.
Session Details
You know you have your data in your database. You know how to query it. But you can't let everyone in on your production database and run their queries. Yet everyone wants to create reports or dig into the data to gain insights.
SQL Server 2025 and Fabric offer the option to mirror your database data directly into Microsoft Fabric. This offloads the analytics from your on-premises environment to the cloud.
Let me show you how this works, what caveats there are and how to set up security.
Because you don't want anyone snooping around, now do you?
After the session, you'll have a better idea of how this integration works and if this is a good fit for your situation.
SQL Server 2025 and Fabric offer the option to mirror your database data directly into Microsoft Fabric. This offloads the analytics from your on-premises environment to the cloud.
Let me show you how this works, what caveats there are and how to set up security.
Because you don't want anyone snooping around, now do you?
After the session, you'll have a better idea of how this integration works and if this is a good fit for your situation.
3 things you'll get out of this session
- Setup SQL 2025 for mirroring
- use SSMS 22 to help in the setup
- Learn how Fabric processes mirrored data
- use SSMS 22 to help in the setup
- Learn how Fabric processes mirrored data
Speakers
Reitse Eskens's other proposed sessions for 2026
Data Literacy: Navigating Your Way to Data-Driven Success! - 2026
Reitse Eskens's previous sessions
Infra as code, control it from the tower.
This session covers deploying an Azure data solution with Infrastructure as Code with emphasis on security but also ease of maintenance.
Besides slides it also offers a demo and the code is on offer for download to give you, the delegate, a head start.
Load Testing Fabric - What is our hold capacity?
This session covers how to test Fabric for larger workloads. The default demo data is usually relatively small whereas a lot of companies process a lot more. This session aims at those use cases where a large dataset needs to be processed. The session goes from data ingestion to data presentation with PowerBI.