MSDN Documentation

Azure SQL Database offers robust security features to protect your data at rest and in transit. This includes:

• Transparent Data Encryption (TDE): Encrypts data at rest using a symmetric key.
• Always Encrypted: Protects sensitive data from database administrators (DBAs) by encrypting it on the client-side.
• Threat Detection: Identifies and responds to potential security threats in real-time.
• Azure Active Directory integration: Centralized identity and access management.
• Compliance Certifications: Adheres to a wide range of industry regulations and certifications.

Experience unparalleled performance and effortless scalability with Azure SQL Database. Key aspects include:

• DTU and vCore Models: Flexible purchasing models to match your performance needs.
• Automatic Tuning: Automatically identifies and resolves performance issues.
• Query Store: Tracks query performance history and helps identify regressions.
• Elastic Pools: Cost-effective solution for managing multiple databases with unpredictable resource demands.
• Read Scale-Out: Offload read-only workloads to secondary replicas.

Ensure business continuity with built-in high availability and disaster recovery capabilities:

• Zone Redundancy: Protects against datacenter-level failures.
• Geo-Replication: Replicates databases to other Azure regions for disaster recovery.
• Automated Backups: Point-in-time restore capabilities.
• Failover Groups: Simplifies disaster recovery by managing failover of multiple databases.

Simplify database management with intelligent tools and automation:

• Azure Portal: Intuitive web interface for managing your databases.
• Azure Resource Manager (ARM) Templates: Infrastructure as Code for deployment.
• PowerShell and Azure CLI: Scripting and automation options.
• Intelligent Insights: Proactive performance and availability monitoring.

Seamlessly integrate your on-premises and cloud data environments:

• Azure Arc-enabled data services: Extend Azure data services to any infrastructure.
• Data Migration Service: Facilitates migration from various sources.

Enhance developer workflows with integrated tools and services:

• Support for familiar tools: SQL Server Management Studio (SSMS), Azure Data Studio, Visual Studio.
• APIs and SDKs: Programmatic access and integration.
• Serverless Compute: Automatic scaling and pay-per-use for predictable workloads.