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