Summary

Intermediate
4m 12s
2,860
4.8/5

This lesson explains how to optimize dedicated SQL pools in Azure Synapse Analytics using different data distribution methods, partitioning, and query optimization. It also gives a quick overview of the security and disaster recovery features of dedicated SQL pools.

Learning Objectives

  • Know when to use round-robin, hash-distributed, and replicated distributions
  • Know when to partition a table
  • Optimize queries using statistics, caching, and log investigation
  • Understand the security and disaster recovery features of dedicated SQL pools

Intended Audience

  • Anyone who would like to learn advanced features of dedicated SQL pools in Azure Synapse Analytics

Prerequisites

About the Author
Avatar
Guy Hummel, opens in a new tab
Azure and Google Cloud Content Lead
Students
238,671
Courses
101
Learning paths
170

Guy launched his first training website in 1995 and he's been helping people learn IT technologies ever since. He has been a sysadmin, instructor, sales engineer, IT manager, and entrepreneur. In his most recent venture, he founded and led a cloud-based training infrastructure company that provided virtual labs for some of the largest software vendors in the world. Guy’s passion is making complex technology easy to understand. His activities outside of work have included riding an elephant and skydiving (although not at the same time).

Covered Topics