Monthly Archives: October 2007

Recently we had a problem with Analysis Services double hop authentication. Thanks to the uber DBA guy here we were able to find a solution.   Thought I would share his write up (he spent a lot of time searching … Continue reading →

About six months ago we had an issue with incorrect query results. (http://jesseorosz.spaces.live.com/blog/cns!E322FD91218E57CF!250.entry). I had included in an aggregation a reference dimension with materialized set to False and SSAS didn’t like this.   Well much to my chagrin I tried the same … Continue reading →

I’m sure these won’t be available on Google books for long, however right now you can look at the pretty much the entire book at no cost. Very cool…even though I prefer to have a hard copy.   Microsoft SQL Server 2005 … Continue reading →

Last month I had a case open with MS and the subject of setting data slices came up. (http://jesseorosz.spaces.live.com/blog/cns!E322FD91218E57CF!304.entry). I decided to do a little investigating myself and found some of our queries were doing a scan of all the … Continue reading →