SQL Server Review

​It has enhanced our real time decision making capabilities but SSRS could include some ad hoc reporting.


What is most valuable?

There are lots of features including the analysis, database, and reporting, services. We use it mainly for reporting and analysis purposes.

The components I use are -

  • SSAS 8.5/10
  • SSIS 8/10
  • SSRS 7/10

How has it helped my organization?

It has enhanced our real time decision making capabilities. It ensures we are up to date regarding our customers buying behaviour.

What needs improvement?

  • SSRS should have more capabilities in terms of more ad hoc reporting
  • SSAS multi-dimensional expression queries should be more simple

For how long have I used the solution?

I've been using it for the last five and a half years.

What was my experience with deployment of the solution?

With the latest version, it's very easy and intuitive.

What do I think about the stability of the solution?

We had a stability issue with the SSRS component when we deployed it into the production environment.

What do I think about the scalability of the solution?

Not much of an issue to date.

How are customer service and technical support?

Customer Service:

9/10.

Technical Support:

9/10.

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

We were using a solution from Informatica for ETL purpose, which was 8.5/10, but now we are doing it through SSIS, because it is easy to use and its cost.

How was the initial setup?

The migration was, as always, a hard job, but we were able to migrate successfully.

What about the implementation team?

We implemented it in-house.

What was our ROI?

We are pleased with the level of our ROI.

**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
1 Comment

author avatarGaryM
Top 5PopularReal User

Re. SSRS for adhoc reporting, I would argue SSRS was not meant for adhoc reporting - that's the purpose of PowerBI and Excel PowerPivot. The people who use SSRS should be data consumers who want specific formats whereas adhoc reporting is data explorers who will want a different tool. One size never fits all with any vendor and this is not exception.