Transcript Document
SQL Server 2012 Pillars MISSION CRITICAL PLATFORM Microsoft Confidential—Preliminary Information Subject to Change DEVELOPER & IT PRODUCTIVITY PERVASIVE INSIGHT Empower users • Power View • Highly visual design experience • Rich metadata-driven interactivity • Presentation-ready at all times Increase Proactive Intelligence • End User Alerting • Defined from within operational or ad-hoc reports • Intuitive Alert rules • Alerts self-managed through SharePoint • XLS/Word 2007/2010 Increase efficiency • Enabled as SharePoint Shared Service • Built-in scale-out for RS Service Apps • SharePoint Cross-farm reporting • Integrated backup & recovery, ULS logging, PowerShell etc. • BIDS integrated with Dev10 shell Managed Self Service BI – Corporate BI Reporting Services is now configured and monitored like other SharePoint shared applications. Maximum set of SharePoint IT management capability enabled Lower TCO on IT who can now leverage existing SharePoint skillset and experience. Proactive and responsive data monitoring that enables action. Data Alerts help IWs cope with information overload. Intuitive and flexible alert rules customized to each Information Worker. Microsoft SQL Server 2011 new Self Services Alerting capability makes it trivial for any end user while viewing a report to define rules and thresholds on data and be alerted when they are reached. This transforms a traditional pull mode activity to a push mode activity greatly increasing Information Workers productivity. Create data alerts from within reports • Users create alerts directly on the data they see in reports • Report authors control which data is available for alerting • Supports reports created in Report Builder or BI Development Studio (BIDS) Detect important data changes • Intuitive Alert Rules (greater than, before/after) • Easy to use scheduling (weekly, daily, monthly) • Relevant data included in Alert Message Source: Data.gov - Data.gov and the Federal Government cannot vouch for the data or analyses derived from these data after the data have been retrieved from Data.gov. Managed through SharePoint • • • • Per site administration reduces IT burden Fine grained authorization Self-managed through SharePoint IT Visibility & Control of user-defined alerts Power View is an interactive data exploration and visual presentation experience. Highly Visual Design Experience • • • Interactive, web-based authoring and sharing of information Familiar Microsoft Office design patterns Powerful data layout with banding, callout and small multiples visualizations Rich metadata-driven interactivity • • • • Fully integrated with PowerPivot Drive greater insight through smart and powerful querying Zero configuration highlighting and filtering Animated trending and comparisons Presentation-ready at all times • • • Interactive Presentation turns pervasive information into persuasive information Deliver and collaborate through SharePoint Full screen presentation mode for interactive boardroom session V1 Scenarios “ Architecture CTP http://connect.microsoft.com/sqlazurectps http://servername/reportserver https://servername.reporting.database.windows.net/ReportServer https://rsprodctp2075.ctp.reporting.database.windows.net/ReportServer?%2fSDR%2fContoso_Competitors&rs:Command =Render http://sar.cloudapp.net/