End End Current support level Mainstream Extended SQL Server 2005 SP4 is in SQL Server 2005 extended support, which ends on April 12, 2011 April 12, 2016 April 12, 2016 SQL Server 2008 and 2008 R2 are in extended support which SQL Server 2008 includes security updates, paid July 8, 2014 July 9, 2019 and 2008 R2 support, and requires purchasing non-security hotfix support SQL Server 20012 SP2+ is in SQL Server 2012 July 11, 2017 July 12, 2022 mainstream support until CY 2017 SQL Server 2014 Currently supporting all versions July 9, 2019 July 9, 2024 Learn more about the SQL Server support lifecycle: support.microsoft.com/lifecycle/
What does There will be no access to critical security updates, opening the potential for business interruptions end of extended Maintaining legacy servers, firewalls, intrusion systems, etc. gets expensive quickly support mean? As support ends, your organization will likely fail to meet regulatory standards compliance
The benefits of upgrading to SQL Server 2014 Achieve mission critical Optimize data Maintain security performance infrastructure and compliance Get up to 30x faster transactions Virtualize and consolidate your The least vulnerable database and more than 100x query data platform for maximum platform six years in a row*, performance gains with in-Memory performance at low TCO engineered for security from the ground-up Experience the 9’s you need — Choose the best of on-premises greater HA and DR with AlwaysOn and Azure with hybrid cloud Manage compliance audit requirements Scale across compute, networking Migrate web applications to and storage with Windows Server Azure SQL Database to reduce Keep receiving support , security 2012 R2 and up to 640 logical updates and hotfixes administrative needs processors **National Institute of Standards and Technology Comprehensive Vulnerability Database 4/2014
The evolution of the Microsoft data platform
The Evolution of SQL Server Increased performance and functionality – release over release 2005 2014 Build mission-critical apps using high-performance, in- A new standard for mission memory technology across critical databases & end-to-end OLTP , data warehousing, BI and Comprehensive, integrated business intelligence with analytics workloads without data management & business cloud-ready technologies & having to buy expensive add- Comprehensive data platform intelligence with award- solutions. ons or high-end appliances. solution with massive strides in winning analytics. “ SQL Server 2012 delivers an Up to 30x faster transactions Solid offering for departmental mission critical & business PowerPivot: Named one of ROI of up to 189% with a 1 year 100x query performance gains IT & enhanced enterprise data intelligence capabilities eWeek’s Top 10 Technologies of payback period“ Enhanced high availability with platform. “Upgrading to Microsoft’s SQL 2010 Forrester up to 8 readable secondaries “Microsoft has made Server 2008 delivered an eWeek TEI Study 2012 Enhanced security and anticipated ROI of between considerable strides in scalability automating SQL Servers 162% & 181%. ” management tasks & improving Hybrid backup and disaster Forrester performance tuning & uptime” recovery TEI Study 2008 According to Forrester, the eWeek 2005 payback period for SQL Server 2014 is only 9.5 months. Forrester TEI Study 2014 ¹Total Economic Impact™ Of Microsoft SQL Server, July 2014 7
Breakthrough performance with SQL Server 2014
Mission critical Breakthrough performance 13x performance from 2005, 5.5x from 2008 with up to 30x additional performance with gains from in-memory OLTP High availability SQL Server 2014 The 9’s you need with readable secondaries using AlwaysOn Security Least vulnerable database six years in a row*, with encryption, key management, auditing, and separation of duties Scalability Scale across compute, networking and storage with Windows Server Manageability Improved manageability with policy-based management, distributed replay, improved performance tuning and Windows PowerShell support Programmability Reduce complexity with advanced developer tools including T-SQL enhancements plus support for unstructured and complex data *National Institute of Standards and Technology Comprehensive Vulnerability Database 4/17/2013
Easy access to data, big and small Scale and manage data across the enterprise Powerful insights with familiar tools
Optimize your data platform investments Upgrade scenarios Hybrid Cloud Shared Achieve mission-critical Lower cost performance on- Paas & SaaS premises SQL Azure SQL Database Virtualize and Virtualized Database consolidate with IaaS Windows Server SQL SQL Server in Azure VM Reduce TCO and Virtualizes Machines increase availability with Virtual Azure VMs Easy on-ramp to cloud SQL Server Private Cloud Virtualized Machine + Appliance for web applications with Physical Azure SQL Database SQL SQL Server Dedicated Physical Machine (raw iron) Higher cost Lower administration Higher administration
Microsoft a leader for… Magic Quadrant for Operational Magic Quadrant for Business Magic Quadrant for Data Warehouse Database Management Systems 1 Intelligence and Analytics Platforms 2 Database Management Systems 3 Farthest right in completeness of vision A leader 7 years running Positioned among industry leaders [1 ] Gartner “Magic Quadrant for Operational Database Management Systems,” by Donald Feinberg , MervAdrian , Nick Heudecker, October 2014; evaluated for SQL Server 2014 [2] [Gartner “Magic Quadrant for Business Intelligence and Analytics Platforms,” by Rita Sallam, Joao Tapadinhas, Josh Parenteau, Daniel Yuen, Bill Hostmann, February 2014 [3] Gartner “Magic Quadrant for Data Warehouse Database Management Systems,” by Mark A. Beyer, Roxane Edjlali, March 2014 http://news.microsoft.com/analyst-reports/
SQL Server 2014 customer momentum In-Memory OLTP In-Memory ColumnStore Hybrid & HA 5
What’s New in SQL Server 2014 since SQL Server 2012 EASY ACCESS TO DATA, PERFORMANCE AND SCALE HYBRID CLOUD SOLUTIONS BIG AND SMALL In-Memory OLTP Simplified backup to Windows Azure Enhanced In-Memory ColumnStore for DW Support for backup of previous versions of Power Query SQL Server to Windows Azure Buffer Pool Extension to SSDs Windows Azure HDInsight Service Cloud back-up encryption support Enhanced Query Processing Analytics Platform System (PDW V2) Simplified cloud Disaster Recovery with Resource Governor adds IO governance POWERFUL INSIGHTS AlwaysOn replicas in Windows Azure VMs SysPrep at cluster level WITH FAMILIAR TOOLS Predictable performance with tiering of compute, network, and storage with EASY ON-RAMP Power BI in Office 365 Windows Server 2012 R2 TO THE CLOUD Power Map for Excel HIGH AVAILABILITY New Windows Azure Deployment UI Mobile interfaces for Power BI for SQL Server Enhanced AlwaysOn, with 8 secondaries and Replica Wizard Larger SQL Server VMs and memory sizes Delayed Durability now available in Windows Azure Clustered Shared Volume support, VHDX support (Windows Server 2012 R2) Manage on-premises and cloud apps (System Center 2012 R2) SECURITY Enhanced separation of duty CC certification at High Assurance Level for 2014 Backup encryption support PROGRAMMABILITY Query optimization enhancements 17
Recommend
More recommend
