Mark Pryce-Maher

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.

In this training session you will build a full fletched green field Lakehouse architecture based on best practices! You will be guided by experts in the field to learn about the key components & how to build it in the most dynamic & performant way!

Learn how to implement a data warehouse analytics solution with Azure Synapse. We will cover best practices on migrations, performance, security, and more!

Microsoft Fabric’s Warehouse and SQL analytics endpoint have evolved rapidly—with capabilities that make SQL-first analytics faster, safer, and simpler to operate. In this session, you’ll see how the SQL analytics endpoint provides a read-only, T-SQL experience over Delta tables with support for views, functions, and granular SQL security, while using the same engine that powers the Warehouse for low-latency queries. We’ll unpack automatic metadata discovery that keeps table stats and schema in sync without manual steps, and we’ll cover endpoint behavior, limitations, and reprovisioning options you can use to self-mitigate provisioning hiccups. On the Warehouse side, we’ll dive into Warehouse Snapshots—point-in-time, read-only views retained for up to 30 days that decouple reporting from ongoing ETL and enable safe roll-forward of the snapshot timestamp for consistent BI and compliance scenarios. You’ll leave with concrete patterns to combine Warehouse and the SQL analytics endpoint for resilient, performant lake-centric analytics in Fabric.

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:

Join Mark Pryce-Maher for an insightful session on leveraging the SQL database in Microsoft Fabric to transform your business. Microsoft Fabric is a unified data platform designed for the era of AI, integrating services such as Data Factory, Real Time Intelligence, Operational Databases, Analytics, Power BI, AI, OneLake, and Purview Data Governance. This session will explore how the SQL database in Fabric, an autonomous database built on Azure SQL Database, optimised for developers with GraphQL and CI/CD support, can unify OLAP and OLTP, deploy in seconds, auto-scale compute and storage, and integrate seamlessly with Azure AI and Fabric services. Discover practical use cases including advanced analysis and reporting, supply chain analysis, metadata-driven pipelines, and data AI using Retrieval Augmented Generation (RAG). Gain insights into technical details, components, and scenarios that demonstrate the capabilities of SQL database in Fabric for real-time insights, predictive analytics, and AI-enhanced applications. Don't miss this opportunity to learn how to harness the power of SQL database in Microsoft Fabric to drive innovation and efficiency in your organisation. Join us for a deep dive into the future of data management and AI integration.

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.​

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.

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.

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!

Come and join the Fabric Product Group for one of our fireside chats. Bring your questions because we have all the answers!!

The famous Power BI Power Hour returns, but this time it has expanded to cover the whole of Fabric!

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.