Overview Recently I've been reading through Microsoft's documentation on implementing medallion lakehouse architecture in Microsoft Fabric (doc is here) and thinking about how to structure the workspaces & lakehouses to…
Well this new Explore This Data (link) feature in Power BI surprised me, both in terms of usefulness and in how much I'm currently using it. I don't usually spend…
As I start to look at how to architect and develop data solutions using Microsoft Fabric, I come back to the thought in my head of how to detect changes…
Ignite is always exciting as there's always a bunch of new announcements, and included in this excitement is a new Microsoft certification, the Microsoft Certified: Fabric Analytics Engineer Associate. This…
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.
Microsoft announced a new accreditation path recently called Microsoft Applied Skills (link here), a set of bite sized assessments in particular areas of MS technology. They're not designed to provide…
I joke about “I’m not much of a Spark Developer” all the time and I’m not joking, really I’m not. I’m a SQL developer. I’ve built Data Warehouses using SQL.…
Working with source control in a Synapse Analytics workspace is a fairly straight-forward process, however you only have a choice between Azure DevOps or GitHub, and it only works with…
Fabric Warehouses are a SQL focused service for building data warehouse structures within a Fabric (Power BI) workspace. The storage of Warehouses is based on the Delta Lake format utilizing…
Recently I had a challenge in terms of providing a least permissions possible security model for a Data Engineer persona when working with Synapse Analytics. I won't go into detail…
Andy