Category Archives: Programming

Run your cubes in Warp Speed – Really Really Fast!

Posted on 01/04/2014 by Jens Vestergaard

So, finally Microsoft came up with a new feature for the MOLAP part of Analysis Services. The community has been hungering for updates ever since the new kid Tabular came around. Now it apears that the SQL Server team has … Continue reading →

Posted in Programming | Tagged , , | 1 Comment

How to Process Multiple Dimensions via BIDS and SSMS

Posted on 31/03/2014 by Jens Vestergaard

This is one of those tips I need to write down, before I forget… Sometimes Analysis Services acts up and you need to do a process full on all the dimensions in the database. When that happens I usually turned … Continue reading →

Posted in Programming | Tagged , , | 1 Comment

SSIS Script Task and Proxy Auto Configuration (PAC) Script

Posted on 19/03/2014 by Jens Vestergaard

Actually this post could have been divided into several topics, but currently time does not permit me to write that often. So this will be the whole shabang at once. We needed to import data from an external source, using … Continue reading →

Posted in Programming | Tagged , , | Leave a comment

How to generate the alphabet from ASCII codes in T-SQL

Posted on 19/02/2014 by Jens Vestergaard

Just now I had the requirement to create a loop in SSIS, and have that loop the alphabet. In order to facilitate that, I generated a T-SQL statement, that provides the alphabet including the Danish Æ, Ø and Å. If … Continue reading →

Posted in Programming | Tagged , , | Leave a comment

Subtle differences in Teradata and SQL Server, Part 2

Posted on 17/02/2014 by Jens Vestergaard

Implementing Business logic in views is something seen quite often. Actually a view in my experience often contains some sort of data enrichment, -enhancement or -extension. So I am surely not the first one to come across the thought of … Continue reading →

Posted in Programming | Tagged , | Leave a comment