Please enter your information to subscribe to the Microsoft Fabric Blog.

Thanks for subscribing to the Microsoft Fabric Blog. You’ll receive email notifications when we publish new posts.

Microsoft Fabric Updates Blog

  1. Updates
  2. Mariya Ali

Introducing SQL Pool Insights in Microsoft Fabric Data Warehouse   

SQL Pool Insights is a powerful new monitoring capability in Microsoft Fabric Data Warehouse designed to give you actionable insights into SQL pool performance and resource utilization. This feature is part of the Query Insights (QI) schema, extending the monitoring experience customers already know and love. SQL Pool Insights addresses a long-standing customer need: understanding whether your pools are … Continue reading “Introducing SQL Pool Insights in Microsoft Fabric Data Warehouse   “

Hints in Fabric Data Warehouse

What are hints? Hints are optional keywords that you can add to your SQL statements to provide additional information or instructions to the query optimizer. Hints can help you improve the performance, scalability, or consistency of your queries by overriding the default behavior of the query optimizer. For example, you can use hints to specify … Continue reading “Hints in Fabric Data Warehouse”

Unlock the Power of Query insights and become a Fabric Data Warehouse performance detective

In today’s data-driven landscape, optimizing query performance is paramount for organizations relying on data warehouses. Microsoft Fabric’s Query Insights emerges as a powerful tool, enabling data professionals to delve deep into query behaviors and enhance system efficiency. Understanding Query Insights Query Insights in Microsoft Fabric serves as a centralized repository, storing 30 days of historical … Continue reading “Unlock the Power of Query insights and become a Fabric Data Warehouse performance detective”

SHOWPLAN_XML in Fabric Data Warehouse

We are excited to announce support for SHOWPLAN_XML in Microsoft Fabric Data Warehouse. This capability allows users to generate and view the estimated query execution plan in XML format, a tool for analyzing and optimizing SQL queries. Whether you’re troubleshooting performance bottlenecks or refining query strategies during development, SHOWPLAN_XML offers a granular, detailed view of … Continue reading “SHOWPLAN_XML in Fabric Data Warehouse”