Azure SQL Database documentation

Find concepts, quickstarts, tutorials, and samples for singled and pooled databases in Azure SQL Database.

Azure SQL Database

What's new

• What's new?

Quickstart

• Create SQL Database
• Configure firewall
• Try for free

Concept

• What is SQL Database?
• What is an elastic pool?
• Purchasing models
• Hyperscale service tier
• Migrate from SQL Server
• T-SQL differences with SQL Server
• Dynamically scale up or down
• Plan for Azure maintenance events

Learn Azure SQL

Training

• Azure SQL for beginners
• Azure SQL fundamentals
• Azure SQL hands-on labs
• Azure SQL bootcamp
• Educational SQL resources

video

• Azure SQL for beginners
• Azure SQL Database essentials

Artificial Intelligence

Concept

• Copilot in Azure SQL Database
• Intelligent Applications

Advanced security

Concept

• Security capabilities
• Security best practices
• Logins, user accounts, roles, and permissions
• Microsoft Defender for SQL
• Microsoft Entra ID (formerly Azure Active Directory)
• Auditing
• Transparent Data Encryption (TDE)
• Dynamic Data Masking

Business continuity

How-To Guide

• Business continuity
• Automated backups
• High availability
• Enable zone redundancy
• Active-geo replication
• Failover groups
• Recover with backup
• Long-term backup retention

Scalability

How-To Guide

• Read Scale-Out
• Cross database jobs
• Elastic scale
• Elastic query

Development

Overview

• Application development
• Connect apps to Azure SQL
• Disaster recovery app design
• Managing rolling upgrades
• SaaS database tenancy patterns

How-To Guide

• Design first database (SSMS)
• Design first database (C#)

Monitor Azure SQL Database

Concept

• Database watcher (Preview)
• Metrics and alerts
• Azure Monitor
• Dynamic management views (DMVs)

Reference

Deploy

• Azure CLI samples
• PowerShell samples
• ARM template samples

Download

• SQL Server Management Studio (SSMS)
• SQL Server Data Tools
• Visual Studio 2022

Reference

• Migration guide
• Transact-SQL (T-SQL)
• Azure CLI
• PowerShell
• REST API