This page shows the posts published with the category 'SQL'

What's new in SQL Server 2016: Always encrypted

The final version of SQL Server 2016 has been released recently. So it's time to take a look at the new features provided by this version. Today we will discover the Always Encrypted feature. Encrypting sensitive data such as some personal information is a plus for security. Currently, SQL Server offers encryption features with TSQL ENCRYPTBY... functions to encrypt a value. Insertion or selection… [read more]

What's new in SQL Server 2016: Live Query Statistics

The final version of SQL Server 2016 has been released recently. So, it's time to take a look at the new features provided by this version. Today we will discover Live Query Statistics. SQL Server 2014 introduced the DMV sys.dm_exec_query_profiles (doc) to get information about the progress of a running query. Live Query Statistics adds a graphical interface to this DMV. Indeed Live Query Statistics… [read more]

What's new in SQL Server 2016: Stretch Database

The final version of SQL Server 2016 has been released recently. So it's time to take a look at the new features provided by this version. Today we will discover the Stretch Database. Stretch Database allows you to archive tables containing historical data. For example, an Order table may contain very recent data, but also older data. The idea is to keep recent data in the local database and archive the… [read more]

What's new in SQL Server 2016: Row-Level Security

The final version of SQL Server 2016 has been released recently. So, it's time to take a look at the new features provided by this version. Today we will set up Row-Level Permissions. This new feature allows you to create implicit filters on tables based on the currently logged on user. For example a salesman will only see his orders while a manager will see all the orders and that with the same query… [read more]

What's new in SQL Server 2016: Dynamic Data Masking

The final version of SQL Server 2016 has been released recently. So it's time to take a look at the new features provided by this version. Today we will see Dynamic Data Masking. This feature already available on SQL Azure for some time is now available to SQL Server. In some tables we may be brought to store sensitive information, or at least information that we do not want all users can access: blue… [read more]

Exploring the SQL Server Database Project in Visual Studio

With the advent of ORMs such as Entity Framework, developers often forget the issues related to database developments. Indeed, ORMs and similar tools often deal with generating the schema (tables, columns) of the database as well as generating SQL queries without the developer writing a single line of SQL. Although this is very practical, a database is not limited to just that. There are stored… [read more]