Working with Dbt and The Fabric Warehouse
Andy Overview Welcome to the world of Microsoft Fabric Warehouses and the deployment of data loading projects using Dbt (Data Build Tool). In this blog I'll work through how these technologies…
Table Relationships in Fabric Warehouses: Impact on the Semantic Model
Overview Relationships are tricky at the best of times...but working with relationships between tables in Fabric Warehouses and Semantic Models has some nuances that I'd like to share. We'll first…
Performance Analysis of V-Ordering in Fabric Warehouse: On or Off?
Overview V-Order is Microsoft's "special sauce" to further optimise data within Parquet files and is a read optimiser feature. V-Order also helps optimise Power BI DirectLake functionality. However, V-Order comes…
10 Tips for Data Warehousing in the Cloud
Overview This blog post takes a little step back from specific technology itself, something I feel is very important to do. I'll delve into 10 tips when looking at Data…
Microsoft Fabric Warehouses for the Database Administrator: Areas of Interest
With cloud technology, vendors will say you don't have to worry about anything, it just works! It's magic to a certain extent but also can be disconcerting if you can't…
The Reality of ALTER TABLE… in Fabric Warehouses
Overview With the recent announcement from Microsoft that ALTER TABLE...ADD COLUMN is now supported in Fabric Warehouses, you might be forgiven for saying "So what? Database systems have had this…
Microsoft Fabric Warehouse for the Database Administrator (DBA) Part 3: Fabric Compute
Overview Welcome to part 3 of this Fabric Warehouse for the DBA series in which we'll look at the Fabric Compute that underpins the Fabric Warehouse (and Lakehouse SQL Endpoint)…
Microsoft Fabric Warehouse for the Database Administrator (DBA): Fabric & Warehouse Service Overview
Overview This is the second part of the Fabric Warehouses for DBAs blog series, if you haven't read the first part which is an overview of the series and includes…
Microsoft Fabric Warehouse for the Database Administrator (DBA): Series Overview
Overview Let me start off this blog post by saying that no matter what data role you have, it's important to handle data you use with care. If you're a…
#DataWeekender 6.5 Fabric SQL Warehouse Session
Here are the slides for my Fabric SQL Warehouse session at #DataWeekender 6.5. Download PDF now. Session Slideshow You can browse the session slides in the image gallery below.