Tag Archives: SQL Server

Rolling period with shell dimension SSAS

Posted on 10/05/2012 by Jens Vestergaard
Share

Often I meet the business requirement of listing data for the last X months. In this blog post, I will try to give my shot at, how this is done elegantly and with maximum flexibility. We start of backwards and … Continue reading →

Posted in Programming | Tagged , , | 2 Comments

SQLBits X PreCon SSAS Deep Dive Summary – Part 1

Posted on 09/04/2012 by Jens Vestergaard
Share

As an exercise for myself I will be writing fairly short post on the session I attended at SQLBits X´. I will begin with the training day where I went for the Deep Dive into SSAS. The only bad thing … Continue reading →

Posted in Programming | Tagged , , | Leave a comment

SSMS Quick Tip

Posted on 23/02/2012 by Jens Vestergaard
Share

If you ever need to test Analysis Services roles, you can easily do so either by browsing the cube or by means of a query. When browsing a cube through SQL Server Management Studio (SSMS) or Bisuness Intelligence Developer Studio (BIDS), you … Continue reading →

Posted in Programming | Tagged , , , , , , , , | Leave a comment

Renaming the name of the physical database and log file

Posted on 10/08/2011 by Jens Vestergaard
Share

During one of my current tasks, which was to run the same test on multiple copies of the same database, I needed to setup a flow where I could deploy the database from VS2010 or setup database w/ vsdbcmd run the … Continue reading →

Posted in Programming | Tagged , , , | Leave a comment

Installing MS SQL Denali CTP3 failed

Posted on 04/08/2011 by Jens Vestergaard
Share

While I was on vacation, the news of the Denali CTP3 release (ref) reached me. When I got back to work I immediately downloaded the package. From there on it would be a smooth ride through the wizard, or at least so I … Continue reading →

Posted in Programming | Tagged , , , | 3 Comments