TECHNOLOGY IS SHAPING HOW BUSINESSES INNOVATE AND GROW

Engage your Transform your

customers products

Digital
transformation

Empower your Optimize your

employees operations
GETTING AHEAD MEANS GETTING TO THE CLOUD

80% of organizations
19.6% faster
 IT OPTIMIZATION IS KEY TO DIGITAL TRANSFORMATION
IDC Worldwide Database Server Forecast

Priorities
• Eliminate time spent managing
SQL Server “long tail” of applications—lift
37% of all units run Microsoft,
>50% of units run 2008/R2 or older2 and shift to managed cloud
• Free up limited IT resources to
drive transformation
• Migrate business critical apps
to cloud—extend and innovate

1 Pie Chart *IDC Worldwide DB Forecast Dec 2016

2 Microsoft Internal Sources
 AZURE SQL DATABASE
THE BEST AND MOST ECONOMICAL CLOUD
DESTINATION FOR YOUR SQL SERVER APPS

Built-in intelligence Breakthrough productivity Seamless and compatible Competitive TCO

and performance

Realize up to a 406% ROI over on-premises and hosted solutions

 AZURE SQL DATABASE MOMENTUM

4.5 million
databases
154 PB
total size
421K
subscriptions

3 trillion
batch requests/day
1.4 million
HTAP transactions/sec
100 million
queries analyzed/hour

“We had an incident lasting for about 6 “Intelligent Insights proactively finds a “SQL Threat Detection helps us to be ahead
months. Before Intelligent Insights we have database performance problem in a more of the threats instead of chasing them.”
not had a way of figuring out where do we efficient way and much faster than humans.
even start troubleshooting. Intelligent With it we can proactively help customers
Insights gave us a list of things to do…it Shahin Kohan, CTO
until we have a fix for the problem.”
enables us to pinpoint where the problem
is and to get a fix deployed within 24hrs.”
Bauke Stil, App Manager, SnelStart “SQL Threat Detection helps us respond to
Frans Lytzen – CTO, New Orbit activities, which were not visible beforehand.”

Manrique Logan, architect & technical lead

INTRODUCING AZURE SQL DATABASE MANAGED INSTANCE

Azure SQL Database

Managed
SQL SQL Single Elastic Pool
Instance
Instance-scoped programming Standalone managed Shared resource model for
model with high compatibility database for predictable and greater efficiency through
to SQL Server stable workloads multi-tenancy

Best for modernization at

scale with low cost and effort
B U I LT - I N
I N T ELLI G EN CE TO
P ROT E C T A N D
OPTIMIZE
Tuning
algorithms
Built-in intelligence learns unique database
patterns and automatically tunes for improved
performance SQL
Intelligent Threat Detection monitors, detects, SQL Database Database advisor
and alerts on malicious activities

Vulnerability Assessment discovers, tracks and

remediates potential database vulnerabilities “My app gets “I can do more
auto-tuned” in less time”

Developer DBA of
no admin skills many databases
C O N T I N U O U S LY Automatic tuning
OPTIMIZED BY THE
P L AT F O R M

• One-click to enable

• Prevent and mitigate issues

• No app changes needed

• Tuning actions

• Create missing indexes

• Drop unused/duplicate indexes
• Force last good plan
 FOCUS ON YOUR BUSINESS

Your work so far How PaaS helps

Hardware purchasing and management Built-in scale on-demand

Protect data with backups (with health checks and retention) Built-in point-in-time restore

High availability implementation Built-in 99.99% SLA and auto-failover

Disaster recovery implementation Built-in geo-redundancy and geo-replication

Ensure compliance with standards on your own Built-in easy to use features

Secure your data from malicious users and mistakes Built-in easy to use features

Role out updates and upgrades Built-in updates and upgrades

Monitor, troubleshoot, and manage at scale Built-in easy to use features

Tune and maintain for predictable performance Built-in easy to use features

We take care of your database chores

BREAKTHROUGH
PRODUCTIVITY AND
PERFORMANCE
30x
faster transactions with in-memory OLTP
Realize the benefits of real-time operational
analytics

100x
Enable scale-up with near zero downtime
through cloud-born innovation

performance gains with in-memory analytics

near 100%
uptime with dynamic scalability
S AV E T I M E W I T H Full compatibility with SQL Server 2005+
FA M I L I A R S Q L
S ERV ER TOOLS AN D
RESOURCES
Eliminate app changes with full SQL Ser ver
programming surface

Use familiar SQL Ser ver features in SQL Database

Managed Instance

Native backup and restore

Cross-database queries and transactions
Broad security features including Transparent Data Encryption,
SQL Audit, Always Encrypted and Dynamic Data Masking
SQL Agent, DBMail, and Alerts for workload orchestration
improved awareness
Scenario enablers including Change Data Capture, Service
Broker, Transactional Replication, and CLR
DMVs, XEvents, and Query Store for troubleshooting
D E D I C AT E D VNET support in SQL Database Managed Instance
RESOURCES THROUGH
C U S T O M E R I S O L AT I O N

Enable full isolation from other tenants without

resource sharing

Promote secure communication over private IP

addresses with native VNET integration

Enable your on-premise identities on cloud

instances, through integration with Azure
Active Director y and AD Connect
C O M P E T I T I V E T O TA L Up to 406% ROI with Azure SQL Database
COST OF
OWNERSHIP

Reduce capital and operational costs with fully-

managed ser vice and achieve up to 406% ROI 1

Financially-backed 99.99% availability SLA 2

Promote business continuity with built-in

capabilities

Maximize your on-premises investments with Azure

Hybrid Benefit for SQL Ser ver

Right-size on-premises workload requirements for

the cloud with independent control of storage and
compute
Adapted from The Business Value of Microsoft Azure SQL Database Services, IDC, March 2015.
DTUS SIMPLIFY CERTAIN ELEMENTS FOR CUSTOMERS BUT CAN MAKE ON-
PREMISES TRANSITIONS DIFFICULT

Challenges with translating on-premises workload requirements to the cloud

when migrating

More flexibility desired to optimize resources for SQL Database workloads

RIGHT-SIZE YOUR Introducing vCores
WORKLOADS FOR
THE CLOUD

Easier to right-size the destination environment by

removing the guesswork of DTUs

You pay only for what you use

1 on-premises core = 1 vCore on Gen4 hardware

COM M I T T ED TO Choose from two tiers in the vCore-based model
CU S TOM ER CH OI CE GENERAL PURPOSE BUSINESS CRITICAL

Best for Most business workloads. Offers Business applications with high IO
Choice drives our approach to resource budget oriented balanced and requirements. Offers highest
management and pricing scalable compute and storage resilience to failures using several
options. isolated AlwaysON replicas.
• Simplicity: We remain committed to the
DTU-based model and the simplicity it Compute Two hardware generations to choose from
offers customers who want a pre-configured tiers Single/Elastic Managed Single/Elastic Managed
solution Pools Instance Pools Instance
• Flexibility: The vCore-based model reflects
our commitment to customer choice and to 1 to 80 vCores 8, 16, 24, 32, 40, 1 to 80 vCores 8, 16, 24, 32, 40,
simplify the hybrid benefit for customers 64, 80 vCores 64, 80 vCores
migrating from on-premises
Storage Premium remote storage (per Super-fast local SSD storage (per
You pay for : instance) instance)
• Ser vice tier + number of vCore
• Type and amount of data storage Single/Elastic Managed Single/Elastic Managed
Pools Instance Pools Instance
• Number of IO*
• Backup storage (RA-GRS)* 5GB – 4TB 32GB – 8TB 5GB – 4TB 32GB – 4TB**

The vCore-based model will exist alongside the Availability 1 replica, no read-scale 3 replicas, 1 read-scale, zone-
DTU-based model redundant HA***

Learn more Backups RA-GRS, 7-35 days (7 days by RA-GRS, 7-35 days (7 days by
default) default)
*Free during preview
**4TB available on Gen 5 only
***Coming soon
 SELECTING THE RIGHT PURCHASING OPTION

Flexibility Simplicity
vCore-based DTU-based
Independently configure compute, Blended measure of compute, storage,
storage, IO IO
Most economical with Azure Hybrid May be more economical for < 3 cores
Benefit for SQL Server

• Compare vCore-based and DTU-based options using this rule of thumb: 100DTU ~ 1 vCore
• Convert from DTU to vCore using the API or portal with no downtime and same SLO update as today
AZURE IS THE MOST Save up to 80% with Azure Hybrid Benefit for SQL
ECONOMICAL Server and SQL Database reserved capacity
D E S T I N AT I O N F O R
SQL WORKLOADS*

Use your on-premises SQL Ser ver licenses with

active Software Assurance to save up to 55% on Total monthly cost of 8
Up to 55% Up to 80%
vCore Managed Instance
vCore-based SQL Database deployment options
with Azure Hybrid Benefit for SQL Ser ver
Business Critical option
savings1 savings2

Pre-pay your SQL Database compute capacity on a

one or three-year term and save up to 33% with
SQL Database reser ved capacity

Customer
Combine the Azure Hybrid Benefit for SQL Ser ver total cost
and SQL Database reser ved capacity for even
more savings, up to 80%. License included With Azure Hybrid Benefit Reserved capacity with
Azure Hybrid Benefit
Learn more:
• Azure Hybrid Benefit
• Azure SQL Database reser ved capacity
1 Savings based on eight vCore Managed Instance Business Critical in East US Region, running 730 hours per month. Savings are calculated from full price (license included) against base rate
(applying Azure Hybrid Benefit for SQL Server), which excludes Software Assurance cost for SQL Server Enterprise edition, which may vary based on EA agreement. Actual savings may vary based
on region, instance size and performance tier. Prices as of May 2018, subject to change.
2 Savings based on eight vCore SQL Database Managed Instance Business Critical in West 2 US Region, running 730 hours per month. Savings are calculated from on demand full price (license

*Based upon comparison of on-demand pricing on Azure for included) against base rate with Azure Hybrid Benefit plus 3-year reserved capacity commitment. Savings excludes Software Assurance cost for SQL Server Enterprise edition, which may vary based
on EA agreement. Actual savings may vary based on region, instance size and performance tier. Prices as of May 2018, subject to change.
Managed Instance versus running SQL on AWS RDS.
E XCLU S I V E TO A Z U RE:
GET MORE FOR YOUR
VIRTUALIZED
SQL Server license trade-in values

WORKLOADS SQL Database Managed Instance

Take an inventor y of on-premises licenses to

determine potential for conversion General Purpose Business Critical General Purpose

Convert on-premises cores to vCores to maximize

value of investments

1 Standard license core = 1 General Purpose core

OR
1 Enterprise license core = 1 Business Critical core
Highly virtualized, Enterprise Edition Standard Edition
1 Enterprise license core = 4 General Purpose Enterprise Edition
cores (virtualization benefit)
SQL Server with Software Assurance
Tools for your
migration journey
SQL Database
SQL Ser ver Migration Assistant (SSMA) Managed Instance
Automates database migration to SQL Ser ver from
Microsoft Access, DB2, MySQL, Oracle, and SAP ASE.

Data Migration Assistant (DMA)

Enables upgrade to SQL Ser ver and Azure SQL Azure Database Migration Ser vice (Azure DMS)
Database. SQL Ser ver Migration Assistant (SSMA)
Data Migration Assistant (DMA)
Database Experimentation Assistant (DEA)
Database Experimentation Assistant (DEA)
Assists in evaluating a targeted version of SQL for
a given workload.

Azure Hybrid Benefit for SQL Ser ver Azure Hybrid

Maximizes current on-premises license investments Benefit for
SQL Ser ver
to facilitate migration.
Azure SQL Database Managed Instance
Facilitates lift and shift migration from
on-premises SQL Ser ver to PaaS.
A C C E L E R AT I N G Azure Database Migration Service
YOU R JOU RN EY TO
THE CLOUD
SQL
Fully managed database migration ser vice for
both operational databases and data
warehouses

Enables reliable and seamless migrations to the

cloud at scale and minimal downtime

Migrate SQL Ser ver & 3rd party databases to

Azure SQL Database MySQL SQL

SQL Server Azure SQL Database single, elastic pools and Managed Instance

MySQL Azure Database for MySQL

PostgreSQL Azure Database for PostgreSQL

Oracle, … Azure SQL Database & Managed Instance

Netezza, … Azure SQL Data Warehouse

YOUR SINGLE Azure migration center
D E S T I N AT I O N F O R
ALL THINGS
M I G R AT I O N
Provides guidance, tools, and partners in context
of your migration scenario

Enables you to:

• Build your case, find others like you
• Assess your environment
• Identify the right migration strategies
• Optimize your cloud resources

Connects you to a migration expert

• Chat enabled, backed by engineering
resources
• Guides you to FastTrack , partner, seller, or
DIY outcomes

Azure.com/Migration
 M I G R AT I O N
COOKBOOK

Migrate an on-premises SQL Server

database to Azure SQL Database
The Migration Cookbook describes
various approaches you can use to
migrate an on-premises SQL Server
database to the latest Azure SQL
Database Update
Download:https://azure.microsoft.c
om/en-us/resources/choosing-
your-database-migration-path-to-
azure/en-us/
LIFT YOUR SQL
S E R V E R I N T E G R AT I O N Azure Data Factory
SERVICES (SSIS)
PA C K A G E S T O A Z U R E
SSIS Integration Runtime

SQL

Easily execute and schedule your SQL Ser ver Data sources SSIS ETL SQL Database
Integration Ser vices (SSIS) packages in managed
execution environment for SSIS in Azure Data Managed Instance
Factor y (ADF)

Gain high availability, scalability and lower TCO Cloud

by lifting your SSIS packages to Azure
On-premises

Continue to build, monitor and manage packages VNET

with existing tools like SQL Ser ver Management
Studio (SSMS) & SQL Ser ver Data Tools (SSDT)

Learn more
SQL
SSIS ETL
Data sources
SQL Server
 A Z U R E S Q L D ATA B A S E Enroll today in Managed Instance preview
M A N A G E D I N S TA N C E
PREVIEW

Submit a provisioning request for Managed Instance

via Azure portal, accept the preview terms and complete
the short form.

You will receive a response from Microsoft within 3

Start provisioning request in
working days Azure Portal and accept the
preview terms
Once approved, return to the portal to complete the https://aka.ms/sqldbclassessment
provisioning request Complete survey (optional)

Managed Instance created within 3-5 working days

upon completing the provisioning request

SQL SQL

Notification (3 Complete Managed

business days) provisioning Instance
request in created
portal (3-5 days)
LEARN MORE • Announcement blog

• Azure SQL Database

• SQL Database Managed Instance

• Create a Managed Instance

• Azure Hybrid Benefit for SQL Server

• Azure Database Migration Service

• Migration Guide

• SQL Server Integration Services

• Hands-on-lab to lift SSIS to Azure with
Azure Data Factory: aka.ms/adflab 2
 Everywhere!
Data & service architecture

Govern Secure Monitor

Active Directory Op / App Insights

Ops
Data Catalog

Ingest Store Interact

Mkt

Data Lake Store

Data Factory HDI / ADLA Data Warehouse PowerBI App Svcs
Sales

Analyze

Analyst Scientist
ML / R / CS / Spark
 C L O U D D ATA WA R E H O U S E S O L U T I O N

Ingest Store Prep & Train Model & Serve

Business
apps
Machine Learning Cosmos DB
SQL DB
Web & mobile apps

Data Factory Blobs / Data Lake HDInsight /

Spark
Custom
SQL Data Warehouse
apps
Operational reports

Analysis Services
Sensors
and devices
Analytical dashboards

DATA INTELLIGENCE ACTION

SQL
Introducing Azure SQL Data Warehouse
A relational platform-as-a-service, fully managed by Microsoft.
Elastic scale cloud data warehouse with proven SQL Server capabilities.
Built for businesses of all shapes, sizes, and industry.

Azure
Azure

Saas

Azure

Office 365
Public
Cloud
 W H E N TO U S E W H AT

Scale up Scale out + across

Cloud
Azure SQL Database Azure SQL DW
Up to 4TB compressed (per DB) Unlimited columnar storage

Azure HDInsight
Data Prep

Built-in Analytics
Business intelligence
Machine learning
On-premises

SQL Server Analytics Platform System

Up to 150TB compressed Up to 4PB compressed
 A Z U R E S Q L D ATA W A R E H O U S E - P E R F O R M A N C E T I E R S

Preview
NEW! available

Optimized for elasticity Optimized for compute

now!

Elastic-scale performance tier provides high Ultra-high performance, compute intensive,

performance for regular workloads and analytics elastic-scale performance tier delivers the
highest performance for the most demanding
analytical workloads

Up to 100x query performance!

Data Warehouse Units (DWUs & cDWUs) are a measure of reserved compute performance or ‘power.’
A customer’s DWU or cDWU needs can vary depending on the characteristics of the workload.
5x compute scale
$

100 200 300 400 500 600 1000 1200 1500 2000 3000 6000 1000 1500 2000 2500 3000 5000 6000 7500 10,000 15,000 30,000

DATA WAREHOUSE UNITS (DWU) COMPUTE-OPTIMIZED DATA WAREHOUSE UNITS (cDWU)

 C L O U D D ATA WA R E H O U S E S O L U T I O N

Ingest Store Prep & Train Model & Serve

Business
apps
Machine Learning Cosmos DB
SQL DB
Web & mobile apps

Data Factory Blobs / Data Lake HDInsight /

Spark
Custom
SQL Data Warehouse
apps
Operational reports

Analysis Services
Sensors
and devices
Analytical dashboards

DATA INTELLIGENCE ACTION

Integrates with existing processes

Analysis
SQL Server Services
Data sources (ROLAP)
Relational
Non-Relational SSIS
Polybase
Event Hubs BCP
Stream Analytics ADF Azure Blob
Hadoop Azure Machine
Stream Analytics Storage Learning

PaaS IaaS

Analysis
Azure SQL Services
Data (MOLAP)
Warehouse
Supports data
ingestion from
literally
anywhere… Data/
Azure
Data Factory

Workload
IaaS PaaS
Analysis
Services Other Azure
(MOLAP) Azure SQL components
Data
Warehouse

Hadoop Azure Blob Azure Machine

Storage Learning
Industry’s first enterprise-class cloud Petabyte scale data warehousing
data warehouse that can grow, shrink, leveraging massive parallel processing
and pause in seconds

Full enterprise-class SQL Server Two performance tiers designed for

experience businesses of all sizes

Seamless compatibility with Power BI, Query and load big data from Hadoop,
Azure Machine Learning, HDInsight, and HDInsight, Data Lake and Blob Storage
Azure Data Factory using Polybase
BI AND ANALYTICS

Self-service Corporate Collaboration Mobile Predictive

DATA ENRICHMENT AND FEDERATED QUERY

Single query model Extract, transform, load Data quality Master data management

DATA MANAGEMENT AND PROCESSING

Relational Non-relational Analytical Streaming Internal & external

 E V O L U T I O N O F T H E D ATA WA R E H O U S E
Increasing data volumes. New data sources and types. Big Data + DW workloads

LOB

CRM INGEST STORE PREP & TRAIN MODEL &

SERVE
Graph

Image
Data orchestration Big data Hadoop/Spark and Data warehouse
and monitoring store machine learning
Social
Apps + insights

IoT
Do I need to modernize to reduce costs?

To maintain required industry certification?

To keep vendor support?

For ISVs, to enable choice for my customers?

And how to minimize risk?

Can I separate application modernization cycles from data modernization cycles?

And what’s my required certification process?

http://aka.ms/dbcompat
 Microsoft Database Compatibility
Level Protection

Maintaining
Full Functional Query Plan
backward
protection once shape
compatibility is
assessment protection on
very important
tools runs clean comparable
to SQL Server
with no errors. hardware.
team.
Simplified application certification on-premise and
Azure (e.g. Azure SQL DB MI).

Ability to provide customer a choice of latest SQL

Server platform based on certified DB compat level.

Improved risk management by decoupling application

upgrade cycles from Database upgrade cycles.
 Side-by-side In-place

• Allows for • Doesn’t require

upgrade of OS additional
• Easier testing hardware
• Easier rollback • No data
strategy migration
• Less downtime required
Feature Notes

Log Shipping Cutover measured in (typically) minutes

Replication Cutover measured in (potentially) seconds

Backup and Restore This is going to take a while!

Filesystem/SAN Copy Ditto - the latter being significantly faster

Availability Groups (NOT available in < 2012) Cutover measured in (typically) seconds
 Functional &
Remediate
Performance
applications
tests
Data
Discover Assess Convert Cutover
Sync
Migrate
schema, Optimize
objects & data
 • Microsoft Review the Database
Migration Guide for
Assessment and
Discover details
Planning Toolkit
(MAP)

Fully
automated • Database
using free tools Assess Migration
from Microsoft Assistant (DMA)

• Database
Test Experimentation
Assistant (DEA)
Which SQL Server versions do I have?

Which Editions am I running?

Which SQL Server components are installed?

How many cores are on each server?

How many databases are in each instance?

What are the sizes of all my databases?

What are the settings for each instance and database?

 Assess • Breaking changes
Compatibility • Behavior changes
Issues
• Deprecated features

Data Migration Discover • Performance

Assistant new • Storage
features • Security

• Connect to source
and target servers
Perform • Choose databases
Migration
• Monitor migration
• Review final report
 A/B testing

Configuration Compatibility
setting execution
comparison errors
Database
Experimentation
Assistant

Hardware Degraded
comparison queries

Workload
comparison
Includes waits in
SQL Server 2017
Query times

Plan 1 Plan 2 Plan 3 Plan 2

Revert to
previously
effective plan
Upgrade SQL Server
Database Migration Guide
Microsoft Assessment and Planning Toolkit
Overview of Data Migration Assistant
DEA 2.1 General Availability: Release Overview – Database
Experimentation Assistant
Post-migration Validation and Optimization Guide
http://aka.ms/dbcompat