SQL Server Review

For Mission Critical Systems, Data Warehouses, And Big Data Solutions.


What is most valuable?

Performance improvements, optimizer enhancements. Most of our clients have high demands for performance, and this version of SQL Server delivers what we need.

How has it helped my organization?

We are a professional services company, so we use SQL Server to help our clients achieve their goals. Our clients use SQL Server 2016 for their most demanding mission critical systems, for data warehouses, and big data solutions.

What needs improvement?

The Query Store is a good start, but I expect the query processor to be a lot smarter and to use machine learning in order to improve and adjust execution plans automatically.

For how long have I used the solution?

One year.

What do I think about the stability of the solution?

Since we are working with a lot of clients on many edge cases, we encounter bugs and stability issues once in a while, but these are rare.

What do I think about the scalability of the solution?

If you know how to work with the product and leverage its various features and possibilities, then you can achieve great scalability.

How is customer service and technical support?

Microsoft offers several levels of technical support, which is OK, but not too good. But there is a wonderful community with lots of resources on the internet, so most issues can be solved without contacting Microsoft support.

Which solutions did we use previously?

No, I have been using SQL Server for the past 20 years.

How was the initial setup?

The initial setup is very clear and friendly. It has improved from the previous version.

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

Unfortunately, SQL Server licensing is a very complex topic. I advise people to consult with a licensing expert.

Which other solutions did I evaluate?

No.

What other advice do I have?

Download the Developer Edition for free, install it on your personal computer (it’s very easy), and start exploring. If you need help with something, just search for it on the internet, and you’ll find a wealth of resources about everything you need.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Guest
Sign Up with Email