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…
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…
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.…
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…
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…
This was originally posted on my Datahai company blog in November 2021. This blog has now been updated as of November 2022 as certain steps have changed, notably the movement…
I'm currently in the process of building a Query and Workload Analyser Power BI report which queries several DMVs (Dynamic Management Views) in Synapse Dedicated SQL Pools. One of the…
Recently I have been exploring an option to use an Azure SQL Database for a small footprint Data Warehouse and wondered whether I could create an elastic query connection to…
This blog is marked as intermediate knowledge as an understanding of Serverless SQL Pools is preferable, but not essential. Refer to Getting Started with Serverless SQL Pools to understand the service and how to…
This blog is marked as intermediate knowledge as an understanding of Serverless SQL Pools is preferable, but not essential. Refer to Getting Started with Serverless SQL Pools to understand the…
Andy