A quick list of things I am / have been reading in the last week.
- Metadata tool and whitepaper for BI components
- SQL 2005 Metadata Samples Toolkit and whitepaper now available
- SQL Server 2005 Business Intelligence Metadata Whitepaper
- SQL Server 2005 Business Intelligence Metadata Samples Toolkit
- Indexes: An Overview and Maintenance for Performance
- Recovery Planning For SQL Reporting Services
- Connecting to a Remote SSIS Server
- Using sqlcmd with Scripting Variables
If you’re about to define standards for your SSIS packages, here’s a few articles that might help:
- SSIS: Common package structure
- SSIS: Development Best Practices and naming conventions
- SSIS: Using checkpoint files
- SSIS: Location for your package templates