1 / 42

Introducing

Introducing. Cloud-Ready Information Platform. Samuel Solieman Partner Technology Advisor Microsoft UK. Agenda. What is Key Feature Changes Edition and Licensing Changes. Introducing SQL Server 2012 Cloud-ready Information Platform.

analu
Download Presentation

Introducing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introducing Cloud-Ready Information Platform Samuel Solieman Partner Technology Advisor Microsoft UK

  2. Agenda • What is • Key Feature Changes • Edition and Licensing Changes

  3. Introducing SQL Server 2012Cloud-ready Information Platform Enable mission critical performance and availability at low TCO • MISSION CRITICAL CONFIDENCE Unlock new insights with pervasive data discovery across the organization • BREAKTHROUGH INSIGHT Create business solutions fast, on your terms across server and private or public cloud • CLOUD • ON YOUR TERMS 3

  4. Mission Critical Confidence • Customers Want • SQL Server 2012 Delivers Required 9s & data protection AlwaysOn for global HA with active, multiple secondaries, 2x faster failover & ease of use Blazing-fast performance In-memory ColumnStore delivers astonishing Data Warehousing performance gains, 10x Organizational compliance Windows Server Core edition support for increased security and greater uptime Peace of mind 70K+ Partners, Premier Support & System Center Advisor for proactive troubleshooting 4

  5. Breakthrough Insight • Customers Want • SQL Server 2012 Delivers Rapid data exploration PowerPivot v2 built on Excel and Power View for stunning data visualizations & broad adoption Managed self-service BI End user agility through self-service BI balanced with enterprise security & governance via SharePoint Credible, consistent data Data Quality Services & BI Semantic Model for increased productivity and data accuracy, built-in Scalable analytics & DW Proven analytics for 24+TB¹ cubes, and 15K partitions delivering Tier 1 scalability for large sliding windows 5 ¹Microsoft Evidence: Yahoo

  6. Cloud On Your Terms • Customers Want • SQL Server 2012 Delivers • Scale on demand • Easily move applications across on-premises and cloud with unlimited virtualization and license mobility • Fast time to market • Enable Hybrid IT to offer flexibility and choice across on-premises and cloud • Optimized productivity • Common management & development tools: SQL Server Data Tools, T-SQL & SSMS • Extend any data, anywhere • Extend to cloud with Windows Azure Marketplace and Data Sync; Support for unstructured data & interop with PHP & Java 6

  7. Key Feature Changes

  8. SQL Server 2012 Highlights

  9. SQL Server 2012 Highlights

  10. AlwaysOnHelping enable global HA, through greater uptime and manageability • HIGHER PRODUCTIVITY • Single solution to manage; Availability Groups for Clustering, Mirroring, Log Shipping, and Diagnostics • Wizards for easy set up; dashboards for visibility • GREATER UPTIME & H/W USE • Multiple, active secondaries • Multi-database failover • Faster connections and page repair • Offload & distribute workloads to secondaries • Additional benefits • Scale on demand; distribute workloads across reables • Performance gains by shifting workloads off primary to secondaries, including backups Hong Kong (Secondary) AG_Listener Asynchronous data movement AG AG AG Synchronous data movement New York (Primary) New Jersey (Secondary) Unified HA Solution

  11. Power View and Power Pivot v2 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 • Full integration between PowerPivot and Power View • Drive greater insight through smart and powerful querying • Zero configuration highlighting and filtering • Animated trending and comparisons Presentation-ready at all times • Presentation and story board turn pervasive information into persuasive information • Deliver and collaborate through SharePoint • Interactive PowerPoint runtime

  12. Blazing-Fast Performance 10x ColumnStore Index & Distributed Replay Now, up to 57,000 transactions per second¹ “400 percent improvement in performance.” 100,000,000 transactions per day² First American Title Insurance Company Faster³ New ¹Source: Microsoft customer evidence, Choice Hotels International ²Source: Microsoft customer evidence, KAS Bank ³Source: Microsoft customer testing; common data warehousing queries Index ColumnStore

  13. Business Intelligence Semantic Model (BISM) One Semantic Model for BI • For reporting, analytics, scorecards, dashboards • For all users – Personal, Team, Organization BI • Unification of OLAP (UDM) and report (SMDL) models Powerful & Flexible • Supports relational and multidimensional APIs • Model can be cached (VertiPaq) or passthrough (Realtime) • Sophisticated business logic using DAX and MDX Enterprise Ready • Optimized for latest hardware – multi-core, in-memory • Supports enterprise grade security and data volumes • Professional development and management tools

  14. Windows Server Core Support • Minimal OS GUI • Less Patching • Less down time • Smaller attack surface • MSDN: http://msdn.microsoft.com/en-us/library/ms723891(VS.85).aspx

  15. Credible, Consistent Data Companies with accurate data perform better¹ % of master data complete & accurate Hrs spent per employee each week searching for info 91% Top 20% Performers 1.2hrs Middle 50% Performers 68% 2.8hrs Bottom 30% Performers 6hrs Under 50% Master Data Data Quality Single BI SemanticModel Delivered with Services Services ¹Source: “Turning Pain into Productivity with Master Data Management,” Aberdeen Group, Feb 2011

  16. Security Enhancements and Compliance NIST Reported Common Vulnerabilities and Exposures Jan 2002 – Jun 2010 “Most secure of any of the major database platforms.” Source: ITIC 2011: SQL Server Delivers Industry-Leading Security Better separationof duties New in Expanded AUDIT &

  17. SSRS SharePoint Integration and Alerting 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. Management through SharePoint Central Admin

  18. Edition and Licensing Changes

  19. SQL Server 2008 R2 SKUs Principal • Departmental • Small / medium scale • Business critical • Large scale • Business critical • Highest scale Specialised • Websites • Web applications • Supported for installation in a small business domain Breadth • Developing and testing • Free with MSDN subscription • Client embedded • Free • Entry level and learning • Free • Branch • Small scale

  20. SQL Server 2012 SKUs Principal • Departmental • Small / medium scale • Departmental • Limited BI projects • Business critical • Large scale • High-end datacenter • Premium BI • Enterprise BI • Self-service analytics Specialised Available through SPLA only • Websites • Web applications Breadth • Developing and testing • Free with MSDN subscription • Entry level and learning • Free • Client embedded • Free

  21. SQL Server 2012 Editions *Enterprise legacy servers licensed under Server/CAL licensing are subject to a 20-core per server limit. ** Basic include 2 node Failover Clustering

  22. Licensing SQL Server 2012 Principal OR Server / CAL Per Core Per Core Server / CAL Specialised Available through SPLA only Breadth FREE* or $50 FREE FREE *Free download with MSDN subscription

  23. Server/CAL Licensing • Editions • Standard • Business Intelligence • Rules • SQL Server 2012 CALs can be used against any SQL Server, regardless of platform or edition • Available as User or Device CALs • Pricing • 27% price increase on CALs • No price increase on servers

  24. CoreLicensing • Editions • Standard • Enterprise • Rules • Count the number of cores in each processor • Buy that number of Core licences as long as a minimum of 4 are purchased per processor • No CALs are required • Pricing • Core licences are priced at a quarter of Processor licences

  25. Licensing SQL Server 2012 in Virtual Environments

  26. Server/CAL Editions License individual virtual machines

  27. Core Editions C C C C C C C C License the virtual processors used by the virtual machines, with a minimum of 4 Core licenses per virtual machine

  28. Unlimited Virtualisation C C C C C C C C SA SA SA SA SA SA SA SA License all the physical cores with Enterprise Edition Core licenses with SA

  29. License Mobility SA SA

  30. Migrating to SQL Server 2012

  31. SA Migration Path • SQL SERVER 2008 R2 • SQL SERVER 2012

  32. SQL Server 2008 R2 Standard: Server Existing SQL Server Standard Server licenses with SA Customers receive use rights for SQL Server 2012 Standard server licenses and CALs SQL Server 2008 R2Standard Server SQL Server 2012Standard Server Server/CAL Server/CAL SQL Server 2008 R2CAL SQL Server 2012CAL Existing licenses with SA Migration to SQL Server 2008 R2Standard 12 Server licenses SQL Server 2012Standard 12 Serverlicenses SQL Server 2008 R2677 CALs SQL Server 2012677 CALs

  33. SQL Server 2008 R2 Standard: Processor Existing SQL Server Standard Processor licences with SA Customers receive as many Core licenses as there are cores in each processor SQL Server 2008 R2 Standard Proc SQL Server 2012Standard Cores Per Processor Existing licenses with SA Migration to SQL Server 2008 R2Standard 1 Processor license(1-4 cores) SQL Server 2012Standard 4 Core licenses* SQL Server 2008 R2Standard 1 Processor license(6 cores) SQL Server 2012Standard 6 Core licenses Per Core SQL Server 2008 R2Standard 1 Processor license(8 cores) SQL Server 2012Standard 8 Core licenses * Minimum of 4 cores per processor granted

  34. SQL Server 2008 R2 Enterprise: Server Existing SQL Server Enterprise Server licences with SA If the customer maintains SA for Enterprise Edition, they will maintain server use rights, with a maximum of 20 cores per server SQL Server 2008 R2Enterprise Server SQL Server 2012Enterprise Server Server/CAL Server/CAL SQL Server 2008 R2CAL SQL Server 2012CAL Existing licenses with SA Migration to SQL Server 2008 R2Enterprise 23 Server licenseson servers with ≤ 20 cores SQL Server 2012Enterprise 23 Server licenseson servers with ≤ 20 cores SQL Server 2008 R25,250 CALs SQL Server 20125,250 CALs

  35. SQL Server 2008 R2 Enterprise: Processor Existing SQL Server Enterprise Processor licences with SA Customers receive as many Core licenses as there are cores in each processor SQL Server 2008 R2 Enterprise Proc SQL Server 2012Enterprise Cores PerProcessor Existing licenses with SA Migration to SQL Server 2008 R2Enterprise 1 Processor license(1-4 cores) SQL Server 2012Enterprise 4 Core licenses* SQL Server 2008 R2Enterprise 1 Processor license(6 cores) SQL Server 2012Enterprise 6 Core licenses Per Core SQL Server 2008 R2Enterprise 1 Processor license(8 cores) SQL Server 2012Enterprise 8 Core licenses * Minimum of 4 cores per processor granted

  36. SQL Server 2008 R2 Datacenter: Processor Existing SQL Server Datacenter Processor licences with SA Customers receive as many Enterprise Core licenses as there are cores in each processor SQL Server 2008 R2 Datacenter Proc SQL Server 2012Enterprise Cores Per Processor Existing licences with SA Migration to SQL Server 2008 R2Datacenter 1 Processor license(1-8 cores) SQL Server 2012Enterprise 8 Corelicenses* SQL Server 2008 R2Datacenter 2 Processor licenses(2 x 4 cores) SQL Server 2012Enterprise 16 Corelicenses Per Core SQL Server 2008 R2Datacenter 4 Processor licenses(4 x 4 cores) SQL Server 2012Enterprise 32 Corelicenses * Minimum of 8 cores per processor granted

  37. SQL Server 2012 Price Increases • Before GA: • Scenario: customer has EA/SA due for renewal Recommendation: renew to get SQL Server 2012 • Scenario: customer has no SA but wants to move to SQL Server 2012 Recommendation: consider an EAP • After GA: • Consider an EAP for best pricing Please contact your software reseller for more information.

  38. More SQL Server 2012 Licensing Information • Please refer to the SQL Server 2012 Licensing Overview Website and download the Licensing Datasheet • Please also refer to the SQL Server 2012 Editions Website.

  39. Summary MISSION CRITICAL CONFIDENCE Peace of Mind 1 Required 9s& Protection Organizational Compliance 4 2 Blazing-Fast Performance 3 BREAKTHROUGH INSIGHT Credible, Consistent Data Scalable Analytics & DW 8 Managed Self-Service BI Rapid Data Exploration 5 6 7 CLOUD ON YOUR TERMS Scale on Demand Extend Any Data, Anywhere 9 10 11 12 Fast Timeto Solution Optimized Productivity

  40. Questions? samuel.solieman@microsoft.com

  41. Online Operation Enhancements Contained Database Authentication AlwaysOn Reliable Secondaries Multi-site Clustering SQL Server Express LocalDB Windows Server Core Support Statistical Semantic Search PHP & Java Connectivity FileTable Unstructured Data Performance ColumnStore Index Extended Events Enhancements AlwaysOn Connection Director Multiple Secondaries PowerShell 2.0 Support Reporting Alerts Database Recovery Advisor SQL Server Data Tools PowerPivot Enhancements Resource Governor Enhancements T-SQL Debugger Enhancements Audit Filtering Power View Full Globe Spatial Flexible Failover Policy Unstructured Data Performance CDC Support for SSIS BI Semantic Model Audit Resilience Distributed Replay New SSIS Design Surface User-defined Audit SSMS to Windows Azure Platform Data Quality Services FTS Support for Czech and Greek 15k Partitions Master Data Management Excel Add-in Full-Text Search Performance HA for StreamInsight Availability Groups SSIS Troubleshooting Ad Hoc Reporting Default Scheme for Windows Groups Spatial 2D Support ODBC Driver for Linux SharePoint Active Directory Support SSIS Package Management SQL Audit for All Editions T-SQL Enhancements

  42. The information in this presentation is Microsoft Confidential and subject to a Non-Disclosure Agreement This presentation contains preliminary information that may be changed substantially prior to the final release of SQL Server 2012 © 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista, and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

More Related