SQL Centre of Excellence

SSAS Maestro Reading List

by Bob Duffy 14. April 2012 08:08

Vidas Matelis made up a more extensive reading list here. My top five reading list. Read these and also if you can bring them as reference material on eBook format.

The Maestro has no doubt changed a bit since I went in June 2011, but I would recommend making sure you are very familiar with all the references below:

1. SQL Server 2008 Analysis Services Unleashed

If you read only one book before doing the Maestro – this is it. Be warned it is a huge tomb of book. Myself and Michael Barrett (who also certified as a Maestro), both carried this around in eBook form on the iPad and constantly referred to it, especially WRT memory internals such as how the cleaner works. The exam was open book, so keep the books handy!

http://www.amazon.com/Microsoft-Server-Analysis-Services-Unleashed/dp/0672330016

2. Analysis Services 2008 Performance Guide

You must read this until you actually get the concept of MaxThreads, CoordinatorExecutionMode and all the other joyful settings for Analysis Services.

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=17303

3. Analysis Services 2008 R2 Operations Guide

Similar to the Performance Guide, a must read BEFORE attending the Maestro course.

http://msdn.microsoft.com/en-us/library/hh226085.aspx

4. Many to Many Revolution 2.0 and Optimisation Techniques

http://www.sqlbi.com/articles/many2many/

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=137

5. Expert Cube Development with Microsoft SQL Server 2008 Analysis Services

http://www.packtpub.com/expert-cube-development-with-microsoft-sql-server-2008-analysis-services/book

Chris Webb, Alberto Ferrari and Marco Russo is to Analysis Services what the Kimball Lifecycle books were to dimensional data warehousing: Something most consultants carry around in their bag when on a customer site.

blog comments powered by Disqus

Page List

Page List