1 / 43

SQL Server 2008 & 2008 R2 End of support

Learn about the upcoming end of support for SQL Server 2008 & 2008 R2, the risks of not upgrading, and the impact on security, compliance, and maintenance costs. Discover how extended security updates can help you meet regulatory standards and improve cost efficiency. Upgrade now to the modern DB platform and ensure mission-critical performance, self-service BI, and cloud readiness.

evansg
Download Presentation

SQL Server 2008 & 2008 R2 End of support

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. SQL Server 2008 & 2008 R2End of support Speaker Name Title

  2. When will end of support happen? SQL Server 2008 and 2008 R2 will no longer be supported starting on July 9, 2019. Learn more about the SQL Server support lifecycle: support.microsoft.com/lifecycle/

  3. What does end of support mean for SQL Server 2008 & 2008 R2? No security updates Higher maintenance costs Compliance concerns There will be no access to critical security updates, opening the potential for business interruptions As support ends, your organization may fail to meet to meet compliance standards and industry regulations • Maintaining legacy servers, firewalls, intrusion systems, etc. gets expensive quickly

  4. Security At the end of support for SQL Server 2008 and SQL Server 2008 R2, there will be no more security updates and hotfixes from Microsoft, opening the door to potential business interruptions. Don’t take the risk of losing precious data or having issues with your business applications performance because of potential weaknesses of your environment by not upgrading! • Without security updates you may fail to comply with standards and regulations that can seriously hamper your ability to: • Protect against hackers, malware with root access to machines, man in the middle scenarios, and government subpoenas • Securely purge for customer data, leaving it vulnerable to access by outside parties • Utilize E2E data protection across SQL Server and frequently used together services

  5. Compliance At the end of support for SQL Server 2008 and 2008 R2, your system may cease to be compliant with regulatory standards. Failure to be compliant can lead to business complications, penalties and fines across several industries. • Regulatory compliance standards may no longer be met at end of support, such as: • PCI-DSS for credit card transactions • HIPAA for medical patient privacy • GLBA for financial institutions • GDPR for companies who do business in the EU

  6. GDPR enforcement begins May 25, 2018 What is the GDPR? General Data Protection Regulation (GDPR) is a comprehensive new privacy law that gives citizens of the European Union (EU) greater control over their “personal data” (which is precisely defined by the GDPR) and requires organizations to maintain appropriate security of personal data. Failure to comply with the GDPR could result in significant penalties. How much can companies be fined for noncompliance? Companies can be fined up to €20m or 4% of annual global turnover, whichever is greater, for failure to meet certain GDPR requirements. When will the GDPR come into effect? The European Parliament approved and adopted the GDPR in April 2016 and enforcement will begin May 25, 2018 GDPR is multinational! When it comes to GDPR compliance, it’s not just European organizations affected, those outside of the EU who process data in connection with the offering of goods and services to, or monitoring the behavior of, EU residents. At the end of support for SQL Server 2008 and 2008 R2, your systems may no longer be compliant with upcoming GDPR regulations. GDPR non-compliance can result in fines for organizations who do not adequately protect consumer data. Download the GDPR e-book

  7. MICROSOFT SQL BASED TECHNOLOGY supports GDPR Security compliance Discover: identify what personal data you have and where it resides Protect: establish security controls to prevent, detect, and respond to vulnerabilities and data breaches Control: manage how personal data is used and accessed. Report: action data subjects requests and keep required documentation

  8. Cost efficiency Benefits of SQL Server Extended Security Updates: Offers flexibility as you move to the cloud Minimizes disruptions to your environment Helps you meet regulatory compliance Helps makes your environment more secure Enables you to proactively plan for end of product support At the end of support for SQL Server 2008 and 2008 R2, your maintenance costs may increase as your IT staff maintains your aging hardware, keeps intrusion and firewalls up to date, and handles network segmentation. Add three more years of product support beyond the end of Extended Support with SQL Server Extended Security Updates Windows Server Extended Security Updates and SQL Server Extended Security Updates support period for 2008/R2 versions

  9. WHY YOU SHOULD UPGRADE TO SQL SERVER

  10. The evolution of SQL Server Modern DB platform Mission critical Performance and productivity Self-service BI Cloud-ready Mission critical and cloud performance Docker & Linux SQL Server 2000 XML ● KPIs SQL Server 2005 Management studio ● Mirroring SQL Server 2008 Compression ● Policy-based mgmt. ● Programmability SQL Server 2008 R2 PowerPivot (In-Memory) ● SharePoint integration ● Master data services SQL Server 2012 AlwaysOn ● In-Memory ColumnStore ● Data quality services ● Power View ● Cloud SQL Server 2014 In-memory across workloads ● Performance & scale ● Hybrid cloud optimized ● HDInsight service ● Cloud BI SQL Server 2016 & 2017 Industry leading performance ● End-to-end mobile BI ● AI built-in ● Choice of language & platform ● Easy migration to the cloud

  11. The Evolution of SQL Server Increased performance and functionality – release over release SQL Server 2016 & 2017 • Build modern applications using the language of your choice, on-premises and in the cloud, now on Windows, Linux and Docker containers. Take advantage of breakthrough scalability, performance, and availability for mission-critical, intelligent applications and data warehouses. • Least vulnerable database over the last seven years • Real-time analytics at up to 1M prediction/second • Turn raw data into meaningful reports that can be delivered to any device – at one-fourth the cost of other self-service solutions. SQL Server 2014 • Build mission-critical apps using high-performance, in-memory technology across OLTP, data warehousing, BI and analytics workloads without having to buy expensive add-ons or high-end appliances. • 10 - 30x faster transactions • 100x query performance gains • Enhanced security and scalability • Hybrid backup and disaster recovery • According to Forrester, the payback period for SQL Server 2014 is only 9.5 months. • ForresterTEI Study 2014 SQL Server 2012 • 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“ • ForresterTEI Study 2012 SQL Server 2008 R2 • Comprehensive, integrated data management & business intelligence with award-winning analytics. • PowerPivot: Named one of eWeek’s Top 10 Technologies of 2010 • eWeek SQL Server 2008 • 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%.” • ForresterTEI Study 2008 SQL Server 2005 • Solid offering for departmental IT & enhanced enterprise data platform. • “Microsoft has made considerable strides in automating SQL Servers management tasks & improving performance tuning & uptime” • eWeek2005 • 2005 • 2017 ¹Total Economic Impact™ Of Microsoft SQL Server, July 2014

  12. more than an upgrade withSQL server 2017 With SQL Server 2017, your business doesn’t just receive an updated database. SQL Server 2017 is the industry leading data platform that provides built-in security, enhanced performance, and analytics to modernize your business. Now available also on Linux, SQL Server 2017 is the first commercial database with AI built-in and out-of-the-box. Transform your enterprise applications with a complete and robust mission critical data platform by upgrading your current SQL Server to SQL Server 2017. SQL #1 OLTP performance¹ #1 DW performance¹ #1 price/performance¹

  13. Azure SQL Database The best and most economical cloud destination for your SQL Server apps Built-in intelligence Breakthrough productivity and performance Seamless and compatible Competitive TCO Realize up to a 406% ROI over on-premises and hosted solutions

  14. Introducing Azure SQL Database Managed Instance Managed Instance Instance scoped programming model with high compatibility to on-premises databases Single Standalone managed database best for predictable and stable workloads Elastic pool Shared resource model best for greater efficiency through multi-tenancy Best for modernization at scale with low cost and effort

  15. 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

  16. SQL based technologies support yourGDPR security needs Track personal data Access Management Encryption everywhere Intelligent Monitoring and Auditing Consistent programmability experience Easily query databases to uncover personal data Tag data with sensitivity labels using Extended Properties Securely authenticate to your database and apply granular authorization policies Restrict access to users using Dynamic Data Masking andRow-Level Security Encrypt data whether at rest, in transit or in client applications Track and log database events to identify potential threats or security violations Use continuously learning algorithms to identify unusual or suspicious activity Track and report on all database activities with granularly configurable auditing Developers and application partners can build to a single programming surface Scale across SQL editions and the cloud SQL Server 2017 features Since SQL Server 2016 SP1 Auditing for SQL Database and SQL Server audit Temporal tables • SQL Database Threat Detection Dynamic Data Masking (DDM) Row-Level Security (RLS) Windows Server authentication SQL Query Language Transparent Data Encryption Always Encrypted

  17. The MODERN DATA Estate HYBRID On-premises Private cloud Cloud Operational databases Operational databases Data warehouses Data warehouses Data lakes Data lakes Reason over any data, anywhere Flexibility of choice Security and performance

  18. The modern data estate Microsoft’s on-premises solution SQL Server 1/10th the cost of Oracle¹ Industry leader 4 years in a row  Operational databases #1 TPC-H performance Data warehouses T-SQL query over any data Data lakes Reason over any data, anywhere Flexibility of choice Security and Performance Only commercial DB with AI built-in Any language, any platform, anywhere Most secure over last 7 years R MULTI JAVA 1Figure taken from public pricing information. SQL Server

  19. 1/10th the cost of Oracle¹ SQL Server 2017 Industry-leading performance and security NOW ON LINUX and DOCKER Only commercial DB with AI built-in Choice of platform and language Most secure over the last 7 years End-to-end mobile BI on any device Industry-leading performance  R $2,230 1/10 Self-service BI per user PHP Node.js Python Ruby T-SQL Java C/C++ C#/VB.NET R and Python + in-memory at massive scale Native T-SQL scoring #1 OLTP performance #1 DW performance #1 price/performance $480 $120 A fraction of the cost Microsoft Tableau Oracle In-memory across all workloads Most consistent data platform Private cloud Public cloud 1Figure taken from public pricing information.

  20. Maximize your investments through multiple SQL Server Editions SQL Server Enterprise Edition Access mission-critical capabilities to achieve unparalleled scale, security, high availability, and leading performance for your Tier 1 database, business intelligence, and advanced analytics workloads. SQL Server Enterprise Edition customers can choose between Business Critical and General Purpose core conversation ratios Applies to server and client access license (CAL) customers General purpose Business critical SQL Server Standard Edition Find rich programming capabilities, security innovations, and fast performance for mid-tier applications and data marts. Easily upgrade to the Enterprise edition without having to change any code. General purpose

  21. The modern data estate Microsoft’s cloud solution SQL Server VM 1/10th the cost of Oracle 70% faster than competition Operational databases Azure SQL Database 2x the global reach Data warehouses SQL Azure SQL Data Warehouse 99.9% SLA  Data lakes Azure Data Lake, HDInsight Reason over any data, anywhere Flexibility of choice Security and Performance SQL All built-in Any language, any platform, anywhere • More certifications than any other cloud R JAVA SQL Server

  22. SQL server on virtual machines Run your new SQL Server 2017 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 database The best and most economical cloud destination for your SQL Server apps Built-in intelligence Breakthrough productivity and performance Seamless and compatible Competitive TCO Realize up to a 406%¹ ROI over on-premises and hosted solutions 1The Business Value of Microsoft Azure SQL Database Services, IDC, March 2015

  24. Modernize customers on their terms Transform with Azure On-premises Rehost Migrate 2008 and 2008 R2 workloads to Azure VM or Azure SQL Database MI Refactor, Rearchitect, or Rebuild Innovate with Windows Server containersand Azure SQL Database MI Upgrade Upgrade to Windows Server 2016 or SQL Server 2017 and get cloud and DevOps ready Free extended security updates Save more with Azure Hybrid Benefit Buy extended security updates

  25. New EOS offer: Extended Security Updates Migrate to Azure Upgrade on-premises Migrate apps and data to Azure VMs • Get free Extended Security Updates for Windows Server and SQL Server 2008 and 2008 R2 VM’s for three years after end of support deadline Migrate data to Azure SQL DB Managed Instances • Azure SQL Database Managed Instance offers a version-free option Save with Azure Hybrid Benefit • Use existing on-premises licenses to save up to 55% on Azure • Upgrade in Azure when ready, or transform with Azure services Upgrade to latest version • Windows Server 2016 or 2019 • SQL Server 2017 Can’t meet the deadline? Protect server workloads • Buy Extended Security Updates to get 3 more years of security updates for Windows Server and SQL Server 2008 or 2008 R2 • Upgrade when ready OR

  26. Paths to Upgrade YOUR SQL SERVER Flexibility to upgrade and modernize your data platform with SQL Server 2008 or 2008 R2 without support, SQL Server 2016 & 2017 on-premises, on virtual machine, or in the cloud SQL Server 2016 or 2017 Azure SQLDatabase SQL Server on Azure VMs SQL Server 2008 or 2008 R2 with Extended Security Updates SQL SQL SQL SQL 2016 2017

  27. Utilize Microsoft migration tools for your on-premises upgrade to SQL Server 2017 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

  28. speed up your cloud migration journey with the Database Migration Guide IaaS PaaS The Database Migration Guide creates a custom report on how to migrate your source data to the destination of your choice: on-premises, cloud, private cloud, IaaS or PaaS Utilize Azure Database Migration Service (Azure DMS) or Azure Migrate to complete your migration Azure DMS is designed as a seamless, end-to-end solution for moving on-premises SQL Server databases to the cloud Azure Migrate is designed for migrating your on-premises VMs to Azure Azure Database Migration Service (Azure DMS) Azure Migrate On-premises

  29. SQL SERVER momentum 2,000,000+ Docker pulls “It was incredibly easy to set up and move SQL Server from Windows to Linux” Dean ChenVP of Engineering, dv01 “One of the easiest migration experiences that we've had” Chris AmarisCTO, Convergent Computing “It guarantees compatibility with more target customers” Ron Dunn Lead Developer, Ajilius

  30. SQL Server customer SUCCESS Customers who are utilizing the power of SQL Server 2017

  31. DELIVERING INSIGHTS FOR INVESTORS 15X FASTERReal-time analytics with SQL Server on Linux Challenge • FinTech company’s loan intelligence platform experienced performance slowdowns with PostgreSQL • Slow query speeds and time-consuming maintenance Impact • Query times cut from 30 to <2 seconds with SQL Server • Management time reduced 90% • Simplified dev operations with Linux “The biggest benefit for us was that we were able to switch SQL Server to Linux and not have degradation in other areas.” Devon Hinton, Software Engineer, dv01

  32. Humantech moves to SQL Server 2017 on Linux to reduce costs and boost efficiency Scenario • Humantech is one of the world’s largest providers of ergonomics consulting and software services. The company decided to standardize its IT environment on one operating system in order to promote its continued growth and success. However, Humantech wanted to keep its preferred Windows database, Microsoft SQL Server, because of the solution’s reliable performance and familiar technology. Solution • To satisfy both needs, the company upgraded from SQL Server 2008 to SQL Server 2017 on Linux. Now, Humantech saves on IT maintenance and has an updated database that offers fast operation and strong security. • “During the restore process, you simply upgrade the SQL Server 2017 database along the way. As a result, it was easy to deploy and gave us confidence in the evaluation.” • - Ken Lupo, Director of Technology at Humantech • “We did not want to go for a walk on the wild side. Our goal was to ensure that our solutions would be as durable, off-the-shelf, and minimally customized as possible, which is why we sought to go with a flexible database that we already knew so well.” • - Jim Good, President of Humantech

  33. Customer resources formigration & updating 100%

  34. Start your MIGRATION journey today DiscoverIdentify your databases to upgrade 1 TargetExplore options to unlock your app potential with Cloud and AI AssessLearn your data maturity 3 2 Migrate Make the move 4 Run the MAP toolkit Innovate faster with SQL Server 2017 and Azure Data Service Take the Data Maturity Assessment Use the Database Migration Guide to obtain Technical and Business guidance

  35. Modernize your apps with Data Accelerator Cloud On-Premise Migrate Azure SQL Database Managed Instance Azure Database for MySQL Azure Database for PostgreSQL SQL Server 2017 Azure SQL Database Qualify for Data Accelerator and begin your journey to the Cloud aka.ms/dataaccelerator Benefits: Leverage our efficient upgrade service to modernize your application Augment your app with intelligent features Access upgrade and migration tools and benefit from subject matter experts advice Requirements: You are ready to proceed with upgrade or migration process within 3 months or less You have available resources to support the upgrade or migration

  36. SQL SERVER 2017 EDITIONS Enterprise Common programming surface area - develop once and scale across editions • MISSION CRITICAL IN-MEMORY PERFORMANCE AND SCALE, SECURITY AND HIGH AVAILABILITY • Mission critical high availability onWindows and Linux • Enhanced in-memory performance • Faster performance with Adaptive Query Processing • Unparalleled data security • PB scale data warehousing • End-to-end mobile BI with rich visualizations on all major platforms • In-database advanced analytics built-in at scale with R and Python • Enhanced hybrid scenarios includingStretch Database, HA, DR and backup • Software Assurance benefits include unlimited virtualization, Machine Learning Server for Hadoop, and Power BI Report Server Standard • FULLY FEATURED DATABASE FOR MID-TIER APPLICATIONS AND DATA MARTS • End-to-end database security with Always Encrypted • Enhanced in-memory performance for all workloads • Basic reporting • Basic analytics • Hybrid scenarios: Stretch Database, backup Express • SMALL-SCALE APPLICATIONS • Development and management tools • Easy backup and restore to Microsoft Azure • Free to use Developer DEVELOPMENT AND TESTING  Build, test, and demo apps in non-production environments  Free to use  All Enterprise Edition features available

  37. Features in blue are newly available. *In-memory OLTP subject to memory limits in Standard Edition **Available for Windows Server only

  38. WHAT’S NEW IN SQL SERVER 2017 SINCE 2005 OLTP Performance Security Data Warehousing Business Intelligence Advanced Analytics Hybrid Cloud Stretch database Partitioning for efficient data loading Hybrid scenarios with SSIS Enhanced backup to Azure Easy migration to the cloud Simplified cloud DR with AlwaysOn replicas Simplified backup to Azure Support for backup of previous versions of SQL Server to Azure Cloud back-up encryption support Simplified cloud Disaster Recovery with AlwaysOn replicas in Azure VMs New Azure Deployment UI for SQL Server Larger SQL Server VMs and memory sizes available in Azure License Mobility with Software Assurance Real-time operational analytics with in-memory OLTP or on disk In-memory for more applications Unparalleled scalability with Windows Server 2017, with 12TB memory and Windows Server 2016 max cores Enhanced AlwaysOn, with 8 secondaries and Replica Wizard Multiple node failover clustering (3 synchronous, up to 8 replicas) In memory OLTP Buffer Pool Extension to SSDs Enhanced query processing Resource Governor adds IO governance SysPrep as cluster level Predictable performance with tiering of compute, network and story with Windows Server 2012 R2 Delayed Durability Clustered Shared Volume support, VHDX support (Windows Server 2012 R2) Query optimization enhancements Query Store Temporal support Transparent Data Encryption Always Encrypted Row-level security Dynamic data masking Enhanced separation of duties CC certification at High Assurance Level for 2017 Backup encryption support Adaptive Query Processing Operational analytics In-memory ColumnStore Deployment rights for APS Enhanced In-memory ColumnStore for DW PolyBase for simple T-SQL to query structured and unstructured data Enhanced database caching Up to 15,000 partitions Analytics Platform System Enhanced connectors, new transformations, object-level security, ragged hierarchies** Graph data support Mobile BI Enhanced SSIS Enterprise-grade Analysis Services Advanced tabular models Enhanced multidimensional models JSON support Enhanced DQS, enhanced MDS Enhanced Reporting Services Temporal tables In-memory analytics Advanced data mining Create mobile reports using the SQL Server Mobile Report Publisher Consume with Power BI mobile apps on all major platforms Azure HDInsight Service Pin report items to Power BI Power Map for Excel Mobile BI interfaces for Power BI Power BI in Office 365 Microsoft Visual Studio dev tools Python integration** R built-in to your T-SQL RRE APIs with full parallelism and no memory limits for scale/performance Built-in In-memory Advanced Analytics Advanced tabular model Direct query Advanced data mining Platform Linux support Container support **Available for Windows Server only.

  39. WHAT’S NEW IN SQL SERVER 2017 SINCE 2012 OLTP Performance Security Data Warehousing Business Intelligence Advanced Analytics Hybrid Cloud Stretch database Partitioning for efficient data loading Hybrid scenarios with SSIS Enhanced backup to Azure Easy migration to the cloud Simplified cloud DR with AlwaysOn replicas Simplified backup to Azure Support for backup of previous versions of SQL Server to Azure Cloud back-up encryption support Simplified cloud Disaster Recovery with AlwaysOn replicas in Azure VMs New Azure Deployment UI for SQL Server Larger SQL Server VMs and memory sizes available in Azure Real-time operational analytics with in-memory OLTP or on disk In-memory for more applications Unparalleled scalability with Windows Server 2016, with 12TB memory and Windows Server 2016 max cores Enhanced AlwaysOn, with 8 secondaries and Replica Wizard Multiple node failover clustering (3 synchronous, up to 8 replicas) In memory OLTP Buffer Pool Extension to SSDs Enhanced query processing Resource Governor adds IO governance SysPrep as cluster level Predictable performance with tiering of compute, network and story with Windows Server 2012 R2 Delayed Durability Clustered Shared Volume support, VHDX support (Windows Server 2012 R2) Manage on-premises and cloud apps (System Center 2012 R2) Query optimization enhancements Query Store Temporal support Automatic Plan Correction Transparent Data Encryption Always Encrypted Row-level security Dynamic data masking Enhanced separation of duties CC certification at High Assurance Level for 2014 Backup encryption support Adaptive Query Processing Operational analytics In-memory ColumnStore Deployment rights for APS Enhanced In-memory ColumnStore for DW PolyBase for simple T-SQL to query structured and unstructured data Enhanced database caching Up to 15,000 partitions Analytics Platform System Enhanced connectors, new transformations, object-level security, ragged hierarchies** Graph data support Mobile BI Enhanced SSIS Enterprise-grade Analysis Services Advanced tabular models Enhanced multidimensional models JSON support Enhanced DQS, enhanced MDS Enhanced Reporting Services Temporal tables In-memory analytics Advanced data mining Create mobile reports using the SQL Server Mobile Report Publisher Consume with Power BI mobile apps on all major platforms Azure HDInsight Service Pin report items to Power BI Power Map for Excel Mobile BI interfaces for Power BI Python integration** R built-in to your T-SQL RRE APIs with full parallelism and no memory limits for scale/performance Built-in In-memory Advanced Analytics Advanced tabular model Direct query Advanced data mining Platform Linux support Container support **Available for Windows Server only.

  40. WHAT’S NEW IN SQL SERVER 2017 SINCE 2014 OLTP Performance Security Data Warehousing Business Intelligence Advanced Analytics Hybrid Cloud Stretch database Partitioning for efficient data loading Hybrid scenarios with SSIS Enhanced backup to Azure Easy migration to the cloud Simplified cloud DR with AlwaysOn replicas Real-time operational analytics with in-memory OLTP or on disk In-memory for more applications Unparalleled scalability with Windows Server 2016, with 12TB memory and Windows Server 2016 max cores Multiple node failover clustering (3 synchronous, up to 8 replicas) SQL Server Development Tools in Visual Studio Query Store Temporal support Automatic Plan Correction Transparent Data Encryption Always Encrypted Row-level security Dynamic data masking Adaptive Query Processing Operational analytics In-memory ColumnStore Deployment rights for APS Enhanced In-memory ColumnStore for DW PolyBase for simple T-SQL to query structured and unstructured data Enhanced database caching Up to 15,000 partitions Enhanced connectors, new transformations, object-level security, ragged hierarchies** Graph data support Mobile BI Enhanced SSIS Enterprise-grade Analysis Services Advanced tabular models JSON support, enhanced DQS Enhanced MDS Enhanced Reporting Services Temporal tables In-memory analytics Advanced data mining Access to reports online or offline Create mobile reports using the SQL Server Mobile Report Publisher Consume with Power BImobile apps Python integration** R built-in to your T-SQL RRE APIs with full parallelism and no memory limits for scale/performance Built-in In-memory Advanced Analytics Advanced tabular model Direct query Advanced data mining Platform Linux support Container support **Available for Windows Server only.

  41. SQL PaaS cost comparison vs. AWS RDS 46% savings vs. AWS $10.0/hr Azure SQL DB Managed Instance General Purpose is 33% cheaper than AWS RDS SE (Single-AZ) at list prices Azure SQL DB Managed Instance Business Critical is 46% cheaper than AWS RDS EE (Multi-AZ) at list prices $5.44/hr 33% savings vs. AWS $3.02/hr $2.02/hr AWS RDS SE Single-AZ (List) Azure SQL DB General Purpose AWS RDS EE Multi-AZ (List) Azure SQL DB Business Critical Note: On-Demand Prices for a Managed Instance price. Pricing accessed on October 2, 2017. US East 2. Comparable AWS RDS is db.r3.2xlarge. AWS Prices based on US East (Virginia).

  42. SQL IaaS cost comparison vs. AWS 19% savings vs. AWS Azure will always be cheaper for SQL on IaaS for customers with Software Assurance on Windows Server and SQL Server These customers can combine both the hybrid use benefit for SQL and Windows for best savings $2.379/hr $1.932/hr 32% savings vs. AWS $1.393/hr $0.946/hr Standard Edition on AWS EC2 (SQL License Mobility) Standard Edition on Azure (Hybrid Use Benefit Pricing) Enterprise Edition on AWS EC2 (SQL License Mobility) Enterprise Edition on Azure(Hybrid Use Benefit Pricing) Note: On-Demand Prices for a D13 v2 VM. Pricing accessed on October 2, 2017. US East 2. Comparable AWS VM is r3.2xlarge. AWS Prices based on US East (Virginia). Savings analysis assumes that customer is paying software assurance on SQL Server. Does not include SA for Windows Server as those costs are fairly negligible - $164 per 2-core license for WS DC, and $23 for Standard (OLP, NL).

More Related