Azure SQL Databases is quick to scale
January 14, 2019

Azure SQL Databases is quick to scale

Michael Jipping | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Azure SQL Database

Azure SQL Database was being utilized at first for development as a low-cost option for development and then was later explored as an option for running production workloads. SQL Database Servers have a relatively high fixed cost and this allowed for a great option at a reduced impact to the budget.
  • Extremely Flexible- You have the ability to increase and decrease the performance resources as needed without taking a downtime or other burden.
  • Connectivity- Connection to your SQL Database is easily accomplished with SSMS or PowerShell.
  • Speed- Azure SQL Databases are quickly set up. You can have access and begin using your database within minutes.
  • It would be appreciated for better integration between SSMS and Azure Database service. Example, you need to a provision user account with the Azure portal. It would be great to be able to do this within SSMS.
  • Being able to run a back from SSMS versus from within the Azure Portal would be great. (Ability to create a standard .bak database backup).
  • Azure SQL Databases are a great solution and with the Azure pricing model, you can reduce costs in most scenarios. They also have added intrinsic value by the products nature of being scale-able to the current task (i.e.- a short term need for more processing power).
Very similar product. Our company preferred to remain in the Microsoft Software Suite.
Azure SQL Database will be great to use for an organization that needs an extremely flexible database solution or a low-cost solution. Some scenarios such as healthcare or banking may require for the solution to remain hosted onsite due to security/regulations. For most scenarios, Azure SQL Database is a great solution.

Azure SQL Database Feature Ratings

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