Design, Produce, and Distribute Reports That Mean Something
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
About the Author
Joseph L. Jorden, MCP, MCSE, MCTS, is a senior consultant for Allin Consulting and a developer of database applications. He was among the first 100 people to achieve the MCSE+I certification from Microsoft and an early qualifier for the MCSE on Windows 2000. During his years as an MCT, Jorden taught Microsoft Official Curriculum courses on SQL Server 6.5, 7.0 and 2000. He has spoken at PASS conferences and Comdex, and has written numerous articles for various publications. He has also written and tech-edited several Sybex books, most of them on SQL Server.