Mark Pryce-Maher
Senior Program Manager - Microsoft Fabric
Norwich, United Kingdom
Actions
Mark Pryce-Maher is a Senior Program Manager on Microsoft Fabric. Primary focusing on the Mirroring, User Experiences and Migrations for the Data Warehouse. Mark has spent the last 7 years at Microsoft in the Big Data space, including helping many customers migrate from Netezza, Teradata, Oracle, APS, SQL Server to Synapse Data Warehouse.
Links
Badges
Area of Expertise
Topics
Unlocking the Secrets of the SQL Analytics Endpoint
Discover the critical differences between the SQL Analytics Endpoint (SQL AE) and the Fabric SQL Warehouse in this technical deep dive. This session will unravel the unique approaches to managing and querying data in each platform, focusing on the key distinction: how data is added. Learn how SQL AE seamlessly integrates with Delta tables in the Lakehouse, contrasted with the traditional COPY INTO and INSERT/UPDATE statements in the Warehouse.
We’ll demystify MD Sync, exploring its pivotal role in synchronizing metadata, ensuring data consistency, and optimizing performance. By the end of this session, you’ll have a clear understanding of when and why to use SQL AE versus the Fabric SQL Warehouse, empowering you to make the most of Microsoft Fabric’s capabilities.
Whether you’re building scalable analytics solutions or just starting with Fabric, this session is your guide to unlocking the secrets of these powerful endpoints.
Unlocking the Power of Open Mirroring in Microsoft Fabric
Discover how Open Mirroring in Microsoft Fabric is revolutionizing data integration. This session begins with an overview of Mirroring in Fabric, laying the groundwork for understanding how this powerful feature streamlines data movement and synchronization. Then, we'll explore how Open Mirroring is a game changer, enabling organizations to create custom Mirroring solutions tailored to their unique needs.
In this deep dive, you'll learn how Open Mirroring works, from its core architecture to the specifics of its file-handling mechanisms. We'll then walk through two practical examples:
Mirroring Excel in Fabric – See how Excel files can seamlessly become part of your Fabric data landscape.
Mirroring Synapse Dedicated SQL Pools in Fabric – Learn how to integrate and migrate your dedicated SQL pools effortlessly.
By the end of this session, you'll have the knowledge and tools to leverage Open Mirroring, transforming how you handle data in Microsoft Fabric.
Audience: Data engineers, solution architects, and developers looking to innovate with Microsoft Fabric.
Unlocking the Power of Open Mirroring in Microsoft Fabric
Discover how Open Mirroring in Microsoft Fabric is revolutionizing data integration. This session begins with an overview of Mirroring in Fabric, laying the groundwork for understanding how this powerful feature streamlines data movement and synchronization. Then, we'll explore how Open Mirroring is a game changer, enabling organizations to create custom Mirroring solutions tailored to their unique needs.
In this deep dive, you'll learn how Open Mirroring works, from its core architecture to the specifics of its file-handling mechanisms. We'll then walk through two practical examples:
Mirroring Excel in Fabric – See how Excel files can seamlessly become part of your Fabric data landscape.
Mirroring Synapse Dedicated SQL Pools in Fabric – Learn how to integrate and migrate your dedicated SQL pools effortlessly.
By the end of this session, you'll have the knowledge and tools to leverage Open Mirroring, transforming how you handle data in Microsoft Fabric.
Audience: Data engineers, solution architects, and developers looking to innovate with Microsoft Fabric.
Unleashing Power BI's Potential with Fabric Mirroring: A Complete Guide
In today's data-driven landscape, optimizing Power BI performance is paramount for organizations aiming to derive actionable insights efficiently. Fabric Mirroring presents a compelling solution, enabling seamless integration and enhanced performance across Azure SQL DB, Azure CosmosDB, and Snowflake in multi-cloud environments. This session delves into the transformative capabilities of Fabric Mirroring.
Fabric Mirroring's integration with Azure SQL DB, Azure CosmosDB, and Snowflake offers organizations unparalleled flexibility and scalability. Through real-time data replication, organizations can ensure that their data remains current and readily accessible for analysis. Moreover, Fabric Mirroring facilitates seamless querying across multiple data sources, streamlining the data analysis process.
Attendees will gain valuable insights into the strategic advantages of Fabric Mirroring, including its ability to expedite data accessibility while maintaining consistency and reliability. Through live demonstrations, participants will witness how Fabric Mirroring accelerates data insights and empowers users to make informed decisions swiftly.
Furthermore, the session will explore the utilization of default semantic models and advanced analytics techniques to derive actionable insights from mirrored data sources. By leveraging these tools, attendees will learn how to extract meaningful insights and drive organizational growth effectively.
Mirroring in Microsoft Fabric
In this session we look at Mirroring in Microsoft Fabric.
We look at the next features and how they will it will make your lives amazingly easy.
This session will delight users.
Fabric Mirroring
In this session I will cover Database Mirroring in Fabric.
I'll explain:
* What Mirroring is
* When to use Mirroring
* Show how to create a Mirror for each source (Snowflake, Azure SQLDB and Azure CosmosDB)
* How to joining Mirroring data with other data in Fabric
* How to use Spark on Mirrored data
* How to use Power BI on Mirrored data
Metadata Sync : The magic behind Fabric
Fabric is Microsoft SaaS Analytics platform, the teams at Microsoft have put a huge amount of effort into making the hard stuff look really simple.
You take it from granted, if you put a create a delta table in the Lakehouse in appears in the SQL Endpoint, but how does that happen?
I will introduce you to MDSync one of the magic services that runs behind the scenes making your life simple.
What does it do? How does it work?
Well, you just need to come to the session and find out.
Fabric Mirroring for SQL Server
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.
Best Practices for Building a Data Warehouse in Microsoft Fabric
Need a data warehouse? Just click a button and it's there. Load some data into a table and the stats are automatically up to date. Need an index? No, you don't because Microsoft Fabric delivers performance by default.
While many of the day-to-day operational aspects of running your data warehouse are taken care of for you in this SaaS environment there are some best practices you should be aware of that can influence the performance and flexibility of your solution. In this session we will walk through those best practices including table design, loading patterns, workload management, security, and workspace architecture.
A Deep Dive into Microsoft Fabric Data Warehouse
In this technical presentation, we will explore the intricacies of Microsoft Fabric Data Warehouse, unravelling its capabilities and demonstrating effective strategies for its utilization. As organizations navigate the evolving landscape of data management, Fabric Data Warehouse emerges as a powerful solution, offering scalability, performance, and flexibility. Join us to delve into the core functionalities of Fabric Data Warehouse, understand best practices for implementation, and discover how to harness its potential to enhance your data processing workflows. Whether you are a seasoned data professional or just embarking on your data journey, this session promises insights and practical guidance for leveraging Microsoft Fabric Data Warehouse effectively in your projects.
Dedicated SQL Pools : How some stuff 'really' works
In the session we look at a few features as Azure Synapse Dedicated SQL Pools;
* Table Distributions
* Partitioning
* Result set caching
* materialized views.
We will cover these great features; When to use them but also which situations when not to use them and why.
This is a L400 session, so you will be expected to have used SQLDW or Synapse Dedicated SQL Pools , not just skimmed the documentation. :-) If you don't know your Round Robin from your Clustered Column Stored Index, then maybe this isn't the session for you.
No/Low-Code Data Ingestion in Microsoft Fabric: COPY JOB & Mirroring
Getting data into Microsoft Fabric doesn’t have to mean writing pages of code or building complex ETL pipelines. In this session, we’ll explore two powerful, low-effort options for importing data into Fabric—COPY JOB and Mirroring—and show you how quickly you can go from “no data” to “ready for analytics.”
We’ll start with an overview of each technology—what it is, how it works, and when to use it—before diving into a practical comparison of their strengths, limitations, and best-fit scenarios. Along the way, live demos will walk you through creating a COPY JOB and setting up Mirroring in real time, so you can see just how straightforward the process can be.
Data Platform Next Step 2023 Sessionize Event
SQLBits 2023 - Full day training sessions Sessionize Event
Mark Pryce-Maher
Senior Program Manager - Microsoft Fabric
Norwich, United Kingdom
Links
Actions
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top