SQL Server Review

Very stable, user-friendly, easy to troubleshoot, and easy to manage databases

What is our primary use case?

We developed a product that is using five or six databases supported on SQL Server. 

What is most valuable?

It is a very user-friendly solution. It is easy to manage the databases and troubleshoot any issue. It is a perfect solution for the volume or transactions that we need to manage.

What needs improvement?

The way to make cursors and manage raw data in rows can be improved. Currently, the way to construct or build these cursors is very hard, and you can waste memory. You need a highly skilled person to make it more efficient.

It can also have support for Cubes, which is the organization of data in different dimensions by using MDX languages.

For how long have I used the solution?

I have been using this solution for ten years.

What do I think about the stability of the solution?

It is very stable. I would rate it an eight out of ten in terms of stability.

What do I think about the scalability of the solution?

It is scalable. You can get scalability by using the link servers, or you can create another instance in another server and make a link with that server. It is very quick.

We have around 50 users of this solution.

How are customer service and technical support?

I have not interacted with them.

How was the initial setup?

Its initial setup is easy. It takes a week. One of the things that you need to pay attention to is the collection.

What other advice do I have?

It is a nice product. You can use it as you want. If you don't know how to use it, you will waste it. Oracle is more powerful than this, but it is great for our needs.

I would rate SQL Server an eight out of ten.

Which deployment model are you using for this solution?


Which version of this solution are you currently using?

**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.
535,919 professionals have used our research since 2012.
Add a Comment
ITCS user