Kevin Conan

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. 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.

Data Architects, let's tackle one of the most common performance pitfalls that people encounter with Synapse Dedicated SQL Pools! We'll work from the ground up so anyone new to Synapse Dedicated SQL Pools will understand the different data distribution methods and index options. Then we'll go though recommendations on when you should pick the best options to increase your workload performance and possibly save you money which will make you look like a hero!