Topic:

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.

Speaker: Warner Chaves

Warner is a SQL Server MCM, Data Platform MVP and Principal Consultant at Pythian, a global Canada-based company specialized in DBA services. A brief stint in .NET programming led to his early DBA formation working for enterprise customers in Hewlett-Packard ITO organization. From there he transitioned to his current position at Pythian, building and managing data solutions in many industry verticals while leading a highly talented team of multi-platform consultants and engineers.

Links:

https://www.meetup.com/dba-fundamentals-group/events/281926242