SQL Server Review

Easy to use and integrates well with other Microsoft products, but the performance needs improvement, and there are many hidden costs at the enterprise level


What is our primary use case?

We are using SQL server for both transactional and analytical purposes, and for storing the data.

How has it helped my organization?

We are familiar with Microsoft products and bringing another Microsoft product was a very easy transition.

What is most valuable?

The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products.

What needs improvement?

The performance needs some improvement and it needs more features integrated into it.

Technical support could be better. 

Scalability could be less costly.

One of the conflicts with Microsoft is if you have an enterprise relationship, you have to deal with a third-party offering Microsoft solutions.

In the 2016 version, they don't have support for Python. It may be included with the 2019 version but if they don't, I would like to see support for Python implemented.

For how long have I used the solution?

The company has been using this solution for approximately 20 years. I was in contracting and now have been using it for approximately five years.

What do I think about the stability of the solution?

SQL Server is pretty stable.

What do I think about the scalability of the solution?

There is a concern with the scalability because it's an on-premise technology. 

Scaling always comes with more costs and also the licensing cost increase, which makes it complex, and more difficult.

We have backend developers, data engineers, data scientists, and analysts using this solution.

How are customer service and technical support?

Most of the time, technical support is not straightforward and it goes to a third party.

I wouldn't say that it is great, but okay.

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

Previously, we had not used any other solutions. We have been a Microsoft shop from the beginning.

How was the initial setup?

The initial setup was not easy but not complex. Rather, it was somewhere in between.

What about the implementation team?

We did not use an integrator or reseller to deploy this solution.

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

Pricing is reasonable for small organizations, but the scaling increases the price.

For larger organizations that would be using enterprise solutions, it contains some hidden costs.

What other advice do I have?

It's suited for small organizations, but if someone from a larger organization is looking for this, they might have some problems implementing enterprise-wide solutions. This is because of the integrations, as there would be hidden costs to it.

The best parts of this solution are the costs and that it is easy to use, but the cons would be with implementing an enterprise-wide solution. There are many hidden factors, such as costs. Also, you have to put more effort into integrating with other solutions across the enterprise.

I would rate this solution a six out of ten.

Which deployment model are you using for this solution?

On-premises
**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 Computer Software Company
...who compared it with Oracle Database
Add a Comment
Guest