SQL Server Pros and Cons

SQL Server Pros

it_user79482
Senior Developer at a tech vendor with 201-500 employees
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.
View full review »
Недашковский Евгений
Senior SQL DBA at a financial services firm with 51-200 employees
If backups and alerts are configured properly, I can also rely on my restoration plan.
It is quite reliable in cluster configurations and has helped me to reduce downtime and improve SLAs.
Comparing with other database management systems that I tried in other companies, SQL Server is quite easy to install, configure, and maintain.
View full review »
Aju Mathai
Database Architect at Huron Consulting
It is one of the most stable relational databases out there.
View full review »
Find out what your peers are saying about Microsoft, Teradata, Oracle and others in Relational Databases. Updated: October 2019.
378,950 professionals have used our research since 2012.
BethWiebusch
Sr. Database and Application Administrator with 10,001+ employees
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.
It is a simple query language. It is consistent across all versions. If you start with an older version, move to the newer version. The same code will still work.
It can go easily on a virtual machine and be accommodated by a virtual machine easily. That is a plus, as not all databases can handle that.
It will do clustering, so you can have two database servers looking at the same data simultaneously.
View full review »
it_user272976
Managing Director at a tech services company with 11-50 employees
It's a very capable, efficient, price-performant OLAP server.
View full review »
it_user117381
Lead Software Engineer at a tech services company with 11-50 employees
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.
View full review »
Rahul Kumar Singh
Software Developer at a tech vendor with 501-1,000 employees
Tuning Advisor suggests where to add indexes and from where to remove them. It works like an adviser.
SQL Server Profiler makes finding and debugging easy.
I use it to fine tune my procedures and functions.
View full review »
Daniel Du Toit
Systems Analyst Developer with 1-10 employees
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.
View full review »
it_user540858
IT Technician / Support Supervisor at a transportation company with 501-1,000 employees
Enables us to convert to bigger DBs and more easily move or upgrade between branches.
View full review »
Pierre Marçon
User at a tech services company with 10,001+ employees
SSAS is the most interesting feature to organize the data and let the users play with it.
View full review »

SQL Server Cons

it_user79482
Senior Developer at a tech vendor with 201-500 employees
An area for improvement would be the SQL Server process monitoring, which is quite basic and could sustain more information.
The only item which I can list is application failure during Integration Services debugging, when restarting a process flow. In a number of instances the solutions fails. I have not given this much thought and simply stop and start the debugging service rather than restarting.
View full review »
Недашковский Евгений
Senior SQL DBA at a financial services firm with 51-200 employees
I would appreciate a dark theme for SQL Server Management Studio and ability to add databases with TDE enabled into availability groups.
View full review »
Aju Mathai
Database Architect at Huron Consulting
I would like to see native plugins built for other platforms versus having to buy third-party plugins to tap into S3 buckets and AWS Cloud. Right now, it does not have those built-in plugins.
View full review »
Find out what your peers are saying about Microsoft, Teradata, Oracle and others in Relational Databases. Updated: October 2019.
378,950 professionals have used our research since 2012.
BethWiebusch
Sr. Database and Application Administrator with 10,001+ employees
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.
View full review »
it_user272976
Managing Director at a tech services company with 11-50 employees
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.
For a big amount of data, when we are speaking about IoT Segments, and Big Data projects, there are performance issues.
View full review »
it_user117381
Lead Software Engineer at a tech services company with 11-50 employees
As a software developer, it can be hard to do something in Oracle that is SQL Server specific, and vice-versa, sometimes.
One stability issue I encountered was the deadlocking between calls to the same resources (tables, etc.). That was solved by row versioning.
View full review »
Rahul Kumar Singh
Software Developer at a tech vendor with 501-1,000 employees
Third-party services from Redgate should be built-in to it, like SQL Search.
Debugging from the debugger tool functionality should be enhanced.
View full review »
Daniel Du Toit
Systems Analyst Developer with 1-10 employees
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.
View full review »
DenisMunger
Chief of Engineering at a comms service provider with 11-50 employees
Only one CPU core can be used. Can’t move a database between servers easily. Can’t use triggers.
View full review »
it_user540858
IT Technician / Support Supervisor at a transportation company with 501-1,000 employees
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.
View full review »
Find out what your peers are saying about Microsoft, Teradata, Oracle and others in Relational Databases. Updated: October 2019.
378,950 professionals have used our research since 2012.
Sign Up with Email