Fabric in Production
Andy This is a placeholder blog which will be revisted many, many times over the coming months. This is a list of features for Fabric that I feel need to be…
Getting Started with Microsoft Fabric: Enabling 60-Day Trial and Analysing Data
There's been an exciting new announcement at Microsoft Build in the form of Microsoft Fabric, a unified platform that brings together Data Engineering, Data Warehousing, Data Science, Real-time analytics, and…
Synapse Link for Dataverse: Delta Lake Export Configuration
Welcome to part 2 in the Synapse Link for Dataverse Delta Lake series. In the recently released functionality in Synapse Link for Dataverse to export to Delta Lake format, this…
Synapse Link for Dataverse: Exporting to Delta Lake
Microsoft recently released the ability to configure Synapse Link for Dataverse and use Delta Lake as the export format. As I've dived into the Synapse Link for Dataverse feature recently…
Parallel Loading of Tables with Power BI & Azure Synapse Analytics
In this blog I'm continuing my series about using Power BI and Azure Synapse Analytics together and the features between the 2 platforms that are useful. The first blog covered…
What Does A “Conformed Dimension” Actually Do?
Every so often the "star schema is dead! dimensional modelling is dead!" discussion rolls around again, and we end up in endless debates about the star schema, the alternatives, and…
Azure Synapse Serverless SQL Pools Cheat Sheet
Here's an Azure Synapse Serverless SQL Pools Cheat Sheet I created to help anyone reference any objects or syntax they may wish to create or use in Serverless SQL Pools.…
Why Cloud Data Platforms?
Always ask "why." I really couldn't think of a better blog title, I usually do technical stuff and the title writes itself in most cases. I also write more technical…
Understanding ResultSet Caching in Dedicated SQL Pools with Power BI
Welcome to this new blog series in which I'll be diving into both Power BI and Azure Synapse Analytics features that can work together. These features are not exclusive between…
Mastering DP-500 Exam: Upcoming Changes on February 6th
Some of the skills measured for the DP-500 Azure Enterprise Data Analyst Associate certification are changing on February 6th 2023 (thanks for the heads-up from Kevin Chant (t). Don't panic,…