Azure SQL Database

Azure SQL Database
Name	Azure SQL Database
Developer	Microsoft
Operating system	Cloud platform
Genre	Relational database management system

Azure SQL Database. It is a fully managed Platform as a service relational database service built on the latest stable version of the Microsoft SQL Server database engine. Hosted on the Microsoft Azure cloud platform, it offers high availability, intelligent performance, and scalable compute and storage resources without infrastructure management. The service supports a broad range of application development frameworks and integrates with other Azure services for comprehensive cloud solutions.

Overview

As a core component of the Microsoft Azure data platform, this service is engineered for modern cloud applications, eliminating the need to manage underlying virtual machines or operating systems. It is built upon the same foundational codebase as Microsoft SQL Server, ensuring compatibility with existing Transact-SQL skills and tools like SQL Server Management Studio. The service is continually updated with the latest features from SQL Server, and its global presence is supported by a vast network of Microsoft datacenters, enabling deployment in regions worldwide. It forms a key part of the Azure SQL family of products, which also includes Azure SQL Managed Instance.

Features

Key capabilities include built-in high availability with a financially backed Service Level Agreement, leveraging local redundant or zone-redundant storage to protect data. Intelligent performance features, powered by Microsoft's Artificial intelligence, provide automatic tuning, performance recommendations, and adaptive query processing. Advanced security is integrated, featuring always-on encryption, dynamic data masking, and advanced threat protection. Other notable features include automated backups, point-in-time restore, and active geo-replication for disaster recovery, facilitating easy creation of readable secondaries in different Azure regions.

Deployment models

The service offers two primary deployment options to cater to different application architectures and migration paths. The single database model represents a fully isolated database with its own guaranteed set of resources within a logical server, ideal for modern cloud-native applications. The elastic pool model allows multiple databases to share a pool of resources, providing a cost-effective solution for SaaS applications with variable and unpredictable usage patterns. Both models are provisioned within a logical server, which acts as a central administrative point for firewall rules, authentication, and auditing policies.

Service tiers

To match performance and budget needs, it is offered in several service tiers, each with distinct resource profiles and pricing models. The General Purpose tier, built on remote storage, provides budget-oriented balanced compute and storage for most workloads. The Business Critical tier, using locally attached SSD storage, delivers the highest resilience to failures and transaction rates, often supporting mission-critical applications with built-in read-scale replicas. The Hyperscale tier, a uniquely scalable architecture, allows for rapid scaling of storage up to 100 terabytes and independent scaling of compute and storage resources, suitable for large, growing databases.

Security and compliance

Security is a foundational pillar, incorporating multiple layers of protection aligned with Microsoft's Trustworthy Computing initiative. Data protection features include Transparent Data Encryption for data at rest, Transport Layer Security for data in motion, and always-encrypted for sensitive data in use. Identity and access management integrates with Microsoft Entra ID for centralized authentication. The service adheres to a comprehensive set of global, regional, and industry-specific compliance standards, such as GDPR, HIPAA, and ISO/IEC 27001, which are independently verified by auditors. Advanced threat detection continuously monitors for suspicious activities.

Management and monitoring

Administrative overhead is minimized through fully automated management of backups, patching, and failure recovery. Comprehensive monitoring and diagnostic tools are available through the Azure portal, Azure Monitor, and Azure Log Analytics, providing insights into performance metrics and query store data. Automation and orchestration can be achieved using Azure PowerShell, the Azure CLI, and Azure Resource Manager templates for infrastructure-as-code deployments. Integration with Azure DevOps services supports modern CI/CD pipelines for database development and deployment.

Category:Cloud databases Category:Microsoft Azure services Category:Relational database management systems