1 / 33

How and when to use this presentation

Learn about Microsoft's perspective on the end of support for SQL Server 2008/R2 and how to overcome challenges with on-premises and cloud solutions. Use this opportunity to embrace digital transformation and modernize your data estate.

kimyoung
Download Presentation

How and when to use this presentation

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. How and when to use this presentation • This presentation is intended to provide a “Level 100” discussion of Microsoft’s perspective on the end of support for SQL Server 2008/R2. • This presentation can be used to set the stage for the Level 200 presentations that dig into the options customers have to overcome end of support challenges across on-premises and cloud. • Account Executive and SSP roles should feel comfortable with the depth of the content in this deck.

  2. Use end of support for SQL Server 2008/R2 as an opportunity to embrace digital transformation Speaker Name Title

  3. The world is changing Data Cloud AI

  4. Data Cloud AI Data will grow to 163ZB in 20251 Today, 80% of organizations adopt cloud-first strategies2 AI investment increased by300% in 20173 1IDC White Paper, Data Age 2025: The Evolution of Data to Life-Critical; 2Building Trust in a Cloudy Sky; 3A Trillian Dollar Boost: The Economic Impact of AI on Customer Relationship Management Organizations that harness data, the cloud, and AI out perform

  5. Modernization triggers ! Software and hardware refresh Security threats Capacity needs Compliance Integrate acquisitions Application innovation End of support Data Store Datacenter contracts expiry OS Hardware or Cloud

  6. Impact of end of support Deadline to act before end of support No security updates Extended Support ends July 9, 2019 SQL Server 2008 and 2008 R2 Compliance concerns Extended Support ends January 14, 2020 Windows Server 2008 and 2008 R2 Missed innovation opportunities 2018 2019 2020 Find lifecycle support deadlines at: support.microsoft.com/lifecycle

  7. Why should you care about the end of support and act now? Security & Compliance Risks Capacity to Innovate Unplanned Costs There will be no access to security updates, opening potential for data breaches and attacks Maintaining legacy systems can get expensive quickly with costly custom support plans New technologies help modernize data estate with Cloud & AI

  8. End of Support – What are the Options? Focus of Discussion Lift-and-shift to PaaS with Azure SQL Database Managed Instance (MI) • SQL DB MI is compatible with versions as far back as SQL Server 2005; no more future upgrades or patches required as SQL DB will always run on the latest feature as part of fully managed services Modernize to Azure SQL Server 2008/R2 end of support Move to IaaS with Azure SQL VM Upgrade to SQL Server 2017 on Azure VMs, or Move “as-is” with SQL Server and Windows Server 2008/R2 and get 3 years of Extended Security Updates* for free Modernize on premises SQL Upgrade on premises Upgrade to SQL Server 2017** (and Windows Server 2016) or stays “as-is” at 2008 and purchase Extended Security Updates * ESU worth 75% of license every year for the next three years after EOS

  9. Saving opportunity for modernizing your data estateis significant Platform (as a Service) On-premises Infrastructure (as a Service) Intelligent performance/security Applications Applications Applications Data Data Data High availability /DR/Backups High availability /DR/Backups High Availability/ DR/Backups On-premise coststends to be driven by hardware and data center management costs Infrastructure-as-a-Service reduces cost categories related to data center and compute Platform-as-a-Service off-loads customers’ most administrative tasks to Azure, further improving efficiency with machine-learning capabilities for performance and security • Managed Instance: instance-level deployment for lift-shift existing apps to Azure, fully backward compatible • Single database: database-level deployment for new apps Database Provision/ Patch/Scaling Database Provision/ Patch/Scaling Database Provision/ Patch/Scaling O/S O/S provision /patching O/S Virtualization Virtualization Virtualization Hardware Hardware Hardware Datacenter Management Datacenter Management Datacenter Management SQL Server 2017 Azure SQL VMs Azure SQL Database (Managed Instance, Single DB) Managed by customer Managed by Microsoft Machine-learning capability

  10. Azure is the most cost-effective cloud for SQL Server Azure Hybrid Benefit, an Azure-only benefit for customers with active SA or subscriptions on SQL Server cores Significantly reduce the costs of migrating to the cloud Pay only the ‘base rate’ in Azure on SQL Server on Azure VM (IaaS), Azure SQL Database (Paas), and ADF v2 SSIS Available for SQL Server core licenses only Customers can use on premises cores or cloud vCores AWS is 5x more expensive than Azure Azure vs. AWS homepage 5x substantiation page Cores can be used on-premises and in Azure simultaneously for up to 180 days, to allow for migration

  11. Azure SQL Database Managed Instance: Best for modernization at scale with low cost and effort SQL * SQL Database (including MI) uses database compatibility level to decouple the application from specific versions of SQL Server, thus enabling applications running on older versions of SQL Server to run on the latest DB engine. Read more on the FAQ of Database Compatibility

  12. WHY YOU SHOULD MOVE TO AZURE SQL DATABASE MANAGED INSTANCE

  13. Migrate to the cloud with Azure SQL Database Unparalleled security and performance of SQL in a fully managed environment Breakthrough productivity & performance Seamless and compatible Industry-leading security Built-in intelligence CompetitiveTCO Intelligent performance tuning and intelligent protection Layers of security and 99.99 percent availability SLA Up to 80% savings with Azure Hybrid Benefit and reserved capacity Up to 100 TB of on-demand scalable storage per DB The broadest SQL Server compatibility and VNET support The best and most economical cloud destination

  14. Azure SQL Database hosting options Azure SQL Database Single Elastic Pool Managed Instance Database-scoped deployment option with predictable workload performance Shared resource model optimized for greater efficiency of multi-tenant applications Instance-scoped deployment option with high compatibility with SQL Server and full PaaS benefits Best for apps that require resource guarantee at database level Best for SaaS apps with multiple databases that can share resources at database level, achieving better cost efficiency Best for modernization at scale with low friction and effort

  15. Azure SQL Database Managed Instance: the best option to run SQL workloads Save up to 58% compared to RDS Best TCO SQL parity Full parity based on 100% code consistency SQL support 99.99% SLA, supporting source version back to SQL 2005 SQL PaaS ++ Machine-Learning based performance and security on top of PaaS

  16. SQL Database Managed Instance offers the best financial value $9.34 Pricing comparisons on 8 core SQL Server EE & SE (MI w/AHB vs AWS RDS) 1-year Reserved Yearly for Highly Virtualized Environment On-Demand PAYG Hourly Cost on SQL DB MI = $27,744 Best TCO $5.44 42% saving SQL parity 4 sets 8 vCore at base rate w/ SA, each = $6,936 $2.67 SQL support 24% saving Cost on AWS RDS = $66,388 $2.02 SQL PaaS ++ 4 sets 8 vCore at License Included, each = $16,597 Azure SQL Database Business Critical AWS RDS SE Single-AZ (List) Azure SQL Database General Purpose AWS RDS EE Multi-AZ (List) 58% saving RDS customers running SQL Server 2008/R2 without access to Extended Security Updates will be out of compliance Note: On-Demand Prices for Azure SQL DB MI General Purpose and Business Critical 8-core Gen5 on US West 2. Compare to on-demand prices for AWS RDS US West (North California) db.m4.2 xLarge on SE and EE, under Single AZ and Multi-AZ. Reserved 1-year upfront cost for same set of machines, assuming customer is paying for Software Assurance for SQL Server. Pricing accessed on October12, 2018.

  17. SQL Database Managed Instance is a turn-key solution for SQL Server in the cloud AWS RDS Azure SQL Database Managed Instance Limited surface area** • No Linked Server, Transactional replication, SQL Server Audit, DB Mail, server level triggers, sysadmin permissions​ • Do not support Always-On for high availability • Backup PITR only at instance level vs. SQL DB goes into DB level • Do not support R/Python integration for machine-learning Full surface area, just like your on-prem SQL Server* On highest version while backward compatible, given everything is being engineered from the Cloud Lift and shift from on-prem with no application code change and minimum database changes* DMS migration tool enable minimum down-time, massive scale migration Best TCO SQL parity SQL support SQL PaaS ++ Pegged to specific versions as in on premises SQL Server *Note: SSIS is available in PaaS under Azure Data Factory V2; SSAS can be ported to AAS as PaaS; SSRS can stay on Azure VM as IaaS **See list of non-supported features on RDS

  18. SQL Database Managed Instance provides unmatched support AWS RDS Azure SQL Database Managed Instance Support migration source back to SQL Server 2005 (via Backups) Limited migration source and support Best TCO SQL parity Database Compatibility Level 100 and higher supported Migration source back to SQL Server 2008​ SQL support No more version upgrades as it runs on highest version and everything is being managed by Microsoft* Will still face End of Support and upgrade needs** SQL PaaS ++ SLA at 99.95% only with Multi-AZ deployment SLA at 99.99% for any services out of the box * See SQL Database Compatibility Level FAQ for details on how Azure SQL DB, including MI, is able to decouple from versions of on premises SQL Server and maintain application as-is. ** RDS customers running SQL Server 2008/R2 without access to Extended Security Updates will be out of compliance

  19. SQL Database Managed Instance brings ML-based performance & security AWS RDS Azure SQL Database Managed Instance Intelligent Advisor and ML-based, Intelligent Insights and recommendation based on root-cause analysis; Auto-tuning from massive DB insights and tailored to specific DB query Table Stake, light-wrapper PaaS only: No ​Advisor for RDS for SQL Server such as performance insights & recommendation*. Best TCO SQL parity Built-in HA with Always-on; active-active GEO replication, providing you the 99.99% SLA out of the box No built-in Always On for HA, customer needs to purchase Multi-AZ (2nd VM) to get the 99.95% SLA SQL support Advanced Threat Protection (ATP) enables data discovery & classification, vulnerability assessment, and advanced threat detection No ATP such as Threat Detection, Vulnerability Assessment, Information Classification SQL PaaS ++ See the summary on Forrester Total Economic Impact study showing 212% ROI and 40% DBA productivity improvement. Full gated report is here on Azure.com *Note: AWS Performance insights only available to Aurora and RDS PostgreSQL,/MySQL based on historical query snapshot only.

  20. WHY YOU SHOULD MOVE TO AZURE SQL SERVER VIRTUAL MACHINES

  21. SQL Server on Azure Virtual Machines Secure and compliant Seamless cloud migration Leading TCO Flexibility and control with automation • 100% SQL Server compatibility and only cloud with pre-configured Developer edition • Most compliant cloud • Easier to maintain than EC2 with automatic security patches and automatic backup • Save up to 43% vs. AWS EC2 with Azure Hybrid Benefit 3 2 4 5 1 Note: Savings vs. AWS based on 8-Core D13 v2 Azure VM in East US 2 region at CentOS/Ubuntu Linux rate (combining Azure Hybrid Benefit for SQL Server with Azure Hybrid Benefit for Windows Server); comparable AWS VM is r3.2xlarge in US East (N. Virginia) at Windows rate (with SQL Server License Mobility). Savings analysis excludes Software Assurance costs for SQL Server and Windows Server, which may vary based on EA or any applicable volume licensing agreement. Actual savings may vary based on region, instance size, and compute type. Publicly-available prices as of June 5, 2018, subject to change.

  22. SQL server on virtual machines Run your new SQL Server licenses in an Azure VM to get more value from your SQL Server investments Operating system choice – support for Windows Server, Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and Ubuntu Linux. Cloud flexibility – Set up and manage your SQL Server deployments in minutes, and then scale up or down on the fly. Tuned for performance – Meet your toughest demands with virtual machines optimized by the team that built SQL Server. Hybrid connectivity – Get the most out of your on-premises investments, and take advantage of all that Azure offers. Highly-secured and trusted – Protect your entire data estate with a highly-secured database on the most compliant cloud.

  23. Azure SQL VM: free extended security updates for end of support customers Save 5x compared to AWS EC2 ** Best TCO Configuration Pre-configurated Developer edition, configurable cloud backup Support Free extended support for SQL Server 2008/R2* Security Ease of maintenance with automatic application of security patches * ESU worth 75% of license every year for the next three years after EOS; ** Applicable to Azure Marketplace images, customers using customer SQL Server 2008/R2 custom images can download the ESU for free and manually apply.

  24. SQL VM on Azure offers great financial value Pricing comparison (on-prem, SQL VM w/AHUB on Reserved Instance, AWS EC2* w/ paid ESU on Reserved Instance) Best TCO Configuration Support Security * AWS EC2 does allow licensing mobility for customers to save on SQL IP. Note: Price comparison dated 09/10/2018 based on: Standard 3-Year Reserved Instance EC2 pricing on 8-core M4.2xlarge on US West (North California) vs. Azure SQL Dv8 VM on US west

  25. Tools and services for your migration journey On-premises Microsoft Azure Assessment (SSMA & DMA) Azure Database Migration Service

  26. Azure Database Migration ServiceAccelerate your transition to Azure Homogeneous sources Heterogeneous sources Orchestration Scale migration Near-zero downtime A seamless, end-to-end solution for moving on-premises databases to Azure

  27. WHY YOU SHOULD UPGRADE TO SQL SERVER 2017 & 2019

  28. What’s New in SQL Server 2017 Since SQL Server 2008 & 2008 R2 OLTP Performance Security Business Intelligence Hybrid Cloud Data-tier application component project FileTablebuild on FILESTREAM Remote Blob Storage with SharePoint 2016 Statistical Semantic Search Contained Database Authentication Automatic Plan Correction Enhanced productivity and performance Power View Configurable reporting alerts Reporting as SharePoint Shared Service Master Data Services Add-in for Excel Extensible object model Disaster Recovery environment in Azure VMs using Always On Availability groups Stretch database Hybrid scenarios with SSIS Enhanced backup to Azure Easy migration to the cloud Secure backups to Azure with managed backups Enhanced connectors, new transformations, object-level security, ragged hierarchies** Mobile BI Enterprise-grade Analysis Services In-Memory analytics with Analysis Services Tabular Model Enhanced multidimensional models Modernized Reports and Dashboard with support for Mobile BI Create mobile reports using the SQL Server Mobile Report Publisher Consume with Power BI mobile apps HA for StreamInsight, complex event processing Import PowerPivot models into Analysis Services Advanced tabular mode Hybrid Transactional and Analytical Processing with real-time insights using In-Memory OLTP and Clustered Columnstore In-Memory Data Warehouse with Clustered Columnstore Indexes Unparalleled scalability with Windows Server 2016, with 24TB memory and Windows Server 2016 max cores Enhanced Always On Availability Groups with easy GUI-based Wizard Automatic failover between three synchronous replicas. Up to eight secondary replicas Buffer Pool Extension to SSDs Adaptive Query Processing Resource Governor with CPU, Memory and IO Governance Delayed Durability of Memory-Optimized Tables Query optimization enhancements Query Store Local DB runtime (Express) Always Encrypted Dynamic Data Masking Row-Level Security Auditing CC certification at EAL2 level for SQL Server 2016 Backup encryption support Enhanced separation of duties Default schema for groups Programmability Enhancements Data Warehousing& Big Data Advanced Analytics Platform JSON support Spatial features, Full Globe and arcs Support for Temporal Tables Graph data support Machine Learning Services with built-in support for Python and R Operationalize Machine Learning algorithms with In-Database Machine Learning support RRE APIs with full parallelism and no memory limits for scale/performance Built-in In-memory Advanced Analytics Advanced data mining Support for Linux (RHEL, Suse, Ubuntu) Support for Docker containers and Kubernetes Operational analytics Enhanced In-Memory DW with Clustered Columnstore Big Data integration with Hadoop and Azure Blob Storage Big Data Queries with T-SQL Enhanced database caching Direct Query Enterprise Information Management (EIM) Enhanced Integration Services Data Quality Services Master Data Services Extensible object model

  29. Coming soon: SQL Server 2019 Industry-leading performance and security, with intelligence over all your data Intelligence over any data Choice of platform and language Industry-leading performance  Most secure over the last 8 years5 Insights in minutes and rich reports + PHP Node.js C#/VB.NET T-SQL Java C/C++ Python Ruby #1 OLTP performance1 #1 DW performance on 1TB2, 10TB3, and 30TB4 Intelligent Query Processing AI and Machine Learning over all data with the power of SQL and Apache Spark The best of Power BI andSQL Server Reporting Services with Power BI Report Server In-memory across all workloads Most consistent data platform 1/10th the cost of Oracle Private cloud Public cloud All TPC Claims as of 1/19/2018. 1 http://www.tpc.org/4081; 2 http://www.tpc.org/3331; 3 http://www.tpc.org/3326; 4 http://www.tpc.org/3321; 5 National Institute of Standards and Technology Comprehensive Vulnerability Database

  30. Utilize Microsoft migration tools for your on-premises upgrade to SQL Server Data Migration Assistant (DMA) enables you to upgrade by detecting compatibility issues that can impact database functionality in your new version of SQL Server and Azure SQL Database. Database Experimentation Assistant (DEA) is a new A/B testing solution for SQL Server upgrades. It will assist in evaluating a targeted version of SQL for a given workload. Customers who are upgrading from previous SQL Server versions (SQL Server 2005 and above) to any new version of the SQL Server will be able to use these analysis metrics. Database Experimentation Assistant (DEA) Data Migration Assistant (DMA) SQL SQL SQL 2008On-premises SQL 2017On-premises

  31. Start your migration journey today Assess Inventory your environment, determine optimal migration path Migrate Move your legacy SQL Server to Azure or upgrade to the latest version Optimize Fine-tune your resources to optimize costs and strengthen security Get detailed guidance with the Database Migration Guide Find a Migration Partner Visit the Microsoft Data Migration Blog Inventory your environment with MAP Toolkit Innovate faster with SQL Server 2017 Lift and shift your SQL Server to Azure SQL Database Learn more about SQL Server on Azure Virtual Machines Compare costs with the TCO calculator Save with Azure Hybrid Benefit Learn about SQL Server and GDPR Manage costs in Azure

  32. End of support: know your options End of support means security updates are no longer provided. We have options to upgrade across cloud and on-premises. For more information, visit www.microsoft.com/lifecycle. 2008 and 2008 2008 and 2008 R2 R2 Extended support ends Recommended action Fallback option Last resort option

More Related