Tag Archives: SQL Server 2008

SSMS Quick Tip

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

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

VSDBCMD troubleshooting

Sometimes, just sometimes, I plunge right into using a tool without reading too much documentation. This has some advantages and some drawbacks. Trying to decipher error messages without the right background knowledge can be a hard nut to crack. Just now … Continue reading

Posted in Programming | Tagged , | Leave a comment

Mit Microsoft Connect forslag er blevet implementeret

m4s0n501 Mit beskedne bidrag til næste version af SSIS er hermed i hus. I går fik jeg bekræftelse fra Microsoft om, at forslaget har fundet vej til enten næste version eller næste service pack.             … Continue reading

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

Perculiar Named Calculations

In regards to this article about named calculations in SSAS, I had the perculiar finding today, that NULLs are handled somewhat differently than I would have expected. In my case I had constructed a named calculation, just as in the article, by concatenating … Continue reading

Posted in Programming | Tagged , , | Leave a comment