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

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

Third up is :

Implementing an SSAS Solution– which accounts for 21 % of the total skils measured

• Implement dimensions in a cube.
  This objective may include but is not limited to: 
  • translations;
    • http://msdn.microsoft.com/en-us/library/ms174552%28v=SQL.100%29.aspx
    • http://msdn.microsoft.com/en-us/library/ms174791.aspx
    • http://msdn.microsoft.com/en-us/library/ms174900.aspx
  • attribute relations;
    • http://msdn.microsoft.com/en-us/library/ms174760.aspx
    • http://msdn.microsoft.com/en-us/library/ms175669.aspx
    • http://msdn.microsoft.com/en-us/library/ms365364.aspx
  • hierarchies;
    • http://msdn.microsoft.com/en-us/library/ms174935.aspx
    • http://msdn.microsoft.com/en-us/library/ms174936.aspx

• Implement measures in a cube.
  This objective may include but is not limited to: 
  • Measure groups
    • http://msdn.microsoft.com/en-us/library/ms174792.aspx
• Implement a data source view.
• This objective may include but is not limited to:
  • Named calculations;
    • http://msdn.microsoft.com/en-us/library/ms174859.aspx
  • Named queries
    • http://msdn.microsoft.com/en-us/library/ms175683.aspx

• Configure dimension usage in a cube.
  This objective may include but is not limited to: 
  • Implement reference dimensions;
    • http://msdn.microsoft.com/en-us/library/ms365365.aspx
  • Implement many to many relationships;
    • http://msdn.microsoft.com/en-us/library/ms365407.aspx
  • Implement fact relationships;
    • http://msdn.microsoft.com/en-us/library/ms365400.aspx
  • Implement role-playing relationships;
    • http://msdn.microsoft.com/en-us/library/ms174487%28v=sql.90%29.aspx
  • Define granularity;
    • http://msdn.microsoft.com/en-us/library/ms166573.aspx
• Implement custom logic in a cube by using MDX.
  This objective may include but is not limited to: 
  • Actions;
    • http://msdn.microsoft.com/en-us/library/ms175345.aspx
    • http://msdn.microsoft.com/en-US/library/ms174515(v=SQL.100).aspx
  • Key performance indicators (KPI);
    • http://msdn.microsoft.com/en-us/library/ms181183(v=SQL.100).aspx
    • http://msdn.microsoft.com/en-US/library/ms174875(v=SQL.100).aspx
  • Calculated members;
    • http://msdn.microsoft.com/en-us/library/ms174952.aspx
  • Calculations;
    • http://msdn.microsoft.com/en-us/library/ms174902(v=SQL.100).aspx
• Implement data mining.
  This objective may include but is not limited to: 
  • Implement data mining structures and models;
    • http://msdn.microsoft.com/en-us/library/ms174842%28v=SQL.100%29.aspx
    • http://msdn.microsoft.com/en-us/library/cc280430%28v=SQL.100%29.aspx
  • Query data mining structures by using DMX;
    • http://msdn.microsoft.com/en-us/library/bb522459%28v=SQL.100%29.aspx
    • http://msdn.microsoft.com/en-us/library/ms175376%28v=SQL.100%29.aspx
  • Data mining views;
    • http://msdn.microsoft.com/en-us/library/ms174580%28v=SQL.100%29.aspx
• Implement storage design in a cube.
  This objective may include but is not limited to: 
  • Aggregations;
    • http://msdn.microsoft.com/en-us/library/ms174758%28v=SQL.100%29.aspx
  • Partitions;
    • http://msdn.microsoft.com/en-us/library/ms175688%28v=SQL.100%29.aspx
  • Storage modes;
    • http://msdn.microsoft.com/en-us/library/ms174915%28v=SQL.100%29.aspx
  • Proactive caching;
    • http://msdn.microsoft.com/en-us/library/ms174769%28v=SQL.100%29.aspx