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!…
Serverless SQL Pools offers a straight-forward method of querying data including CSV, JSON, and Parquet format stored in Azure Storage. A common pattern is to move data from source systems…
Here is the link to the slides for the Power BI UK User Group session on Thursday 17th March, 2022 here. The video recording should be available soon.
Dedicated SQL Pools have a feature called Materialized Views which can generate a pre-calculated/processed dataset ready for consumption and is automatically updated as new data is added to its source…
In this video we're talking a look at the new Power BI Hybrid Tables feature which combines Import, Incremental Refresh, and DirectQuery (real-time) modes in a single table. We look…
One of the objects that can be created within a Serverless SQL Pools database is a View. A View, along with an External Table, allows us to cast structure over…
A recent feature to be released for Serverless SQL Pools is error handling when processing external data (please see the November 2021 Synapse Analytics update). When querying external data, Serverless…
Andy