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. Data Warehouse

OPENROWSET function in Fabric Data Warehouse (Generally Available)

The OPENROWSET function is generally available in Fabric Data Warehouse and Fabric SQL endpoints for Lakehouse and Mirrored databases. The OPENROWSET function enables you to easily read Parquet and CSV files stored in Azure Data Lake Storage and Azure Blob Storage: With the OPENROWSET function, you can easily browse files before loading them into the … Continue reading “OPENROWSET function in Fabric Data Warehouse (Generally Available)”

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 (Preview)

We are excited to announce support for SHOWPLAN_XML in Microsoft Fabric Data Warehouse in preview. 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 … Continue reading “SHOWPLAN_XML in Fabric Data Warehouse (Preview)”

Secure, comply, collaborate: Item Permissions in Fabric Data Warehouse

In today’s data-driven world, managing access to data is crucial for maintaining security, ensuring compliance, and optimizing collaboration. Item permissions play a vital role in controlling who can access, modify, and share data within an organization. This blog post will delve into the rationale behind the need for item permissions, what permissions can be assigned … Continue reading “Secure, comply, collaborate: Item Permissions in Fabric Data Warehouse”