SQL Server related thoughts

This is a collection of links to free articles that may help in studying for

Exam 70 448  -Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

I have broken this up into 6 posts based on the major areas of skills being measured taken from the Microsoft Learning page at

http://www.microsoft.com/learning/en/us/exam.aspx?id=70-448

Fourth up is :

Configuring, Deploying, and Maintaining SSAS - which accounts for 17 % of the total skils measured

• Configure permissions and roles in SSAS.
  This objective may include but is not limited to: 
  • Server roles;
    • http://msdn.microsoft.com/en-us/library/ms174840.aspx
  • SSAS database roles;
  • Cube roles;
    • http://msdn.microsoft.com/en-us/library/ms177198%28v=sql.100%29.aspx
  • Enable client application access;
    • http://msdn.microsoft.com/en-us/library/ms174786.aspx
  • implement custom access to data
• Deploy SSAS databases and objects.
  This objective may include but is not limited to: 
  • Deployment Wizard;
    • http://msdn.microsoft.com/en-us/library/ms176121.aspx
  • BIDS;
    • http://msdn.microsoft.com/en-us/library/ms175406.aspx
  • SSMS;
    • http://msdn.microsoft.com/en-us/library/ms174928.aspx
  • SSIS Analysis Services Execute DDL task;
• Install and maintain an SSAS instance.
  • http://msdn.microsoft.com/en-us/library/ms143708%28v=SQL.100%29.aspx
• This objective may include but is not limited to:
  • Disaster recovery
• Diagnose and resolve performance issues.
  This objective may include but is not limited to: 
  • Use SQL Profiler;
    • http://msdn.microsoft.com/en-us/library/ms174946%28v=sql.90%29.aspx
  • Performance monitor counters;
  • DMVs;
    • http://dwbi1.wordpress.com/2010/01/01/ssas-dmv-dynamic-management-view/
  • Usage Based Optimization Wizard ;
    • http://sqlcat.com/technicalnotes/archive/2008/11/18/reintroducing-usage-based-optimization-in-sql-server-2008-analysis-services.aspx
• Implement processing options;
  • http://technet.microsoft.com/en-us/library/ms174860.aspx