I had the pleasure to present in front of one of the biggest and best SQL Server User Groups in Australia and as Greg Linwood proudly (justified so) said – in the world. As I promised I have uploaded the presentation materials to this blog and you can find links to the slides, MDX scripts I run and some useful links below. As a side announcement, Darren Gosbell is now officially in charge of the Melbourne SQL Server User Group. I am sure that his passion for SQL Server will lead to great results and we will be able to enjoy a strong stream of speakers in the coming years.
To everyone who attended tonight – Thank You for coming and for giving me great reviews!
Useful Resources
The Many-To-Many Revolution by Marco Russo
SQL Server 2008 Performance Guide by SQL CAT and the SSAS Product Team
VBA Functions in SSAS by Irina Gorbach
Performance Improvements in Analysis Services on MSDN
Measure expressions: how performant are they? By Christian Wade
MSDN SQL Server Analysis Services Forum
TechNet Tech Center: Analysis Services – Multidimensional Data
Books
Microsoft SQL Server 2008 MDX Step by Step – Beginner/Intermediate
MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase – Beginner/Intermediate
The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset – Beginner/Intermediate
Expert Cube Development with Microsoft SQL Server 2008 Analysis Services – Intermediate/Advanced
Microsoft SQL Server 2008 Analysis Services Unleashed – Expert
Slides and Scripts
[listyofiles folder=”wp-content/MDX Gotchas”]
Please let me know if you need more reference materials or if you think that some that I have missed should go in this post.