Optimisation

Andy July 7, 2022

Welcome to the 3rd and final part in this blog series in which we're looking at how Azure Synapse Analytics...

Andy June 30, 2022

Welcome to part 2 in this blog series in which we're looking at what happens when schema changes are made...

Andy March 24, 2022

Serverless SQL Pools offers a straight-forward method of querying data including CSV, JSON, and Parquet format stored in Azure Storage....

Andy February 10, 2022

In part one we looked at a process in which a pre-aggregated dataset can be created by Azure Synapse Analytics...

Andy January 27, 2022

Dedicated SQL Pools have a feature called Materialized Views which can generate a pre-calculated/processed dataset ready for consumption and is...

Andy December 23, 2021

In this video we're talking a look at the new Power BI Hybrid Tables feature which combines Import, Incremental Refresh,...

Andy December 16, 2021

One of the objects that can be created within a Serverless SQL Pools database is a View. A View, along...

Andy December 9, 2021

A recent feature to be released for Serverless SQL Pools is error handling when processing external data (please see the...

Andy August 29, 2021

Temporary (temp) tables have been a feature of Microsoft SQL Server (and other database systems) for many years. Temp tables...

Andy July 22, 2021

Serverless SQL Pools do not contain data (unlike Dedicated SQL Pools) but rather allow you to cast structure over data...