SQL Server related thoughts

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

• Install and maintain SSIS components.
  • This objective may include but is not limited to: implement disaster recovery for SSIS
    • http://msdn.microsoft.com/en-us/library/ms141699%28v=SQL.100%29.aspx
    • http://msdn.microsoft.com/en-us/library/ms143731%28v=SQL.100%29.aspx
• Deploy an SSIS solution.
  This objective may include but is not limited to: 
  • deploy SSIS packages by using DTUTIL;
    • http://msdn.microsoft.com/en-us/library/ms162820%28v=SQL.100%29.aspx
  • deploy SSIS packages by using the deployment utility;
    • http://msdn.microsoft.com/en-us/library/ms137952%28v=SQL.100%29.aspx
    • http://msdn.microsoft.com/en-us/library/ms141693%28v=SQL.100%29.aspx
  • deploy SSIS packages to SQL or file system locations
    • http://msdn.microsoft.com/en-us/library/ms140117%28v=SQL.100%29.aspx
• Manage SSIS package execution.
  • http://msdn.microsoft.com/en-us/library/ms138023.aspx
• This objective may include but is not limited to:
  • schedule package execution by using SQL Server Agent;
    • http://msdn.microsoft.com/en-us/library/dd440761%28v=sql.100%29.aspx
    • http://msdn.microsoft.com/en-us/library/dd440760%28v=sql.100%29.aspx
  • execute packages by using DTEXEC;
    • http://msdn.microsoft.com/en-us/library/ms162810%28v=SQL.100%29.aspx
  • execute packages by using SQL Server Management Studio;
  • execute packages by using the SSIS .NET API
    • http://msdn.microsoft.com/en-us/library/ms136090%28v=SQL.100%29.aspx
• Configure SSIS security settings.
  • http://msdn.microsoft.com/en-us/library/ms137833%28v=SQL.100%29.aspx
• This objective may include but is not limited to:
  • MSDB database roles;
    • http://msdn.microsoft.com/en-us/library/ms141053(v=SQL.100).aspx
  • package protection levels
    • http://msdn.microsoft.com/en-us/library/ms141747.aspx
• Identify and resolve issues related to SSIS solution deployment.
  This objective may include but is not limited to: 
  • validate deployed packages;
    • http://consultingblogs.emc.com/jamiethomson/archive/2008/08/19/ssis-validating-your-package-to-see-if-it-will-execute.aspx
  • deploy packages and dependencies between servers
    • http://www.tsck.net/DasBlog/PermaLink,guid,7687ba4e-30aa-4e56-8b30-b37adc497559.aspx