An Introduction to Data Sources in SSRS: The Shared Data Source and Report-Specific Data Sources - Video Series Video Category: Inside SQL Server Reporting Services: Understanding the Architecture of SSRS Skill Level: 300 (Intermediate) Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008 In SQL Server Reporting Services, you have two options for connecting to the various data sources: you can either use a Shared Data Source, which is shared among multiple reports, or the Report-Specific Data Source which the name implies its use. This series of SQL Server Reporting Services video tutorials explains the difference between the two (a quick difference at that) and then gets into the nitty gritty: performance tuning your Shared Data Sources. Tweaking Shared Data Sources usually offers the most impact on performance and, after watching this series, you'll have a much more in-depth understanding of what to do (and use), when.

Videos in this Series:

Title Skill Length Download Pt. 1 - Data Sources in SSRS: An Intro to Shared and Report-Specific Data Source...   200 11 mins. Download Pt. 2 - How to Share a Shared Data Source Across Multiple Projects and Solutions   300 11 mins. Download Pt. 3 - Performance Tuning Your Reporting: How to Ensure Connection Pooling in Y...   400 13 mins. Download Pt. 4 - Best Practices for Maximum SQL Server Reporting Services Performance: Sh...   400 9 mins. Download

< Return to list of all videos