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...
Serverless SQL Pools
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...
How does Serverless SQL Pools deal with different file schemas? Part 2 – Parquet
Welcome to part 2 in this blog series in which we're looking at what happens when schema changes are made...
Lake Databases And The Importance of Data Types
I encountered an issue with Azure Synapse Analytics Lake Databases and I'd like to share the problem and the solution....
How does Serverless SQL Pools deal with different file schemas? Part 1 – CSV
Serverless SQL Pools offers a straight-forward method of querying data including CSV, JSON, and Parquet format stored in Azure Storage....
Integrating Power BI & Azure Synapse Analytics – Power BI UK User Group
Here is the link to the slides for the Power BI UK User Group session on Thursday 17th March, 2022...
Using CETAS in Serverless SQL Pools to Generate Pre-Calculated Datasets – Part 1 of 2
Dedicated SQL Pools have a feature called Materialized Views which can generate a pre-calculated/processed dataset ready for consumption and is...
Power BI Hybrid Tables with Synapse Analytics Serverless SQL Pools
In this video we're talking a look at the new Power BI Hybrid Tables feature which combines Import, Incremental Refresh,...
View Generation in Serverless SQL Pools
One of the objects that can be created within a Serverless SQL Pools database is a View. A View, along...
Testing Error Handling in Serverless SQL Pools
A recent feature to be released for Serverless SQL Pools is error handling when processing external data (please see the...
