Azure SQL Databases is quick to scale
January 14, 2019
Azure SQL Databases is quick to scale
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.