Microsoft BI Review

Despite vague error messages, some functions were cut down from 90 seconds to about less than one second

Valuable Features

  • SQL Server Integration Services
  • SQL Server Management Studio

Improvements to My Organization

There have been occasions when a certain application would work very slowly on other DB platforms and once we migrated to SQL Server the response times improved dramatically. For example, I recently migrated an application from TeraData to SQL Server and the response times for some functions were cut down from 90 seconds to about less than 1 second! This obviously speeds up the work that gets done within a day.

Room for Improvement

The SQL Server Reporting Services can certainly use some more help. Within SSIS, I see room for more connectors and easier debug messages that would speed up the process of development. The biggest hurdle that any developer comes across is vague error messages.

Use of Solution

About eight to nine years.

Deployment Issues

No. The installation and deployment process has always been smooth and simple.

Stability Issues

No. Product is very robust and reliable.

Scalability Issues

Adding extra machines to the cluster environment is not difficult but certainly needs experienced developers/implementers to do that.

Customer Service and Technical Support

Customer Service:

Excellent. They usually turn around within good time and you can also request new features directly from the group that is responsible for the product.

Technical Support:


Previous Solutions

A different solution was not used previously.

Initial Setup

I have been to many projects and usually the setup is pretty straight forward. But even when it comes to complicated setups such as multiple clusters, the product still seems easy once understood.

Implementation Team

In-house implementation.

Pricing, Setup Cost and Licensing

It varies from place to place. But a typical license would cost anywhere from a few thousand bucks to the upper $20k-$30k range.

Other Solutions Considered

  • MicroStrategy
  • TeraData
  • Informatica.

Other Advice

Look at the amount of data that you have and the amount you anticipate in the future. If you have multiple sources of data and multiple applications consuming it, sticking to a single solution might not be the best idea.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Sign Up with Email