Category Archives: Programming

Teradata based Data Source Views in Analysis Services

Posted on 05/11/2013 by Jens Vestergaard

Now here’s a catch. I was trying all night long to figure out why Visual Studio was hanging on me, every time I wanted to add a Teradata based relational data source. Turns out that the list of available objects … Continue reading →

Posted in Programming | Tagged , , | 1 Comment

Microsoft SQL Server 2014 CTP2 Data Tools BI templates for VS2012

Posted on 28/10/2013 by Jens Vestergaard

In case you missed it, here is the Microsoft SQL Server 2014 CTP2 Data Tools Business Intelligence project templates for Visual Studio 2012. http://www.microsoft.com/en-us/download/details.aspx?id=40736 This fixes one major pain on my laptop: No longer need for SSDT on one machine … Continue reading →

Posted in Programming | Tagged , , | Leave a comment

SQL Server 2014 Community Technology Preview 2 (CTP2) Available

Posted on 17/10/2013 by Jens Vestergaard

Finally the SQL Server 2014 Community Technology Preview 2 (CTP2) was released early Thursday morning. Get it here: http://technet.microsoft.com/en-us/evalcenter/dn205290.aspx Get the product guide here: http://www.microsoft.com/en-us/download/confirmation.aspx?id=39269  

Posted in Programming | Tagged , | Leave a comment

SqlSaturday Cambridge, #SqlSat228, re-cap

Posted on 03/10/2013 by Jens Vestergaard

SQL Saturday This past weekend, was one of the most exciting weekends so far this year. In case my wife is reading, this is of course in a different league, and nothing like when you gave birth to our third … Continue reading →

Posted in Mixed, Programming | Tagged , , , , | 2 Comments

Using Powershell to view Partition Slice Information in Excel

Posted on 18/09/2013 by Jens Vestergaard

Challenge In a blog post written by Chris Webb (b|t), years ago, Chris displays how to query the ASSP.DiscoverPartitionSlices(…). I stumbled upon the post while investigating solutions to problems with partition slicing. But since there were about 20 cubes, each containing … Continue reading →

Posted in Programming | Tagged , , | Leave a comment