James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.
Another must read white-paper: Analysis Services 2008 R2 Performance Guide.
This white paper describes how business intelligence developers can apply query and processing performance-tuning techniques to their Microsoft SQL Server 2008 R2 Analysis Services OLAP solutions. It applies to SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2.
This is an update and expansion to the previous performance guide white-paper, which was published three years ago, and which only applied to SQL Server 2008. There are about 30 new pages of new content.
If you are working with SSAS, you have to add this to your “to read” list and make it a high priority.