Transcript
Overview of Microsoft SQL Server on SUSE ®
Tommy Mullaney Program Manager, Microsoft SQL Server
[email protected] | @tmullaney33 | linkedin.com/in/tmullaney
Empowering every person and organization
{} 1010 0101 0010
Data types
Windows Server Java
PHP
Node.js
Python
C/C++
Ruby
C#/VB.NET
R
Languages
Linux
Clouds
Platforms
Committed to choice. 2
Why SQL Server? Industry leader
1
1
Most secure
Gartner Magic Quadrant leadership
Highest performing
All built-in
#1 performance
6 years in a row least vulnerable
built-in
12x savings relative to Oracle
80
12x
69 70 60 49 50
43
40
SQL Server SQL Server
34
SQL Server
29 30
2220
22 18
15
20 6
10 0
5
4
1
0
3
0
3
0 2010
2011
SQL Server
2012
Oracle
2013
MySQL
2014
2015
SAP HANA
#1
#2
#3 TPC-H
Oracle is #6
Microsoft
*Gartner “Magic Quadrant for Operational Database Management Systems,” by Donald Feinberg , Merv Adrian, Nick Heudecker, Adam Ronthal, October 2015. “Magic Quadrant for Business Intelligence and Analytics Platforms,” by Josh Parenteau, Rita L. Sallam, Cindi Howson, Joao Tapadinhas, Kurt Schlegel, Thomas W. Oestreich, February 4, 2016. Institute of Standards and Technology Comprehensive Vulnerability Database update February 2016. 4 http://www.tpc.org/tpch/results/tpch_perf_results.asp?resulttype=noncluster; http://www.tpc.org/tpce/results/tpce_perf_results.asp?resulttype=NONCLUSTER&version=1%¤cyID=0
Oracle
1
2 *Gartner 3 National
3
SQL Server on Linux Private Preview 22.21K preview signups
55% of Fortune 500 in first week
4
What’s working already? Operations Features
Programming Features
Support for RHEL, Ubuntu, Docker
All major language driver compatibility
• SLES very soon… demo today!
In-Memory OLTP
Package-based installs
Columnstore
Docker image
Query Store
Support for Open Shift, Docker Swarm
Compression
Failover Clustering via Pacemaker
Always Encrypted
Backup / Restore
Row-Level Security, Data Masking
SSMS on Windows connected to Linux
Auditing
Command line tools: sqlcmd, bcp, sqlpackage
Service Broker
Transparent Data Encryption
Change Data Capture
Backup Encryption
Partitioning
SCOM Management Pack
CLR
DMVs
JSON, XML Third-party tools
..and more!
5
Demo time!
6
What’s next? More features: • • • •
SLES Support Always On Availability Groups Full-Text Search Active Directory Authentication
Work closely with partners to support SQL Server on Linux SQL Early Adoption Program (SQL EAP)
March 2016
Nov 2016
TBD
Mid-2017
Announce and kick-off private preview
SUSECON
Public Preview
General Availability 7
Get involved! Sign up for private preview and for email notifications & surveys Watch for announcements at Connect() Email
[email protected] if you are interested in Early Adoption Program Come talk to me at the Microsoft booth! Tommy Mullaney Program Manager, Microsoft SQL Server
[email protected] | @tmullaney33 | linkedin.com/in/tmullaney 8
System Architecture System Resource & Latency Sensitive Code Paths Everything else
RDBMS
AS
IS
RS
SQL Platform Abstraction Layer (SQLPAL)
Win32-like APIs SQL Platform Abstraction Layer (SQLPAL) Windows Host Ext.
Linux Host Extension
Windows
Linux
SQL OS API
SQL OS v2
Host Extension mapping to OS system calls (IO, Memory, CPU scheduling) 9
