Synapse Link for Dataverse: Exporting to Delta Lake
Andy 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,…
Partition Pruning with Delta Tables in Azure Synapse Analytics
A question that is often asked about Azure Synapse Analytics is how it handles Delta tables that are partitioned. Delta tables (or the Delta Lake) is one of the technologies…
Synapse Link for Dataverse: Video Series
I've been diving into Synapse Link for Dataverse recently for a project and created a series of videos going through setting up Synapse Link with Dynamics 365 Sales and syncronising…
Azure Analysis Services Migration to Power BI Premium
Around November 2022, Microsoft announced a new feature within Power BI which allows you to migrate Tabular models from Azure Analysis Services into Power BI Premium. This interested me as…