DBI 328 SQL SERVER 2005 SP 2 2008

DBI 328

SQL SERVER 2005 SP 2, 2008 R 2

Empower users • Project “Crescent” • Highly visual design experience • Rich metadata-driven interactivity • Presentation-ready at all times Increase Productivity Proactive Intelligence • End User Alerting • Defined from within operational or ad-hoc reports • Intuitive Alert rules • Alerts self-managed through Share. Point • XLS/Word 2007/2010 Managed Self Service BI – Corporate BI Increase efficiency • Enabled as Share. Point Shared Service • Built-in scale-out for RS Service Apps • Share. Point Cross-farm reporting • Integrated backup & recovery, ULS logging, Power. Shell etc.

Reporting Services is now configured and monitored like other Share. Point shared applications. Maximum set of Share. Point IT management capability enabled Lower TCO on IT who can now leverage existing Share. Point skillset and experience.

Demo

Demo

SSRS Add-in for Share. Point SSRS Shared Service Share. Point 2010 App Server Share. Point 2010 WFE Share. Point Service Application (IIS Hosted) Share. Point Web Application Report. SSRS Viewer. Add-in web part bits (incl. Crescent and Alerting , Crescent & Alerting XAP) in: Silverlight components - Share. Point 2010 folders, SOAP - GAC SSRS Service Proxy WCF Claims and. Service Background SSRS Shared bits: SSRS Shared Alerting 2010 folders, - Share. Point Processing Service WCF Service Endpoint- GACApp - Registry entries Runtime - Perf ctrs etc. Data Management Security URLAccess Share. Point Object Model Share. Point Config / Content DB Create SSRS Service Register SSRS Shared Share. Point Object Model Application Service SSRS Service Application DB

SSRS Add-in for Share. Point SSRS Shared Service Share. Point Report 2010 Server App Server Share. Point 2010 WFE Share. Point Service Application (IIS Hosted) Share. Point Web Application Report Viewer web part SSRS Add-in bits (incl. , Crescent & Alerting Crescent and Alerting Silverlight components XAP) in: Report-Viewer Share. Point 2010 SOAP management UI web part folders, - GAC SSRS Service SSRS Proxy WCF Claims SSRS Shared Service bits: and Background SSRS Shared Alerting 2010 folders, Share. Point Processing Service WCF Service - GAC Report Server in Share. Point Mode Endpoint App - Registry entries (Service Acct 1) Runtime - Perf ctrs etc. Data Management Security Extension Data Management Security URLAccess Share. Point Object Model Share. Point Config / Content DB Create SSRS Service Share. Point Object Model Register SSRS instance Application SSRS Service Application DB SSRS catalog DB

Shp App Server 1 Web Front End 1 SSRS Shared Service Application 1 (IIS SSRS Shared Hosted) Service Application 2 (IIS Hosted) SSRS in Web Application 1 Report Viewer. SSRS web partin Web Application 2 , Crescent & Alerting SSRS Report Viewer web part Silverlight components Service , Crescent & Alerting SSRS Proxy Silverlight components SOAP URLAccess Service Proxy URLAccess Share. Point Object Model Share. Point Config / Content DBs WCF Claims SSRS and Background Alerting SSRS and Processing Background Service Alerting Processing App Service Runtime App Runtime Data Management Security SSRS Shared Service SSRS WCF Shared Endpoint Service WCF Endpoint Share. Point Object Model Report Server Shared. Report Server Service DBs Shared Service DBs

SSRS Shared Service Share. Point 2010 WFE Shp App Server 1 SSRS in Web Application 1 Report Viewer web part , Crescent & Alerting Silverlight components SOAP SSRS Service Proxy URLAccess Share. Point Object Model Shp App Server Service 2 Application 1 (IIS Hosted) WCF SSRS Share. Point Service Application 1 (IISbits: Hosted) SSRS and Background SSRS Shared Alerting Share. Point 2010 folders, Processing Service WCF Service GAC SSRSEndpoint and Background App Alertingentries Processing Registry Runtime Service Perf ctrs etc. App Data Management Runtime Security Data Management Security Claims SSRS Shared WCF Service WCF Endpoint Claims Share. Point Object Model Register SSRS instance Share. Point Object Model Share. Point Config / Content DBs Report Server Shared Service DBs

Share. Point 2010 WFE Share. Point 2010 App Server SSRS Shared Service Application WCF Endpoint REQUEST der Ren Out over WCF Report Viewer web part SSRS Service Proxy put Security Extension RESPONSE Render Service Runtime (Data Management) (User 1) Processing & Rendering over WCF Share. Point Object Model Windows User U S E R 1 On. Demand Sync Share. Point Object Model C 2 WTS Windows Service Share. Point Config / Content DB Report Sever Service Application DB Windows USER 1 SQL Server Data Source

Share. Point 2010 WFE SP Service Application SP Web Application URLAccess SOAP, … Denali SSRS Addin for Share. Point functionality Share. Point OM Share. Point Config / Content DB Share. Point 2010 App Server WCF Claims Denali New BISM Power. Pivot or Denali SSRS Service Application connection SSAS Service (non Functionality -Share. Point) Share. Point OM Report Server Shared Service DB

Demo

Share. Point Dashboards & Scorecards Share. Point Collaboration Analysis Services Integration Services Excel Workbooks Reporting Services Master Data Services Power. Pivot Applications Most Broadly adopted Productivity & Collaboration Tools Most widely deployed EIM & BI Platform LOB Apps Odata Feeds

SSRS 2008 R 2 Add-in Share. Point 2010 WFE SSRS 2008 R 2 Reporting Services Add-in (Connected (Local. Mode) mode) Report Server in Share. Point Mode (SSRS 2005 SP 2, 2008 R 2) Report Viewer web part Report management UI SSRS Proxy Share. Point Object Model Share. Point Config / Content DB Security Extension Data Management Share. Point Object Model Report Sever DB

Appendix – Power. Shell script

Appendix – Power. Shell script…

http: //bi http: //spmarketing http: //infoweb 2007/sqlserver/Pages/default. aspx http: //sharepoint/sites/safepassage/pages/default. aspx http: //www. buildabetterapp. com http: //sharepoint/sites/dpevan/sql 2 k 8 r 2/default. aspx http: //comphot http: //blogs. msdn. com/prash http: //blogs. msdn. com/b/bi/ http: //blogs. msdn. com/oneclickbi http: //blogs. msdn. com/b/sqlrsteamblog/ http: //blogs. msdn. com/powerpivot http: //learnpowerpivot http: //pps 14

microsoft. com/sqlserver

Connect. Share. Discuss. http: //northamerica. msteched. com Sessions On-Demand & Community Microsoft Certification & Training Resources www. microsoft. com/teched www. microsoft. com/learning Resources for IT Professionals Resources for Developers http: //microsoft. com/technet http: //microsoft. com/msdn

Scan the Tag to evaluate this session now on my. Tech • Ed Mobile