SQL Server 2005 extended support, which ends on April 12, 2011 - - PowerPoint PPT Presentation

Current support level End Mainstream

SQL Server 2005

SQL Server 2005 SP4 is in extended support, which ends on April 12, 2016 April 12, 2011 April 12, 2016

SQL Server 2008 and 2008 R2

SQL Server 2008 and 2008 R2 are in extended support which includes security updates, paid support, and requires purchasing non-security hotfix support July 8, 2014 July 9, 2019

SQL Server 2012

SQL Server 20012 SP2+ is in mainstream support until CY 2017 July 11, 2017 July 12, 2022

SQL Server 2014

Currently supporting all versions July 9, 2019 July 9, 2024

End Extended

Learn more about the SQL Server support lifecycle: support.microsoft.com/lifecycle/

There will be no access to critical security updates, opening the potential for business interruptions Maintaining legacy servers, firewalls, intrusion systems,

• etc. gets expensive quickly

As support ends, your organization will likely fail to meet regulatory standards compliance

What does

end of extended support mean?

The benefits of upgrading to

SQL Server 2014

Achieve mission critical performance

Get up to 30x faster transactions and more than 100x query performance gains with in-Memory Experience the 9’s you need— greater HA and DR with AlwaysOn Scale across compute, networking and storage with Windows Server 2012 R2 and up to 640 logical processors

Maintain security and compliance

The least vulnerable database platform six years in a row*, engineered for security from the ground-up Manage compliance audit requirements Keep receiving support, security updates and hotfixes

Optimize data infrastructure

Virtualize and consolidate your data platform for maximum performance at low TCO Choose the best of on-premises and Azure with hybrid cloud Migrate web applications to Azure SQL Database to reduce administrative needs

**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

7

¹Total Economic Impact™ Of Microsoft SQL Server, July 2014

A new standard for mission critical databases & end-to-end business intelligence with cloud-ready technologies & solutions. “SQL Server 2012 delivers an ROI of up to 189% with a 1 year payback period“ Forrester TEI Study 2012 Solid offering for departmental IT & enhanced enterprise data platform. “Microsoft has made considerable strides in automating SQL Servers management tasks & improving performance tuning & uptime” eWeek 2005 Comprehensive data platform solution with massive strides in mission critical & business intelligence capabilities “Upgrading to Microsoft’s SQL Server 2008 delivered an anticipated ROI of between 162% & 181%. ” Forrester TEI Study 2008 Comprehensive, integrated data management & business intelligence with award- winning analytics. PowerPivot: Named one of eWeek’s Top 10 Technologies of 2010 eWeek Build mission-critical apps using high-performance, in- memory technology across OLTP , data warehousing, BI and analytics workloads without having to buy expensive add-

• ns or high-end appliances.

Up to 30x faster transactions 100x query performance gains Enhanced high availability with up to 8 readable secondaries Enhanced security and scalability Hybrid backup and disaster recovery According to Forrester, the payback period for SQL Server 2014 is only 9.5 months. Forrester TEI Study 2014

2014 2005

Breakthrough performance with SQL Server 2014

*National Institute of Standards and Technology Comprehensive Vulnerability Database 4/17/2013

Mission critical performance with SQL Server 2014

Breakthrough performance

13x performance from 2005, 5.5x from 2008 with up to 30x additional gains from in-memory OLTP

High availability

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

Easy access to data, big and small Scale and manage data across the enterprise Powerful insights with familiar tools

Optimize your data platform investments

Shared Lower cost Dedicated Higher cost Higher administration Lower administration

Hybrid Cloud

Physical

SQL Server Physical Machine (raw iron)

SQL

IaaS

SQL Server in Azure VM Virtualizes Machines

SQL

Virtual

SQL Server Private Cloud Virtualized Machine + Appliance

Paas & SaaS

Azure SQL Database Virtualized Database

SQL

Upgrade scenarios

 Achieve mission-critical performance on- premises  Virtualize and consolidate with Windows Server  Reduce TCO and increase availability with Azure VMs  Easy on-ramp to cloud for web applications with Azure SQL Database

Magic Quadrant for Data Warehouse Database Management Systems3

Positioned among industry leaders

Microsoft a leader for…

Magic Quadrant for Business Intelligence and Analytics Platforms2

A leader 7 years running

Magic Quadrant for Operational Database Management Systems1

Farthest right in completeness of vision

[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

5

In-Memory OLTP In-Memory ColumnStore Hybrid & HA

What’s New in SQL Server 2014 since SQL Server 2012

17

PERFORMANCE AND SCALE

In-Memory OLTP Enhanced In-Memory ColumnStore for DW Buffer Pool Extension to SSDs Enhanced Query Processing Resource Governor adds IO governance SysPrep at cluster level Predictable performance with tiering of compute, network, and storage with Windows Server 2012 R2

HIGH AVAILABILITY

Enhanced AlwaysOn, with 8 secondaries and Replica Wizard Delayed Durability 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

HYBRID CLOUD SOLUTIONS

Simplified backup to Windows Azure Support for backup of previous versions of SQL Server to Windows Azure Cloud back-up encryption support Simplified cloud Disaster Recovery with AlwaysOn replicas in Windows Azure VMs

EASY ON-RAMP TO THE CLOUD

New Windows Azure Deployment UI for SQL Server Larger SQL Server VMs and memory sizes now available in Windows Azure

EASY ACCESS TO DATA, BIG AND SMALL

Power Query Windows Azure HDInsight Service Analytics Platform System (PDW V2)

POWERFUL INSIGHTS WITH FAMILIAR TOOLS

Power BI in Office 365 Power Map for Excel Mobile interfaces for Power BI

What’s New in SQL Server 2014 since SQL Server 2008 R2

18

PERFORMANCE AND SCALE

In-Memory OLTP Enhanced In-Memory ColumnStore for DW Support for 640 logical proc. and Support to 15,000 partitions Resource Governor IO governance Buffer Pool Extension to SSDs Query optimization enhancements SysPrep at cluster level Predictable performance with tiering of compute, network, and storage with Windows Server 2012 R2

HIGH AVAILABILITY

SQL Server AlwaysOn Delayed Durability Recovery Advisor Windows Server Core Live Migration Online Operations enhancements Clustered Shared Volume support, VHDX support (Windows Server 2012 R2) Manage on-premises and cloud apps (System Center 2012 R2)

SECURITY

User-Defined Server Roles Default Schema for Groups SQL Server Audit SQL Server Fine-grained Auditing Enhanced separation of duty CC certification at High Assurance Level Backup encryption support

PROGRAMMABILITY

SQL Server Data Tools Local DB runtime (Express) Data-tier Application Component project template Data-Tier Application Framework (DAC Fx) Query optimization enhancements Interoperability support (ADO.NET, ODBC, JDBC, PDO, ADO APIs and .NET C/C++, Java, Linux, and PHP platforms)

T-SQL enhancements

Enhanced support for ANSI SQL standards Transact-SQL Static Code Analysis tools Transact-SQL code snippets Intellisense

Unstructured and complex data support

FileTable built on FILESTREAM Remote Blob Storage with SharePoint 2010 Statistical Semantic Search Spatial features, including Full Globe and arcs Large user-defined data types

MANAGEABILITY

Distributed Replay Contained Database Authentication System Center Management Pack for SQL Server 2012 Windows PowerShell 2.0 support Multi-server Management with SQL Server Utility Control Point Data-Tier Application Component

HYBRID CLOUD SOLUTIONS

Simplified backup to Windows Azure Support for backup of previous versions of SQL Server to Windows Azure Cloud back-up encryption support Simplified cloud Disaster Recovery with AlwaysOn replicas in Windows Azure VMs

EASY ON-RAMP TO THE CLOUD

New Windows Azure Deployment UI for SQL Server Larger SQL Server VMs and memory sizes now available in Windows Azure DAC enhancements: Import/export with Windows Azure SQL Database

COMPLETE AND CONSISTENT FROM ON-PREM TO CLOUD

SQL Server Data Tools License Mobility (with SA) Resource Governor enhancements Snapshot backups to Windows Azure via SQL Server Management Studio

ACCESS ANY DATA

Power Query Windows Azure HDInsight Service Analytics Platform System (PDW V2) Mash up data from different sources, such as Oracle & Hadoop

INSIGHTS WITH FAMILIAR TOOLS

Power BI in Office 365 Power Map for Excel Mobile interfaces for Power BI

COMPLETE BI SOLUTION

SQL Server BI Edition HA for StreamInsight, complex event processing BI Semantic Model SQL Server Data Tools support for BI Change Data Capture for Oracle

Analysis services

Import PowerPivot models into Analysis Services Enhancements on productivity, performance

Reporting services

Power View Configurable reporting alerts Reporting as SharePoint Shared Service Report Builder 3.0

Data quality services

Build organizational knowledge base Connect to 3rd party data cleansing providers

Master data services

Master Data Hub Master Data Services Add- in for Microsoft Excel

Integration services

Graphical tools in SSIS Extensible object model SSIS as a Server Broader data integration with more sources; DB vendors, cloud, Hadoop Pipeline improvements

What’s New in SQL Server 2014 since SQL Server 2008

19

PERFORMANCE AND SCALE

In-Memory OLTP Enhanced In-Memory ColumnStore for DW Support for 640 logical proc. and 4 TB memory Support to 15,000 partitions Resource Governor IO governance Buffer Pool Extension to SSDs Query optimization enhancements SysPrep at cluster level Predictable performance with tiering of compute, network, and storage with Windows Server 2012 R2 Data Compression with USC-2 Unicode support Backup Compression

HIGH AVAILABILITY

SQL Server AlwaysOn Delayed Durability Recovery Advisor Windows Server Core Live Migration Online Operations enhancements Clustered Shared Volume support, VHDX support (Windows Server 2012 R2) Manage on-premises and cloud apps (System Center 2012 R2)

SECURITY

User-Defined Server Roles Default Schema for Groups SQL Server Audit SQL Server Fine-grained Auditing Enhanced separation of duty CC certification at High Assurance Level Backup encryption support

PROGRAMMABILITY

SQL Server Data Tools Local DB runtime (Express) Data-tier Application Component project template Data-Tier Application Framework (DAC Fx) Query optimization enhancements Interoperability support (ADO.NET, ODBC, JDBC, PDO, ADO APIs and .NET C/C++, Java, Linux, and PHP platforms)

T-SQL enhancements

Enhanced support for ANSI SQL standards Transact-SQL Static Code Analysis tools Transact-SQL code snippets Intellisense

Unstructured and complex data support

FileTable built on FILESTREAM Remote Blob Storage with SharePoint 2010 Statistical Semantic Search Spatial features, including Full Globe and arcs Large user-defined data types

MANAGEABILITY

Distributed Replay Contained Database Authentication System Center Management Pack for SQL Server 2012 Windows PowerShell 2.0 support Data-Tier Application Component

HYBRID CLOUD SOLUTIONS

Backup to Windows Azure Cloud Disaster Recovery Extend on-premises apps to the cloud

EASY ON-RAMP TO THE CLOUD

New Windows Azure Deployment UI for SQL Server Larger SQL Server VMs and memory sizes now available in Windows Azure DAC enhancements: Import/export with Windows Azure SQL Database

COMPLETE AND CONSISTENT FROM ON-PREM TO CLOUD

SQL Server Data Tools License Mobility (with SA) Resource Governor enhancements Snapshot backups to Windows Azure via SQL Server Management Studio

ACCESS ANY DATA

Power Query Windows Azure HDInsight Service Analytics Platform System (PDW V2) Mash up data from different sources, such as Oracle and Hadoop

INSIGHTS WITH FAMILIAR TOOLS

Power BI in Office 365 Power Map for Excel Mobile interfaces for Power BI

COMPLETE BI SOLUTION

SQL Server BI Edition StreamInsight, complex event processing BI Semantic Model SQL Server Data Tools support for BI Change Data Capture for Oracle

Analysis services

Import PowerPivot models into Analysis Services Enhancements on productivity, performance

Reporting services

Power View Configurable reporting alerts Reporting as SharePoint Shared Service Report Builder 3.0

Data quality services

Build organizational knowledge base Connect to 3rd party data cleansing providers

Master data services

Master Data Hub Master Data Services Add-in for Microsoft Excel

Integration services

Graphical tools in SSIS Extensible object model SSIS as a Server Broader data integration with more sources; DB vendors, cloud, Hadoop Pipeline improvements

What’s New in SQL Server 2014 since SQL Server 2005

20 PERFORMANCE AND SCALE

HIGH AVAILABILITY

SECURITY

PROGRAMMABILITY

T-SQL enhancements

Data support

Programmability support

MANAGEABILITY

HYBRID CLOUD SOLUTIONS

EASY ON-RAMP TO THE CLOUD

COMPLETE AND CONSISTENT FROM ON-PREM TO CLOUD

ACCESS ANY DATA

INSIGHTS WITH FAMILIAR TOOLS

COMPLETE BI SOLUTION

Analysis services

Reporting services

Data quality services

Master data services

Integration services

Upgrade

Make the move

Target

Identify your destination(s)

Get started today—Upgrade to SQL Server 2014 2

Discover

Categorize applications and workloads  Read Forrester’s TEI of SQL Server 2012 & 2014  Run the MAP toolkit  SQL Server 2014  Azure VMs  Azure SQL database  Read the SQL Server 2014 Upgrade Guide  Consult the SQL Server 2014 Upgrade Advisor  Azure SQL Database Migration Wizard

3 1