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…
Databricks Certified Data Engineer Professional: Resources
Overview Each of the 6 sections below have several skills being measured for the Databricks Certified Data Engineer Professional. The resources are links to blogs that look to cover those…
Exploring Open Mirroring in Microsoft Fabric
Overview Announced at Microsoft Ignite on November 24 were a batch of new features for Fabric, the most exciting and useful to me was Open Mirroring. This feature allows data…
Video: Fabric Open Mirroring: Mirror Any Data Into Fabric?
Fresh from Microsoft Ignite on November 24, Microsoft has introduced a new feature in Fabric, Open Mirroring. This feature allows you to mirror data from any source (well, we'll go into…
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…
Fabric Warehouse Monitoring with Dynamic Management Views (DMVs)
Overview Monitoring warehouse queries is crucial for maintaining the efficiency and performance of SQL Analytics Endpoints and Warehouses. This blog post explores the use of Dynamic Management Views (DMVs) to…
DP-700 Microsoft Fabric Data Engineering Associate – Skills Measured Resources
New certification time! At FabCon Europe, a new certification was announced...the Microsoft Fabric Data Engineering Associate. This joins the DP-600 as the next Fabric-based cert and focuses more on data…
Reallocate Workspaces To A Different Fabric Capacity: Low Code Solution
Overview I'm not saying this blog coincides with the current active Fabric Trials coming to an end, but... What we're trying to do here is move Workspaces from one Fabric…
Fabric Warehouse Monitoring and Query Performance Analysis
Overview Warehouse Monitoring and Query Performance Analysis? Yes...it's important! You've spent time building a Data Warehouse & Analytical solution in Microsoft Fabric using the Warehouse service, you need to monitor…