Mar 2, 2013Mar 18, 2013Business Intelligence

First impressions of Microsoft Data Explorer for Excel

Today, while I was going over my RSS feeds, I noticed that Microsoft released their Data Explorer as official Preview version. You can read the…

Nov 16, 2012Administration

Enable additional logging for SQL Server management data warehouse collection sets

Today I finally found some spare time to dig into some SQL Server management data warehouse issues we were experiencing. The collection jobs failed for no…

Jun 24, 2012Mar 18, 2013Administration

Analysis Services 2000 – a ton of discoveries over a weekend

This weekend I had quite a lot of activities related to a migration of Analysis Services 2000 from one machine to another. With the limited…

Oct 29, 2011Feb 11, 2012Administration

How to set PreAllocate parameter in SQL Server Analysis Services and something more

I suppose you think that changing a parameter in SQL Server Analysis Services engine is quite easy stuff. And probably you are right, because I…

Mar 3, 2011Jan 2, 2018SQL Server 2005

SQL Server AS failed to start with message “SQL Server Analysis Services () service on Local Computer started and then stopped. Some services stop automatically if they are not used by other services or programs”

This is a very strange issue I came across last week. We have a consolidation server with several 2005 SP3 instances, including couple of…

Oct 12, 2010SQL Server Analysis Services

Minimum requirements for starting SQL Server 2008 analysis services

In this article I will try to explain what are the minimum requirements to start SQL server analysis services instance in case of failure. Analysis…

Mar 18, 2010Jan 6, 2013Business Intelligence

Creating dual Y-axis chart in SSRS 2008

In this post I will show you how to create a simple report with dual Y-axis column chart. It is a very common requirement in…