Whats is Azure SQL Database?

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.Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability. PaaS capabilities that are built into Azure SQL Database enable you to focus on the domain-specific database administration and optimization activities that are critical for your business.

Technical Details

With Azure SQL Database, you can create a highly available and high-performance data storage layer for the applications and solutions in Azure. SQL Database can be the right choice for a variety of modern cloud applications because it enables you to process both relational data and non-relational structures, such as graphs, JSON, spatial, and XML.

• ​Fully managed SQL database automates updates, provisioning, and backups so you can focus on application development
  
• Flexible and responsive serverless compute and Hyperscale storage rapidly adapt to your changing requirements
  
• Layers of protection, built-in controls, and intelligent threat detection keep your data secure
  
• Built-in AI and built-in high availability maintain peak performance and durability with an SLA of up to 99.995 percent
  

Pricing

Has a vCore-based purchase model, for those who look for flexibility, control and transparency of individual resource consumption.

$0.5218 vCore-hour rate.

$0.12 per GB-monthly in Locally Redundant Storage.

Backup storage and long term retention have varying prices.

Example Price

10 vCores ($5,218) with 10GB of storage ($1,2) alongside 10GB of LRS storage and retention ($1+$0,25) $7,668 USD

Performance

Onboarding
Massive documentation, free to start. Might be a bit overwhelming at first.

​Scalability
Configurable autoscaling.

Regions

Azure SQL Database is available on all the platforms that have Azure available, such as the United States, Europe, Asia Pacific, and more to come.

​Backups 
With Azure SQL Database, you can set a long-term backup retention policy (LTR) to automatically retain backups in separate Azure Blob storage containers for up to 10 years. You can then recover a database using these backups using the Azure portal or PowerShell.

​Security
​Supports JWT, ABAC-based role, and permissions. Identity and anonymous-base

​

Feedback

What do you think about Azure SQL Database? This product is used by 7 companies & 8 companies wants to use it in future.