What is our primary use case?
We're using it for scalability. Everything is on Azure SQL for us. It is an enterprise application data warehouse, so all our applications are on this. It is useful for entire data warehousing. It is also good for microservices applications. We have its latest version.
What is most valuable?
It is good for scalability and high availability. It is also secure because of Microsoft's cloud investment.
It is easy to use because it is on the cloud. Creation or making it available through web services is super easy. Azure SQL can be quickly published as web services for APIs to connect with other applications. Because it is in Microsoft Cloud, you can easily integrate with Microsoft stack.
What needs improvement?
Its price could be better. It is expensive.
I am not sure if Microsoft Master Data Services is included in this. If not, Master Data Services can be integrated with Azure SQL. I have only used Master Data Services on-premises.
For how long have I used the solution?
I have been using this solution for four years.
What do I think about the stability of the solution?
It is stable. Microsoft has been in the market for quite some time.
What do I think about the scalability of the solution?
It is quite scalable. It is a good choice for any kind of application database, data warehousing, or data lake.
In terms of the number of users, it is being used by all users in our enterprise. For development, we have four to five developers, and we also have partners to help us.
How are customer service and technical support?
Technical support is managed by Microsoft partners, which is good.
Which solution did I use previously and why did I switch?
We have used Microsoft SQL Server on-premises. We are still using it, and slowly, we'll move to Azure SQL.
How was the initial setup?
You don't have to install it because it is on the cloud.
What's my experience with pricing, setup cost, and licensing?
It is expensive. Snowflake and PostgreSQL are cheaper than this. Google is also cheaper than Azure.
Its licensing is on a pay-as-you-go basis. It is based on usage and storage.
What other advice do I have?
I would recommend this solution. If anybody is using Azure Cloud, they should definitely use Azure SQL. Our strategy is to have all our applications on Azure, and we will keep using this solution. We will also be using it for our analytical data mart.
I would rate SQL Azure a nine out of ten. It is a good product, and it has all the required features.
Which deployment model are you using for this solution?
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?