Item: Azure SQL Database
Rating: 10
Author: Verified User

Use Cases and Deployment Scope

Azure SQL Database service, two of our critical workloads are used for online structure serving our customers. Since we work both physically and online, the cloud infrastructure equivalent of the entire on-premise structure managed for physical retailing is Azure SQL Database service. On the online side, the important thing for us was to have a structure that we can stretch very quickly, and this service provides exactly that.

Pros and Cons

Scalability
Simplicity, ability to just focus on SQL, no need to manage anything else.
High speed and minimal down time.
Keeping data in the country you want.

In the traditional on-premise Microsoft SQL Database structure, while everything the database developer does is almost the same in Azure, the database administrator needs to be separated from the interfaces they are used to.
Job and Task manager work in different logic.
The maintenance structure is different, if only it could stay the way we are used to.

Return on Investment

As you know, Cloud is an incredibly useful environment for really lowering costs. We purchased the systems that we anticipated we might need in the future decades-long ago, those resources were in vain. There is no waste on the cloud side because the resource is determined according to the need.
Backup space costs per GB per unit lower than physical storage costs.
You can rent the system that you need dozens of approvals and budgets to have in the normal process, and you can return to the old cost-effective structure immediately when you are done.
You can turn off the system you don't need.
We use geographic backup, which we could not have without cloud, with very reasonable numbers.

Alternatives Considered

Google Cloud SQL and Amazon Relational Database Service (RDS)

We looked at Google Cloud SQL and Amazon RDS services, but we did not want to switch to a different structure from the system we currently use.

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?

Yes

Did implementation of Azure SQL Database go as expected?

Yes

Would you buy Azure SQL Database again?

Yes

Other Software Used

AnyDesk, TeamViewer, Radmin Remote Administrator

Likelihood to Recommend

The most important feature of Azure SQL Database is that it is a service. There is no virtual machine to manage, no operating system to run on, no updates or security work for this operating system or virtual machines. Therefore, you can only focus on SQL service. It is almost unclear when the online world will gain speed/acceleration, especially in the covid-19 process, an unpredictable increase in online services may occur due to restrictions. Azure SQL server, which works on the cloud side, can keep the system automatically in accordance with every condition exactly as it should be, and you can do all the work on a single service and simple screens.

Simple, Fast, and Powerful

Overall Satisfaction with Azure SQL Database