Mastering SQL Server 2005 Reporting Services Infrastructure Design
1st Edition
Published on 7. August 2007
Book
Paperback/Softback
486 pages
978-0-470-11459-9 (ISBN)
Description
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
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
More details
Edition
1., Auflage
Language
English
Place of publication
Chichester
United Kingdom
Publishing group
John Wiley and Sons Ltd
Target group
Professional and scholarly
Illustrations
Illustrations
Dimensions
Height: 23.4 cm
Width: 18.7 cm
Thickness: 25 mm
Weight
725 gr
ISBN-13
978-0-470-11459-9 (9780470114599)
Schweitzer Classification
Other editions
Additional editions
Joseph L. Jorden
Mastering SQL Server 2005 Reporting Services Infrastructure Design
E-Book
10/2007
Sybex
€45.50
Available for download
Person
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.
Content
Part I. Reporting Infrastructure.
Chapter 1. Principles of a Reporting Infrastructure.
Chapter 2. Building the Right Reporting Infrastructure. Determining Business Requirements.
Chapter 3. Planning & Developing Role based Security.
Chapter 4. Managing User Expectations.
Chapter 5. Change Management.
Chapter 6. Business Intelligence and SSRS.
Part II. Putting Theory into Practice - How to use reporting services in your infrastructure.
Chapter 7. Deploying Reporting Services based on the planned reporting infrastructure.
Chapter 8. Managing Models.
Chapter 9. Using and Planning Subscriptions.
Chapter 10. Tweaking the Reporting Infrastructure.
Part III. Advanced Reporting Services Topics.
Chapter 11. Extending Reporting Services (Gunderloy?).
Chapter 12. Managing Reports Using Program Code
Chapter 13. Report Definition Language.
Chapter 14. Report Server Security.
Chapter 15. Defining Report Data Sources & Datasets.
Chapter 16. Performance Tuning a Reporting Services Solution.
Appendices.
Appendix A. Reporting Services Basics.
Appendix B. Creating Reports.
Appendix C. Rendering Reports.
Glossary.
Chapter 1. Principles of a Reporting Infrastructure.
Chapter 2. Building the Right Reporting Infrastructure. Determining Business Requirements.
Chapter 3. Planning & Developing Role based Security.
Chapter 4. Managing User Expectations.
Chapter 5. Change Management.
Chapter 6. Business Intelligence and SSRS.
Part II. Putting Theory into Practice - How to use reporting services in your infrastructure.
Chapter 7. Deploying Reporting Services based on the planned reporting infrastructure.
Chapter 8. Managing Models.
Chapter 9. Using and Planning Subscriptions.
Chapter 10. Tweaking the Reporting Infrastructure.
Part III. Advanced Reporting Services Topics.
Chapter 11. Extending Reporting Services (Gunderloy?).
Chapter 12. Managing Reports Using Program Code
Chapter 13. Report Definition Language.
Chapter 14. Report Server Security.
Chapter 15. Defining Report Data Sources & Datasets.
Chapter 16. Performance Tuning a Reporting Services Solution.
Appendices.
Appendix A. Reporting Services Basics.
Appendix B. Creating Reports.
Appendix C. Rendering Reports.
Glossary.