GDPR, SHIELD and CCPA have put data privacy in the spotlight. Are your database processes fully compliant while you still deliver faster than ever?
SQL SERVER – Authentication in SQL Server (Windows and Mixed Mode) – GDPR Series
Part of my GDPR series: Authentication in SQL Server, Windows and Mixed Mode, and how it helps with GDPR Article 25, data protection by design and default.
SQL SERVER – How to Make SQL Server GDPR Compliance?
Readers ask me about GDPR Compliance for SQL Server all the time. It is really about your business practice. Here is a brief on GDPR and where SQL Server fits.
SQL Server Audit: Tracking Who Read or Changed Sensitive Tables
Configure SQL Server Audit for reads and changes, inspect file records by user and time, and plan retention and target failures.
SQL SERVER – Exploring SQL Auditing with SQL Compliance Manager
Who is accessing our data, and is it secure at rest? A chat with a junior DBA about SQL auditing and how SQL Compliance Manager helps answer those questions.
Auditing SELECT Statements on Sensitive Tables
Auditing SELECT statements on sensitive tables needs a narrow database audit, protected files, volume checks, and active review.