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

116 reviews
96% willing to recommend

576 followers

Pros & Cons summary

Microsoft Azure SQL Database offers high stability and performance, often exceeding expectations. It delivers cost savings and flexibility with a pay-as-you-go model and seamless integration with Microsoft services. While highly scalable, expanding beyond two terabytes and reducing pricing could improve it. Enhancements are needed for integration with open-source technologies and performance tools. Complex initial setup requires better documentation and training, and users request more accessible and effective support.

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 offers high availability and business continuity, making it a reliable choice for database management.

The solution is known for its stability and fantastic performance, even when handling inquiries into issues.

Initial setup is straightforward, allowing quick deployment and minimizing downtime during implementation.

Azure SQL enables significant cost savings, eliminating the need for dedicated environments and infrastructure management.

The scalability and integration capabilities of Azure SQL with Microsoft Cloud and related applications enhance efficiency and ease of use.

CONS

Microsoft Azure SQL Database is considered expensive by users, and there's a need for a more competitive pricing model.

There are limitations in scalability and memory, affecting performance and storage capabilities.

The initial setup is complex, and the documentation and support are lacking.

Integrations with existing applications and third-party tools could be improved for better compatibility and functionality.

Security and customer support need improvements to simplify user authorization and access processes.

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: January 2025.

831,158 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

TG

CTO at 2W Technologies, INC

Dec 11, 2024

Azure SQL Database is very quick and easy to use. It certainly makes my infrastructure and development teams more efficient.

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

Show 10 more reviews (out of 109)

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: January 2025.

831,158 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

TG

CTO at 2W Technologies, INC

Dec 11, 2024

There are compatibility issues that prevent Azure SQL Database from being a direct replacement for SQL Server running on a virtual machine. For instance, handling application-initiated DBCC commands is a challenge.

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

Show 10 more reviews (out of 110)

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

SingleStore vs Microsoft Azure SQL Database

Oracle Database as a Service vs Microsoft Azure SQL Database

Google Cloud Spanner vs Microsoft Azure SQL Database

Oracle Exadata Cloud at Customer 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

SingleStore vs Microsoft Azure SQL Database

Oracle Database as a Service vs Microsoft Azure SQL Database

Google Cloud Spanner vs Microsoft Azure SQL Database

Oracle Exadata Cloud at Customer 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?

51

Which database is the best for session cashing?

138

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

36

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?