The easiest way to skyrocket your YouTube subscribers
Get Free YouTube Subscribers, Views and Likes

André Kamman: Synapse Analytics Dedicated SQL Pool Best Practices

Follow
Ceteris AG

This is from Microsoft Data & AI Meetup Berlin on the 18th of February 2021:

#### Practical Data Distribution in Dedicated SQL Pools #####
Having just finished a project where 200+ TB of data was moved to a Synapse Dedicated SQL pool, formerly SQL DW, I learned that there is no one size fits all method regarding how you partition and distribute your data and what your index options are. (Hint, column store is not always a good choice)
This session is demo heavy based on notes from the field, mixed with some diagrams to explain the theory behind what we are seeing.

André is a SoCalled Modern Data Engineer and architecht for mostly in Azure. He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML), and even implementing PDW. Having to wrangle a lot of data he's using Python, SparkSQL in Azure Databricks, Data Factory and Power BI as well these days. André is a Data Platform MPV, Dutch PASS Chapter, Leader organiser of SQL Saturday Holland and Data & BI track volunteer for Techorama Holland

posted by Granciaf0