Easy decision, good price.
Updated August 09, 2019
Easy decision, good price.
Score 9 out of 10
Overall Satisfaction with Azure SQL Database
We use Azure SQL DB throughout our entire business since we migrated to the cloud 4 years ago. It is the backbone of our CRM, Call Center and BI platforms, and feeds out Data Management initiative. On our CRM we use three instances, two for primary/failover and one for disaster recover and external queries running 10 seconds behind. Call Center links to that and BI runs 2 instances, one for sales/marketing data the other for manufacturing data. We have been quite satisfied with the control over the access and security of the data and the subscriptions themselves.
- Control of access and security is easy to manage and share within our team. Response is quick and quite a bit of things are preloaded to help.
- Having the SQL component reside directly within our subscription makes connecting and managing very easy and highly transparent. Added spots for notes on things like why an IP is whitelisted is very helpful when working with a large team that includes off-shore components.
- Scalability is another bonus, easy to scale up or down during peak times, and even automate that function makes it almost competitive with something like Snowflake.
- A little slow on processing complex or large Views. We use a lot of Views to feed our BI system, and the processing time could see some improvement, IMHO.
- Additional monitoring components would be nice too, automating some built in performance measurement tools would be a nice feature.
- Price can always be improved as well. It’s not bad, but room for improvement.
- We get our data much faster and hassle-free with direct connections to our apps.
- All our costs for major projects are now self-contained within a subscription, so managing costs is easy.
- Negative is the speed at which it can take to connect DB that are not in the same subscription or region, but that’s across the board.
We moved away from Oracle and NoSQL because we had been so reliant on them for the last 25 years, the pricing was too much and we were looking for a way to cut the cord. Snowflake is just too up in the air, feels like it is soon to be just another line item to add to your Azure subscription. Azure was just priced right, easy to migrate to and plenty of resources to hire to support/maintain it. Very easy to learn, too.
If you have any apps in the cloud, this is the way to go. The interface and management is much better than AWS, and no one else is getting closer. If you are running just BI, you could go with a Snowflake or Cloudera approach, but Cloudera is complex and Snowflake simply sits on top of Azure Data Storage anyway, and I hear will soon be an offering by Microsoft as well.