What is our primary use case?
The only use case I have for the Microsoft Azure SQL Database is this data lake. The client decided that they want to concentrate all integrations between systems on the Azure SQL Server on the cloud to just be the repository of the interface. Every system that needs to transfer data from each other puts the information on the data lake on the SQL Server, and the other system gets it from there. I believe that's not a good solution, but the client wants to do it this way.
What is most valuable?
The Microsoft Azure SQL Database performs effectively, and if money is not a problem, you can scale. It can grow, and with a click of a button, you can add more memory and more CPU. This is a good feature if you need it and if you have the resources to invest in these capabilities.
The initial setup for the Microsoft Azure SQL Database is straightforward, as with all Microsoft tools. It's usually easy to set up and get running. Management is consistent, which is beneficial. You can manage your Azure instance with the same tools, Management Studio, from your computer. You can treat it as a box in your house.
What needs improvement?
I have used the Microsoft Azure SQL Database for two years now, and I don't find it satisfactory. It's slow and expensive.
The Microsoft Azure SQL Database is not the latest version of Microsoft SQL Server. I believe it's a really old engine that does not have the newest features. It's very slow and too expensive. I really don't think it's a good solution for most cases, except when you specifically need to put your data on the cloud.
Regarding stability, the Microsoft Azure SQL Database is very stable, but I noticed very poor performance. My client bought a specific configuration with some memory and two cores only. This configuration performs very badly compared to the same situation on-premises. Even if I put my SQL Server on an old machine, I will get better performance from the hardware on-premises.
There are problems with connection, and I believe most clients would be better served by a database on-premises. There is also an issue with extracting data - you cannot do a backup and dump the database to your local network. You need to rely on Microsoft backups to restore your data and pay for it. I really think that the data belongs to the client, and the client should always have the ability to download their data.
For how long have I used the solution?
I have used the Microsoft Azure SQL Database for two years now, and I don't find it satisfactory.
What do I think about the scalability of the solution?
The pricing for the Microsoft Azure SQL Database is expensive, though I don't have the current numbers as I saw these figures more than a year ago when preparing the environment. The client is already planning to move back on-premises because it is not working well in terms of performance. Now that we are starting to move big volumes of data, the system starts to slow down. Queries are slow, and the performance is now impacting the application.
How are customer service and support?
I would rate the Microsoft support for this product as poor because we did not use it. The client just pays for the storage. We have some kind of built-in support, but we never used it as we try to figure things out by ourselves. In Brazil, this is a little bit more complicated. They have used the support from Microsoft for other products. They have Microsoft Windows 365 and volume licensing with Microsoft. They use their support, and I know that it works. On the database part, I didn't use it.
In general, I would give Microsoft support a rating of six out of ten.
How would you rate customer service and support?
How was the initial setup?
The initial setup for the Microsoft Azure SQL Database is straightforward as with all Microsoft tools. It's usually easy to set up and get running. Management is consistent, and you can manage your Azure instance with the same tools, Management Studio, from your computer.
What other advice do I have?
My client does not use Amazon services at all, including the Azure Data Box.
I am not familiar with just the Data Lake Storage because we are just using the SQL Server database, not the other products that are supposed to be dedicated to this kind of use of a data lake.
The Microsoft Azure SQL Database is not the latest version of Microsoft SQL Server. It's a really old engine that does not have the newest features. It's very slow and too expensive. I really don't think it's a good solution for most cases, except when you specifically need to put your data on the cloud.
The client is already planning to move back on-premises because it is not working well in terms of performance. Now that we are starting to move big volumes of data, the system starts to slow down. Queries are slow, and the performance is impacting the application.
On a scale of one to ten, I rate this solution a six.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.