SQL Server Review

User friendly, performs well, and backward compatibility

What is our primary use case?

The solution is an RDBMS and can be used to simplify customers' requirements for a back-end database. The main function of the solution is to store information from front-end users.

What is most valuable?

The most valuable feature of the solution, compared to other RDBMS solutions, such as Oracle MySQL or IBM DB2, it is more user-friendly and has backward compatibility. For example, if you have an application that requires an old version of SQL Server and you have the latest version of the license, you are able to install and use it in backward compatibility mode. They keep supporting the existing legacy application. Additionally, the solution is simple and if it is configured properly it performs very well. 

For how long have I used the solution?

I have used the solution for approximately six years.

What do I think about the stability of the solution?

I find the solution to be very stable. 

What do I think about the scalability of the solution?

The solution is scalable. 

How are customer service and technical support?

The technical support is only provided to the customers having a subscription-based license with a Software Assurance server. For other forms of licensing the solution will not provide support. 

Which solution did I use previously and why did I switch?

I have previously used other RDBMS solutions, such as Oracle MySQL, Maria DB, PostgreSQL, and IBM DB2.

When comparing PostgreSQL, Oracle MySQL, and Microsoft SQL, Microsoft SQL has an advantage over the other two server databases because it provides a graphical user interface by default.

How was the initial setup?

The initial setup of the solution is very easy and the time it takes depends on the architecture required. If the deployment of a cluster is required then the setup may take up to three hours, whereas standard environment deployment needs half an hour. 

What about the implementation team?

The solution can be installed by our selves but the use of an integrator makes it much easier. 

What's my experience with pricing, setup cost, and licensing?

The solution requires authorization in either the form of perpetual licensing or subscription-based licenses for two years. If a perpetual license version is purchased then customers have it to the end of life, whereas a subscription-based called server with Software Assurance, has to be renewed every two years. 

The areas that need improvement are with regards to the commercial aspect of the solution, the licensing cost could be reduced in order to help customers to adopt it.

What other advice do I have?

I would recommend this solution. However, the customer has to make sure it fits their use case.

I rate SQL Server a nine out of ten. 

Which deployment model are you using for this solution?

Hybrid Cloud

Which version of this solution are you currently using?

Latest version
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More SQL Server reviews from users
...who work at a Financial Services Firm
...who compared it with Oracle Database
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: August 2021.
534,768 professionals have used our research since 2012.
Add a Comment
ITCS user