Design decisions and coding techniques for a dedicated SQL pool (formerly SQL DW) in Azure Synapse Analytics

In this article, you'll find additional resources to help you better understand key design decisions, recommendations, and coding techniques for a dedicated SQL pool (formerly SQL DW) in Azure Synapse.

Key design decisions

The following articles highlight concepts and design decisions for developing a distributed data warehouse using the dedicated SQL pool (formerly SQL DW) capability in Azure Synapse:

• connections
• concurrency
• transactions
• user-defined schemas
• table distribution
• table indexes
• table partitions
• CTAS
• statistics

Development recommendations and coding techniques

The following articles feature specific coding techniques, tips, and recommendations for developing a dedicated SQL pool (formerly SQL DW):

• stored procedures
• labels
• views
• temporary tables
• dynamic SQL
• looping
• group by options
• variable assignment

Next steps

For more reference information, see T-SQL statements.