Integrating SSRS with SharePont Technologies

This session was more about Denali than SQL Server 2008 R2. Also it was geared more towards SharePoint Admins. Here are some highlights:

• Crescent and Alerting, which are new features of Denali, only will require SharePoint integration.


• Apparently in the past, SSRS reports running on SharePoint were much slower than running them natively (from Report Manager). Delani address this issue and the performance is "almost" as good.


• There can be more than one SSRS catalog in Denali, which is different than previous versions where there could only be one.


• Claims based authentication via the WCF framework endpoints.


• Powershell is used extensively for configuration and management.


• There will be support for consuming reports "cross-farm".


• Integrated Backup/Restore, monitoring with SharePoint.


• Denali will NOT require the SSRS configuration management tool.


• There will be 3 databases which will comprise the SSRS catalog: main, tempdb, and alerts.


• SSRS can be backed up via the SharePoint application management screen.