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...
Andy
Mastering DP-500 Exam: Querying JSON Data in Serverless SQL Pools
This blog forms part of the DP-500 blog series on this site here and also from Data Mozart's blog here....
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...
User Permissions in Serverless SQL Pools: External Tables vs Views
In a recent Synapse Analytics Serverless SQL Pools QnA session, the Serverless SQL Pools team stated that using External Tables...
Up and Running: How to make your Azure Synapse Analytics Proof of Concept a Success (Data Relay Session)
Firstly, I'd like to say a huge thank you to the Data Relay team, the helpers, the sponsors, the attendees,...
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...
PASS Summit Recording Available: Creating a Logical Data Warehouse using Azure Synapse Analytics Serverless SQL Pools
My PASS Data Community Summit 2021 recording is now available, please click here for the recording. I've re-watched the session...
How does Serverless SQL Pools deal with different file schemas? Part 3 – Delta
Welcome to the 3rd and final part in this blog series in which we're looking at how Azure Synapse Analytics...
