SQL Server Review

Stable, flexible, and scalable

What is our primary use case?

Currently, I'm moving to another set of projects. One is for a small company that supports a client and is building on a different surface on the SQL server. The cloud that is used is essentially Amazon AWS.

What is most valuable?

SQL SSIS is the most useful aspect of the solution.

We find the product to be relatively stable.

The solution seems to be pretty flexible.

What needs improvement?

Due to the fact that I'm dealing with the product more as a data analyst, the SQL Server management studio is really relatively primitive compared to other more advanced tools. There are other tools on the market that are much more advanced. It would be better if they managed to give us a bit more of a user-friendly product with just a bit more meat on the bone. It's a bit basic.

There are a number of features that are lacking. Just recently I had to do something and it's not available on the SQL Server. However, it's available on another solution that's actually a much cheaper product. 

Some areas need improvement. For example, how you deal with the manipulation of data is probably not the best.

For how long have I used the solution?

While I haven't constantly used the product all of the time, overall, I've used it for over 10 years at this point. I have quite a few years of experience with it.

What do I think about the stability of the solution?

The solution is quite stable. It doesn't have issues with bugs or glitches. It doesn't crash or freeze. It's good.

What do I think about the scalability of the solution?

In general, the solution is scalable. Microsoft, compared to the others, tends to focus more on the programming ability of the solution rather than the user experience. Rather than making it more user-friendly, they tend to make it more program-friendly.

We have about 70 users on the solution currently.

It's my understanding that the client is planning to scale up to be able to take on more customers in the near future. They may therefore increase usage.

How are customer service and technical support?

Mostly, I personally am on the analytics and new project development side of things in our organization. Therefore, I typically don't deal with technical support. I can't speak to how supportive, knowledgeable, or responsive they are. 

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

I typically use SQL wherever I go, however, I don't necessarily use Microsoft all the time. I also occasionally use a solution called Teradata.

How was the initial setup?

I was not involved in the installation of the solution. I'm more on the side of creating metadata. Therefore, it would be difficult for me to comment on if the solution was easy or difficult to implement or how our team deployed it. I don't have any exact details on that front.

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

While there are costs involved in using the product, I'm not a part of the billing or payments team. I can't speak to how much the solution costs or how much our organization pays. I do not know if it's monthly or yearly and how long our contract is for, if we have one.

What other advice do I have?

I'm using the 2016 or 2017 version of the solution.

There are many SQL options. I'd only recommend this one if it made sense to the individual company and their requirements.

In general, I'd rate the solution at an eight out of ten.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

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