Thursday, May 14, 2015

SQL Server 2016 public preview coming soon

Highlights of the upcoming public preview of SQL server 2016 features:

  • Dynamic Data masking
  • Row-level Security 
  • Three synchronous replicas on AlwaysOn
  • Native JSON support (Now supporting the world of Big Data)
  • More improvements on hybrid backups (pushing more of cloud)
  • Built-in advanced analytic, polybase and mobile BI
  • Real-time Operational Analytics & In-Memory OLTP
  • Stretch database. New technology that allows you to dynamically stretch your warm and cold transnational data to Microsoft Azure
  • Always  encrypted : as per T.K. Ranga Rengarajan blog "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"

No comments: