Monthly Archives: May 2012

Server and column collation conflicts in properties of a login

Problem: Error: Cannot resolve the collation conflict between “Danish_Norwegian_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the UNION operation. (Microsoft SQL Server, Error: 468) when clicking “Securables” in properties of a server login. Setup: Server is set up with collation: SQL_Latin1_General_CP1_CI_AS The database, or … Continue reading

Posted in Programming | Tagged , , , | 2 Comments

Reporting Services issue when installing local Domain Controller

Problem: At a client we had to produce a server, in order for us to have a development environment, since they couldn’t spare the server power. Odd situation, but that’s not the point. The point is that, somewhere during the … Continue reading

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

SQL Server Data Tools being really anoying

Before today I have only been fiddling about in with new SQL Server Data Tools Integration Services projects, without any problems what so ever. I’ve seen demos done without any problems what so ever. And now that I finally get … Continue reading

Posted in Programming | Tagged , , | Leave a comment

Rolling period with shell dimension SSAS

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

Parameter ordering in SSRS – Gotcha!

After banging my head against the screen for about three or four hours, trying to solve what seemed as a Reporting Services mystery, a coworker of mine came up with the solution. I was trying to inject a role into an embedded … Continue reading

Posted in Programming | Tagged , | Leave a comment