Table Distribution in Dedicated Pool: That is not "a simple table"

Italiano Intermediate Data & AI

Dedicated Pool refers to the enterprise data warehousing features that are available in Azure Synapse Analytics. Its engine is based on SQL Server's one and working with it will be very familiar for SQL Server people. Do you need a table? You can start with CREATE TABLE command but, be aware that Dedicated Pool is a distributed engine and that table could be Replicated or Distributed over multiple nodes. Distribution, Data Skew, Data Movement are "new concepts" you must be familiar with to get better performance in a Dedicated Pool.


Riccardo Perico

BI & Power BI Engineer @ Lucient | Microsoft Data Platform MVP

Back in 2010 I started working in Information Technology. After a brief experience as ERP Consultant, I moved into Data Realm. I spent these years exploring Data world from different points of view, both as DBA and Business Intelligence Engineer. I'm a Microsoft Certified Professional (MCP), Microsoft Data Analyst Associate, Microsoft Technology Associate (MTA), Microsoft Certified Solution Associate (MCSA) in database, BI and Azure areas. Microsoft MVP for Data Platform category. I'm one of the leaders of Power BI User Group in Italy and I'd been speaker during the Power Platform World Tour and Power Platform Bootcamp stops in Italy. I'm also speaker during Azure Saturday, SQL Saturday and Data Saturday events in Europe. Last but not least, Hard Rock and Heavy Metal addicted!

Code of Conduct

We seek to provide a respectful, friendly, professional experience for everyone, regardless of gender, sexual orientation, physical appearance, disability, age, race or religion. We do not tolerate any behavior that is harassing or degrading to any individual, in any form. The Code of Conduct will be enforced.

Who does this Code of Conduct apply to?

All live stream organizers using the Global Azure brand and Global Azure speakers are responsible for knowing and abiding by these standards. Each speaker who wishes to submit through our Call for Presentations needs to read and accept the Code of Conduct. We encourage every organizer and attendee to assist in creating a welcoming and safe environment. Live stream organizers are required to inform and enforce the Code of Conduct if they accept community content to their stream.

Where can I get help?

If you are being harassed, notice that someone else is being harassed, or have any other concerns, report it. Please report any concerns, suspicious or disruptive activity or behavior directly to any of the live stream organizers, or directly to the Global Azure admins at All reports to the Global admin team will remain confidential.

Code of Conduct for local live streams

We expect local organizers to set up and enforce a Code of Conduct for all Global Azure live stream.

A good template can be found at, including internationalized versions at An excellent version of a Code of Conduct, not a template, is built by the DDD Europe conference at