Top Posts & Pages
- Filtering SQL Agent Jobs
- MDX Query using other hierarchy in same dimension as in slicer
- Microsoft Visual Studio is unable to load this document
- Microsoft SQL Server 2014 CTP2 Data Tools BI templates for VS2012
- Slotskage i lyserød
- Run your cubes in Warp Speed - Really Really Fast!
- How to Process Multiple Dimensions via BIDS and SSMS
- Did someone restart the server over night?
- Donald Parish on Run your cubes in Warp Speed – Really Really Fast!
- Kenneth M. Nielsen (@DoktorKermit) on How to Process Multiple Dimensions via BIDS and SSMS
- Jens Vestergaard on Teradata based Data Source Views in Analysis Services
- Sudipta on Teradata based Data Source Views in Analysis Services
- Jens Vestergaard on Subtle differences in Teradata and SQL Server
Tags.Net 3rd. ed. AMO Analysis Services BI Business Intelligence Bønner C# Certificering Coffee D&D Espresso FAIL Fejl Humor Kværn MCP MDX MSConnect NFL Personal politik Powershell Roleplay Security SQL SQL2008 SQL2012 SQLBits SQLBits X SQLPASS SQLServer SQL Server SQL Server 2008 SQLTip SSAS SSIS SSIS 2008 SSMS SSRS T-SQL Teradata vandkøling VS2008 VS2010
Monthly Archives: May 2012
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
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
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
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