Azure SQL DB is an example of how a DBaaS should be done.
August 07, 2018
Azure SQL DB is an example of how a DBaaS should be done.
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Azure SQL Database
Azure SQL DB is a great service. It optimizes licensing cost and lets you pay per usage. You can grow as needed and it supports from small to large databases. Be aware it can require some networking/security steps to have it in large or more controlled environments.
- It optimizes cost - pay per usage. It can scale up and down as needed.
- It can be migrated to from Oracle, MySQL and other on premises databases.
- It is always updated with management and administrative functionalities being added weekly.
- Migration from on premises databases can be painful at first - but after couple of migrations it becomes easy.
- Network capabilities and restrictions should be carefully evaluated.
- It can be costly if you don't implement scale up/down automations.
- Perfect for small and medium databases, being very cost effective.
- As a Platform as a Service, there is no concern about patches, upgrades and end of life.
- Be aware of security and network capabilities. The service cannot run in the VNET as Azure Virtual Machines do.
Comparing with Amazon Aurora: Azure SQL DB is 100% compatible with SQL Server and Aurora is compatible with MySQL and PostGreSQL. Because of if, SQL DB suits large enterprises with hundreds of databases better.
Comparing with Oracle: the main issue is that Oracle will try to push all other services available in their product offering.
Comparing with Oracle: the main issue is that Oracle will try to push all other services available in their product offering.