Synapse Serverless and Dedicated Pool: The differences no one told you about


 

The basic differences between Synapse Serverless and the Dedicated pool are obvious: While the serverless doesn’t store data, only access data from storage accounts and scale the MPP environment automatically, the dedicate SQL Pool keeps a static number of servers according to the service level we choose and a constant number of distributions – always 60.

About these basic differences, I wrote 3 articles about Synapse Serverless:

How to query blob storage with SQL using Azure Synapse How to query private blob storage with SQL and Azure Synapse Performance of querying blob storage with SQL 

I also wrote