SQL Server 2016

Everything built-in
 SQL Server 2016: Everything built-in
built-in built-in built-in built-in built-in

$2,230
80
69
70
SQL Server
60
49 SQL Server
50 43 SQL Server
40 34

30
29
$480
2220 22
18
20 15 $120
6 Oracle
#1
10 4 5 3 3
0 1 0 0
#2 #3 is #5
0 Microsoft Tableau Oracle
2010 2011 2012 2013 2014 2015

SQL Server Oracle MySQL SAP HANA TPC-H non-clustered 10TB Self-service BI per user at massive scale

In-memory across all workloads

Consistent experience from on-premises to cloud

The above graphics were published by Gartner, Inc. as part of a larger research document and should be evaluated in the context of the entire document. The Gartner document is available upon request from Microsoft. Gartner does not endorse any vendor, product or service depicted in its research
publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner's research organization and should not be construed as statements of fact. Gartner disclaims all warranties,
expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.
National Institute of Standards and Technology Comprehensive Vulnerability Database update 10/2015
TPC-H non-clustered results as of 04/06/15, 5/04/15, 4/15/14 and 11/25/13, respectively. [Link]
Industry leading TCO

$648K $2.2M 3.4x Built-in with SQL Server vs.

+ $120
per user for Power BI
+ $2,230
per user for BI 20x expensive add-ons with Oracle
per user

In-memory built-in
ADVANCED ANALYTICS ADVANCED ANALYTICS

BUSINESS INTELLIGENCE BUSINESS INTELLIGENCE

End-to-end security built-in

DATA WAREHOUSING DATA WAREHOUSING Advanced Analytics built-in

OLTP OLTP
Complete mobile BI built-in
SQL Server 2016

Note: For OLTP and DW scenario, the price comparison

is based on a server with 2 proc, 8 cores each
Real-time operational analytics

Mission critical OLTP

In-memory built-in
SQL Server
In-memory
Data Warehouse
ColumnStore
2-24
hrs
Up to 30x faster transactions
with in-memory OLTP

ETL
Queries from minutes to
seconds
Business problem Real-time
NEW
Real-time business problem
detection
operational analytics
In-memory
SQL Server
0100101010110 OLTP
Dramatically simplify HA & DR

Mission critical OLTP

+35% operational efficiencies with hybrid cloud
Enhanced AlwaysOn
NEW

35%
Most secure database

Most secure database

Layers of protection Least vulnerable 6 years
in a row & most utilized
NEW
• Advanced Threat Analytics
• SQL Server auditing
Monitor activity
80
69 69
70
60 53 53 55
• Windows Authentication 49
50 43
NEW
• Row-level security 40 34
NEW 28 29 29
Control access • Dynamic data masking 30 25
22 20 22
21
16 16 18
20 13 15
11 9 8 8 6 6 6
10 5 4 3 5 3 3
0 2 0 1 0 0 0
0
NEW
• Always Encrypted 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015

• Transparent data encryption SQL Server Oracle DB2 MySQL SAP HANA
Protect data

* National Institute of Standards and Technology Comprehensive

Vulnerability Database update 10/2015
Protect your data at rest and in motion

Most secure database

without impacting database performance
NEW 
Always Encrypted
Apps Trusted SQL Server SELECT Name FROM
Patients WHERE SSN=@SSN
Client side @SSN=0x7ff654ae6d
Query
SELECT Name FROM Enhanced
Patients WHERE SSN=@SSN [Link]
@SSN='198-33-0987' Library

Result Set Result Set

Column Column
Master Name SSN Country Encryption
Key
198-33-0987 ciphertext
Denny Usher 0x7ff654ae6d USA Key

[Link]
Name SSN Country
Philip Wegner 1x7fg655se2e
243-24-9812 USA
Denny Usher 198-33-0987 USA
0x7ff654ae6d
Alicia Hodge 123-82-1095 USA
0y8fj754ea2c
#1 Price/performance with massive scale

Highest performing DW
#1 TPC-H
10 TB TPC-H world record* Unparalleled scalability
@ ½ hardware costs with Windows Server 2016

24X TPS boost

In throughput on the
same hardware

#1 SAP performance 12TB of memory WS 2016 max cores

2-tier 16-processor SAP benchmark
on Superdome X + SQL Server
* As of 4/6/2015 ([Link]
Highest performing data warehouse

Highest performing DW
In-memory built-in
On-premises, cloud, or hybrid

SMP MPP SMP MPP

Scale to MPP
NEW

Data marts Petabyte- Data marts Petabyte- on-premises & in the cloud
scale scale
+ Simple T-SQL
NEW

to manage structured
SQL Server SQL Server +
Analytics Platform System
SQL Server
in Azure VM
Azure
SQL Data Warehouse
and unstructured data

½ the cost
of Oracle Exadata
Consistent experience from on-premises to cloud
End-to-end mobile BI on any device

End-to-end mobile BI
Lightning fast queries & reports On all mobile devices
built-in
NEW
built-in
NEW

NEW

Reports in minutes not days

PB scale DW in SQL Server

Windows iOS Android HTML5
Remove the complexity of big data

End-to-end mobile BI
T-SQL over Hadoop
PolyBase
NEW

Quote:
NEW

Simple T-SQL
************************

T-SQL query **********************

to query Hadoop data (HDFS)

*********************

**********************

***********************

$658.39
SQL Server JSON support
NEW
Hadoop

Name DOB State

Denny Usher 11/13/58 WA

Gina Burch 04/29/76 WA
In-database Advanced Analytics

Advanced Analytics
Build intelligent applications with SQL Server R Services

R built-in to your
NEW

T-SQL
Real-time
NEW

operational analytics
without moving the data

Open Source R with

NEW

in-memory & massive

Mission critical OLTP
scale - multi-threading and
massive parallel processing
R built-in to SQL Server
Continuous Innovation

Hybrid cloud
Cloud-First Approach SQL Server 2016

New innovations
Continuous
enhancements

SQL DB SQL DB SQL DB SQL DB

Advanced Analytics

Across customer base

End-to-end mobile BI

Speed Proven Enterprise-grade DW The best

SQL Server
Agility Feedback Mission critical OLTP release in history
Cut storage costs with Stretch Database

Hybrid cloud
Stretch Database
NEW

with Always Encrypted

NEW

Microsoft Azure

Denny Usher ox7ff654ae6d 3/18/2005

Order history Stretch to cloud

Name SSN Date
Customer data
Philip Wenger cm61ba906fd 2/28/2005 Query
Denny Usher ox7ff654ae6d 3/18/2005
Product data
Alicia Hodge i2y36cg776rg 4/10/2005
Alta Levy
 Order History
nx290pldo90l 4/27/2005 App
Dionne Hardin ypo85ba616rj 5/12/2005
Kristy Flowers bns51ra806fd 5/22/2005
Sara Wiley mci12hh906fj 6/07/2005
Only Microsoft delivers

Hybrid cloud
On-premises & cloud
Consistent experience is everything
Upgrade easily
Without breaking changes
New tools built-in to ease upgrades

New upgrade advisors


Accelerate upgrade cycle
with new tools built-in

Upgrade and optimize

Clone Upgrade &
environment compatibility testing existing query plans with new
Query Data Store
NEW
Migrate from other top databases
With free tools from Microsoft
SQL Server migration assistant

Simplify migration to
SQL Server

Saves you time and money

SQL Server
Thousands of ISVs build on SQL Server
Healthcare Manufacturing Power & utilities Banking & capital markets Hospitality & travel
Customers using SQL Server for Tier 1
Appendix