Synapse Analytics Source Control with Serverless SQL Pools Databases
Working with source control in a Synapse Analytics workspace is a fairly straight-forward process, however you only have a choice...
Optimisation
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...
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...
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...
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...
Connecting Power BI to Azure SQL Database using Private Endpoints
This was originally posted on my Datahai company blog in November 2021. This blog has now been updated as of...
Dedicated SQL Pools DMVs: Show Name of Synapse Studio Script Being Executed
I'm currently in the process of building a Query and Workload Analyser Power BI report which queries several DMVs (Dynamic...
Elastic Queries with Azure SQL Database and Synapse Analytics Serverless SQL Pools
Recently I have been exploring an option to use an Azure SQL Database for a small footprint Data Warehouse and...
Use Azure Log Analytics to analyse Azure Data Lake Gen2 activity from Serverless SQL Pools
This blog is marked as intermediate knowledge as an understanding of Serverless SQL Pools is preferable, but not essential. Refer to Getting Started...
Use Azure Storage Logs to analyse Synapse Analytics Serverless SQL Pools Activity
This blog is marked as intermediate knowledge as an understanding of Serverless SQL Pools is preferable, but not essential. Refer...
