Data Modernization with Azure February 2019 Your trusted

Data Modernization with Azure February 2019

Your trusted technology partner for data estate modernization 25+ years Innovation Seamless Migration Competitive TCO Industry leading performance and security*, with unmatched cloud scale Full parity with SQL Server for easy lift-and-shift Migration tools Save up to 88%** vs. AWS with Azure Hybrid Benefit * All Claims as of 2/20/2019. http: //www. tpc. org/4081; http: //www. tpc. org/3331; http: //www. tpc. org/3329; http: //www. tpc. org/3321; National Institute of Standards and Technology Comprehensive Vulnerability Database ** Programmatic Support Free migration tools, POC/ trials with financial aid and engineering support

25+ Years of continued innovation on SQL engine SQL Server 2008 R 2 SQL Server 2014 SQL Server 2016 SQL Server 2017 SQL Server 2019

Azure Data: common services for all data engines on intelligent perf, security, hyperscale with built-in HA Azure SQL Database Azure SQL Data Warehouse Azure Database for Postgre. SQL Azure Database for My. SQL Azure Database for Maria. DB Database Services Platform Intelligent Advisors, tuning, monitoring Flexible Independent scaling of compute & storage, resource governance GEO Replication Azure compute Azure storage Globally Available in 54 Regions Trusted HA/DR, backup/restore, security, audit, isolation

Azure SQL Database Managed Instance The best destination for SQL workloads in the cloud Focus of Conversation SQL Move to Paa. S with Azure SQL Database Managed Instance (MI) Lift-and-shift to MI for fully managed services that always runs on evergreen features, i. e. the end of End of Support Modernize to Azure Upgrade to SQL Server 2017 on Azure VMs, or SQL Server on premises Move to Iaa. S with Azure SQL VM Modernize on premises Upgrade on premises Move “as-is” with SQL Server and Windows Server 2008/R 2 and get 3 years of Extended Security Updates* for free Upgrade to SQL Server 2017/2019 (and Windows Server 2016) * ESU worth 75% of license every year for the next three years after EOS

Migration simplified with free tools SQL Server to Azure SQL DB MI On-premises SQL Cloud My SQL Server 2005 - 2017 Lift-and-shift with no application code change needed Azure Internet VPN or Express Route • Database Migration Assistant (DMA) on schema migration • Database Migration Services (DMS) for massive cloud migration at near zero downtime, online and offline • Free DMS offline; free online up to 6 months with 4 v. Cores My Azure DMS Assessment tools SQL SSMA & DMA https: //datamigration. microsoft. com/

Three financial options for modernizing to Azure SQL Server Modernize to Azure SQL Database or Azure SQL Virtual Machines Recommended Option A Option B Option C Use Software Assurance (SA) for Azure Hybrid Benefits (AHB) Server subscription for CSP customers (No SA required) License included (pay-as-you-go) for customers without SA • Use on-premise cores for v. Cores in Azure; • SQL Software Subscriptions give customers the same benefits as Software Assurance Up to 4 v. Cores per 1 Enterprise Edition core • All Option A benefits apply • Dual use rights up to 180 days • • One-click experience enabling AHB in billing Flexibility to try out Azure SQL without heavy upfront commitment • SQL Save up to 88% vs. AWS RDS* • Pay for what you use • Azure Iaa. S customers (without SA) running on SQL Server 2008/R 2 will qualify for free Extended Security Update up to three years SQL Save up to 46% vs. AWS RDS* Save up to 43% vs. AWS EC 2*

Comprehensive program support for customer modernization to Azure Presale activities Po. C and Trials Migration Tools • • • Broadest set of migration program: support both like-to-like and heterogeneous migrations Direct Engineering support: target architecture, POC execution, migration project quality control Funding on Po. C, extended free trial and Azure credits for any deal size with justified ROI or impact

The Total Economic Impact of Azure SQL Database Managed Instance Microsoft commissioned Forrester Consulting to conduct a Total Economic Impact™ study to examine potential cost savings and business benefits enterprises would achieve from migrating on-premises workloads to Azure SQL Database Managed Instance. Key report benefits and findings 3 years after initial investment & migration to Azure SQL Database Managed Instance $1. 8 M Savings from avoided hardware, network, storage and ongoing maintenance costs 6 months or less Payback post migration 40% Improvement in productivity for in -house DBAs 20% Increase in productivity for IT teams “ “ 212% Total ROI Total Economic Impact™ of Azure SQL Database Managed Instance report

Azure Migration Customer Momentum SQL DB Managed Instance SQL DB Elastic Pools SQL DB Managed Instance “We determined Azure SQL Database Managed Instance was the best choice for us in terms of scalability, cost, and performance. … We’ve seen a 49 percent cost reduction and 25 to 30 percent performance gains. ” “Azure SQL Database with Elastic Pools is a very convenient way to manage sharded or partitioned databases. We have a lot of experience with Oracle, Postgre. SQL, and other databases, and they can be hard to manage in a sharded way. But with elastic pool, it’s very simple to share databases across a resource set. ” Allscripts took advantage of Azure SQL Database Managed Instance to gain platform as a service (Paa. S) benefits while taking a lift and shift approach. “We’ve already closed or moved three of our datacenters…It’s much easier for us to manage systems in Azure than hardware in a datacenter half a world away. ” Alan Wales Senior Solution Architect, Property and Casualty Peter Tomlinson Director of IS, Technology Operations “Our on-premises solutions are expensive, and they’re good for complex, large deals, but they aren’t so good at handling fast transactions with low margins. We needed a very scalable, cost-effective Paa. S environment, and that’s what Azure provided. ” “When we had an Iaa. S-based development model, we produced one solid product release a year…But with an Azure Paa. S model, we enhance our product functionality quickly and continuously and give clients the flexibility to deploy small enhancements or not. ” Jürg Staub Head of Tech Architecture, Property and Casualty Jeff Brady Senior Program Manager, Azure Transformation Nipun Sharma Analytics Architect, Business Technology & Systems “Now we have a single consolidated source of truth that everyone uses, and we can increasingly automate our analysis for a deeper dive. . . employees have data available on a daily basis, they can analyze it and better manage and move around inventory in response to market and customer needs. ” John Steele General Manager, Business Technology & Systems

Start today on your modernization Assess Migrate Optimize Inventory your environment, determine optimal migration path Move your legacy SQL Server to Azure or upgrade to the latest version Fine-tune your resources to optimize costs and strengthen security Get the details on SQL DB Managed Instance Backup and Restore to Managed Instance Feel comfortable with Azure’s Paa. S model Use Data Migration Assistance offline: SQL Server to Managed Instance Know how SQL DB Managed Instance handles patching Use Data Migration Assistance online: SQL Server to Managed Instance Know how SQL DB Managed Instance handles business continuity Use Database Compatibility Level for SQL Server EOS to Managed Instance Manage costs in Azure Step-by-step guidance with the Database Migration Guide Inventory your environment with MAP Toolkit Visit the Microsoft Data Migration Blog Save with Azure Hybrid Benefit

Appendix Comparing Azure to AWS - RDS vs. SQL Database EC 2 vs. Azure SQL VM Aurora vs. SQL Database

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

SQL Database Managed Instance offers the best financial value (license-included) Pricing comparisons on 8 core SQL Server EE & SE (list-to-list on license-included, no SA required) 3 -year Reserved Hourly On-Demand Hourly Best TCO 54% saving 46% saving SQL parity SQL support 33% saving 30% saving Paa. S ++ AWS RDS SE Single. AZ (List) Azure SQL Database General Purpose AWS RDS EE Multi. AZ (List) Azure SQL Database Business Critical RDS customers running SQL Server 2008/R 2 without access to Extended Security Updates will be out of compliance

SQL Database Managed Instance offers the best financial value (with AHB) Pricing comparisons on 8 core SQL Server EE & SE (MI w/AHB vs AWS RDS) 3 -year Reserved Hourly On-Demand Hourly Best TCO 76% saving SQL parity SQL support 88% saving 60% saving 72% saving Paa. S ++ AWS RDS SE Single. AZ (List) Azure SQL Database General Purpose AWS RDS EE Multi. AZ (List) Azure SQL Database Business Critical RDS customers running SQL Server 2008/R 2 without access to Extended Security Updates will be out of compliance

SQL Database Managed Instance is a turn-key solution for SQL Server in the cloud Best TCO SQL parity SQL support Paa. S ++ Azure SQL Database Managed Instance AWS RDS Full surface area, just like your on-prem SQL Server* Limited surface area** 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 • No Linked Server, Transactional replication, SQL Server Audit, DB Mail, server level triggers, sysadmin permissions • Backup PITR only at instance level vs. SQL DB goes into DB level • Do not support R/Python integration for machine -learning Pegged to specific versions as in on premises SQL Server *Note: SSIS is available in Paa. S under Azure Data Factory V 2; SSAS can be ported to AAS as Paa. S; SSRS can stay on Azure VM as Iaa. S **See list of non-supported features on RDS

SQL Database Managed Instance provides unmatched support Best TCO SQL parity Azure SQL Database Managed Instance AWS RDS Support migration source back to SQL Server 2005 (via Backup and Restore) Limited migration source and support Database Compatibility Level 100 and higher supported Migration source back to SQL Server 2008 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** SLA at 99. 99% for any services out of the box SLA at 99. 95% only with Multi-AZ deployment SQL support Paa. S ++ * 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/R 2 without access to Extended Security Updates will be out of compliance

SQL Database Managed Instance brings ML-based performance & security Best TCO SQL parity SQL support Paa. S ++ Azure SQL Database Managed Instance AWS RDS 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 Paa. S only: No Advisor for RDS for SQL Server such as performance insights & recommendation*. Built-in HA with Always-on; active-active GEO replication, providing you the 99. 99% SLA out of the box; Shorter Failover duration given Accelerated Database Recovery only on Azure; quicker Failover Detection due to Azure Infrastructure integration No built-in Always On for HA, customer needs to purchase Multi-AZ (2 nd VM) to get the 99. 95% SLA; Longer Failover duration and no Failover Detection Advanced Threat Protection (ATP) enables data discovery & classification, vulnerability assessment, and advanced threat detection No ATP such as Threat Detection, Vulnerability Assessment, Information Classification 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 Postgre. SQL, /My. SQL based on historical query snapshot only.

Azure SQL Database: ML-enabled DBaa. S with best-fit engineering in mind RDS (SQL Server) SQL 2017 Azure SQL Database Managed Instance Singleton Elastic Pool SQL 2016 SQL 2014 SQL 2012 SQL 2008 Table-stake Paa. S: • Managed VMs of versions of SQL Server released on-prem • Backward compatible • Limited surface area • 99. 95% SLA only on Multi-AZ • Instance will face End of Support, no inplace upgrade • • • Evergreen with latest features, the end of Eo. S Intelligent performance and security improving productivity Built-in HA on a single node to save cost and effort Independent scaling of compute & storage for better perf/cost 99. 99% SLA for all service tiers • Fully backward compatible from SS 2008 • Full surface area

Azure SQL VM: free extended security updates for end of support customers Best TCO Save 5 x compared to AWS EC 2 ** Configuration Pre-configurated Developer edition, configurable cloud backup Support Free extended support for SQL Server 2008/R 2* 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/R 2 custom images can download the ESU for free and manually apply.

SQL VM on Azure offers great financial value Pricing comparison (on-prem, SQL VM w/AHUB on Reserved Instance, AWS EC 2* w/ paid ESU on Reserved Instance) Enterprise Edition Best TCO Configuration Standard Edition $ 80, 000 $ 25, 000 $ 70, 000 $66, 997 $ 60, 000 $ 50, 000 $23, 150 $ 20, 000 $ 15, 000 $ 40, 000 Support $ 10, 000 $ 30, 000 $ 20, 000 Security $ 5, 000 $ 10, 000 $- On-Prem (License only) SQL SA costs SQL VMs with AHB SQL Enterprise and Compute costs AWS EC 2 with SQL Enterprise 2008 Eo. S SKUs $- On-Prem (License only) SQL SA costs SQL VMs with AHB SQL Standard and Compute costs AWS EC 2 with SQL Standard 2008 Eo. S SKUs * AWS EC 2 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 EC 2 pricing on 8 -core M 4. 2 xlarge on US West (North California) vs. Azure SQL Dv 8 VM on US west

Demystifying Aurora AWS claims Aurora is… Open Source? Low Cost? Performant & Secure? Easy Migration? In reality… A proprietary, closed-source database Customers cannot port Aurora back to any community versions of OSS DB SQL DB is priced within 5% of Aurora pricing w/AHB; discount on all replica Add’l cost on PITR*, each replica priced as primary for Aurora No ML-enabled perf tuning and insights Lack enterprise security e. g. TDE, DDM, Always-Encrypted, and no ML-enabled protection as in SQL DB Time-consuming and costly for SQL Server users The Aurora Lock-in: No multi-cloud, no inter-cloud

Thank you