Data Mozart

Category: Warehouse

01 Jul
Data Architecture Data Engineering Microsoft Fabric Warehouse

One-minute trap! How new Fabric Warehouse CU metering affect your workloads

by Nikola
No Comments
Microsoft is moving Fabric Warehouse CU metering from per-query CPU time to per-workspace virtual-node time. That brings Fabric closer to Snowflake and Databricks, but it...
18 Jun
Data Architecture Data Engineering Data Integration Lakehouse Microsoft Fabric Warehouse

Variable libraries in Microsoft Fabric: One value to rule them all!

by Nikola
No Comments
Hardcoded values are the cockroaches of a data platform: you think you got them all, then Test starts reading from Prod and nobody notices for...
20 May
Data Architecture Data Engineering Microsoft Fabric T-SQL Warehouse

CLUSTER BY in Fabric Warehouse: when the magic shows up and when it doesn’t!

by Nikola
No Comments
Microsoft's announcement post for data clustering in Fabric Warehouse promised 24x speedups. So I built a 100-million-row clickstream table and tested it myself. The result...