Try our new research platform with insights from 80,000+ expert users

Microsoft Azure SQL Database pros and cons

Vendor: Microsoft

4.3 out of 5

115 reviews
96% willing to recommend

576 followers

Pros & Cons summary

Microsoft Azure SQL Database offers high availability, ease of use with Microsoft apps, and automated scalability, reducing management efforts and total cost of ownership. Despite these advantages, it faces criticism for high pricing, complex setup, limited integration with third-party systems, and inadequate scalability for larger databases. Additionally, customer support is often unresponsive. These factors influence tech buyers seeking efficient and cost-effective database management solutions.

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.

Prominent pros & cons

PROS

Microsoft Azure SQL Database provides high availability and business continuity, offering users a stable and reliable database experience.

The cost-saving potential is significant, with customers benefiting from a reduced total cost of ownership.

Users appreciate the ease of setup and administration, highlighting the straightforward deployment process.

Its scalability is a notable feature, allowing seamless upscaling or downscaling to accommodate changing workload demands.

Integration with other Microsoft services is smooth and efficient, benefiting from Microsoft's ecosystem.

CONS

Microsoft Azure SQL Database has complex initial setup and configuration, often requiring extensive documentation and support, which could be improved.

The pricing structure of Microsoft Azure SQL Database is frequently cited as high and could benefit from being more competitive and clear.

The current scalability limitations of Microsoft Azure SQL Database restrict memory and usage, necessitating improvements in scalability without significant restrictions.

Users experience challenges with automation and integration with existing tools and systems, indicating a need for better integrations and automation features in Microsoft Azure SQL Database.

The customer support for Microsoft Azure SQL Database is often difficult to reach, with responses sometimes being ineffective and lacking in technical documentation, which could be enhanced.

Microsoft Azure SQL Database Pros review quotes

Solution architect at Rackspace

Mar 21, 2024

The product's initial setup phase is very easy.

Read full review

reviewer1615530

Project Manager at a educational organization with 11-50 employees

Jul 1, 2021

We have come from hosting on-premise for customers, or they've done it themselves with SQL. We've now taken a cloud offering for the equivalent services of standard database management and the inbuilt backup and restore offerings. The scalability is probably the biggest feature that we are benefiting from by being in the cloud.

Read full review

reviewer2596431

Software Engineer at a financial services firm with 51-200 employees

Nov 21, 2024

The ease of scaling the server up and down by simply pressing a few buttons in a dropdown menu has made our lives significantly more comfortable, especially as we aim to process more data this year by utilizing the cloud.

Read full review

Microsoft Azure SQL Database

Free Report: Microsoft Azure SQL Database Reviews and More

Learn what your peers think about Microsoft Azure SQL Database. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.

824,053 professionals have used our research since 2012.

FW

Fredrick Weinshenk

Cloud Engineer at Med Tech Solutions

Nov 20, 2024

Overall, Azure SQL has been great. The ease of deployment and scalability are significant reasons we push our larger clients to Azure. We could throw the kitchen sink at the thing if we wanted.

Read full review

Samuel Lambrecht

Principal Industry Consultant at Intelligent Operations Solutions

Aug 5, 2022

The most valuable aspect of SQL Azure is the SQL language itself. It's open and everybody can use it at my company. Also, we thought in the beginning that the response time would be inadequate, but it's actually decent. It's much better than expected. Then again, I'm not a programmer, but that's what I hear from our development team.

Read full review

Charley Hanania

Data Platform Specialist at QS2 AG - Quality Software Solutions

Nov 20, 2024

Microsoft Azure SQL Database is integrated into other Azure capabilities and has a great foundation being on SQL Server with a long history of security, performance, and usability from a DBA perspective.

Read full review

Digital Consulting Coe Lead & Delivery Engineer at Lunavi-wa

Nov 20, 2024

I like that Microsoft Azure SQL Database is almost identical to an on-premise SQL Server except for a few things, like how you edit rows and some jobs that you can't run.

Read full review

Raed Gharzeddine

Technical advisor and software architect at Technical advisor and software architect

Dec 8, 2022

I prefer using Microsoft SQL Server because I like the experience and the way Microsoft handles the query tuning and security.

Read full review

SZ

Slawomir Zablocki

Data Platform Architect at APN Promise

Jul 16, 2019

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.

Read full review

Senior Database Administrator at a comms service provider with 10,001+ employees

Feb 23, 2021

Cost savings are the most valuable. The DR/high availability is also valuable. The failover group with the built-in DR/high availability features is probably one of the easiest things.

Read full review

Show 10 more reviews (out of 108)

Microsoft Azure SQL Database Cons review quotes

Solution architect at Rackspace

Mar 21, 2024

There are certain shortcomings when it comes to the stability of the product, especially if I consider the fact that there can always be some bug-related issues in the tool.

Read full review

reviewer1615530

Project Manager at a educational organization with 11-50 employees

Jul 1, 2021

We haven't had any major issues that have prevented us from doing stuff fundamentally. For its implementation, sometimes, it is complicated to understand what your needs are. It would be good to have a few use cases that provide different cloud variations that match on-premise installations and show how they can be moved to the cloud a bit better.

Read full review

reviewer2596431

Software Engineer at a financial services firm with 51-200 employees

Nov 21, 2024

We've noticed an unexpected increase in the cost of running the server over the past few months.

Read full review

Microsoft Azure SQL Database

Free Report: Microsoft Azure SQL Database Reviews and More

Learn what your peers think about Microsoft Azure SQL Database. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.

824,053 professionals have used our research since 2012.

FW

Fredrick Weinshenk

Cloud Engineer at Med Tech Solutions

Nov 20, 2024

Improvement could be made in the performance tools, offering a better overview of core issues like process activity and latency, as we currently rely on third-party tools and SQL jobs for monitoring and alerts. A comprehensive built-in solution for performance analysis would be beneficial.

Read full review

Samuel Lambrecht

Principal Industry Consultant at Intelligent Operations Solutions

Aug 5, 2022

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.

Read full review

Charley Hanania

Data Platform Specialist at QS2 AG - Quality Software Solutions

Nov 20, 2024

Microsoft Azure SQL Database could improve by having better tooling in terms of connecting to other database platforms and better capabilities around programmable interfaces. There should be more fine-tuning on the storage layer. I would like to see T-SQL improvements to automatically translate features from other database platforms for easier migration, as well as some improvements around column store and native capabilities like those in Iceberg and PowerK built into the SQL Server product.

Read full review

Digital Consulting Coe Lead & Delivery Engineer at Lunavi-wa

Nov 20, 2024

They could improve Azure SQL by adding some of the features available on-prem, such as cross-database queries and the ability to run particular jobs. We need to migrate those to something else, like a function or logic app.

Read full review

Raed Gharzeddine

Technical advisor and software architect at Technical advisor and software architect

Dec 8, 2022

One of the nice features in Microsoft SQL Server is the SQL Server CLR, which we sometimes need to use to protect our procedures using C# or CLR. This is not available in the SQL Azure database.

Read full review

SZ

Slawomir Zablocki

Data Platform Architect at APN Promise

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.

Read full review

Senior Database Administrator at a comms service provider with 10,001+ employees

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.

Read full review

Show 10 more reviews (out of 109)

Product Categories

Product Categories

Database as a Service (DBaaS)

Popular Comparisons

Popular Comparisons

Amazon RDS vs Microsoft Azure SQL Database

Google Cloud SQL vs Microsoft Azure SQL Database

MongoDB Atlas vs Microsoft Azure SQL Database

Oracle Database as a Service vs Microsoft Azure SQL Database

Google Cloud Spanner vs Microsoft Azure SQL Database

vCloud Air vs Microsoft Azure SQL Database

Yugabyte Platform vs Microsoft Azure SQL Database

Oracle Exadata Express Cloud Service vs Microsoft Azure SQL Database

IBM Db2 on Cloud vs Microsoft Azure SQL Database

See all alternatives

Product Categories

Product Categories

Database as a Service (DBaaS)

Popular Comparisons

Popular Comparisons

Amazon RDS vs Microsoft Azure SQL Database

Google Cloud SQL vs Microsoft Azure SQL Database

MongoDB Atlas vs Microsoft Azure SQL Database

Oracle Database as a Service vs Microsoft Azure SQL Database

Google Cloud Spanner vs Microsoft Azure SQL Database

vCloud Air vs Microsoft Azure SQL Database

Yugabyte Platform vs Microsoft Azure SQL Database

Oracle Exadata Express Cloud Service vs Microsoft Azure SQL Database

IBM Db2 on Cloud vs Microsoft Azure SQL Database

See all alternatives

Related questions

5

When evaluating Database as a Service, what aspect do you think is the most important to look for?

10

What would be the best application SQL optimizer over the WAN?

53

Which database is the best for session cashing?

157

What is the biggest difference between Google BigQuery and Oracle Database as Service?

32

Which low-code (no-code) database solution do you prefer?

10

Which databases are supported under DBaaS solutions?

0

Why is Database as a Service important for companies?