ENHANCED FEATURES FOR SQL 2014 AND 2016

The first cycle of lectures at Sipod has ended but no worry, we’ll back soon. Our colleague Aleksandar had the honor to hold the last lecture and decided to share with us enhanced features for SQL 2014 and 2016.

For the purpose of this text, we will mention only a few features for both SQL 2014 and SQL 2016, and if you find it interesting click on the links below.

NEW FEATURES FOR SQL 2014

Some of enhanced features for SQL 2014 are :

1. AlwaysOn integration has been enhanced, so now the maximum number of secondary replicas is eight. Readable secondary replicas are available for read workloads. Therefore it doesn’t no matter whether the primary replica is unavailable or not.

2. Power View multidimensional models support queries using Data Analysis Expressions (DAX). With SQL Server 2014, you can use Power View with multidimensional models (OLAP cubes) and create a variety of data visualizations such as tables, matrices, or bubble charts.

3. SQL Server 2014 is able to encrypt database backups for at-rest data protection. Besides that, it supports various encryption algorithms such as Advanced Encryption Standard (AES) 128, AES 192, AES 256, and Triple DES. NEW

NEW FEATURES FOR SQL 2016

Some of enhanced features for SQL 2016 are:

1. The ability of the AlwaysOn to have around three synchronous replicas so it could support availability and disaster recovery functions, have also been improved in SQL 2016 version.

2. The major development in SQL 2016 is the Row Level Security feature. It serves to restrict some users to view data in tables by using a SQL Server login. Additionally, SQL 2016 allows the implementation of row level security so that new users are not able to detect whether the rows of data were filtered for restricting data.

3. The JavaScript Object Notation feature allows a mutual exchange of  JSON data between the SQL Server database engine as well as other applications. The SQL 2016 is able to analyze JSON formatted data and convert relational data into JSON format.

For more info about this topic click on the following links:

https://www.microsoft.com/en-us/sql-server/sql-server-2016

https://www.microsoft.com/en-us/download/details.aspx?id=42299