Design decisions and coding techniques for a dedicated SQL pool 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 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 capability in Azure Synapse:
- user-defined schemas
- table distribution
- table indexes
- table partitions
Development recommendations and coding techniques
The following articles feature specific coding techniques, tips, and recommendations for developing a dedicated SQL pool:
- stored procedures
- temporary tables
- dynamic SQL
- group by options
- variable assignment
For more reference information, see T-SQL statements.