What is Microsoft SQL Server 2016 and new features, improvements

What is Microsoft SQL Server 2016 and new features, improvements

SQL Server 2016 is a version of Microsoft's relational database management system (RDBMS) that first became available in preview releases during 2015, with general availability on June 1, 2016. SQL Server 2016 is a SQL-based database designed to support a mix of transaction processing, data warehousing and analytics applications in enterprise environments.

With SQL Server 2016, you can build intelligent, mission-critical applications using a scalable, hybrid database platform that has everything built in, from in-memory performance and advanced security to in-database analytics. The SQL Server 2016 release adds new security features, querying capabilities, Hadoop and cloud integration, R analytics and more, along with numerous improvements and enhancements.

This page provides summary information and links to more detailed SQL Server 2016 what's new information for each SQL Server component.

Top 8 new features of SQL Server 2016

1. Always Encrypted

2. Dynamic Data Masking

3. Support for JSON

4. Row Level Security

5. PolyBase

6. Query Store

7. Stretch Database

8. R in SQL Server

SHARES

Share

Pin it

Tweet

Share

Share

Share

Buffer

Print

About Mariano

I'm Ethan Mariano a software engineer by profession and reader/writter by passion.I have good understanding and knowledge of AngularJS, Database, javascript, web development, digital marketing and exploring other technologies related to Software development.