This course explains how to manage reports after the development process is complete and how to manage the reporting environment. It explains how to move reports to the report server and how to configure properties to control report execution behavior. This course also explains how to create and manage report subscriptions, how to secure reports, and options for configuring the report server. The features and demonstrations in this course focus on the SQL Server 2008 R2 release, although most topics with the exception of report server configuration also apply to earlier versions of Reporting Services.
Stacia Misner Varga is a consultant, instructor, author, mentor, BI Partner for SQLSkills, and principal of Data Inspirations specializing in Microsoft business intelligence technologies for over 10 years. She is a frequent speaker at the PASS Summit, IT/Dev Connections
conferences, and various SQL Saturday and Microsoft-related events
Report Deployment Hello, I'm Stacia Misner and I'll be presenting Report Deployment. The process of deploying reports includes a variety of tasks that you learn about in this module. We'll start with an overview of what the deployment process does. Then we'll review the properties in a report project that are used by the deployment process in bits. Next we'll explore three different ways that we can deploy reports to the report server. We'll also discuss what happens when we need to make changes to a report and then redeploy it. Last, we'll introduce report parts, a new feature in SQL Server 2008 R2, and we'll learn how to deploy and use them.
Report Administration Hello, I'm Stacia Misner and I'll be presenting Report Administration. After we deploy reports to the ReportServer, we have some decisions to make about how they'll be used and how we might need to change some settings on the server accordingly. How the report will run may affect the data source configuration, so we'll start by reviewing the changes we might need to make here. Then we'll explore what actually happens when reports execute so that we can decide how best to configure our reports on the server. We'll look at how the report execution process works when a report runs on demand, then we'll see the difference made by caching reports, and then we'll review yet another alternative, report snapshots, and see how snapshots effect the execution process.
Subscriptions Hello, my name is Stacia Misner and I'll be presenting Subscriptions. In this module we'll cover everything you need to know about subscriptions, from creating standard subscriptions, which we can use to email reports to a list of recipients or to periodically publish reports to a file share, to setting up data-driven subscriptions, which takes a bit more planning and is only available in the Enterprise Edition of Reporting Services. And then of course once subscriptions are created, we'll need to know what options we have for managing substations on the report server.
Security Hello, I'm Stacia Misner, and I'll be presenting Security. After we deploy content to the report server we need to take some steps to ensure that users can see only the reports that they're allowed to see. We'll start this module by reviewing how users are authenticated on the ReportServer, and then we'll look at how authorization works on the ReportServer at a high level. Then we'll get more specific by reviewing how we secure individual items on the server, and we'll also review the system roles on a native mode report server. Then we'll look at techniques that we have for implementing data-level security within our reports.
Server Administration Hello I'm Stacia Misner, and I'll be presenting Server Administration. Now in addition to managing and securing content, which we learned how to do in the previous modules in this course, there are some administrative tasks on the report server that we need to perform from time to time. When we first set up a report server, we need to work through the report server configuration settings. Also, there might be some repetitive tasks that we need to perform that we can do using the RS utility. Now report rendering can be a very memory-intensive process on the report server, so we might need to make some changes to the report server configuration to optimize memory management on the server. There are also changes we might need to make to reduce the surface area of the server if there are certain features we aren't using. Surface area reduction is a security best practice. We'll also learn how to use the SQL Server Management Studio to set report server properties, and we'll learn how to monitor the report server using various log files, and using performance counters.