What started as Azure SQL Data Warehouse, has now evolved into Synapse Analytics, an all-encompassing analytics development service full of new features.

A key component of these new capabilities is the SQL Serverless Pool. This new db engine allows for querying and exploration of file based data through the familiar T-SQL syntax that we know. It also has a different cost model and internals.

In this demo-heavy session we will go over the main concepts behind Serverless Pools as well as demos to showcase the major features like EXTERNAL TABLES and the extended OPENROWSET function.