Manda QoP

Notes from Ian Morrish's talk at TechEd NZ '09. SQLServer 2005 R2 - deep sharepoint integration Light up reporting experience (that's my note, and no, I don't know what I meant here either...) Report server in sharepoint mode Reporting services sharepoint add in New in SQLServer 2008 Data driven subscriptions Support for URL parameters Support for RS management tools in sharepoint mode Integration benefits Single user interface Use SP deployment topologies to distribute reports SP features such as workflows, versioning, collaboration are available Reporting authoring tools can publish direct to SP Report subscriptions can be delivered via SP Reports are executed in report server to leverage all its enterprise capabilities Limitations No report manager No linked reports No Sharepoint SSO Anonymous enabled web apps are not supported Default zone only Architectural decisions to make Sharepoint topology SQL topology Security - NTLM / Kerberos Misc Notes Demo samples availa

Kilimanjaro is the code name for SQL Server 2008 R2. This version of SQL Server 2008 contains 6 major new components: Gemini - self service business intelligence Synthesis - application and multi-server management Madison - High end scale out for data warehousing Orinoco - Complex Event Processing (CET) - streaming data without persistence SSRS - Report builder enhancements and Sharepoint integration > 64 core support Kilimanjaro should be available in the 1st half of CY10.