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.
Overview
Syllabus
Introduction
Resources
Architecture
SQL Server Linked Servers
Distribution of Tables
Index Options
Data Movement Types
Parallelization
Azure Portal
Data Model
Basic Queries
Change Request Status
Longrunning Queries
Performance Considerations
Beth Wolfset
Primary and Foreign Keys
Taught by
PASS Data Community Summit
Related Courses
-
Work with Data Warehouses using Azure Synapse Analytics
-
Architect a data platform in Azure
-
Azure SQL Data Warehouse Synapse Analytics Service
-
Winning with Column Store in SQL Server 2016 - A Customer Story
-
Head to Head - SSIS Versus Azure Data Factory
-
Azure Big Data and MPP Offerings - Summit Preview
