Are you ready to unlock the massive power of Synapse SQL Pools? Do you want to see some of the features that are coming and what impact they will have on your workloads?

Join us to learn and apply the best strategy when it comes to ingesting and consuming your data with Azure Synapse!

The day will be packed with tips and tricks for your Data Warehouse from two folks who work on the largest deployments in the world!

In the morning we will ease into Synapse and explaining all key features, from there on we will deep dive into the Polaris engine and how it changes the game.

The focus of the morning will be around Dedicated SQL pools and how to get the best performance out of it. We will look at loading patterns and ways to optimize these, table distribution issues, security features, statistics handling, workload management, streaming data and indexing strategies!

After lunch we handle the other side of our Synapse Pool environment: Serverless. We will explain how it works, and how to optimize the reading patterns. We will touch upon delta lake and how it fits in, parquet file structure, flat file differences, security features, partitioning strategies, optimized data loading with Spark and many more.

After this day you will be able to tackle any issues you face to build a performant, cost efficient and dynamic data warehouse with Azure Synapse SQL Pools.