The successor to SQL Server 2014 will include enhanced in-memory technologies, real-time operational analytics, new security and encryption technologies, built-in advanced analytics with the R language and mobile business intelligence for on-premises data, officials said this week.
SQL Server 2016 will include a new Stretch Database feature that will provide access to historical data by "dynamically stretching" warm and cold transactional data to Microsoft Azure, so that users will have an easier time getting immediate access to that data.
"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. 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 real-time operational analytics."
The Polybase data-processing engine that's been part of the SQL Server Parallel Data Warehouse appliance will now be built into the core SQL Server 2016 product.