Masukkan informasi Anda untuk berlangganan Blog Microsoft Fabric.

Terima kasih telah berlangganan Blog Microsoft Fabric. Anda akan menerima notifikasi email saat kami memublikasikan postingan baru.

Microsoft Fabric Updates Blog

  1. Pembaruan
  2. Data Warehouse

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)”

Simplifying file access in OPENROWSET using data sources and relative paths (Preview)

The introduction of data sources and relative paths in the OPENROWSET function unlocks a new level of simplicity and flexibility for querying files in your Lakehouse and beyond. By leveraging external data sources, you can write cleaner, more maintainable SQL queries and easily access data wherever it resides — making data engineering and analytics more … Continue reading “Simplifying file access in OPENROWSET using data sources and relative paths (Preview)”