Word Cloud on Second Presidential Debate :- SSIS and PowerBI

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…

Plan reuse for conditional statements in MS SQL Server

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…

Creating subfolders within SSAS

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…

Tracing Analysis Services – the trace that won’t stop

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…