Skip to content

🗄️ Dedicated SQL Pool

Status Complexity Last Updated

Enterprise data warehousing solution within Azure Synapse Analytics.

🎯 Overview

Dedicated SQL Pool (formerly Azure SQL Data Warehouse) provides a massively parallel processing (MPP) engine for enterprise-scale analytics workloads.

Key Capabilities

  • Petabyte-scale data warehousing
  • Massively parallel query processing
  • T-SQL compatibility for existing SQL skills
  • Workload isolation with resource classes
  • Pause/Resume for cost optimization

📚 Documentation

Topic Description
Sizing Guide DWU selection and capacity planning
Performance Tuning Query optimization techniques
Cost Management Cost optimization strategies
Troubleshooting Common issues and solutions

🚀 Quick Start

-- Create a simple table
CREATE TABLE dbo.sales_fact
(
    sale_id BIGINT NOT NULL,
    customer_key INT NOT NULL,
    product_key INT NOT NULL,
    sale_amount DECIMAL(18,2),
    sale_date DATE
)
WITH
(
    DISTRIBUTION = HASH(customer_key),
    CLUSTERED COLUMNSTORE INDEX
);

-- Load data from Data Lake
COPY INTO dbo.sales_fact
FROM 'https://datalake.dfs.core.windows.net/bronze/sales/*.parquet'
WITH (
    FILE_TYPE = 'PARQUET',
    CREDENTIAL = (IDENTITY = 'Managed Identity')
);

Last Updated: January 2025