SQL Server Review

Great integration with extensive documentation and a good community for support purposes

What is our primary use case?

We primarily use the solution for recording transactions and information related to the reservation of a service. 

What is most valuable?

The product is very stable.

It offers very good documentation. When there are some little issues, it's always very easy to go into the documentation for troubleshooting purposes. There's just so much documentation on hand and a really great community around the product that is very helpful.

It's a very complete product.

We've found it to basically be pretty problem-free.

The integration with other products has always been quite good.

The security of the product has never given us any issues.

What needs improvement?

We're quite satisfied with the solution. There aren't any outstanding features we would like to add.

The interface could be updated to make it slightly more user-friendly.

For how long have I used the solution?

We've been using the solution for more than ten years. It's been a while. It's been more than a decade at this point.

What do I think about the stability of the solution?

The solution is very stable. there are no bugs or glitches. It doesn't crash or freeze. it's excellent.

What do I think about the scalability of the solution?

We haven't really scaled the solution all that much. At the moment, we have measured the scalability in a horizontal way. When we needed to have more installation and more capacity, we split the database into a different SQL Server instance.

In the future, we'll likely need to consider scalability more. We are also moving in the last two years, also to a different architecture from a monolithic to a more microservice architecture. Maybe the scalability can be more easily handled in the applications that are talking to each other and leaving the database out of the equation.

While end-users are hard to quantify, I can say that likely half a million users have come through our system for transactions.

In the near future, we will continue to use the solution. We might use it for the next four or five years, although it is hard to say.

How are customer service and technical support?

We've always been able to rely on the fantastic documentation and great community around the product in order to troubleshoot problems. It's very easy to fix issues as they arise due to the public knowledge available to everyone.

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

We've mostly always used this solution. Last quarter, we moved a little bit to a NoSQL database. We have done a little experiment on Cassandra however, previously, it has always been on SQL Server.

We're considering moving away from the solution right now and trying something new. The owner of the company wants to experiment with other technologies and see what is out there, which is why there is talk of change. However, it's not a reflection on this product, which has been largely quite good.

How was the initial setup?

The initial setup is not overly difficult. It's pretty straightforward. A company shouldn't have any issues with the process.

We have 12 technical people on our team that can handle the implementation.

What other advice do I have?

The last version we used is 2015 if I'm not mistaken. We don't jump immediately to the latest version due to the fact that, usually, we look for stability. We make the move to the next version in case of some integration or limitation. We prefer not to move onto something that might have bugs or glitches that need to be patched. It's more secure for us that way. 

I'd recommend the solution to other companies.

I'd rate the solution at a ten out of ten. It's doing exactly what we need it to do. We've very happy with it.

Which deployment model are you using for this solution?

**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: May 2021.
513,091 professionals have used our research since 2012.
Add a Comment
ITCS user