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.

We’ll start by exploring a clever trick to create a case-insensitive warehouse using a simple API call, a small adjustment that can have a significant impact on query consistency and usability. 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.

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.

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.