Take a look through these development articles to better understand key design decisions, recommendations and coding techniques for SQL Data Warehouse.
Key design decisions
The following articles highlight some of the key concepts and design decisions you will need to understand for the development of your distributed data warehouse using SQL Data Warehouse:
- user-defined schemas
- table distribution
- table indexes
- table partitions
Development recommendations and coding techniques
These articles highlight specific coding techniques, tips and recommendations for developing your SQL Data Warehouse:
- stored procedures
- temporary tables
- dynamic SQL
- group by options
- variable assignment
Once you have been through the development articles take a look through the Transact-SQL reference page for more details on the supported syntax for SQL Data Warehouse.