What Does A “Conformed Dimension” Actually Do?
Andy 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…