sql-data-warehouse-overview-develop.md

title	Resources for developing a dedicated SQL pool (formerly SQL DW) in Azure Synapse Analytics
description	Development concepts, design decisions, recommendations, and coding techniques for a dedicated SQL pool (formerly SQL DW) in Azure Synapse Analytics.
author	XiaoyuMSFT
ms.author	xiaoyul
ms.date	08/29/2018
ms.service	azure-synapse-analytics
ms.subservice	sql-dw
ms.topic	concept-article

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.