Optimizing Dedicated SQL Pools in Azure Synapse Analytics

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

• Some knowledge of Azure Synapse Analytics (take Introduction to Azure Synapse Analytics if you’re not familiar with this Microsoft service)
• Experience with SQL (not mandatory)