We just raised a $30M Series A: Read our story
2019-07-16T05:40:00Z

What needs improvement with SQL Azure?

2

Please share with the community what you think needs improvement with SQL Azure.

What are its weaknesses? What would you like to see changed in a future version?

ITCS user
Guest
3232 Answers

author avatar
Top 5LeaderboardReal User

It would help if the solution was more secure. It's an aspect they could work on for future releases.

2021-05-29T14:51:27Z
author avatar
Top 5Real User

There are some limitations for cross-database queries and features. The migration of data from older systems should be easier. For deployment, there are too many options, which sometimes makes it difficult to figure out the best option. There is not enough information to help you to find the best option for deployment. There should be more documentation about this.

2021-05-01T06:25:06Z
author avatar
Top 5Real User

We have a very small database running on SQL Azure. We have not been able to load bigger systems on it. It is still not something that is feasible. All our heavy-duty systems are on SAP, and it should have more compatibility with other vendors such as SAP. Its price can definitely be lower. It is pretty pricey.

2021-04-27T09:12:28Z
author avatar
Top 5LeaderboardReal User

The solution could improve by supporting more operating systems. In a future release, I would like to see more development on SQL servers on containers where you can manage a skill across multi-clouds.

2021-04-05T14:47:01Z
author avatar
Top 10Real User

I would like to have more tools for feedback. I find that there are a lot of things offered in other solutions that don't exist in Azure SQL. There are also tricky commercial issues. When you use Google or Amazon, you know exactly how much you will pay. With Microsoft solutions, you don't know, it's very unclear and impossible to get anyone on the phone.

2021-03-09T09:45:29Z
author avatar
Top 5LeaderboardReal User

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.

2021-03-03T23:35:09Z
author avatar
Top 5Real User

Its automation can be improved. SQL Server Agent was a very big part of the on-prem tools. While moving from on-prem to the cloud, redoing some of such tools was very cumbersome in Azure. There was a whole new set of technologies and methodologies. It should have easier automation-type features to be able to implement such tools. It should have almost a SQL agent type of substance built into that.

2021-02-23T12:23:43Z
author avatar
Top 5LeaderboardReal User

It is difficult to find any disadvantages when I can only see advantages in using SQL Azure. When you have a subscription, the subscription itself is not secure. You have to add the user into the directory and you will be able to use it. I would like to see integration with Snowflake.

2021-02-15T13:51:38Z
author avatar
Top 5LeaderboardReal User

It can have more dashboards for monitoring, which would naturally help a lot. Other than that, everything is okay.

2021-01-10T08:29:58Z
author avatar
Top 10Real User

Its compatibility with existing applications can be improved. Its compatibility is currently a little bit imbalanced.

2020-11-20T21:18:59Z
author avatar
Top 10Real User

What I don't like is the personalization of an instance is difficult to deploy. Sometimes it's hard if you want to make a cluster of SQLs on Azure; it's not a good approach, but sometimes it worked out for me. If I have to do something very specific to the instance, sometimes I am not allowed to leave those types of configurations because they need it to be broader. They are not at the level that I need to make the configurations that I want. The configuration is the only area to be improved. Everything else is what it is and what we expected. The configuration is the area that is most cumbersome.

2020-11-11T18:07:39Z
author avatar
Top 10Real User

Price definitely may be a negative point. As for most of cloud based solution, certain cost components as CPU and IO usage may cause extremely hi costs.

2020-11-03T14:57:19Z
author avatar
Top 10Real User

The way it has been designed, in the on-premises deployments, the underlying Windows OS is highly scalable but has a very large resource requirement. A lot of power-related and memory-related things are there, which I have not seen in the RHEL and Oracle. I have not tried SQL on RHEL EXEC. On Windows, infrastructure-wise, a very large workload is running on the SQL. This issue is related to Windows, not SQL.

2020-10-26T22:27:00Z
author avatar
Top 5Real User

I am very happy with this solution; right now, I don't think there is anything I would change. More power should be included between the upgrades. We started with a less costly service but we needed more power. We paid a lot and upgraded but we still needed more power. The power should increase more between each upgrade.

2020-10-22T19:54:00Z
author avatar
Top 5Real User

There is so much information that it becomes confusing at times. The information can be more friendly. They could also provide additional training, especially at the beginning.

2020-10-21T04:33:58Z
author avatar
Top 10Real User

If you use the solution in the Microsoft environment, it's fine. But if you're using Java then it seems to be out of place. AWS has a new product called Aurora, it's a new database that can deal with both types of workloads: transactional and analytical. That's a big challenge for all the other databases including SQL, because most of the databases out there are designed for either type of workload but the Amazon AWS Aurora does both. With SQL, if they do the BI normally, you then have to replicate the production database to another database which is no longer necessary with Aurora. It's something SQL could include.

2020-10-04T06:40:00Z
author avatar
Top 5LeaderboardReal User

It is a little bit expensive for us. They can improve the price. It would also be very helpful if they can offer some free trial.

2020-09-30T08:03:31Z
author avatar
Top 5Real User

In terms of management, you can't really pause things. It doesn't allow for that kind of capability. From a security perspective, although their features are decent, they can always be improved upon, updated, and refined to help protect clients better. I would love it if that had dynamic data masking and features of that nature.

2020-09-27T04:10:14Z
author avatar
Top 10Real User

The implementation process needs to be improved. Support isn't that great. They need to work on this aspect of their service. It can be challenging to reach them. The solution needs to be more flexible overall. It would help if there were better reporting features on offer.

2020-09-27T04:10:03Z
author avatar
Top 5Real User

I feel that the price is high and it could be reduced.

2020-08-20T07:50:19Z
author avatar
Top 10Real User

The availability of resources could be improved. The solution needs to offer online training to help improve the capacity of teams to manage the SQL. The pricing is very high.

2020-07-13T06:55:49Z
author avatar
Top 5Consultant

The product has many features that might not be explored by many end users because there isn't much technical guidance available. If I'm interested in understanding a particular feature I'd like there to be some kind of explore button that would provide technical in-depth assistance, and that's lacking for now. There is very little technical documentation. As already mentioned, additional features should include technical documentation on the product features. Secondly, there could also be some improvement in performance. I know they have done benchmark testing but sometimes performance is lacking. They can improve in that area too.

2020-06-18T05:17:42Z
author avatar
Real User

Migrating existing application to SQL database had many problems, developing a new app for Azure Database not. Their support is nice but frequently their responses aren't effective. The documentation is always updated with the latest features but the documentation for the database features should be better. It doesn't specify when specific features will be released. The documentation needs improvement. They should improve the way they explain the information to the market. It should have better support for UTF 8 (a feature already present on the on-premises version of SQL Database 2019) a for Hadoop integration.

2019-08-13T10:41:00Z
author avatar
Real User

Security can sometimes be a problem when it affects our business needs. It needs to integrate more security without stopping the service or our business. In some cases we have a lot of restriction on people who needs to use the database for whatever reason. We need more performance but in the same way we need more security - from the application and also in the Internet. The problem is therefore in the internet.

2019-08-13T06:03:00Z
author avatar
LeaderboardReal User

This solution suffers from the same problems that come about in a normal SQL server. One issue is the optimization of function-heavy evaluations. If you define your own functions, the execution plan of the SQL server performs sub-passes of the execution path, which makes the process very slow. Even if there are very easy means to optimize them, it is still slow. The server should perform automatic function optimization. This is a problem in any implementation, Azure or otherwise. The management is entirely controlled by Microsoft, so there are some restrictions.

2019-08-06T07:17:00Z
author avatar
Real User

The solution could be less expensive. They need to work on their pricing model.

2019-08-04T07:38:00Z
author avatar
Real User

The concurrency between the amount of the transactional replications and the logging needs to be improved. Also, the GUI, the specific management tool itself, needs some improvement as well. It's not a feature, but the solution only offers a certain amount of memory and that's limiting. The scalability should be extended to more than two terabytes.

2019-08-01T05:43:00Z
author avatar
Real User

We're still discovering aspects of the solution. We haven't yet deployed all of the components, so I'm not sure of what additional features we'd like to see.

2019-07-31T05:52:00Z
author avatar
Real User

This solution would be improved with the inclusion of better self-service tools. It needs to be easier for my technical teams to perform support tasks.

2019-07-31T05:52:00Z
author avatar
Real User

I need Microsoft to allow their network to access open source technologies.

2019-07-30T10:41:00Z
author avatar
Real User

The solution needs to improve its customer network, including its online support. In the next release, I'd like to see Azure SQL improve user rights management and user rights control management.

2019-07-29T10:11:00Z
author avatar
Real User

I need something which is in one place so I can automate the Azure data factory, but it's a different tool. It's not easy and in one place, so I can't switch to the other tool and do something there, automate everything there in the on-prem infrastructure, and then have everything in the agent. I can just pick one packet and use it. However, I want to be able to click it and run it. We could definitely use something which can automate the work. For example, I know there are a lot of tips like what indexes you should use, or what security features you should look at with your current SQL server. The acquired performance is assured, so some more statistics about acquired performance would be really valuable for the developer and also the administrators who use it. That would be really valuable, but we also need something which automates the work in particular SQL agents. I'm disappointed that it is not in the simple plan and I have to buy a higher plan.

2019-07-16T05:40:00Z
Learn what your peers think about SQL Azure. Get advice and tips from experienced pros sharing their opinions. Updated: September 2021.
540,984 professionals have used our research since 2012.