Item: Azure SQL Database
Rating: 10
Author: Rishabh Khanna

Use Cases and Deployment Scope

Currently, my organization is working on moving to cloud. we are trying to convert our products to SaaS products, so that we can provide them as a service on various clouds. Microsoft Azure SQL Database is one of many services that we are using in our organization. It is a primary tool for storing data up in the cloud. I am working on IoT based ERP system and I am using Azure SQL database to store data in the cloud. It is very easy to setup SQL server on Azure.

Pros and Cons

It is fully managed and secure SQL database.
It is highly available and scalable.
It provides automatic backup and restore.
Documentation of Azure SQL is perfect with all best practices.

I would love to see some new sizes of databases for compute and storage.
prices related to different size can be improved.
performance can be improved to reduce the latency.

Return on Investment

It was easy for our developers to setup and use this service.
It has helped us in reducing the cost of managing SQL database.
Its ability to scale up and down based on requirement is best.

Alternatives Considered

Amazon Relational Database Service (RDS), Microsoft SQL Server and Google Cloud SQL

It is very easy to setup SQL database on Azure. one can always refer to their documentation for best practices. It is highly available and scalable. It is cheaper than its alternatives and provide better performance than others. As we are using many other services of Azure for creating a SaaS application, so it is always better to have all services at one place.

Key Insights

Do you think Azure SQL Database delivers good value for the price?

Yes

Are you happy with Azure SQL Database's feature set?

Yes

Did Azure SQL Database live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of Azure SQL Database go as expected?

Yes

Would you buy Azure SQL Database again?

Yes

Other Software Used

Amazon Relational Database Service (RDS), Google Cloud SQL, Microsoft SQL Server

Likelihood to Recommend

It is best suited if your company is making a transition from on-prem to cloud and if your product is based on SQL then it is best service to go for. It is highly available and secure.
There might be some performance issues when using it as an external database with kubernetes cluster. There might be some latency while performing database operations from a containerized app.

Microsoft Azure SQL Database: Fully Managed and secure SQL database

Overall Satisfaction with Azure SQL Database