Implementing (and cracking) new Security Features in SQL Server 2016, Part 1

SQL Server 2016 provides several new data security features like Always Encrypted, Dynamic Data Masking and Row-Level Security. These new features are 'game changer' to developers, DBAs, and above all to architects that need to design applications and Data platforms. These features increase the security and reduce the development time significantly.

Features that usually implemented in the application side, now can be implemented in the server side, while encryption keys, which are usually stored in the server side, can be stored in the client side.

The lecture will be held in two parts. In part one, we will explore the implementation of Dynamic Data Masking in the server side, using the new built-in feature in SQL Server 2016 and in older versions. We will discuss the benefits and limitations, and we will show some simple tricks to crack (bypass) the new feature and expose the masked data.

 

>> Here you can find part 2 event at the PASS DBA Virtual Chapter website: 
http://dba.sqlpass.org/Home.aspx?EventID=6543

 >> You can watch part 2 recording in this link: 
https://www.youtube.com/watch?v=jIB77xkAESs

>> The demos code and the presentation file for part 2 available to download from this link: 
https://gallery.technet.microsoft.com/Implementing-new-Security-7362f178