{"id":123,"date":"2015-05-04T07:30:00","date_gmt":"2015-05-04T14:30:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2015\/05\/04\/sql-server-2016-public-preview-coming-this-summer\/"},"modified":"2024-01-22T22:52:16","modified_gmt":"2024-01-23T06:52:16","slug":"sql-server-2016-public-preview-coming-this-summer","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/05\/04\/sql-server-2016-public-preview-coming-this-summer\/","title":{"rendered":"SQL Server 2016 public preview coming this summer"},"content":{"rendered":"

Satya Nadella, CEO of Microsoft, announced SQL Server 2016<\/a>, an intelligent platform for a mobile first, cloud first world.\u00a0 The next major release of Microsoft\u2019s flagship database and analytics platform provides breakthrough performance for mission critical applications and deeper insights on your data across on-premises and cloud. Top capabilities for the release include: Always Encrypted – a new capability that protects data at rest and in motion, Stretch Database – new technology that lets you dynamically stretch your warm and cold transactional data to Microsoft Azure, enhancements to our industry-leading in-memory technologies for real-time analytics on top of breakthrough transactional performance and new in-database analytics with R integration.\u00a0<\/p>\n

Always Encrypted<\/b><\/p>\n

Data security is top of mind, especially for mission critical applications, and SQL Server has been the enterprise database with the fewest security vulnerabilities six years running.* \u00a0To help customers with data security and compliance when using SQL Server on-premises or in the cloud, we are introducing Always Encrypted. Always Encrypted, based on technology from Microsoft Research, protects data at rest and in motion. With Always Encrypted, SQL Server can perform operations on encrypted data and best of all, the encryption key resides with the application in the customers trusted environment. Encryption and decryption of data happens transparently inside the application which minimizes the changes that have to be made to existing applications.<\/b><\/p>\n

\"<\/a>
<\/b><\/p>\n

Stretch Database<\/b><\/p>\n

Today, in the Ignite keynote, we showcased how you can gain the benefits of hyper-scale cloud in the box with new hybrid scenarios including Stretch Database. As core transactional tables grow in size, you may need to archive historical data to lower cost and to maintain fast performance. This unique technology allows you to dynamically stretch your warm and cold transactional data to Microsoft Azure, so your operational data is always at hand, no matter the size, and you benefit from the low cost of using Microsoft Azure.\u00a0 You can use Always Encrypted with Stretch Database to extend your data in a more secure manner for greater peace of mind.<\/p>\n

\"<\/a><\/p>\n

Real-time Operational Analytics & In-Memory OLTP<\/b><\/p>\n

Building on our industry leading and proven in-memory technologies, customers will benefit from the combination of real-time operational analytics with blazing fast transactional performance – a first among enterprise vendors.\u00a0 For In-Memory OLTP, which customers today are using for up to 30x faster transactions than disk based systems, you will now be able to apply this technology tuned for transactional performance to a significantly greater number of applications as well as benefit from increased concurrency.\u00a0 With these enhancements, we also introduce the unique capability to use our in-memory columnstore delivering 100X faster queries with in-memory OLTP for in-memory performance and<\/span> real-time operational analytics.<\/b><\/p>\n

\"<\/a><\/p>\n

Built-in Advanced Analytics, PolyBase and Mobile BI<\/b><\/p>\n

For deeper insights into data, SQL Server 2016 expands its scope beyond transaction processing, data warehousing and business intelligence to deliver advanced analytics as an additional workload in SQL Server with proven technology from Revolution Analytics.\u00a0 We want to make advanced analytics more accessible and increase performance for your advanced analytic workloads by bringing R processing closer to the data and building advanced analytic capabilities right into SQL Server.\u00a0 Additionally, we are building PolyBase into SQL Server, expanding the power to extract value from unstructured and structured data using your existing T-SQL skills. With this wave, you can then gain faster insights through rich visualizations on many devices including mobile applications on Windows, iOS and Android.<\/p>\n\n\n\n
\n

\"<\/a><\/p>\n<\/td>\n

\n

\"<\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Additional capabilities in SQL Server 2016 include:<\/b><\/p>\n