Mastering Microsoft Fabric Data Warehousing: Tips & Tricks You Need to Know

1. During this session, we’ll dive into a range of helpful tips and tricks that I wish I had known when starting out with Microsoft Fabric data warehouses. These insights are designed to save you time, optimize performance, and make managing your data warehouse more efficient.
2. We’ll start by exploring how to easily query data from Lakehouses, Mirrored SQL databases, and Fabric SQL databases to leverage a medallion architecture with the best engine for each job. From there, we’ll tackle performance monitoring, focusing on identifying and addressing slow queries. You’ll learn how to leverage built-in tools and techniques to pinpoint bottlenecks and take corrective action.
3. But what happens when a rogue query threatens to cripple your capacity? Don’t worry, we’ll cover how to detect and kill capacity-destroying queries before they disrupt operations. This critical skill will ensure your data warehouse remains stable and responsive, even under heavy workloads.
4. Throughout the session, I’ll share practical, real-world examples and actionable strategies to help you get the most out of Microsoft Fabric. Whether you’re new to data warehousing or looking to sharpen your skills, this session is packed with valuable insights you can start using immediately.

1. Learn how to query across Lakehouses, Mirrored SQL databases, and Fabric SQL databases to build an effective medallion architecture using the right engine for each layer.
2. Gain practical techniques for monitoring query performance, identifying bottlenecks, and taking corrective action before slow queries become a bigger problem.
3. Discover how to detect and kill capacity-destroying queries, keeping your data warehouse stable and responsive even under heavy workloads.
4. Walk away from two live demos with hands-on knowledge: how to handle cross-collation joins in Fabric, and how to close the gaps in Fabric’s current monitoring solutions.
5. Get real-world, actionable strategies that you can apply immediately, whether you are just getting started with Fabric data warehousing or looking to level up your existing skills.