Warehouse

Andy January 10, 2025 0

Overview Welcome to the world of Microsoft Fabric Warehouses and the deployment of data loading projects using Dbt (Data Build...

Andy December 20, 2024 1

Overview Relationships are tricky at the best of times...but working with relationships between tables in Fabric Warehouses and Semantic Models...

Andy October 4, 2024 0

Overview V-Order is Microsoft's "special sauce" to further optimise data within Parquet files and is a read optimiser feature. V-Order...

Andy August 25, 2024 0

With cloud technology, vendors will say you don't have to worry about anything, it just works! It's magic to a...

Andy July 22, 2024 0

Overview With the recent announcement from Microsoft that ALTER TABLE...ADD COLUMN is now supported in Fabric Warehouses, you might be...

Andy June 14, 2024 0

Overview Welcome to part 3 of this Fabric Warehouse for the DBA series in which we'll look at the Fabric...

Andy May 2, 2024

Overview This is the second part of the Fabric Warehouses for DBAs blog series, if you haven't read the first...

Andy April 24, 2024

Overview Let me start off this blog post by saying that no matter what data role you have, it's important...

Andy November 4, 2023

Here are the slides for my Fabric SQL Warehouse session at #DataWeekender 6.5. Download PDF now. Session Slideshow You can...

Andy October 6, 2023

Fabric Warehouses are a SQL focused service for building data warehouse structures within a Fabric (Power BI) workspace. The storage...