Tag Archives: power

SSIS – Starter kit for the uninitiated – Data enrichment

By | August 10, 2015

In this last post (after which there will be a video explaining how to bring all this together in Power view) I cover how to convert geo coordinates from 38° 53′ 55.133″ N to Decimal Coordinate system 38.898648. You can find the previous posts here. The calculations is fairly simple the sql for it is… Read More »

SSIS – Starter kit for the uninitiated Foreachloop – for each file enumerator

By | August 7, 2015

In this post we continue from where we left off in the last post, with the xml files now formatted properly it’s time to load the data into the database. To achieve this I am going to use the foreach loop container once more and this time use the for each file enumerator. Step Screenshot… Read More »

SSIS – Starter kit for the uninitiated – Execute process task and PowerShell

By | August 4, 2015

In this fourth part of the series (see previous post here) we proceed to modify the XMl files downloaded from the web service. While this step is not mandatory in most cases where the XML is well formed, in this particular example we see an issue with the file. Namely < And > text is… Read More »

SSIS – Starter kit for the uninitiated – Dynamic File Paths

By | August 4, 2015

Continuing from our previous post here we explore how to configure tasks to behave dynamically. More specifically how to configure the file connection manager to accept dynamic paths to store the output of our web service task. Navigate to the connection managers in the bottom pane of SSIS and right click the Connection manager we… Read More »

SSIS – Starter kit for the uninitiated – Foreachloop

By | August 4, 2015

I was up at 3:00 AM in the morning and felt that the world needs to know where all the airports are and how you could use SSIS and PowerView to display this information in a clean and concise way. This need was so powerful that I spent the next 4 hours writing an SSIS… Read More »

SQL 2016 – Updatable Columnstore Index finally OLTP and DW workloads delivered

By | July 13, 2015

So SQL 2016 comes with updatable non clustered columnstore index. Are you wondering why this is a big deal. It is and here’s why In SQL 2012 the Non clustered Columnstore index was introduced but was severely handicapped by the fact that once implemented the table was read only. In SQL 2014 the Clustered Columnstore… Read More »

Sometimes common sense takes a back seat to BI

By | March 9, 2015

This post has to do with how we sometimes loose the tree for the forest (no this is not a mistake), I had written a blog post sometime back about game theory and how it can help decide the outcome of certain business cases. I came across two instances in the last week where game… Read More »