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

These are some notes from Matt Velloso's session at TechEd 09 on the 14th Sept. These are just my notes created whilst watching the session and they can be used as a start point to find out more information. Myths to debunk: You can change meta data easily. Well, yes you can, however, that doesn't mean you should. So don't. If you need to change your meta data, plan it out first and make sure that your changes don't break another part of the system. There's no code so it's risk free. Cobblers. What do you think runs Sharepoint if it's not code? Always manage risk and plan for various eventualities. It's an out of the box app, we don't need to test. Sigh.... just test it already and get over the 'testing isn't necessary' mentality. Blobcache Stop going to SQL Server all the time Use Fiddler2 (HTTP debugging proxy) to check the status of your blobcache Enable blobcache in web.config How to break your blobcache: reset IIS, hit refresh

Sharepoint Designer is now available as a free download. Check out this link for more information. http://blogs.msdn.com/sharepoint/archive/2009/04/02/sharepoint-designer-available-as-a-free-download.aspx