Microsoft has launched a native graph data management, analytics, and visualization service. Its horizontally scalable, native graph engine empowers enterprises of all sizes with a relationship‑first way to model and explore interwoven data.
Fabric data agents now support CI/CD, ALM flow, and Git integration. These enhancements help you implement best practices for managing your data agent artifacts and tracking changes, leading to more reliable and collaborative development. Benefits of CI/CD and ALM Flow Fabric data agents support a variety of data sources, including Lakehouse, Warehouse, Power BI Semantic … Continue reading “Fabric Data Agent now supports CI/CD, ALM Flow, and Git Integration”
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”
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”
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)”
