SQL Server 2016 provides several new data security features like Always Encrypted, Dynamic Data Masking and Row-Level Security. These new features are game changers for developers and application architects. For example, features that are usually implemented in the application side 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. In this session we will explore the implementation of these features in older versions of SQL Server in the server side and/or in the application side, and we will demonstrate the use of the new built-in features in SQL Server 2016. We will compare flexible custom implementations to the benefits and limitations of using the built-in features.
For feedback, Question and coment please feel free to contact me on Facebook