1 / 21

I need my reports............. YESTERDAY!!!!!

Learn about report authoring, SQL Server 2008 features, and how to optimize report performance by utilizing parameters and filters. Explore caching techniques, snapshots, and historical data creation. Discover ways to create user-driven and data-driven subscriptions. Get insights on reducing the number of stored reports and enhancing report delivery with subscriptions. Find out about available courses and upcoming events in the SQL Server community. Be part of Europe's premier SQL Server conference and power up your SQL skills! Register now at tinyurl.com/PowerUpSQLServer.

levin
Download Presentation

I need my reports............. YESTERDAY!!!!!

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. I need my reports.............YESTERDAY!!!!! Chris Testa-O’Neill QA

  2. Who am I • Chris 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 Organiser • www.sqlserverfaq.com • www.learnsqlserver.org

  3. Agenda • Parameters and Filters • Caching • Snapshots • History • Subscriptions • Q and A (if time permits)

  4. Due to time this session cannot • Report Authoring • Microsoft SQL Server 2008 R2: What’s new in Reporting Services – Donald Farmer • Report Builder 3 (tomorrow) – Andrew Fryer • Security

  5. Parameters and Filter • From 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

  6. Caching • Caching 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

  7. Execution process for cached instances • Retrieves most up-to-date data and processes report • Creates intermediate report and stores intermediate result in the cache in ReportServerTempDB • Flags intermediate report as a cached instance • Renders report from cached instance • Later requests for the same report are retrieved from the cached copy

  8. Snapshots • Snapshot are created in advance of the user browsing • Stored in the ReportServerDB and are persistent • Can be used to create historical data

  9. Execution process for snapshots • Creation of snapshot is scheduled for a specific point in time • The intermediate report is created and the result is stored as a snapshot in the report server database • Requests are satisfied by retrieving and rendering the snapshot

  10. Demonstration Creating Parameters and Filters Creating Cache settings Creating Report snapshots

  11. I need a report from.....yesterday • Historical data provides a point in time copy of reports • Impact on parameters and filters • Control the number of reports stored • BE AWARE – Reducing the number of reports stored will truncate the reports

  12. Demonstration Creating Historical Reports

  13. Subscriptions • Standard Subscriptions • User and Administrator driven • Data Driven Subscription • Administrator driven • Requires the creation of a subscriber table • Can be used to pre populate a cache

  14. Demonstration Creating User Subscriptions Creating Data Driven Subscriptions

  15. Available courses • Microsoft Official Curriculum courses • SQL Server 2005 • 2793 – Implementing and Maintaining SQL Server Reporting Server 2005 • SQL Server 2008 • 6236 - Implementing and Maintaining SQL Server Reporting Server 2008 • Microsoft Elearning • Collection 6322: Implementing and Maintaining Business Intelligence in SQL 2008: Integration Services, Reporting Services and Analysis Services (available late 2009)

  16. Related Sessions • Report Builder 3 (tomorrow) – Andrew Fryer

  17. Europe’s Premier Community SQL Server Conference

  18. Up and coming events.. November 2009 Tuesday 24th London – Storage and Query Optimisation - www.sqlpass.org.uk Thursday 26th London – SQL Internals and MS BI – SQLServerFAQ.com Thursday 26th London – Looking at newsgroups for Info – SQLServerFAQ.com December 2009 Thursday 3rd Online – PowerUp with SQL Server (see next slide) Tuesday 8th Cork – Query Optimisation – MTUG.ie Wednesday 9th Dublin – Query Optimisation – IrishDev.com Thursday 10th Leeds – Service Broker and Powershell – SQLServerFAQ.com Tuesday 15th Cambridge – Christmas Special down the pub – SQLSocial.com Thursday 17th Manchester – SQL Server Internals – SQLServerFAQ.com

  19. 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

  20. It’s party time! Coming up next in the Atrium: Time to relax and let your hair down. Rockband Table football Air Hockey and more Don’t forget speakers and sponsors have drinks vouchers

  21. We hope you had a great conference! See you at the next one in the Spring Thank you

More Related