More Related Content
What's hot (20)
Viewers also liked (18)
Similar to SQL Server on Linux - march 2017 (20)
More from Sorin Peste (8)
Recently uploaded (20)
SQL Server on Linux - march 2017
- 1. SQL Server on Linux Sorin Peste, Microsoft
- 2. SQL Server on Linux Why ? What ? When ? How ?
- 3. Businesses are embracing choice 1010 0101 0010 { } T-SQL Java C/C++ C#/VB.NET PHP Node.js Python Ruby Heterogenous environments Multiple data types Different development languages On-premises, cloud, and hybrid environments
- 4. Microsoft is delivering on choice HDInsight on Linux R Server on Linux Linux in Azure SQL Server drivers and connectivity Visual Studio Code extension for SQL Server Python, Ruby, …
- 5. Why ?
- 6. The world is demanding SQL Server on Linux 20K+applications for private preview Enterprise DB market runs on Linux 36%
- 7. Bringing SQL Server to Linux is another way we are making our products and new innovations more accessible to a broader set of users and meeting them where they are. Scott Guthrie Microsoft
- 8. What ?
- 9. 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 2/2016. Most consistent experience from on-premises to cloud Microsoft Tableau Oracle $120 $480 $2,230 Self-service BI per user built-inbuilt-in built-in built-in built-in at massive scale 0 1 4 0 0 3 34 29 22 15 5 22 6 43 20 69 18 49 3 0 10 20 30 40 50 60 70 80 1 2 3 4 5 6 SQL Server Oracle MySQL2 SAP HANA TPC-H Oracle is #5#2 SQL Server #1 SQL Server #3 SQL Server The power of SQL Server June 2016 SQL Server 2016
- 10. Only data solution to encrypt your data at rest and in motion Connect your relational data to big data with PolyBase Real-time operational analytics without impacting performance Up to 30x faster transactions, 100x faster queries with InMemory Unparalleled choice for developer tools and languages 1 T-SQL Java C/C++ C#/VB.NET PHP Node.js Python Ruby For all your applications Innovations across all editions Available now SQL Server 2016 SP1
- 11. For all your applications Innovations across all editions Available now SQL Server 2016 SP1
- 12. • Many Enterprise features now available across editions • Database Cloning • CREATE OR ALTER • Storage Class Memory • Lots of performance and troubleshooting improvements Features SQL Server 2016 SP1 – new features
- 13. On the platform of your choice SQL Server v.Next Targeting CY2017 SQL Server v.Next GA* SQL Server v.Next Public Preview available now on Linux, Windows, and Docker.
- 14. Database engine enhancements SQL Server on the platform of your choice Linux Linux/Windows container Windows Windows Server • Linux distributions including Red Hat Enterprise Linux (RHEL), Ubuntu, and SUSE Linux Enterprise (SLES) • Linux containers for Docker engine on MacOS, Windows and Linux; Windows and Hyper-V container for SQL Server on Windows • Package-based installation, yum install, apt-get, zypper and more options
- 15. Deploy your SQL Server license on Windows or Linux Get access to the latest release with Software Assurance Same license—new choices LICENSE
- 18. Developing new applications on Linux Choose your path Deploy your application Choose your development environment Upgrade to SQL Server v.Next Use simple backup and restore from Windows to Linux Go-live Deploy today and easily migrate to v.Next Test your app today and go live close to GA with the Early Adoption Program OR macOS
- 19. Migrate to SQL Server v.Next Get free SQL Server licenses today when you migrate!* Use migration tools and partners Identify apps for migration Run SQL Server v.Next Deploy to production Oracle Sybase DB2 AND OR Use simple backup and restore from Windows to Linux Go-live Deploy today and easily migrate to v.Next Test your app today and go live close to GA with the Early Adoption Program Software Assurance subscription required. Some restrictions may apply. Limited time offer—free training and subsidized deployment services available until December 31, 2016.
- 20. When ?
- 21. SQL Server v.Next Timeline 3/2016 Announce and private preview 11/2016 Public Preview @ Connect() Targeting CY2017 GA Monthly previews
- 22. • Support for RHEL, Ubuntu, Docker • Package based installs, Docker image • Failover Clustering through Pacemaker • Backup/Restore • SSMS on Windows connected to Linux • Command line tools: sqlcmd, bcp, sqlpackage • Log Shipping • Transparent Data Encryption • SCOM Management Pack • DMVs • AlwaysOn Availability Groups • Full text search Operations Features Programming Features • All major language driver compatibility • In memory OLTP and ColumnStore • Compression • Always Encrypted, Row Level Security, and Data Masking • Service Broker • Change Data Capture • Partitioning • Auditing • CLR • JSON, XML • Third party tools What’s working already? …and more!
- 23. • Mirroring • Replication • Windows Authentication • SQL Server Agent (coming CTP 1.4) • SQL Server Browser • SQL Server R Services • SSAS, SSRS, SSIS, DQS, MDS Operations Features Programming Features • Stretch DB • Polybase • XP_CMDSHELL What’s not available yet?
- 24. • SQL Server on Linux • Cluster-less Availability Groups • Temporal Tables Retention Policy • sys.dm_db_stats_histogram • Online non-clustered columnstore index build and rebuild • Linux process DMVs Operations Features Programming Features • In-memory: computed columns, JSON functions, CROSS APPLY • CONCAT_WS, TRANSLATE, TRIM • BULK INSERT from Azure BLOB storage • Clustered Columnstore Indexes now support LOB columns (nvarchar(max), varchar(max), varbinary(max)) What’s coming in vNext?
- 25. Download the bits www.sqlserveronlinux.com Join the SQL Early Adoption Program twright@microsoft.com
- 26. How ?
- 28. 2005: SQLOS
- 29. 2011: Library OS (project Drawbridge)
- 30. 2016: SQLOS + Library OS = SQLPAL