October 2006 Entries

SSAS IA64 Server Fun: Using VBA functions in MDX
Occasionally I have the pleasure of working with Analysis Services 2005 on an IA64 (64 bit Intel Itanium) servers and on the whole, most things work the same. But there is the occasional small difference that can cause some frustration. Background: In Analysis Services 2000, you could not use VBA functions in MDX calculations as the VBA library was COM based and had not been ported to the 64 bit platform. In SSAS 2005, the core VBA functions have been implemented in a .Net library which will run ......

Posted On Sunday, October 29, 2006 12:09 AM | Comments (5)

Office 2007 Video - Business Intelligence
[via Stefan Gossner] Wow, there is a bit over 1Gb over video content that can be downloaded for your viewing pleasure. I'm off to get my external USB hard drive. Below is a excerpt from the download site: Overview The Microsoft Office System Developers Conference 2006 featured more than 60 breakout sessions organized in eight technical tracks. In this track, you'll learn how the 2007 Microsoft Office system helps developers build smart client and browser-based BI solutions leveraging a wide array ......

Posted On Saturday, October 28, 2006 10:27 PM | Comments (0)

Performance Monitoring done right
[via The Daily Grid] Roy Osherove, the guy who gave us Regulator and Regulazy has been at it again. This time with a cool replacement for Perfmon called Perf+. This definitely looks like one to download and add to your tool box ......

Posted On Tuesday, October 17, 2006 11:07 PM | Comments (0)

SSIS: Setting properties on Foreach enumerators
Well, I thought for once that I might have been able to blog something about SSIS before Jamie did... but I was wrong. :) All I wanted to do was to dynamically set the folder for a foreach file container in SSIS using an expression. It was not immediately obvious how to achieve this. I struggled through a few other blog posts and then eventually came across an obscure reference in the documentation. Friday afternoon I took a screenshot of the settings page, but I left the file on the workstation ......

Posted On Monday, October 16, 2006 10:44 PM | Comments (7)

XAML pivot table control
[via Mosha] Mosha posted today about a sample XAML Pivot table control. http://sqljunkies.com/WebLo... I think I'll have to download a copy and have a play. :) I have not really done any hands on work with XAML yet and this sounds like something that could be quite useful. According to Mosha the MDX generation needs to be cleaned up. I would even like to see something that could round trip the MDX (or at least spit out the MDX after the pivot table has been setup the way you ......

Posted On Tuesday, October 10, 2006 8:48 PM | Comments (0)

Congratulations to Rob Farley - a new SQL Server MVP
Congratulations to Rob Farley, who runs the SQL Server User Group in Adelaide on recently being awarded as an MVP in SQL Server http://robfarley.blogspot.c... That takes the total number of SQL Server MVPs in Australia up to 5. Rob is a fellow speaker at the SQLDownUnder Code Camp this week end, so if you are going, make sure to congratulate him. And if you look really close, you might still be able to see the scars where the implants were inserted :) ......

Posted On Wednesday, October 4, 2006 9:19 AM | Comments (0)