The release of Microsoft SQL Server 2016 grants users the largest update in Microsoft's data platform with real-time operational analytics, brand new visualizations for mobile devices, built-in advanced analytics, an updated security protocol, and new hybrid cloud scenarios.
Learn more about what you can acheive with the increasingly powerful SQL Server 2016
- Query Store:
The Query Store feature offers users the option to save their query execution plans with their performance & data. This allows you to locate query deceleration and allows admins or developers to force the use of an older better plan if necessary.
PolyBase is a new featured technology that allows access to data outside of the database via the T-SQL language. New to the 2016 version, this allows you to run queries on external data connecting with Hadoop or Azure Blob Storage, making large text file processing a breeze!
- JSON Support:
- Stretch Database:
Stretch Database provides a cost-effective availability with cold-data. Microsoft allows parts of your tables to be moved into an Azure SQL Database hosted on a secure cloud. On-premises instances can access this remote endpoint data with no application changes.
- In-Memory OLTP Enhancements:
Growing off of the concept introduced in SQL Server 2014, in-memory enhancements were designed to optimize high speed data loading with no locking issues. SQL Server 2016 OLTP Enhancements are reinstated to work at RAM speed, and boasts a larger table support size at up to 2 TB (from 256 GB)! This updated feature now offers support for Clustered Indexes, Check Contraints, Foreign Keys, and Parallelism.
- Always Encrypted:
Never go unprotected with the Always Encrypted feature built in to SQL Server 2016. This compenent is designed to conceal sensitive data, such as credit card numbers an SSNs, from cyber snipers. Always Encrypted will allow clients to keep secure data inside client apps and never expose the encryption keys to the Database Engine. This will permiss seperation of those who ultimately own the data versus those who only manage the data.
- Row Level Security
Row Level Security (RLS) adds the option to functionally restrict which users can view what data in a table. This new feature implemented in SQL Server 2016 will allow Admins to easily control the data based on User ID or security context.