SQL Server Review

Capable, efficient, OLAP server for Analysis Services; has Big-Data performance issues


What is our primary use case?

Initially as a post-transactional database, but now it's mainly a transactional database and for Analysis Services.

How has it helped my organization?

It's a very capable, efficient, price-performant OLAP server on which we can build our solutions.

What is most valuable?

Analysis Services, because we are an independent software vendor in the business-intelligence area.

What needs improvement?

The web interface and the command line interface could be better so we could manage and build some things around an API. If we could build our own solution, our own interface, and then manage the solution through that open API, that would be better.

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

With the new, big releases, there's quite a lot of work that we have to do. From 2005 to 2008, and then from 2012 to 2016. But, otherwise, it's quite stable. It's nice.

What do I think about the scalability of the solution?

Even for us, it's quite okay. For the type of customers we have now, it's okay. But, for a big amount of data, when we are speaking about IoT Segments, and Big Data projects, there are performance issues.

How is customer service and technical support?

If there wasn't Stack Overflow, that would be a problem. But luckily there are also other resources on the web which we can use to help ourselves. Just depending on Microsoft support it would not be so great.

Which solutions did we use previously?

We used PostgreSQL, and we also used some other OLAP servers.

How was the initial setup?

It's more and more complex. The 2005 version was very nice and neat, but now it's more and more complicated.

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

The price has been going higher and higher. The market is quite price sensitive.

Which other solutions did I evaluate?

At that time there was also Sybase, Oracle, MySQL. That's at the time those databases were up.

What other advice do I have?

It's good if you need OLAP services.

I give it a seven out of 10 overall, because of the things mentioned: First is that during the version upgrades, sometimes things are complicated. The second thing is the support is not so... without an open-source community it would not be so good. Third is the pricing, because it's changing, sometimes it's confusing.

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