Azure SQL Database documentation

Azure SQL Database

What's new

• What's new?

Quickstart

• Create SQL Database
• Configure firewall

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

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
• 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

How-To Guide

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

Monitor Azure SQL Database

Concept

• 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)
• Azure Data Studio
• SQL Server Data Tools
• Visual Studio 2019

Reference

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