SQL Server Pros and Cons
SQL Server Pros
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 »
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 »
It is one of the most stable relational databases out there.View full review »
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's a very capable, efficient, price-performant OLAP server.View full review »
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 »
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 »
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 »
Enables us to convert to bigger DBs and more easily move or upgrade between branches.View full review »
SSAS is the most interesting feature to organize the data and let the users play with it.View full review »
SQL Server Cons
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
Only one CPU core can be used. Can’t move a database between servers easily. Can’t use triggers.View full review »
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 »