June 2006 Entries

[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 ......
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, ......
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 ......
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... ......
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... ......
[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 ......
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 ......
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 ......


About Me
I am a consultant, based in Melbourne Australia. I primarily work in the Business Intelligence area with SQL Server, although I also dabble in Content Management Server and .Net coding

Contact Me


Any and all code, software, examples, suggestions and anything else on this web site is available for you to use at your own risk. No warranty is expressed or implied.
Views and Opinions
The views and opinions expressed on this web site are not necessarily the views or opinions of my employer.

Subscribe in Bloglines Subscribe in NewsGator Online

Locations of visitors to this page


Tag Cloud

Article Categories


Post Categories

.Net Blogs

Aussie Bloggers

BI Blogs

CMS Blogs