SQL Server Review

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

Valuable Features

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

Improvements to My Organization

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

Room for Improvement

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

Use of Solution

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

Deployment Issues

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

Stability Issues

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

Scalability Issues

Not much of an issue to date.

Customer Service and Technical Support

Customer Service:


Technical Support:


Previous Solutions

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.

Initial Setup

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

Implementation Team

We implemented it in-house.


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.
1 visitor found this review helpful
1 Comment

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.

18 May 16
Sign Up with Email