Microsoft Fabric: Open Mirroring Deep Dive!

Open Mirroring is here!! Join Microsoft Fabric PG team member Mark Pryce-Maher, aka @MarkPryceMaher , as he walks us through using Open Mirroring to do a worlds first! Mirror Microsoft Access or Microsoft Excel to Fabric!! We will show the demo and step through the code, check out Mark's GitHub! Mark's Github with the Code from the Video https://github.com/MarkPryceMaherMSFT/OpenMirroring Mark's YouTube Channel with his videos! https://www.youtube.com/@MarkPryceMaher Open mirroring in Microsoft Fabric (Preview) https://learn.microsoft.com/en-us/fabric/database/mirrored-database/open-mirroring /******************* /CONNECT WITH US!! /******************* Tales from the Field Twitter/X: https://x.com/TalesftField Linkedin: https://www.linkedin.com/company/100091910/ Bradley Ball Twitter/X: https://x.com/SQLBalls Linkedin: https://www.linkedin.com/in/sqlballs/ Daniel Taylor Twitter/X: https://x.com/dbabulldog Linkedin: https://www.linkedin.com/in/danieltaylor3/ Neeraj Jhaveri Twitter/X: https://x.com/neeraj_jhaveri Linkedin: https://www.linkedin.com/in/neerajjhaveri/ Josh Luedeman Twitter/X: https://x.com/joshluedeman Linkedin: https://www.linkedin.com/in/joshluedeman/ Bradley Schacht Twitter/X: https://x.com/BradleySchacht LinkedIn: https://www.linkedin.com/in/bradleyschacht/ Chapters 00:00 Open Mirroring What is it & How does it work? 05:57 Demo Create Mirrored database 07:12 Demo Running C# Application for Microsoft Access 09:10 Demo Adding a New Record 10:01 Demo What is Happening in the Storage layer? 10:26 Demo Top Secret new Feature!! 11:00 Demo SQL Analytics Endpoint 12:09 Demo Creating Shortcuts from Mirrored database to Lakehouse 12:51 Demo Looking at the Delta Files 13:47 Demo Stepping through the C# Code 14:28 Demo Configure the app.config file 16:41 Demo Change the Program.cs file 16:55 Demo Mark steps through the Excel Code