Category: Warehouse
03
Aug
How to check table sizes in a Microsoft Fabric warehouse
by Nikola
No Comments
If you've tried to check how much storage your Fabric warehouse tables consume, you've probably discovered that the usual SQL Server approaches don't work. This...
31
Jul
Analytics Engineering Data Architecture Data Engineering Data Modeling Microsoft Fabric OneLake T-SQL Warehouse
(Don’t) Stop materializing your silver layer!
by Nikola
1 Comment
Why is your silver layer a set of tables? Challenging the fully materialized medallion pattern - with benchmark numbers and reproducible demo scripts.
01
Jul
One-minute trap! How new Fabric Warehouse CU metering affect your workloads
by Nikola
3 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
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
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...