New blog post on SQLShack this time i am walking through the new feature Dynamic Data Masking in SQL 2016
This feature enables you to mask data dynamically for your applications, and other data consumers, which should not be allowed to have full access to all data. Continue reading →
Just had my post on Always Encrypted feature in SQL Server 2016 going online at www.sqlshack.com.
This feature will make sure your data is encrypted all the way from the database and to the client application, and back again. Continue reading →
The other day one of my clients asked me if there was any way to audit what users did on their data, and in particular some tables of importance. I had to look it up, well I knew that there was some Audit possibilities build into SQL Server, but I had never had the need for it before. Continue reading →