![Page 1: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/1.jpg)
I need my reports.............YESTERDAY!!!!!
Chris Testa-O’NeillQA
![Page 2: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/2.jpg)
Who am IChris Testa-O’Neill
Business Intelligence Specialist at QA
Technical Author for Microsoft E-Learning Author of the SQL Server 2008 E-Learning track
Manchester SQL Server User Group Organiserwww.sqlserverfaq.comwww.learnsqlserver.org
![Page 3: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/3.jpg)
AgendaParameters and FiltersCachingSnapshotsHistorySubscriptionsQ and A (if time permits)
![Page 4: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/4.jpg)
Due to time this session cannot
Report AuthoringMicrosoft SQL Server 2008 R2: What’s new in
Reporting Services – Donald FarmerReport Builder 3 (tomorrow) – Andrew Fryer
Security
![Page 5: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/5.jpg)
Parameters and FilterFrom a users perspective, parameters and
filters look the same
Parameters restricts the data at the source
Filters returns all of the data and filters in place
Parameters and filters affected by caching and snapshot settings
![Page 6: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/6.jpg)
CachingCaching is not enable by default
Can be used to improve the performance of retrieving reports by storing a copy in the ReportServerTempDB
Configured to set an expiry time for the cache
Consider “pre heating” the oven using data driven subscriptions
![Page 7: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/7.jpg)
Execution process for cached instances1. Retrieves most up-to-date data and processes
report2. Creates intermediate report and stores
intermediate result in the cache in ReportServerTempDB
3. Flags intermediate report as a cached instance 4. Renders report from cached instance5. Later requests for the same report are retrieved
from the cached copy
![Page 8: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/8.jpg)
SnapshotsSnapshot are created in advance of the user
browsing
Stored in the ReportServerDB and are persistent
Can be used to create historical data
![Page 9: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/9.jpg)
• Execution process for snapshots
Creation of snapshot is scheduled for a specific point in time
Requests are satisfied by retrieving and rendering the snapshot
The intermediate report is created and the result is stored as a snapshot in the report server database
![Page 10: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/10.jpg)
DemonstrationCreating Parameters and Filters
Creating Cache settings
Creating Report snapshots
![Page 11: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/11.jpg)
I need a report from.....yesterdayHistorical data provides a point in time copy
of reports
Impact on parameters and filters
Control the number of reports storedBE AWARE – Reducing the number of reports
stored will truncate the reports
![Page 12: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/12.jpg)
DemonstrationCreating Historical Reports
![Page 13: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/13.jpg)
SubscriptionsStandard Subscriptions
User and Administrator driven
Data Driven SubscriptionAdministrator drivenRequires the creation of a subscriber tableCan be used to pre populate a cache
![Page 14: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/14.jpg)
DemonstrationCreating User Subscriptions
Creating Data Driven Subscriptions
![Page 15: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/15.jpg)
Available coursesMicrosoft Official Curriculum courses
SQL Server 2005 2793 – Implementing and Maintaining SQL Server Reporting
Server 2005SQL Server 2008
6236 - Implementing and Maintaining SQL Server Reporting Server 2008
Microsoft ElearningCollection 6322: Implementing and Maintaining Business
Intelligence in SQL 2008: Integration Services, Reporting Services and Analysis Services (available late 2009)
![Page 16: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/16.jpg)
Related SessionsReport Builder 3 (tomorrow) – Andrew Fryer
![Page 18: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/18.jpg)
November 2009Tuesday 24th London – Storage and Query Optimisation - www.sqlpass.org.ukThursday 26th London – SQL Internals and MS BI – SQLServerFAQ.comThursday 26th London – Looking at newsgroups for Info – SQLServerFAQ.com
December 2009Thursday 3rd Online – PowerUp with SQL Server (see next slide)Tuesday 8th Cork – Query Optimisation – MTUG.ieWednesday 9th Dublin – Query Optimisation – IrishDev.comThursday 10th Leeds – Service Broker and Powershell – SQLServerFAQ.com Tuesday 15th Cambridge – Christmas Special down the pub – SQLSocial.comThursday 17th Manchester – SQL Server Internals – SQLServerFAQ.com
Up and coming events..
![Page 19: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/19.jpg)
Time to Power Up with SQL Server within your organization! Who Should Attend:-Database administrators-Application developers/programmers-Database developers- IT Professionals responsible for SQL Server management Sign Up Today at http://tinyurl.com/PowerUpSQLServer
During the day's presentations by SQL Server experts, Greg Low, Javier Loria, and Niels Berglund, you'll get detailed information and time to ask your questions.
Three sessions, directly from your own computer:- Understanding Query Plan Caching in SQL Server- SQL Server High Availability- SQL Server Performance
![Page 20: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/20.jpg)
It’s party time!Coming up next in the Atrium:
Time to relax and let your hair down. Rockband
Table footballAir Hockeyand more
Don’t forget speakers and sponsors have drinks vouchers
![Page 21: I need my reports............. YESTERDAY!!!!!](https://reader035.vdocuments.us/reader035/viewer/2022062410/56816077550346895dcfa2ac/html5/thumbnails/21.jpg)
We hope you had a great conference!
See you at the next one in the Spring
Thank you