Insira suas informações para assinar o Blog do Microsoft Fabric.

Agradecemos por assinar o Blog do Microsoft Fabric Você receberá notificações por email quando publicarmos novas postagens.

Microsoft Fabric Updates Blog

  1. Atualizações
  2. Twinkle Cyril

ALTER TABLE inside explicit transactions in Fabric Data Warehouse (Generally Available)

Schema evolution is a fact of life for modern analytics platforms. As data models grow, teams need to add columns, drop unused fields, and evolve constraints—often as part of tightly controlled deployment pipelines. Fabric DW supported transactional execution for key table‑focused DDLs like CREATE TABLE, DROP TABLE, TRUNCATE TABLE, CTAS and sp_rename—with this release, ALTER … Continue reading “ALTER TABLE inside explicit transactions in Fabric Data Warehouse (Generally Available)”

Warehouse Snapshots in Microsoft Fabric (Generally Available)

Managing data consistency during ETL has always been a challenge for our customers. Dashboards break, KPIs fluctuate, and compliance audits become painful when reporting hits ‘half-loaded’ data. With Warehouse Snapshots, Microsoft Fabric solves this by giving you a stable, read-only view of your warehouse at a specific point in time and now, this capability is … Continue reading “Warehouse Snapshots in Microsoft Fabric (Generally Available)”

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”

Warehouse Snapshots in Microsoft Fabric (Preview)

Maintaining data consistency during ETL (Extract, Transform, Load) processes has long been a critical challenge for data engineers. Whether it’s a nightly pipeline overwriting key records or a mid-day transformation introducing schema drift, the risk of disrupting downstream analytics is both real and costly. In today’s fast-paced, data-driven world, even brief inconsistencies can break dashboards, … Continue reading “Warehouse Snapshots in Microsoft Fabric (Preview)”