External Tables vs Views…Which to Use and Why?
Andy Serverless SQL Pools do not contain data (unlike Dedicated SQL Pools) but rather allow you to cast structure over data in Azure Storage, Azure Data Lake Gen1 & 2, Cosmos…
Azure Storage Folder Filtering using the Filepath Function
Serverless SQL Pools includes 2 SQL functions, filepath and filename, that can be used to return the folder path/name and file name from which a row of data originates from…
10 Billion Rows: Parquet File Size and Distribution When using CETAS
When using Serverless SQL Pools to write data to Azure Storage/Data Lake Gen2 using the CREATE EXTERNAL TABLE AS SELECT (CETAS) syntax, the number of source rows and size of…
Creating a Logical Data Warehouse with Synapse Serverless SQL: Part 4 of 4 – Connecting Power BI to the Dimensional Model
Welcome to Part 4 in the Creating a Logical Data Warehouse with Synapse Serverless SQL Pools series. We are now looking at connecting Power BI to Serverless SQL Pools to…
Creating a Logical Data Warehouse with Synapse Serverless SQL: Part 3 of 4 – Incremental Fact Loading and Slowly Changing Dimensions
Welcome to part 3 of the Logical Data Warehouse with Serverless SQL Pools series. In this part we'll be covering Incrementally loading Fact data when new sales data becomes available…
Creating a Logical Data Warehouse with Synapse Serverless SQL: Part 2 of 4 – Creating a Dimensional Model
Welcome to part 2 of this 4 part blog series on creating a Logical Data Warehouse with Azure Synapse Analytics Serverless SQL. Please note that we are only using Serverless…
Creating a Logical Data Warehouse with Synapse Serverless SQL: Part 1 of 4 – Setting Up and Querying Source Data
Welcome to part one of a four part blog series where we'll be looking at one of the main scenarios that Microsoft state Azure Synapse Analytics Serverless SQL can be…
Azure Synapse Analytics Serverless SQL Pools Learning Resources
Welcome to this collection of links to resources focussed on Azure Synapse Analytics Serverless SQL Pools. It includes official Microsoft documentation, the Learning courses available, and also community content such…
Azure Synapse Analytics Serverless SQL Best Practices
Microsoft have a best practices document available here which highlights certain actions that can be taken to optimise use of the Serverless SQL service within Azure Synapse Analytics. The best…
Getting Started with Azure Synapse Analytics SQL Serverless
The new Azure Synapse Analytics SQL Serverless service enables querying file-based data stored in an Azure Data Lake Gen2 storage account by using familiar T-SQL. The data remains stored in…