Explore design and data modeling considerations for optimizing Azure Data Warehouse performance in this conference talk. Learn about architecture, SQL Server linked servers, table distribution, index options, data movement types, and parallelization. Discover how to leverage the Azure Portal, create effective data models, and write efficient queries. Gain insights into managing change request status, addressing long-running queries, and implementing performance considerations. Understand the importance of primary and foreign keys in Azure Data Warehouse design. Benefit from Beth Wolfset's extensive experience in data architecture and practical approach to balancing current requirements with future needs.