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

Bringing Customer-Managed Keys to Fabric Warehouse and SQL Analytics Endpoint

With this release, customers gain greater control and assurance over the encryption of their most critical analytical workloads. The Value of Customer-Managed Keys Fabric already ensures that your data is encrypted at rest using Microsoft-managed keys. But for many organizations—especially in regulated industries—encryption alone isn’t enough. They need the ability to control and manage the … Continue reading “Bringing Customer-Managed Keys to Fabric Warehouse and SQL Analytics Endpoint”

Extending Outbound Access Protection to Fabric Warehouse and SQL Analytics Endpoint

With the release of Outbound Access Protection (OAP) for Fabric workspaces, customers gained a powerful safeguard: the ability to strictly control where outbound connections can be established. Meaning data loads and queries across the workspace are limited to trusted destinations, reducing risk and strengthening governance. Now, Fabric Warehouse (Preview) and SQL Analytics Endpoint (GA) are … Continue reading “Extending Outbound Access Protection to Fabric Warehouse and SQL Analytics Endpoint”

Understanding Locking and DDL Blocking in Microsoft Fabric Data Warehouse

As adoption of Microsoft Fabric Data Warehouse accelerates, understanding its concurrency model becomes essential for developers, architects, and data engineers. In this post, we’ll explore how Fabric DW handles locking, the nuances of DDL blocking, and how these behaviors impact your workloads. Locking Behavior in Fabric Data Warehouse Fabric DW supports ACID-compliant transactions using standard … Continue reading “Understanding Locking and DDL Blocking in Microsoft Fabric Data Warehouse”

Resolving Write Conflicts in Microsoft Fabric Data Warehouse

Fabric Data Warehouse (DW) supports ACID-compliant transactions using standard T-SQL (BEGIN TRANSACTION, COMMIT, ROLLBACK) and uses Snapshot Isolation (SI) as its exclusive concurrency control model. All operations within a transaction are treated atomically—either all succeed or all fail. This ensures that each transaction operates on a consistent snapshot of the data as it existed at … Continue reading “Resolving Write Conflicts in Microsoft Fabric Data Warehouse”

Query and ingest JSONL files in Data Warehouse and SQL Analytics Endpoint for Lakehouse (Generally Available)

The OPENROWSET function that can read JSONL format empowers you to easily read and ingest JSONL files – for example log files, social media streams, machine learning datasets, configuration files, and other semi-structured sources. With the versatile OPENROWSET T-SQL function, you can reference and query JSONL files as if they were tables, eliminating the need … Continue reading “Query and ingest JSONL files in Data Warehouse and SQL Analytics Endpoint for Lakehouse (Generally Available)”