Monthly Archives: May 2012

Server and column collation conflicts in properties of a login

Posted on 30/05/2012 by Jens Vestergaard
Share

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

Posted on 29/05/2012 by Jens Vestergaard
Share

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

Posted on 22/05/2012 by Jens Vestergaard
Share

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

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

Parameter ordering in SSRS – Gotcha!

Posted on 09/05/2012 by Jens Vestergaard
Share

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