Azure SQL Database

Azure SQL Database is a fully managed Platform as a Service (PaaS) database engine that handles most database management functions such as upgrading, patching, backups, and high availability without user involvement.

Note: Azure SQL Database is built on the SQL Server engine, offering broad compatibility with on-premises SQL Server.

Getting Started

Learn how to quickly set up and connect to your first Azure SQL Database.

Core Concepts

Understand the fundamental building blocks and design principles of Azure SQL Database.

Architecture

Azure SQL Database offers a cloud-native architecture optimized for performance, scalability, and reliability. It includes features like automated backups, point-in-time restore, and transparent data encryption.

Deployment Options

Choose the deployment model that best suits your needs:

  • Single Database: An isolated database with its own set of resources managed via an Azure SQL logical server. Ideal for new cloud applications.
  • Elastic Pool: A collection of databases with shared resources. Cost-effective for applications with fluctuating resource needs.
  • Azure SQL Managed Instance: A fully managed instance of the SQL Server engine with near 100% compatibility with on-premises SQL Server. Ideal for lift-and-shift scenarios.

Performance Tiers

Azure SQL Database offers various service tiers to meet different performance and cost requirements:

  • General Purpose: Balances cost and performance for common workloads.
  • Business Critical: Offers the highest level of performance and availability for demanding transactional workloads.
  • Hyperscale: Provides elastic storage and compute scaling for very large databases.
Tip: Use the DTU-based or vCore-based purchasing models to select the right resources for your workload.

Key Features

Discover the advanced capabilities that make Azure SQL Database a powerful database solution.

Automatic Tuning

Leverage AI-driven insights to automatically identify and resolve performance issues without manual intervention.

Azure Defender for SQL

Enhance your security posture with advanced threat detection that monitors for anomalous activities and potential threats.

Intelligent Query Processing

Benefit from continuous improvements in query performance through features like intelligent plan selection and adaptive query processing.

Tutorials

Dive deeper with hands-on tutorials:

Quickstarts

Get started quickly with these concise guides:

API & Reference

Access comprehensive API documentation and technical references.

Always refer to the latest official Microsoft documentation for the most up-to-date information.