Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

Administering SQL Server Reporting Services


The BI strategy is centered on two key suites of products—'SQL Server' and 'Office'. SQL Server is used as the data and reporting platform and Office provides popular easy-to-use front-end tools for end users to view and manage the data and analysis. This includes products such as Excel, Word, and SharePoint.

The key point is that SharePoint provides a central way to collaborate online. This is where reports serve the purpose of sharing the data for trends about business processes. SharePoint is a central collaboration tool enabling users to view and manage reports within SharePoint. That is the key motivation behind Reporting Services integration with SharePoint. SQL Server Reporting Services (SSRS) is one of the components in the Business Intelligence platform, which provides the unified, server-based, extensible, and scalable platform to deliver and present data. SSRS is capable of generating reports in various formats (HTML, XLS, PDF, CSV, and...