Business Intelligence, Data Warehouse and Data Lake

SQW04 Where We're Going, We Don't Need Servers: Serverless SQL Pools in Azure Synapse Analytics

11/16/2022

9:30am - 10:45am

Level: Introductory

Kevin Feasel

Proprietor

Catallaxy Services, LLC

Within Azure Synapse Analytics, the serverless SQL pool allows users to query data in a data lake using T-SQL but without spinning up dedicated resources. This lets data analysts, developers, and database administrators spelunk through the data without the need to integrate this data into a more permanent solution. In this talk, we will look at how to use serverless SQL pools, including how serverless SQL pools integrate with existing dedicated SQL pools and Spark pools. Then, we will gain a better understanding of the pricing model for serverless SQL pools in comparison to dedicated SQL pools. Finally, we will discuss good practices around maximizing value when working with serverless SQL pools. This includes performance tuning, cost management, and data preparation tips.

You will learn:

  • Gain an understanding of the different Azure Synapse Analytics pools
  • How to interact with the serverless SQL pool
  • How to optimize serverless SQL pool queries and save money along the way