SQL Azure Room for Improvement

SZ
Slawomir Zablocki
Tech Clinical Engineer at APN Promise

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.

View full review »
Michael John
Senior Database Administrator at a recruiting/HR firm with 11-50 employees

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.

View full review »
JS
reviewer1294518
Solution Principal at a computer software company with 5,001-10,000 employees

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.

View full review »
Learn what your peers think about SQL Azure. Get advice and tips from experienced pros sharing their opinions. Updated: March 2021.
476,892 professionals have used our research since 2012.
RM
reviewer1352925
Senior Information Technology Manager at a aerospace/defense firm with 10,001+ employees

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.

View full review »
Nhan-Nguyen
Development Manager at Incepta

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. 

View full review »
IM
IbrahimMuhanna
IT Manager at a pharma/biotech company with 201-500 employees

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

View full review »
BB
reviewer1369602
Lead Consultant at a tech services company with 10,001+ employees

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. 

View full review »
HM
Haytham Mohamed
Enterprise End User Operations at a comms service provider with 1,001-5,000 employees

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.

View full review »
Ariful Mondal
Head - Analytics, Digital World at a financial services firm with 1,001-5,000 employees

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.

View full review »
MT
reviewer1443378
IT Manager at a financial services firm with 51-200 employees

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.

View full review »
KG
reviewer1488372
Associate Manager at a consultancy with 501-1,000 employees

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.

View full review »
Sérgio Rita
IT Manager at a university with 51-200 employees

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.

View full review »
MichaelSoliman
Owner at Alopex ONE UG

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.

View full review »
CA
Masterinfotec67
Master of Information Technology at a individual & family service with 201-500 employees

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. 

View full review »
RJ
reviewer1427208
Technical Account Manager at a tech services company with 11-50 employees

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.

View full review »
Marco Cenzato
Ing. at a media company with 10,001+ employees

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.

View full review »
LN
reviewer1534722
Enterprise Cloud Architect at a insurance company with 10,001+ employees

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.

View full review »
MA
Mohamed Alnuaimi
Director of IT at a comms service provider with 1,001-5,000 employees

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.

View full review »
PauloPedro
Co-Founder & Managing Director at a marketing services firm with 1-10 employees

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.

View full review »
Fabio Taddia
IT Manager at SIMOPARMA PACKAGING ITALIA SRL

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.

View full review »
CL
reviewer1410678
Web Developer at a tech company with 51-200 employees

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.

View full review »
AhmedArafat
DevOps Engineer at a comms service provider with 10,001+ employees

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

View full review »
SE
Proserv67
Professional Service Manager at a tech services company with 11-50 employees

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.  

View full review »
NK
reviewer1392441
Senior IT Manager at a pharma/biotech company with 501-1,000 employees

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

View full review »
RA
Business677
Business Analyst at Paunaste OÜ

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.

View full review »
Karel Van Der Walt
Data Architect at ACPAS Loan Management Software

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

View full review »
Subhrajit Mitra
Sr. Technical Architect - Business Intelligence / Data Warehouse at a computer software company with 1,001-5,000 employees

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

View full review »
AO
reviewer1361295
Head of Cloud Engineering at a financial services firm with 10,001+ employees

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

View full review »
AU
reviewer1087131
Consultor Senior at a tech services company with 51-200 employees

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. 

View full review »
Punam Lade
Chief Operating Officer at humancloud

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.

View full review »
Learn what your peers think about SQL Azure. Get advice and tips from experienced pros sharing their opinions. Updated: March 2021.
476,892 professionals have used our research since 2012.