Monthly Archives: October 2016

Pushing till we get there

By | October 18, 2016

I am a very difficult boss to work with. Before I carry on I want to explain that I don’t derive any pleasure from it; it’s just something that’s worked for me. A few days back I was watching a documentary on the training of Special Forces in the Indian Army and the end of… Read More »

Word Cloud on Second Presidential Debate :- SSIS and PowerBI

By | October 11, 2016

With the recent debates on the US presidential election we felt it presented a good opportunity to do some text analytics on the second presidential debates. We used the links in the reference section below to do most of the analysis and the results are presented as is. The intention of the post is to… Read More »

Plan reuse for conditional statements in MS SQL Server

By | October 7, 2016

I was asked this question the other day on linkedin and figured it might be good to write a post on it considering the confusion around the topic. The question was I always read that in case of multiple execution paths, execution plan is saved for the first ever executed path. So if my SP… Read More »

Creating subfolders within SSAS

By | October 5, 2016

Recently there was a requirement for organizing columns from certain dimensions into individual entities within the presentation layer of powerview and powerbi. The approach that was taken was to create additional dimension tables that reference only those subset of columns. Similar to the diagram below. While the above design will do the job, we see… Read More »

Tracing Analysis Services – the trace that won’t stop

By | October 4, 2016

I am currently facing an issue where profiler is running a trace on SSAS and the trace can’t be stopped from within SSMS profiler since it keeps throwing the below message. Here is a very good link to identify and stop traces that are currently running on SSAS using XMLA commands. Unfortunately this hasn’t worked… Read More »