Designing a Reporting Solution Architecture using Microsoft SQL Server 2005

Designing a Reporting Solution

• Evaluating Business Requirements for a Reporting Solution
• Designing for Reporting Services

Developing a Reporting Solution

• Developing Reports
• Developing Report Models

Integrating Reporting Services with Applications

• Integrating with Custom Applications
• Controlling Reporting Services by Using Web Services

Deploying and Managing a Reporting Solution

• Deploying a Reporting Services Solution
• Managing Report Distribution

Designing Security for a Reporting Solution

• Designing an Authentication Strategy
• Designing an Authorization Strategy
• Designing a Secure Communication Strategy

Optimizing Report Performance

• Monitoring Report Execution
• Designing a Report Execution Strategy
• Scaling Reporting Services