Tag Archives: SQL Server

Speaking at #SQLSatCambridge

Posted on 28/07/2013 by Jens Vestergaard

Do you sometimes drift off, thinking/dreaming crazy scenarios, that you almost instantly know won’t ever become a reality? I had one of those moments, when I spotted, that #SQLSatCambridge and the NFL game at Wembley between The Pittsburgh Steelers and Minnesota … Continue reading →

Posted in Community | Tagged , , | 4 Comments

Rolling period with shell dimension SSAS

Posted on 10/05/2012 by Jens Vestergaard

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

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

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

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