Mastering SQL Server 2005 Reporting Services Infrastructure Design





eBOOK Details

Publisher Sybex
Release Date August 6, 2007
ISBN 0470114592

eBOOK Description

Today's DBAs need to know how to work with users, management, and key stakeholders to identify organizational needs and leverage the technology to meet them. Covering intermediate to advanced subjects, such as performance tuning, this book shows you how to build a reporting infrastructure that can be used in any environment.


Focusing on six key principles simplicity, clarity, generality, automation, and communications all vital elements of meaningful reports, you'll learn everything you need to know to design a report infrastructure that integrates the best practices of reporting systems. When you're finished, you will have a roadmap that enables you to help corporate managers make the most of this technology.

Loaded with real-world examples, this book arms you with guidelines that apply equally well to small businesses and mega-corporations.

Coverage includes:
  • Assessing user needs and managing user/corporate expectations
  • Managing change and satisfying stakeholders
  • Integrating RS with other SS2005 components
  • Building and running reliable, scalable reporting systems
  • Creating and enforcing security policies
  • Performing reviews and assessing report effectiveness
  • Writing user documentation
  • Justifying technology or report value to management
  • Extending Reporting Services programmatically
  • Build the Right Reporting Infrastructure For Your Organization
  • Tailor Role-Based Security To Fit Your Environment
  • Use Reporting Services With Business Intelligence Technology
  • Define Report Data Sources and Datasets
  • Plan a Disaster Recovery Strategy