Designing for Azure Data Warehouse Performance - Cloud
PASS Data Community Summit via YouTube
The Fastest Way to Become a Backend Developer Online
Live Online Classes in Design, Coding & AI — Small Classes, Free Retakes
Overview
Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
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.
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