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

Final part is :

Configuring, Deploying, and Maintaining SSRS – which accounts for 13 % of the total skils measured

• Configure report execution and delivery.
  This objective may include but is not limited to: 
  • Subscriptions;
    • http://msdn.microsoft.com/en-us/library/ms159762%28v=SQL.100%29.aspx
  • Report caching;
    • http://msdn.microsoft.com/en-us/library/ms155927%28v=SQL.100%29.aspx
  • Schedules;
    • http://msdn.microsoft.com/en-us/library/bb283320.aspx
  • Snapshot history
    • http://msdn.microsoft.com/en-us/library/ms156002%28v=SQL.100%29.aspx
• Install and configure SSRS instances.
  This objective may include but is not limited to: 
  • Deploy an SSRS Web farm
    • http://msdn.microsoft.com/en-us/library/ms156453%28v=SQL.100%29.aspx http://msdn.microsoft.com/en-us/library/ms159114%28v=SQL.100%29.aspx
• Configure authentication and authorization for a reporting solution.
  This objective may include but is not limited to: 
  • Configure server-level and item-level role-based security;
    • http://msdn.microsoft.com/en-us/library/bb522728%28v=SQL.100%29.aspx
  • Configure Windows authentication and custom authentication
• Deploy an SSRS solution.
  This objective may include but is not limited to: 
  • RS.exe scripts;
    • http://msdn.microsoft.com/en-us/library/ms162839%28v=SQL.100%29.aspx
  • Report Builder;
    • http://msdn.microsoft.com/en-us/library/ms365173%28v=sql.90%29.aspx
  • BIDS
    • http://msdn.microsoft.com/en-us/library/ms155802.aspx
• Configure SSRS availability.
  This objective may include but is not limited to: 
  • Key management;
    • http://msdn.microsoft.com/en-us/library/ms156305.aspx
  • Migrate SSRS databases

http://msdn.microsoft.com/en-us/library/ms143724%28v=sql.100%29.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

Fifth up is :

Implementing an SSRS Solution – which accounts for 17 % of the total skils measured

• Implement report data sources and datasets.
  This objective may include but is not limited to: 
  • Query types;
    • http://msdn.microsoft.com/en-us/library/ms156450.aspx
  • Dynamic data sources;
    • http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/one-report-for-many-instances-dyanmicall
  • Filter location (dataset vs. query)
    • http://msdn.microsoft.com/en-us/library/ms156270.aspx
• Implement a report layout.
  This objective may include but is not limited to: 
  • http://msdn.microsoft.com/en-us/library/ms159267%28v=SQL.100%29.aspx
  • Apply conditional formatting;
  • Page configuration;
  • Headers and footers
    • http://msdn.microsoft.com/en-us/library/ms159677%28v=SQL.100%29.aspx
• Extend an SSRS solution by using code.
  This objective may include but is not limited to: 
  • Custom .NET assembly;
    • http://msdn.microsoft.com/en-us/library/ms155034%28v=SQL.100%29.aspx
  • Private code
    • http://msdn.microsoft.com/en-us/library/aa902641%28v=sql.80%29.aspx

• Create an SSRS report by using an SSAS data source.
  This objective may include but is not limited to:

• • MDX in an SSRS report;
    • http://msdn.microsoft.com/en-us/library/ms156303.aspx
  • DMX in an SSRS report
    • http://msdn.microsoft.com/en-us/library/ms155812.aspx
• Implement report parameters.
  This objective may include but is not limited to: 
  • Databound parameters;
    • http://msdn.microsoft.com/en-us/library/ms155917.aspx
  • Multi-value parameters
    • http://msdn.microsoft.com/en-us/library/aa337292.aspx
• Implement interactivity in a report.
  This objective may include but is not limited to: 
  • Drilldown;
    • http://msdn.microsoft.com/en-us/library/dd207141.aspx
  • Drillthrough;
  • Interactive sorting
    • http://msdn.microsoft.com/en-us/library/cc627509.aspx
• Implement report items.
  This objective may include but is not limited to: 
  • Matrix;
    • http://msdn.microsoft.com/en-us/library/ms157334%28v=sql.100%29.aspx
  • Table;
    • http://msdn.microsoft.com/en-us/library/ms159169%28v=SQL.100%29.aspx
  • Chart;
    • http://msdn.microsoft.com/en-us/library/ms155847%28v=SQL.100%29.aspx
  • Image;
    • http://msdn.microsoft.com/en-us/library/ms156482%28v=SQL.100%29.aspx
  • List;
  • Grouping ;
    • http://msdn.microsoft.com/en-us/library/ms155903%28v=SQL.100%29.aspx
• Embed SSRS reports in custom applications.
  This objective may include but is not limited to: 
  • Use the Windows Forms Report Viewer;
    • http://msdn.microsoft.com/en-us/library/ms345248%28v=SQL.100%29.aspx
  • Use the Web Forms Report Viewer;
  • Use the SSRS Web service
    • http://msdn.microsoft.com/en-us/library/ms152787%28v=SQL.100%29.aspx