1 Microsoft 2016 12/2/2017 2:10 AM Take your database capabilities to the next level: SQL Server across 3 clouds Damir Bersinic Chief Architect, MTC Canada © 2016 Microsoft Corporation. All rights reserved. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
2 Session objectives and takeawaysTech Ready 15 12/2/2017 Session objectives and takeaways Session Objectives: Outline SQL Server capabilities across private, public and hybrid clouds Provide best practices guidance on implementing SQL Server across several cloud scenarios Describes capabilities of various SQL databases options across private, IaaS and PaaS Key Takeaways: SQL Server allows you to leverage capabilities on premise, as a VM in IaaS as well as a database as a service offering in PaaS Leveraging hybrid cloud capabilities of SQL Server 2016 allows you to architect a more robust solution to business data requirements © 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
3 Only Microsoft delivers on-premises & cloudServer & Tools Business 12/2/2017 Only Microsoft delivers on-premises & cloud SQL Server in Azure VM SQL Server Azure SQL Database Common tools for development and management Analytics Platform System Azure SQL Data Warehouse Common T-SQL surface area Common tools Dev ops tools Identity Virtualization Management tools Single-vendor support Simple cloud migration © 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
4 SQL Server Cloud Continuum
5 Cloud Services On Premises Infrastructure Platform Software StorageServers Networking O/S Middleware Virtualization Data Applications Runtime Infrastructure (as a Service) Storage Servers Networking O/S Middleware Virtualization Data Applications Runtime You Manage Platform (as a Service) Storage Servers Networking O/S Middleware Virtualization Applications Runtime Data You Manage Vendor Manages Software (as a Service) Storage Servers Networking O/S Middleware Virtualization Applications Runtime Data You Manage Vendor Manages You Manage Vendor Manages
6 Pizza Services AnalogyOn Premises Toppings Tomato Sauce Cheese Fire Oven Pizza Dough Soda Dining Table Electric / Gas Infrastructure (as a Service) Toppings Tomato Sauce Cheese Fire Oven Pizza Dough Soda Dining Table Electric / Gas You Manage Platform (as a Service) Toppings Tomato Sauce Cheese Fire Oven Pizza Dough Dining Table Electric / Gas Soda You Manage Vendor Manages Software (as a Service) Toppings Tomato Sauce Cheese Fire Oven Pizza Dough Dining Table Electric / Gas Soda You Manage Vendor Manages You Manage Vendor Manages Made at home Take & Bake Pizza Delivery Italian Restaurant
7 How we develop SQL Cloud-first but not Cloud Only12/2/2017 2:10 AM How we develop SQL SQL Server Azure SQL Virtual Machines Azure SQL Database DB Cloud-first but not Cloud Only Using Azure SQL DB to improve core SQL Server features & cadence Many interesting and compelling on-premises Cloud scenarios © 2014 Microsoft Corporation. All rights reserved. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
8 SQL Server - on Premise In the box components;Relational Engine – high availability (always on), in memory, management/tuning etc. Analysis Services (SSAS) – multidimensional or tabular Reporting Services (SSRS) – multi-page, dashboards and mobile Integration Services (SSIS) – orchestration and ETL Data Quality Services (DQS) Master Data Services (MDS)
9 SQL Server in Azure VM & Azure SQL Database Which one to use?Microsoft Consumer Channels and Central Marketing Group 12/2/2017 SQL Server in Azure VM & Azure SQL Database Which one to use? SQL Server in Azure VM Azure SQL Database Need a specific version of SQL Server or Windows Need instance-level SQL features (e.g. Agent Job, Linked Servers, DTC) Ok configuring/managing SQL Server and Windows (patching, high availability, backups) Great for migrating existing apps Don’t need a specific version of SQL Server or Windows Don’t need instance-level SQL features Don’t want to configure and manage SQL Server or Windows Great for new apps Many customers use both © 2013 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
10 SQL Server in Azure VM and Azure SQL Database More details..Microsoft Consumer Channels and Central Marketing Group 12/2/2017 SQL Server in Azure VM and Azure SQL Database More details.. SQL Server in Azure VM Azure SQL Database You access a VM with SQL Server installed You manage SQL Server and Windows (patching, high availability, backups) You select the SQL Server and Windows version and edition Different VM sizes: A0 (1 core, 1GB mem, 100GB) to G5 (32 cores, 448GB mem, 64TB) VM availability SLA: 99.95% (No SQL SLA) You access a database Database is fully managed Runs latest SQL Server version with Enterprise edition Different DB sizes: Basic (2GB, 5tps) to Premium (1 TB, 1750tps) Database availability SLA: 99.99% © 2013 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
11 SQL Server in Azure VM
12 Azure VM VM hosted on Microsoft Azure Infrastructure Pay per useFrom Microsoft images or your own - SQL 2008R2 / 2012 / 2014 / 2016 Web / Standard / Enterprise / Express - Refreshed with latest SP, important Win/SQL hotfixes, and every 3 months – latest CU Create VM in 8 minutes Connect via RDP, Powershell, or TDS Pay per use Per minute (only when running) Cost depends on size and licensing EA customers can use existing SQL licenses (BYOL) Network: only outgoing (not incoming) Storage: only used (not allocated) Elasticity 1 core / 2 GB mem / 1 TB 32 cores / 512 GB mem / 64 TB
13 Microsoft Consumer Channels and Central Marketing Group12/2/2017 Azure VM - Security Physical Security Data centers monitored all the time Microsoft Ops and Support personnel don’t have access to customer storage Infrastructure Security Virtual Networks – Deployments are isolated in their own private networks Azure Storage – Storage accounts authentication via strong keys Many certifications ISO 27001/27002, SOC 1/SSAE 16/ISAE 3402 and SOC 2, Cloud Security Alliance CCM, FISMA, HIPAA, EU Model Clauses, FIPS 140-2, … SQL Security Encryption of connections Encryption of Databases and Backups Integrated with Azure Key Vault Authentication: Windows / SQL © 2013 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
14 Azure VM - ConnectivityMicrosoft Consumer Channels and Central Marketing Group 12/2/2017 Azure VM - Connectivity Over the Internet Public endpoints Over a site-to-site tunnel Secure tunnel Extend on-premise network to Azure Can join Azure VMs to on-premise domain (Windows auth) VPN Device / Windows Server RRAS © 2013 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
15 Microsoft Consumer Channels and Central Marketing Group12/2/2017 Azure VM - Storage Every VM disk is a BLOB in Azure Storage 3 sync local copies No data loss Highly available (automated checksum verification and disk commissioning/decomissioning) 3 more async remote copies (if geo-replication enabled) For disaster recovery (manually managed by Microsoft) Optionally, readable © 2013 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
16 Microsoft Consumer Channels and Central Marketing Group12/2/2017 Azure VM - Storage 2 Types: Standard Storage Uses Hard Disk Drives (HDD) Max 500 IOPs or 60 MB/s p/disk Varying latency: 20ms-60ms Billed by used size Premium Storage Uses Solid-State Drives (SSD) Leverages local VM disk (SSD) as a read cache Max 5000 IOPs or 200 MB/s p/disk Low-latency: avg ~4ms, (1ms reads from cache) Billed by provisioned size © 2013 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
17 Azure VM Series and StorageMicrosoft Consumer Channels and Central Marketing Group 12/2/2017 Azure VM Series and Storage VM Series that support Standard Storage only A-Series: Slowest CPU, least memory D-Series: Faster CPU, more memory, has one local SSD (temporary) G-Series: Fastest CPU, most memory VM Series that support Premium and/or Standard Storage DS-Series: Same CPU and memory as D-Series. Has one local SSD (temporary), leveraged as read cache GS-Series: Same CPU and memory as G-Series. Has one local SSD (temporary), leveraged as read cache Dev/test Only in new Azure Portal Production © 2013 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
18 Azure VM - AvailabilityAzure Storage guarantees no data loss Azure “Fabric” automatically “moves” VM to another host in case of failures: ~12 minutes downtime Azure patches host OS (~once per month): ~10 minutes downtime You’re responsible to patch guest OS and SQL Server Azure doesn’t detect failures inside of VM (e.g. SQL service down or hung) VM VM Health check (15s) Health check (15s) Azure Fabric Controller Host Agent Host
19 Azure VM – AvailabilityAn Azure Availability Set distributes VMs in different failure domains (racks) and upgrade domains So that VMs are not impacted at the same time by rack/host failures azure host upgrades
20 Azure VM - AvailabilityAzure SLA: 1 of 2 VMs in Availability Set: 99.95% (<22 min downtime p/month) Includes Planned downtime due to host OS patching Unplanned downtime due to physical failures Doesn’t include servicing of guest OS or software inside (e.g. SQL) For SQL this requires configuring high availability If VM becomes unavailable, fail over to another one: ~15s Detects SQL instance failures (e.g. service down or hung) SQL HA achieves ~99.99% (<4 min downtime p/month) Witness VM S S P P VM VM
21 AlwaysOn Availability GroupsApps transparently connect to the AlwaysOn primary replica using a Listener (Virtual Network Name mapped to an IP address) VNET On-premises: Windows Cluster moves (floating) IPs between replicas Azure VMs don’t support floating IPs yet Listeners are supported using an Azure Load Balancer Internal (VNET) or External (Internet)
22 SQL Server in Azure VM – PatchingMicrosoft Consumer Channels and Central Marketing Group 12/2/2017 SQL Server in Azure VM – Patching Install important/critical hotfixes (Windows & SQL) Use Automated Patching Configurable day and maintenance window Portal and Powershell © 2013 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
23 SQL Server in Azure VM – BackupMicrosoft Consumer Channels and Central Marketing Group 12/2/2017 SQL Server in Azure VM – Backup Backup to VM disk or Azure Storage (SQL12+) The latter can be accessed at any time from SSMS, Portal, Azure Storage Explorer Configure a Maintenance Backup Plan to specify backup policy or use Automated Backup Automated Backup (SQL14+) Backup all DBs to Azure Storage Based on log generation Configurable retention period Supports Compression and Encryption Portal and Powershell © 2013 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
24 SQL Server in Azure VM – MonitoringMicrosoft Consumer Channels and Central Marketing Group 12/2/2017 SQL Server in Azure VM – Monitoring Monitor SQL Perf Counters in Azure Portal Operations Insights Portal Monitor best practices: Availability, Perf, Security System Center DMVs, Profiler, XEvents © 2013 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
25 SQL Database as a Service
26 Microsoft Data Platform & Azure SQL DBRelational Non-relational On-premises Cloud Azure SQL DB Azure SQL DW SQL Server 2016 on VM Azure Data Lake Manage all your data in a mission critical, scalable, secure way Gain deep insights across all of your data without data movement Utilize existing skills and investments Consistent on-premises, cloud and hybrid experiences Federated query Business intelligence Machine learning & advanced analytics Insights SQL Server 2016 Analytics Platform System SQL Analytics Platform System
27 Build 2015 12/2/2017 2:10 AM Azure SQL Database Fully managed SQL database service so you can focus on your business Built for SaaS and Enterprise applications Predictable performance & pricing 99.99% availability built-in Geo-replication and restore services for data protection Secure and compliant for your sensitive data Fully compatible with SQL Server 2014 databases © 2015 Microsoft Corporation. All rights reserved. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
28 V12 Servers SQL DB SQL 16 code base is now driving SQL DB V12Improved query optimization and performance RTM features showed up in SQL DB first Premium databases run on local SSD Azure Gen3 and Gen4 hardware Standard databases transitioning to premium storage Full parity with SQL Server 2014 database surface area Better support for large databases No transaction size limit
29 Azure SQL Database Service TiersBuild 2015 12/2/2017 2:10 AM Azure SQL Database Service Tiers Basic Standard Premium Light transactional workloads Go-to option for most business applications High throughput and business-critical databases Intended Use 99.99%* Availability • •• ••• Performance Fully compatible with SQL Server 2014 databases Programming Surface Isolated databases and elastic database pools Workload Elasticity © 2015 Microsoft Corporation. All rights reserved. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
30 Singleton vs Elastic DatabasesSingleton databases Fixed resource reservations Optimized for apps with predictable performance demands Seamless scale up and down through service tiers Elastic pool database Individual database resources fluctuate dynamically with capacity demands For workloads with unpredictable database resource consumption Pool resources shared among a group of databases Helps avoid overprovisioning databases to meet peak demand Elastic database pool can host hundreds of databases Resources and cost budget are per pool Cost are independent of database count in pool
31 Azure SQL Database Scale up 350x B S0 S1 S2 S3 P1 P2 P4 P6 P11 5 10 20100 125 250 500 1000 1750 B S0 S1 S2 S3 P1 P2 P4 P6 P11 BASIC STANDARD PREMIUM Database Throughput Units (DTUs)
32 What exactly is a DTU? DTU represents a set of operations that are typical for an online transaction processing (OLTP) request, and then measured by how many transactions could be completed per second under fully loaded conditions % CPU % READ % WRITE % MEMORY
33 Scale up Basic, Standard, and Premium provide increasing performance levels Scale individual databases up/down via portal, PS, APIs, or T-SQL Database remains online while scaling Hourly billing provides cost efficiency P11 1750 P6 P4 1000 P2 P1 500 S3 250 S2 S1 125 B S0 100 50 20 5 10 DTUs $5 $15 $30 $75 $150 $465 $930 $1,860 $3,720 $7,000
34 Elastic Database Pool Elastic database pool provides large scale SaaS vendors a simple cost effective solution to achieve performance goals for a group of databases with widely varying and unpredictable usage patterns. Max per-database burst level DTUs 200 400 800 1200
35 Scale-out Simplify development and management of apps that span many SQL Databases Cross-database query for reporting scenarios with Elastic Database Query Jobs management tooling Route requests to shards and split/merge shards with Elastic Database tools
36 Workload Insight Using service telemetry and machine learning to help customers achieve better efficiency for their workloads Boost your performance with recommendations for optimum index design tailored for your workload Find your right scale with recommendations for elastic pools and monitoring of historical usage and trends
37 Azure SQL Data WarehouseA relational data warehouse-as-a-service, fully managed by Microsoft. Industries first elastic cloud data warehouse with enterprise-grade capabilities. Integrated with on-premises and cloud assets. Elastic scale & performance Integrated with Azure platform and other Microsoft services Enables hybrid solutions Built on SQL Server experience & technology End-to-end platform built for the cloud Market leading price/performance Simple compute & storage billing Pay for what you need High performance without rewriting applications Low cost for latent data Infrastructure, management and support provided Scales to petabytes of data with MPP processing Resize compute nodes < 1 minute Faster time to insight than other SMP offering Designed for “on-demand” workload
38 SQL Server Hybrid Scenarios
39 Hybrid cloud solutionsServer & Tools Business 12/2/2017 Hybrid cloud solutions Simplified cloud backup Manual or automatic At an instance level with point in time restore Measures DB usage patterns to set backup frequency Reduce CAPEX and OPEX with cloud backup On-premise network Microsoft Azure storage Domain controller Periodic Snapshot (automatic/manual) SQL Server Microsoft Azure Restore to VM Geo replication Cloud disaster recovery Fast disaster recovery (low RTO) Easy to deploy and manage Extend on-prem apps Cloud bursting Greater global reach Better isolation of internal assets © 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
40 Hybrid cloud solutionsServer & Tools Business 12/2/2017 Hybrid cloud solutions Simplified cloud backup Manual or automatic At an instance level with point in time restore Measures DB usage patterns to set backup frequency Reduce CAPEX and OPEX with cloud backup Run backups Microsoft Azure Run BI reports Cloud disaster recovery Fast disaster recovery (low RTO) Easy to deploy and manage Secondary replica VPN tunnel (Microsoft Azure Virtual Network) Asynchronous commit On-premise network Extend on-prem apps Cloud bursting Greater global reach Better isolation of internal assets Domain controller Primary replica Synchronous commit Secondary replica © 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
41 Hybrid cloud solutionsServer & Tools Business 12/2/2017 Hybrid cloud solutions Simplified cloud backup Manual or automatic At an instance level with point in time restore Measures DB usage patterns to set backup frequency Gain cloud scale by extending on-prem apps Microsoft Azure Microsoft Azure load balancer Cloud disaster recovery Fast disaster recovery (low RTO) Easy to deploy and manage SQL Servers Web servers VPN Tunnel Microsoft Azure Virtual Network On-premise network Linked Server Extend on-prem apps Cloud bursting Greater global reach Better isolation of internal assets Domain controller (authenticating all users on-premise and cloud) Web server SQL Server © 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
42 Server & Tools Business12/2/2017 Stretch SQL Server into Azure Stretch warm and cold tables to Azure with remote query processing Capability Stretch cold database tables from on-premises SQL Server Databases to Azure with remote query processing Benefits Cost effective historical data Entire table is online and remains queryable from on-premises apps Transparent to applications Supports Always Encrypted & Row Level Security Microsoft Azure Jim Gray ox7ff654ae6d 3/18/2005 Always Encrypted Order history Name SSN Date Jane Doe cm61ba906fd 2/28/2005 Jim Gray ox7ff654ae6d 3/18/2005 John Smith i2y36cg776rg 4/10/2005 Bill Brown nx290pldo90l 4/27/2005 Order history Name SSN Date Jane Doe cm61ba906fd 2/28/2005 Jim Gray ox7ff654ae6d 3/18/2005 John Smith i2y36cg776rg 4/10/2005 Bill Brown nx290pldo90l 4/27/2005 Sue Daniels ypo85ba616rj 5/12/2005 Sarah Jones bns51ra806fd 5/22/2005 Jake Marks mci12hh906fj 6/07/2005 Eric Mears utb76b916gi 6/18/2014 Rachel Hogan px61hi9306fj 7/1/2014 Sam Johnson ol43bi506gd 7/12/2014 David Simon tx83hal916fi 7/29/2014 Michelle Burns nb95re926gi 8/10/2014 Reed Dean vc61ira536fe 8/23/2014 Customer data Product data Order History Stretch to cloud Query SQL Server App Hyperscale cloud © 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
43 Secure by default (and then some)Data in motion always via secure channels (TLS1.2 / 1.1) Supports Always Encrypted Encryption key remains on-premises Row level security SQL Server and SQL Azure audit Integrated authentication (pass-through) with AAD integration Orders_History Orders Trickle migration
44 Next Steps…
45 What is the best path to the cloud? It depends…1 Lift & shift (Move) 2 Lift & port (Remodel) Build for cloud (New construction) 3 Migrating application with no changes Reducing infrastructure cost (CAPEX), not willing to invest in application Moving packaged app not certified for Azure One or small number of applications IT controlled and managed Need to control OS and instance Modernizing application Leveraging scale, reducing infrastructure management overhead (OPEX) One or many applications IT controlled and managed New modern applications Large scale Ability to start small and grow very large Building SaaS applications Moving to DevOps model Unpredictable growth Large number of databases Azure SQL Database SQL Server in Azure VM SQL Server in Azure VM Azure SQL Database
46 Please evaluate this session12/2/2017 2:10 AM Please evaluate this session Your feedback is important to us! From your PC or Tablet visit MyIgnite at From your phone download and use the Ignite Mobile App by scanning the QR code above or visiting https://aka.ms/ignite.mobileapp © 2014 Microsoft Corporation. All rights reserved. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
47 12/2/2017 2:10 AM © 2014 Microsoft Corporation. All rights reserved. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.