Azure SQL DB is an example of how a DBaaS should be done.
No photo available
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
Review Source

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.
For large databases cost should be carefully evaluated as it can be very expensive. But for medium and small databases (usually 80% of the organization) it has perfect fit. Data replication (for disaster recovery), backup, security and performance recommendation are great tools and work very well. When planning to migrate from Oracle, start first with smaller databases - but be aware Microsoft is always improving its migration tools.

Azure SQL Database Feature Ratings

Automatic software patching
9
Database scalability
9
Automated backups
7
Database security provisions
7
Monitoring and metrics
9
Automatic host deployment
8