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]