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

SQL Server pros and cons

Vendor: Microsoft
4.2 out of 5
Badge Ranked 1

Pros & Cons summary

Buyer's Guide

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

Prominent pros & cons

PROS

SQL Server is highly scalable and can handle increasing database sizes and traffic with ease, making it suitable for large-scale operations.
It offers robust features for high availability and disaster recovery, including AlwaysOn availability groups and clustering capabilities.
The platform integrates well with other Microsoft tools and services, enhancing its utility in varied IT ecosystems.
SQL Server is praised for its stability and reliability, minimizing downtime and ensuring smooth operations for businesses.
With a mature ecosystem, SQL Server provides excellent technical support and resources for users.

CONS

SQL Server faces scalability challenges that need improvement for handling larger data volumes and concurrent users.
Integration with third-party tools and platforms is lacking and could be improved for better compatibility.
Licensing costs are high and present a significant barrier for many users, with calls for more affordable pricing options.
Performance issues are noted, particularly with handling big data and requiring enhancements for better speed and efficiency.
Security concerns are frequently mentioned, requiring more robust measures against vulnerabilities and threats.
 

SQL Server Pros review quotes

it_user117381 - PeerSpot reviewer
Lead Software Engineer at a tech services company with 11-50 employees
Dec 26, 2017
There was an online system in which we had about 2500 requests to the DB per second. Every request had a completion window of one second to process and retrieve data. After switching to SQL Server, and AlwaysOn, and Snapshot, and tinkering, and configuring and tinkering, the handling capacity we measured increased to about 5000 requests per second, while the time decreased to 0.5 seconds per request.
it_user796899 - PeerSpot reviewer
Sr. Database and Application Administrator with 10,001+ employees
Jan 4, 2018
You could have an offsite and an onsite, and if the onsite goes down, the offsite picks it up. I like that flexibility to provide continuing operations.
НЕ
Senior SQL DBA at a financial services firm with 51-200 employees
Jan 4, 2018
If backups and alerts are configured properly, I can also rely on my restoration plan.
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: January 2026.
881,082 professionals have used our research since 2012.
it_user540858 - PeerSpot reviewer
IT Technician / Support Supervisor at a transportation company with 501-1,000 employees
Jan 7, 2018
Enables us to convert to bigger DBs and more easily move or upgrade between branches.
it_user272976 - PeerSpot reviewer
Managing Director at a tech services company with 11-50 employees
Jan 23, 2018
It's a very capable, efficient, price-performant OLAP server.
it_user79482 - PeerSpot reviewer
Senior Developer at a tech vendor with 201-500 employees
Jan 23, 2018
Without any doubt the Integration Services and Analysis Services are the most widely used. These are the basis for data quality, data gathering, ETL process, as well as collation for the data warehouse, Cube-generation, and ad-hoc processes. The ease in which you may mold a process flow or even modularly add in new structures is something which is much needed in my job.
it_user823959 - PeerSpot reviewer
Works at a tech services company with 10,001+ employees
Feb 21, 2018
SSAS is the most interesting feature to organize the data and let the users play with it.
PF
Engineer / MS SQL DBA at Solvinity
Jul 19, 2018
This solution has proven stability and operational power.
RS
Software Developer at OATI
Aug 10, 2018
Tuning Advisor suggests where to add indexes and from where to remove them. It works like an adviser.
it_user941640 - PeerSpot reviewer
Systems Analyst Developer with 1-10 employees
Nov 18, 2018
I have experience with this product for many years. I never have problems with it. It can handle a PC, and it can also handle huge data. It is fast and efficient.
 

SQL Server Cons review quotes

it_user117381 - PeerSpot reviewer
Lead Software Engineer at a tech services company with 11-50 employees
Dec 26, 2017
As a software developer, it can be hard to do something in Oracle that is SQL Server specific, and vice-versa, sometimes.
it_user796899 - PeerSpot reviewer
Sr. Database and Application Administrator with 10,001+ employees
Jan 4, 2018
It pesters you to update the Client every month when there is nothing new that you really need to add, but it is constantly pestering you. I do not care for it.
НЕ
Senior SQL DBA at a financial services firm with 51-200 employees
Jan 4, 2018
I would appreciate a dark theme for SQL Server Management Studio and ability to add databases with TDE enabled into availability groups.
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: January 2026.
881,082 professionals have used our research since 2012.
it_user540858 - PeerSpot reviewer
IT Technician / Support Supervisor at a transportation company with 501-1,000 employees
Jan 7, 2018
From a DB administrator perspective, I would like to see more space requirements and space capacity history, so that we are able to see which DBs are growing, and by how much per day or week.
it_user272976 - PeerSpot reviewer
Managing Director at a tech services company with 11-50 employees
Jan 23, 2018
The web interface and the command line interface could be better so we could manage and build some things around an API. If we could build our own solution, our own interface, and then manage the solution through that open API, that would be better.
it_user79482 - PeerSpot reviewer
Senior Developer at a tech vendor with 201-500 employees
Jan 23, 2018
An area for improvement would be the SQL Server process monitoring, which is quite basic and could sustain more information.
it_user823959 - PeerSpot reviewer
Works at a tech services company with 10,001+ employees
Feb 21, 2018
The reporting services of the solution (SSRS and now Power BI) are the less valuable items of the SQL Server suite.
PF
Engineer / MS SQL DBA at Solvinity
Jul 19, 2018
Improvements to the indexing, columnstore indexing, and high availability groups are good improvements for future versions.
RS
Software Developer at OATI
Aug 10, 2018
Third-party services from Redgate should be built-in to it, like SQL Search.
it_user941640 - PeerSpot reviewer
Systems Analyst Developer with 1-10 employees
Nov 18, 2018
It would be nice if there was a feature to search for a specific value across multiple tables. This would save a lot of time for its users.