SQL Azure Pros and Cons

SQL Azure Pros

Slawomir Zablocki
Tech Clinical Engineer at APN Promise
What is really helpful about the Azure SQL is that when we have a problem with our sound queries, we can trade information about what indexes we should create on tables. It's really helpful for me and also for developers.
View full review »
reviewer1294518
Solution Principal at a computer software company with 5,001-10,000 employees
The solution is a fairly mature product. It provides good stability.
View full review »
reviewer1352925
Senior Information Technology Manager at a aerospace/defense firm with 10,001+ employees
We primarily and generally use it only for DB purposes. When it comes to the Azure part, we can easily provision, scale up, and scale down the generator machine. This kind of flexibility is the USP of SQL Azure. Its interface and ease of use are also valuable. It is very easy to use and integrate with multiple databases. If I need to pull in or import some data from my on-premises database, the ease with which you can connect and pull the data, not only from SQL Server but also from other flavors of MySQL or even Oracle, is very good.
View full review »
Learn what your peers think about SQL Azure. Get advice and tips from experienced pros sharing their opinions. Updated: January 2021.
456,966 professionals have used our research since 2012.
Nhan-Nguyen
Development Manager at Incepta
The solution has become easier to use over time and it's also reasonably priced.
View full review »
reviewer1369602
Lead Consultant at a tech services company with 10,001+ employees
Coding does not require much effort.
View full review »
IbrahimMuhanna
IT Manager at a pharma/biotech company with 201-500 employees
The initial setup was straightforward. It took less than one day for deployment.
View full review »
Haytham Mohamed
Enterprise End User Operations at a comms service provider with 1,001-5,000 employees
The stability is good and the performance is fantastic. Even when we try to do an inquiry into issues we can do it easily.
View full review »
reviewer1443378
IT Manager at a financial services firm with 51-200 employees
We like the ease of integrating it with our on-premises environment. We use a hybrid model. We have a SQL Server on-premises, and we have an integration with the cloud version. We do CPU or disk intensive processes on-premises. For accessibility, we offload onto the cloud. When you do a lot of IO and things like that in the cloud, Microsoft charges for the CPU activity.
View full review »
Sérgio Rita
IT Manager at a university with 51-200 employees
What I like the most is the processes and the easiness of deployments.
View full review »
MichaelSoliman
Owner at Alopex ONE UG
This solution provides more comfort to the end-user compared to a normal SQL server.
View full review »

SQL Azure Cons

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.
View full review »
reviewer1294518
Solution Principal at a computer software company with 5,001-10,000 employees
From a security perspective, although their features are decent, they can always be improved upon, updated, and refined to help protect clients better.
View full review »
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 »
Learn what your peers think about SQL Azure. Get advice and tips from experienced pros sharing their opinions. Updated: January 2021.
456,966 professionals have used our research since 2012.
Nhan-Nguyen
Development Manager at Incepta
Some issues with scalability.
View full review »
reviewer1369602
Lead Consultant at a tech services company with 10,001+ employees
Lacking in technical documentation.
View full review »
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 »
Haytham Mohamed
Enterprise End User Operations at a comms service provider with 1,001-5,000 employees
The initial setup is complex.
View full review »
reviewer1443378
IT Manager at a financial services firm with 51-200 employees
Price definitely will be the negative point. It is quite expensive.
View full review »
Sérgio Rita
IT Manager at a university with 51-200 employees
The configuration is the area that is most cumbersome.
View full review »
MichaelSoliman
Owner at Alopex ONE UG
The management is entirely controlled by Microsoft, so there are some restrictions.
View full review »
Learn what your peers think about SQL Azure. Get advice and tips from experienced pros sharing their opinions. Updated: January 2021.
456,966 professionals have used our research since 2012.