Whats coming SNEAK PEEK Denali SQL Server 2012

What’s coming? SNEAK PEEK

‘Denali’ = SQL Server 2012 The next version of Microsoft SQL Server, SQL Server 2012 will be available in H 1 of CY 2012, enables a cloud-ready information platform that will help organizations unlock breakthrough insights with mission-critical confidence across the organization. Solution Briefing

Mission-Critical Confidence Required 9 s and Data Protection A A Blazing-Fast Performance Organizational Compliance and Peace of Mind A Greater flexibility and availability with SQL Server Always. On Maximized hardware resources Support for Windows Server Core to reduce planned downtime Column-based query accelerator for dramatic performance gains User-defined server roles for better separation of duties and Audit support across editions Faster performance for FILESTREAM, spatial, and FTS Share. Point and Active Directory integration for secure BI data Simplified application testing with Distributed Replay and streamlined troubleshooting with Extended Events Solution Briefing

Big Data Drives Increased Focus on Data Visualization, simulations, and scenario development are the next frontier Historic trend analysis and forecasting Standardized reporting DATA VISUALIZATION Analytics applied within business processes SIMULATIONS AND SCENARIO DEVELOPMENT Clustering and segmentation Regression analysis, discrete choice modeling, and mathematical optimization DATA VISUALIZATION SIMULATIONS AND SCENARIO DEVELOPMENT Analytics applied within business processes Regression analysis, discrete choice modeling, and mathematical optimization Historic trend analysis and forecasting Clustering and segmentation Standardized reporting Today In 24 Months Top 3 Value-Creating Analytic Techniques Source: MIT Sloan Management Review Research Report Fall 2010, Analytics: The New Path to Value Solution Briefing

Breakthrough Insight Rapid Data Exploration Credible, Scalable Analytics and Visualization Consistent Data DW Solutions Familiar data exploration and visualization with Power View (Project “Crescent”) Consistent view of your data through a single BI Semantic Model Engine tuning for high-scale analytics in Analysis Services Inspire innovation with powerful data mash-ups in Power. Pivot Ease of integration and management with Integration Services and Master Data Services Enhanced capabilities for high-scale data warehousing with Parallel Data Warehouse Greater IT oversight and management through Share. Point Quickly manage, analyze, and cleanse data across sources in Data Quality Services Comprehensive offerings for Data Warehouses of all sizes Solution Briefing

Power View 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 Power. Pivot and BI SM Drive greater insight through smart and powerful querying Zero configuration highlighting and filtering Animated trending and comparisons Presentation-ready at all times • • • Turn pervasive information into persuasive information Deliver and collaborate through Share. Point Interactive at all times Solution Briefing

Cloud on Your Terms Scale on Demand Extend Data Anywhere Optimized Productivity Roadmaps for SQL Server appliances and reference architectures DAC parity across Denali and SQL Azure to seamlessly extend new applications Common architecture across servers, appliances, and clouds File. Table for increased data storage flexibility Single database application development experience with Microsoft SQL Server Data Tools (Project “Juneau”) Fast Time to Solution Greater interoperability and support for web applications Streamline virtualization management with System Center Virtual Machine Manager Solution Briefing

Windows Azure Future Unified Programming Platform and Tools Simplified Management Flexible and Trustworthy Storage Efficient Networking Global Platform Compliance Adaptable Pricing Models • Enhance support for JAVA, PHP and Ruby • Improved compatibility between on-premise applications and Windows Azure applications • Improved interoperability with System Center and APIs for integration with mainstream management tools like Open. View and Tivoli • Windows Azure Storage: Automatic data geo-replication • SQL Azure: Larger database sizes for SQL Azure. On-premise and cloud data sync • Improvements in flexibility and responsiveness • Additional locations and CDN nodes • Global Traffic Management Capabilities • Important new security and compliance certifications • Integration with MS Volume Licensing Solution Briefing

Future of Dynamics—CRM Online Enhancements for Enterprise Cloud New Social CRM Capabilities § § § Micro-blogging Activity feeds Conversations Automated activity updates Windows Phone 7 mobile application Unification with Office 365 for Enterprises Other updates announced include support for Safari, Firefox and Chrome browsers on both PC and Mac platforms becoming available in the first half of CY 2012, helping open up Microsoft Dynamics CRM to a whole new audience. Solution Briefing