SQL Server Pros and Cons

SQL Server Pros

Aju Mathai
Database Architect at Huron Consulting
It is one of the most stable relational databases out there.
View full review »
Rahul Kumar Singh
Software Developer at OATI
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 »
Find out what your peers are saying about Microsoft, Teradata, Oracle and others in Relational Databases. Updated: March 2020.
407,538 professionals have used our research since 2012.
Paul Fijma
Engineer / MS SQL DBA at Solvinity
This solution has proven stability and operational power.
View full review »
GhamdanAl-Anesi
Member of the Board & Co-Founder, Executive Manager at Networld Systems
The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations.
View full review »

SQL Server Cons

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 »
Rahul Kumar Singh
Software Developer at OATI
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 »
Find out what your peers are saying about Microsoft, Teradata, Oracle and others in Relational Databases. Updated: March 2020.
407,538 professionals have used our research since 2012.
Paul Fijma
Engineer / MS SQL DBA at Solvinity
Improvements to the indexing, columnstore indexing, and high availability groups are good improvements for future versions.
View full review »
GhamdanAl-Anesi
Member of the Board & Co-Founder, Executive Manager at Networld Systems
I would like to have more replication scenarios.
View full review »
Find out what your peers are saying about Microsoft, Teradata, Oracle and others in Relational Databases. Updated: March 2020.
407,538 professionals have used our research since 2012.