June 2006 Entries

Documentation on Analysis Services Server Properties
[via Jamie Thomson] http://download.microsoft.c... As Jamie points out, what would be really nice now is a white paper on performance tuning and how best to tune these settings. Mosha discussed a white paper some time ago, that he was working on regarding AS caching, but I don't know if that touch on server settings. It looked more like it would help in understanding some of the volumes of information that can be ......

Posted On Wednesday, June 28, 2006 8:44 PM | Comments (0)

Generating XMLA - referencing Objects by name
Jamie Thomson has an interesting post here http://blogs.conchango.com/... about some of his recent experiences with Analysis Services. One point that particularly stuck out for me an that was his criticism of having to access objects using their ID instead of their name in XMLA. This affected me recent while I was working on the PowerShell provider for AMO (which is still a work in progress). Most of the collections in AMO can be accessed using the object's ID, ......

Posted On Wednesday, June 21, 2006 8:52 PM | Comments (6)

Powershell IDE's
As you may have figured out, I am a bit of a PowerShell fan - and it just keeps getting better. As Scott Hanselman posted last week (http://www.hanselman.com/b... there are now 2 high quality IDE's for PowerShell available for free download. PowerShell Analyzer http://karlprosser.edify.us... PowerShell IDE http://powershell.com/ I don't know if PowerShell IDE's claim to be the “first PowerShell IDE“ is entirely true or not. From my perspective, I thought that ......

Posted On Thursday, June 15, 2006 9:14 PM | Comments (0)

Cool SSIS bits
There have been a number of SSIS bits and pieces coming across my “desk” lately, here are a few of them: File Watcher Task http://www.sqlis.com/defaul... Regular Expression Transformation http://www.sqlis.com/defaul... Data Generation Source Adaptor http://www.sqlis.com/defaul... for testing) Trash Destination Adaptor http://www.sqlis.com/defaul... for testing) SSIS Performance Webcast [via Simon S]http://msevents.microsoft... ......

Posted On Thursday, June 15, 2006 8:45 PM | Comments (4)

Running XMLA Queries the Powershell way
I have been experimenting a bit more recently to see what I can do with Powershell and Analysis Services. The following small script executes an MDX query using an XMLA connection. I have borrowed the xsl files from one of Chris Harrington's excellent ThinOlap samples. 1 [System.Reflection.Assembly... 2 [Microsoft.AnalysisServices... = new-Object Microsoft.AnalysisServices.... 3 $xmlac.Connect("localhost\s... ......

Posted On Wednesday, June 14, 2006 8:25 PM | Comments (2)

SSIS alternative to the Slowly Changing Dimension transformation
[via Jamie Thomson] If you are transforming large dimensions this will be of interest to you. Alberto Ferrari has come up with an interesting solution to the performance of the SCD transform task. The built-in SCD transform issues separate SQL statements for each incoming dimension row, Alberto has a custom SSIS component here (http://www.sqljunkies.com/... that compares two tables in one operation. It is definitely something I am going to look ......

Posted On Wednesday, June 14, 2006 7:44 PM | Comments (6)

DSO Script: Adding a Role to a Cube
I had a question over the weekend about how to add a role to a cube using DSO. As more and more people start using AS2k5 I think the interest is going to shift more towards AMO scripting, but someone else may find the following helpful. The VBScript below shows the basic technique. The key thing to remember is that the Role object is set up at the database level. The cube's role collection basically holds references back to the database role collection (not that you can really tell this from the ......

Posted On Tuesday, June 13, 2006 8:26 PM | Comments (1)

Database Professional Edition of Visual Studio Team System
Both Simon http://sqljunkies.com/WebLo... and Greg http://msmvps.com/blogs/gre... have blogged about this so I will not go into the details here, but you really should check out this product, it looks really cool :) The official Microsoft page can be found here, http://msdn.microsoft.com/v... The CTP is due to be released on June 11, sounds like it will be worth checking ......

Posted On Sunday, June 4, 2006 9:28 PM | Comments (1)