Microsoft Fabric shortcuts enable organizations to unify their data across various domains and clouds by creating a single virtual data lake. These shortcuts act as symbolic links to data in different storage locations, simplifying access and reducing the need for multiple copies. OneLake serves as the central hub for all analytics data. By using OneLake … Continue reading “What’s new with OneLake shortcuts”
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”
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”
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”
Co-Author – Gyani Sinha, Abhishek Narain Overview A well-architected lakehouse enables organizations to efficiently manage and process data for analytics, machine learning, and reporting. To achieve governance, scalability, operational excellence, and optimal performance, adopting a structured, metadata-driven approach is crucial for lakehouse implementation. Building on our previous blog, Demystifying Data Ingestion in Fabric, this post … Continue reading “Playbook for metadata driven Lakehouse implementation in Microsoft Fabric”
