2019-07-16T05:40:00Z

What needs improvement with SQL Azure?

Miriam Tover - PeerSpot reviewer
  • 1
  • 20
PeerSpot user
Get the report
Helped 765,234 peers since 2012
66

66 Answers

Zubair_Ahmed - PeerSpot reviewer
MSP
Top 5
2023-11-30T09:29:05Z
Nov 30, 2023

There is room for improvement regarding the pricing structure. It would be beneficial if the cost is reduced.

Search for a product comparison
SC
Real User
Top 10Leaderboard
2023-11-30T09:14:58Z
Nov 30, 2023

The user interface (UI) could be more flexible. It's not that the data access or storage format is bad, but the UI feels clunky and isn't up to par with other tools.

Marco Cenzato - PeerSpot reviewer
Real User
Top 10
2023-08-21T15:52:00Z
Aug 21, 2023

They have some problems with the introduced features in the latest version of the server. The multiple query planning parameters have problems. The problem is the automated configuration. Even when they address the problems, there are still issues. The second issue is to audit the real users on behalf of whom we operate secret servers. Normally in our application, we use only a single connection to leverage the pooling.

Naresh Reddy - PeerSpot reviewer
Real User
Top 5Leaderboard
2023-08-04T09:23:10Z
Aug 4, 2023

Basic Knowledge on any cloud platform and SQL knowledge

Naresh Reddy - PeerSpot reviewer
Real User
Top 5Leaderboard
2023-07-04T06:58:16Z
Jul 4, 2023

Increased Third-Party Integrations: Giving users additional options and flexibility would require expanding Azure's ecosystem to incorporate more third-party integrations.

Al Mcpherson - PeerSpot reviewer
Real User
Top 10
2023-04-28T14:57:12Z
Apr 28, 2023

SQL Azure could improve the feature set. They are catching up to Microsoft SQL Server.

Learn what your peers think about SQL Azure. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
Marios Christodoulou - PeerSpot reviewer
Real User
Top 5Leaderboard
2023-04-28T12:19:00Z
Apr 28, 2023

The solution could improve by allowing the export of the data more seamlessly. It is difficult to copy and back up data.

SehrishTahir - PeerSpot reviewer
Real User
Top 5Leaderboard
2023-04-26T12:30:00Z
Apr 26, 2023

Azure does not provide features like RDS for Oracle that AWS offers. The solution has to scale up its expertise for hosting Oracle.

AF
Consultant
Top 20
2023-04-24T08:59:00Z
Apr 24, 2023

They should include more accessible functions for image tooling. Presently, we are using optional features for it.

Joyal Benni - PeerSpot reviewer
Real User
Top 5
2023-04-24T08:36:00Z
Apr 24, 2023

The preset configuration switches we can select on SQL Azure should be made more liberal to work on. The licensing cost for the solution is very expensive and should be improved.

KS
Real User
Top 20
2023-03-13T13:55:55Z
Mar 13, 2023

The pricing plans when using multiple Microsoft solutions are complex and have room for improvement.

GB
Real User
Top 20
2023-02-22T11:39:20Z
Feb 22, 2023

Microsoft could improve its documentation and support. Without the necessary knowledge and expertise, it can be difficult to navigate the platform and find a technical person to guide us through. There is not currently enough documentation available to make it easy to use. If I had not been certified in Azure, I would have faced a lot of difficulties. I would like reports attached to my phone if there's an error that occurs within SQL Azure or if there are updates that need to run, I would like to receive notifications.

AM
Real User
Top 20
2023-02-21T15:55:17Z
Feb 21, 2023

The default 1433 port for communication should be customizable because most hacks or attacks are attempted when creating any application or database on the default port. The solution should allow use of any custom port.

RP
Real User
Top 20
2023-01-12T12:29:41Z
Jan 12, 2023

The solution can be improved by reducing the constraints available on cloud and improving support response times.

RT
Real User
Top 20
2022-12-02T09:32:03Z
Dec 2, 2022

From a user standpoint, there isn't really any need for improvement. We'd like the solution to be available on mobile phones. The product could be more competitive in terms of features, security, and scalability.

EI
Real User
Top 5
2022-11-10T21:33:29Z
Nov 10, 2022

I think that the cost management in SQL is not clear because we may use some tax to identify products, but in some cases identifying the transactions in SQL is not easy for some financial cost centers. Perhaps if in Azure cost management we have the opportunity to monitor the SQL cost in more detail, it will be helpful.

SR
Real User
Top 5Leaderboard
2022-10-12T10:30:43Z
Oct 12, 2022

I want the pricing to be improved. They should try to lower it for their customers.

Sakiru Dosumu - PeerSpot reviewer
Real User
Top 5
2022-10-08T10:55:59Z
Oct 8, 2022

I would like to see the cloud connectivity environment improved.

Samuel Lambrecht - PeerSpot reviewer
Consultant
Top 20
2022-08-05T22:58:34Z
Aug 5, 2022

There are some characteristics called "joins," like "inner join," "full join," "left join," "right join," etc. It's a little confusing for some coders. I think that could be simplified. I'm in the analytic space, so I would introduce a higher level of coding using artificial intelligence. SQL is quite close to English. They could add a voice interface where you speak into it, and the machine writes the code for you. My weakness in coding requires something automated, so I can be more proactive. They should also simplify the security in Azure. We are using the cloud as a platform, so there is no physical infrastructure. We're using Azure components like databases and servers to create an application. Integrating those components in terms of permissions and security is challenging for us. Maybe there is a lack of knowledge on our side, but it's not straightforward. The data modeling is not good for me. There are better tools than SQL Azure when you need to create the abstract part of the database design. It's weak. It's not user-friendly, and the notation is specific to Microsoft. I believe we use a third-party tool for data modeling because it's easier to use. Communicating with that tool is easier than SQL Azure. The model is nicer.

Daniel_Marin - PeerSpot reviewer
Real User
Top 20
2022-07-29T15:42:50Z
Jul 29, 2022

I was using a user list for connecting a program in OTF for getting information. The connection in SQL Azure can improve by being easier because at the moment I have to use private certificates for user authentication. I had to do additional configuration to have the connections.

Akin Ayodele - PeerSpot reviewer
Real User
Top 5
2022-05-31T13:26:00Z
May 31, 2022

If the product could support applications requiring an SQL server for installation, by using SQL Azure as a backend, that would be useful.

AM
Real User
ExpertModerator
2022-05-31T12:28:16Z
May 31, 2022

What would make SQL Azure better is users having the capability of managing the database solution from the cloud, instead of having to do it from an actual machine because currently, database management via SQL Azure is done on a virtual machine or a PC. The solution should have the data functionality of managing SQL databases inside the cloud.

Paul Elson - PeerSpot reviewer
Real User
Top 10
2022-05-15T17:00:04Z
May 15, 2022

There is probably more functionality in our on-prem SQL Server than SQL Azure.

Naresh Reddy - PeerSpot reviewer
Real User
Top 5Leaderboard
2022-03-21T09:14:00Z
Mar 21, 2022

In terms of support, they don't give much support.

Rafael Veloso - PeerSpot reviewer
MSP
2022-02-18T17:16:47Z
Feb 18, 2022

SQL Azure could improve by adding more features.

SC
Real User
2022-01-30T06:38:01Z
Jan 30, 2022

If we need to deploy data management or services with SQL Azure we need InterSecure.

Mangesh Masaye - PeerSpot reviewer
Real User
Top 10
2022-01-26T16:40:00Z
Jan 26, 2022

Integration needs to be improved for this solution.

ST
Real User
2021-10-27T10:41:25Z
Oct 27, 2021

SQL Azure could offer a lot more services and applications. I'd also like to see some tools that we could use on the SQL Server for data virtualization. That would be an improvement.

AK
Real User
2021-10-06T10:40:00Z
Oct 6, 2021

SQL Azure's performance monitoring features need to be improved. It has a pricing calculator, but it would be great if we could get a rough estimate of the pricing based on fewer parameters, like the data size and the scale of the company.

AV
Real User
2021-07-21T13:31:06Z
Jul 21, 2021

I think SQL could be improved in terms of ease of use for developers when it comes to performance. For example, enabling suggestions or auto-tune performances, providing results which are higher level recommendations. I know there are tools that performance analyze, but I personally find it to be overly complicated. If they look at performance assistance, add-ons or plugins that might help the developer, focus can be on business logic rather than performance. This is an ongoing issue for me and I'd like to see developers given the flexibility to change those recommendations, it would simplify things.

CO
Real User
2021-06-22T13:28:52Z
Jun 22, 2021

It should have better profiling capabilities. Its price could also be lower.

MF
Real User
2021-05-29T14:51:27Z
May 29, 2021

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

SE
Real User
2021-05-28T19:34:32Z
May 28, 2021

I'm not really a SQL DBA, so I can't go into the depths of the areas that need to be improved. They can maybe make it a bit easier to educate people on how to develop SQL Server in Azure. They can provide some free seminars and webinars and more training in general for easier migration. I know there is some stuff on Microsoft learning, but it would be helpful and useful to have more up-to-date content.

SJ
Real User
2021-05-01T06:25:06Z
May 1, 2021

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.

RS
Real User
2021-04-27T09:12:28Z
Apr 27, 2021

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.

KH
Real User
2021-04-22T20:41:54Z
Apr 22, 2021

The solution should start covering more regions in Gulf countries and other regions. This is due to the fact that other cloud providers are not locally available. Yet this is what people require here. Their availability in the Middle East and Asia regions needs to improve.

Lakshman Nimmakayala - PeerSpot reviewer
Real User
Top 5
2021-04-05T14:47:01Z
Apr 5, 2021

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.

KV
Real User
2021-03-19T14:12:00Z
Mar 19, 2021

Service Broker should be added in Azure Cloud. Service Broker is currently available only in the on-premises version.

AU
Real User
2021-03-09T09:45:29Z
Mar 9, 2021

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.

AM
Real User
ExpertModerator
2021-03-03T23:35:09Z
Mar 3, 2021

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.

MJ
Real User
2021-02-23T12:23:43Z
Feb 23, 2021

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.

KG
Real User
2021-02-15T13:51:38Z
Feb 15, 2021

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.

NK
Real User
Top 5Leaderboard
2021-01-10T08:29:58Z
Jan 10, 2021

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

Alvaro Olivares - PeerSpot reviewer
Real User
Top 5
2020-11-20T21:18:59Z
Nov 20, 2020

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

SR
Real User
Top 5Leaderboard
2020-11-11T18:07:39Z
Nov 11, 2020

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.

MT
Real User
2020-11-03T14:57:19Z
Nov 3, 2020

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.

RM
Real User
2020-10-26T22:27:00Z
Oct 26, 2020

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.

PP
Real User
2020-10-22T19:54:00Z
Oct 22, 2020

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.

PL
Real User
2020-10-21T04:33:58Z
Oct 21, 2020

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.

NN
Real User
2020-10-04T06:40:00Z
Oct 4, 2020

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.

CL
Real User
2020-09-30T08:03:31Z
Sep 30, 2020

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.

JS
Real User
2020-09-27T04:10:14Z
Sep 27, 2020

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.

RJ
Real User
2020-09-27T04:10:03Z
Sep 27, 2020

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.

SM
Real User
2020-08-20T07:50:19Z
Aug 20, 2020

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

FT
Real User
2020-07-13T06:55:49Z
Jul 13, 2020

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.

BB
Consultant
2020-06-18T05:17:42Z
Jun 18, 2020

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.

Marco Cenzato - PeerSpot reviewer
Real User
Top 10
2019-08-13T10:41:00Z
Aug 13, 2019

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.

CA
Real User
2019-08-13T06:03:00Z
Aug 13, 2019

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.

MS
Real User
2019-08-06T07:17:00Z
Aug 6, 2019

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.

IM
Real User
2019-08-04T07:38:00Z
Aug 4, 2019

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

SE
Real User
2019-08-01T05:43:00Z
Aug 1, 2019

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.

HM
Real User
2019-07-31T05:52:00Z
Jul 31, 2019

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.

MA
Real User
2019-07-31T05:52:00Z
Jul 31, 2019

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.

AA
Real User
2019-07-30T10:41:00Z
Jul 30, 2019

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

RA
Real User
2019-07-29T10:11:00Z
Jul 29, 2019

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.

SZ
Real User
2019-07-16T05:40:00Z
Jul 16, 2019

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.

Microsoft Azure SQL Database is a relational database-as-a-service that delivers predictable performance, scalability, business continuity, data protection, and near-zero administration to cloud developers and solution architects. This is the deep technical library for Azure SQL Database.
Download SQL Azure ReportRead more