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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
Andy