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

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”

COMING SOON: Introducing SQL Audit Logs for Fabric Data Warehouse

Introducing SQL Audit Logs for Fabric Data Warehouse, a powerful new feature designed to enhance security, compliance, and operational insights for our users. The Role of SQL Audit Logs in Fabric Data Warehouse Security SQL Audit Logs in Microsoft Fabric Data Warehouse provide a comprehensive and immutable record of all database activities, capturing critical details … Continue reading “COMING SOON: Introducing SQL Audit Logs for Fabric Data Warehouse”

Another dimension of Functions in Data Warehouse

Today, we are announcing new types of Functions in Fabric Data Warehouse and Lakehouse SQL endpoint. Continue reading to find out more and if interested refer to sign up form for Functions preview in Fabric Data Warehouse. About functions Functions in SQL encapsulates specific logic that can be executed by invoking the function within queries, … Continue reading “Another dimension of Functions in Data Warehouse”

Supporting Database Mirroring sources behind a firewall

Database mirroring is a powerful feature in Microsoft Fabric, enabling seamless data replication and high availability for critical workloads (learn more about mirroring). However, connecting to mirrored databases behind a firewall requires the right integration approach. Database Mirroring now supports firewall connectivity for Azure SQL Database, with Snowflake and Azure SQL Managed Instance coming soon, ensuring … Continue reading “Supporting Database Mirroring sources behind a firewall”