Dynamic Data Masking in SQL 2016

2015-07-23 10_51_06-sqlserver2016ctp2technicallevel300deck-150706223653-lva1-app6892.pptx - PowerPoiNew 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 →

Audit on SQL Server

ShowImageThe 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 →