October 2009 Entries

Which Edition is my Analysis Services Server?
There was a question the other day on the MSDN SSAS forum asking how to find out the Edition of SSAS which is running on a given server. The answer to this question could be either Standard, Enterprise or Developer. The Object Explorer in Management Studio displays the current version next to the server name, but not the Edition. Now at a basic level I know that this is stored as a property of the server, so you could run a DISCOVER_XML_METADATA command like the following. <Discover xmlns="urn:schemas-microsof... ......

Posted On Wednesday, October 14, 2009 8:20 PM | Comments (0)

SQL Downunder 2009 Presentation: SSAS Metadata – Knowledge is Power
I just finished my talk at the 2009 SQL Downunder Code Camp on Analysis Services data. As promised, attached below are the scripts and Powerpoint slides that I used in the presentation. There is not that much information in the slides, they were really just introduction and conclusion - all of the content is in the scripts. And the scripts probably only make sense if you at the session. In addition to the scripts, below are the links to all of the free tools that I was using: •MDX Studio http://ssas-info.com/forum/... ......

Posted On Sunday, October 11, 2009 2:18 PM | Comments (2)

Book Review - Analysis Services 2008 Unleashed
Full Disclosure: I was lucky enough to be sent a free review copy by the publisher But... if I had not been sent a review copy I would have gone out and bought a copy of this book anyway. Why is that? Because I had purchased the previous edition and I knew that it would be the most in depth book on SSAS 2008 available. It has been written by members of the product team and contains a wealth of information that just could not come from any other source. I'm sure most of you have heard that Attribute ......

Posted On Sunday, October 4, 2009 9:36 PM | Comments (1)