LAST LECTURE AT SIPOD

Our first cycle of lectures has ended this Thursday. But, no need for tears, because we will start with new lectures very soon.

Our last was about new features in SQL 2014 and 2016 and it was held by our newest colleague Aleksandar.

We will mention only a few new features in both SQL 2014 and SQL 2016, and if you are interested to find more about this topic, you can read a text in the link below.

When we talk about SQL Server 2014 it is necessary to mention that it enables memory optimization of selected tables and stored procedures.

1. AlwaysOn integration has been enhanced, and now the maximum number of secondary replicas is eight. Readable secondary replicas are available for read workloads, 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 creates 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. It supports various encryption algorithms such as Advanced Encryption Standard (AES) 128, AES 192, AES 256, and Triple DES.

As regards SQL Server 2016, Microsoft has designed it with intention to build critical applications and advanced programs by using a hybrid database platform. It has an advanced security, in-database analytics and in-memory performance.

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. 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 and other applications. The SQL 2016 is able to analyze JSON formatted data and convert relational data into JSON format.

If you want to find out more about SQL click on the links below.

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

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