Transcript SQL_Server_Evolutionx

SQL Server Evolution
New innovations
Jen Underwood
Sr. Program Manager of Business Intelligence & Analytics
Microsoft
George Walters
Sr. Technical Solutions Professional, Data Platform
Microsoft
Applications
Reports
Dashboards
Natural
language
query
Mobile
Modeling
Machine
learning
Data
Orchestration
Information
management
The Microsoft
data platform
Relational
Non-relational
Complex event
processing

NoSQL
Streaming
Internal &
external
Cloud first
Speed
Agility
Proven
Feedback
All of this results in a better on-premises SQL Server
Announcing
SQL Server 2016
Do more. Achieve more.
In-memory enhancements
Operational analytics & enhanced performance
In-memory
SQL Server
ColumnStore
data warehouse
2-24
hrs
ETL
Fraud detected
Real-time
fraud
detection
0100101010110
In-memory
SQL Server
OLTP
Always Encrypted
Help protect data at rest and in motion, on-premises & cloud
Apps
SQL Server
Trusted
SELECT Name FROM
Patients WHERE SSN=@SSN
Client side
SELECT Name FROM
Patients WHERE SSN=@SSN
@SSN='198-33-0987'
Column
Master
Key
Result Set
Name
Jim Gray
Query
@SSN=0x7ff654ae6d
Enhanced
ADO.NET
Library
Result Set
Column
Encryption
Key
Name
Jim Gray
ciphertext
dbo.Patients
Name
SSN
Country
Jane Doe
243-24-9812 USA
1x7fg655se2e
Jim Gray
198-33-0987 USA
0x7ff654ae6d
John Smith
123-82-1095 USA
0y8fj754ea2c
Mission critical performance
Performance
Security
Availability
Scalability
Operational analytics
Always Encrypted
Enhanced AlwaysOn
Enhanced database
caching
In-memory OLTP for
more applications
Row Level
Security
Query data store
Dynamic Data
Masking
Native JSON
Temporal database
support
• 3 synchronous replicas for
auto failover across domains
• Round robin load balancing
of replicas
• DTC for transactional integrity
across database instances
with AlwaysOn
Enhanced online
operations
Support for Windows
Server 2016
• 12 TB memory support
Do more. Achieve more.
PolyBase
Query relational and non-relational data with T-SQL
Quote:
************************
T-SQL query
**********************
*********************
**********************
***********************
SQL Server
Name
DOB
State
Jim Gray
11/13/58 WA
Ann Smith 04/29/76 ME
Hadoop
$658.39
Built-in advanced analytics
In-database analytics at massive scale
Example Solutions
Extensibility
• Sales forecasting
R Integration
• Warehouse efficiency
• Predictive maintenance
R
?
New R scripts
• Credit risk protection
010010
100100
010101
Analytic Library
010010
100100
010101
Data Scientist
Interact directly with data
010010
100100
010101
T-SQL Interface
Relational Data
Built-in to SQL Server
Data Developer/DBA
Manage data and
analytics together
010010
100100
010101
010010
100100
010101
Microsoft Azure
Marketplace
Rich visualizations on mobile devices
Business insights through rich visualizations
on any device. Native apps for Windows,
iOS and Android
Demo
Jen Underwood
Deeper insights across data
Access any data
Scale and manage
Powerful insights
PolyBase
Enterprise-grade
Analysis Services
Built-in advanced analytics
Power Query for analytics
and reporting
Enhanced SSIS
• Designer support for previous
SSIS versions
• Support for Power Query
New single SSDT in
Visual Studio 2015
Enhanced MDS
• Excel add-in 15x faster
• More granular security roles
• Archival options for transaction logs
• Reuse entities across models
Business insights through
rich visualizations on
mobile devices
Enhanced Reporting
Services
Do more. Achieve more.
Stretch SQL Server into Azure
Stretch warm and cold tables to Azure with remote query processing
Microsoft Azure
Jim Gray
Order history
Name
ox7ff654ae6d
3/18/2005
Stretch to cloud
SSN
Jane Doe
Date
Customer data
cm61ba906fd 2/28/2005
Jim Gray
ox7ff654ae6d
3/18/2005
Product data
John Smith
Bill Brown
i2y36cg776rg 4/10/2005
Order History
nx290pldo90l 4/27/2005
Sue Daniels
ypo85ba616rj
5/12/2005
Sarah Jones
bns51ra806fd
5/22/2005
Jake Marks
mci12hh906fj
6/07/2005

Query
App
Hyperscale cloud
Hybrid solutions
Simplicity
Consistency
Stretch tables into Azure
Easy migration of on-premises
SQL Server
Common development,
management and
identity tools
Power BI with on-premises data
Hybrid scenarios with SSIS
Enhanced backup to Azure
Simplified Add Azure
Replica Wizard
Consistent experience
from on-premises to Azure
SQL Server 2016
Introducing Azure SQL Data Warehouse
Separate storage & compute
Elastic scale
Integration with Power BI, ADF,
and Machine Learning services
Scale-out relational
data warehouse
Applications
Reports
Dashboards
Orchestration
Information
management
Complex event
processing
Natural
language
query
Mobile
Modeling
Machine
learning
The Microsoft
data platform

Relational
Non-relational
NoSQL
Streaming
Internal &
external
 Check out all the data sessions
 Pre-register for the SQL Server 2016 CTP &
Azure SQL DW previews
http://www.Microsoft.com/mcpnews
© Microsoft 2015. All rights reserved.