Azure SQL Database Documentation

Welcome to the comprehensive documentation for Azure SQL Database. This guide provides resources to help you build, deploy, and manage relational databases in the cloud.

Getting Started

Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.

Learn how to create your first Azure SQL Database in our Quickstart: Create an Azure SQL Database using the Azure portal.

Key Features

Intelligent Performance: Automatic performance tuning, query performance insights, and adaptive query processing.
High Availability: Built-in disaster recovery and automated backups ensure your data is always accessible.
Scalability: Easily scale your database resources up or down based on demand.
Security: Advanced threat protection, data encryption, and granular access control.
Hybrid Capabilities: Seamlessly connect to on-premises data with Azure Arc.

Explore Core Concepts

Understand the fundamental building blocks of Azure SQL Database:

Reference Material

Access detailed API references, T-SQL syntax, and management tools:

T-SQL Reference:

SELECT * FROM sys.databases;

For full T-SQL language reference, visit the T-SQL Language Reference.

REST API:

Manage Azure SQL Database resources programmatically using the Azure REST API. Learn more in the Azure SQL Database REST API Reference.

Tip:

Leverage Azure Advisor for personalized recommendations on performance, security, and cost optimization for your SQL Database.