New Security Features in SQL Server 2016
It seems like that every month we hear about another company having a major data breach. GDPR raises the stakes with huge fines for those that lose or don't keep data safe. Ensuring that your data is secure has become more important than ever. With this in mind, in SQL Server 2016, Microsoft gave us three new features that have the potential to improve the security of your SQL database, either on premises or in the cloud. These are:
Dynamic Data Masking which allows us to obfuscate data in real time
Always Encrypted which helps protect data both at rest and in motion with a master key
Row Level Security that gives us control over who can see which rows in a table based on the user's rights
In this presentation we will have an overview of these important security features and demos on how to configure them and make them work.