Video: Fabric Open Mirroring: Mirror Any Data Into Fabric?
Andy 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…
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…
Fabric Workspace Storage Analysis
Challenge: How can I see the underlying storage and files being used in my Fabric items like Lakehouses and Warehouses and check if files still exist even after I delete…
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…