Built using the new rapid-release model, SQL Server 2016 incorporates many features introduced first in the cloud in Microsoft Azure SQL Database. Furthermore, SQL Server 2016 includes the capability to dynamically migrate historical data to the cloud.
Build mission-critical applications for online transaction processing (OLTP) with breakthrough scalability, in-memory performance, and high availability.
Protect data at rest and in motion with new Always Encrypted. SQL Server is the least vulnerable database for six years running in the NIST vulnerabilities database.
Transform data into actionable insights. Deliver insights on any device—online or offline—at one-fifth the cost of other business intelligence (BI) solutions.
Analyze operational data using R Services, in real time and at scale, directly within SQL Server database—without moving the data for analysis.