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…
In a recent Synapse Analytics Serverless SQL Pools QnA session, the Serverless SQL Pools team stated that using External Tables rather than Views was preferred if you wanted to restrict…
Firstly, I'd like to say a huge thank you to the Data Relay team, the helpers, the sponsors, the attendees, the venues, venue staff, and speakers for making Data Relay…
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…
My PASS Data Community Summit 2021 recording is now available, please click here for the recording. I've re-watched the session and have some thoughts which are listed below in the…
Welcome to the 3rd and final part in this blog series in which we're looking at how Azure Synapse Analytics Serverless SQL Pools deals with changing schemas in CSV (delimited),…
Welcome to part 2 in this blog series in which we're looking at what happens when schema changes are made in source data lake files which is then queried by…
I encountered an issue with Azure Synapse Analytics Lake Databases and I'd like to share the problem and the solution. This really should be filed under "the solution was obvious!…
Andy