One of the big problems I have with some new customers is the knowledge gap between where they are and where they need to be in order to be successful. Given that people can read much faster than they can receive presented information it makes sense to have a reading list.
I’ve blogged previously some Analysis Services resources but new and better content is appearing all the time. In addition to that article here are my current reading recommendations for anyone planning a BI or Analysis Services project. Know this lot backwards and you should have a good head start.
Everyone
SQL Performance Tuning with Waits and Queues
Analysis Services Performance Guide
Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services
The Data Loading Performance Guide
Report Server Catalog Best Practices
Reporting Services Performance Optimizations
New Data Warehouse Scalability Features in SQL Server 2008
Scaling Up Your Data Warehouse with SQL Server 2008
Architects and Developers
OLAP Design Best Practices for Analysis Services 2005
Best Practices for Data Warehousing with SQL Server 2008
Analysis Services Processing Best Practices
Top 10 SQL Server Integration Services Best Practices
Top 10 Best Practices for Building a Large Scale Relational Data Warehouse
Operations and Support
Storage Top 10 Best Practices
SQL Server Best Practices
IIS Performance Tuning
Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios
In fact pretty much anything on the sqlcat website is pure gold.
Page rendered at Friday, September 03, 2010 9:09:51 AM (GMT Daylight Time, UTC+01:00)
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.