SQL Server
4 05 2012
I haven’t posted on this for a while as I’ve been neck-deep in a fairly decent sized Business Intelligence project in SQL Server Analysis Services 2008 R2, but have subsequently learnt an enormous amount with regards to performance. So I thought I’d share a list of the biggest things I’ve learnt from various places (mostly […]
2 02 2012
This is purely for my own reference, but when I upgraded 2008 R2 to SP1 it somehow corrupted my master database. As this was a dev box, I didn’t have a backup of the master database (and as I’m not a DBA, didn’t know I needed to :P), so I had to rebuild, re-add the […]
5 10 2010
Came across another common error message in SSIS, here was the output when trying to execute the package… Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 19:37:49 Error: 2010-10-05 19:37:54.67 Code: 0xC0202009 Source: Data Flow Task OLE DB Source [1] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE […]
29 09 2010
Came across an interesting error whilst thrashing out some deployment automation scripts today. As part of the deployment it was executing a SSIS package using DTExec running on the machine local to SQL Server, thus as part of the command line it omitted the /SERVER switch, insinuating that the package I’m executing exists in the […]
28 08 2010
I’ve been dipping my toes into the black art of MDX (or MultiDimensional Expressions) and I had a requirement whilst building a KPI that I needed to get the current date from a Dimension I had called “Date”. I had been linked to this blog: http://my.opera.com/duncans/blog/using-custom-sets-in-analysis-services-to-deliver-special-date-ranges-to-end-use but couldn’t for the life of me get his first […]