A collection of articles covering SQL Server audit topics
SQL Server audit for who saw what
SQL Server audit log for Before-after changes
SQL Server audit log for Security changes
- Track SQL Server database security changes
- SQL Server database security auditing
- Auditing security changes in SQL Server
- SQL Server database security and compliance
- Audit failed SQL Server logins – Part 1 – distributed queries, brute force attacks, and SQL injections
- Audit failed SQL Server logins – Part 2 – using native tools to investigate failed logins
- Audit failed SQL Server logins – Part 3 – the solution
- Tracking SQL Server object usage
- Using SQL Server database snapshots to protect yourself against accidental data modification
Specific events alerting
- Managing low storage space using SQL audit tool features and automation
- SQL Server auditing – how to be alerted about important auditing events
- How to automatically revert database changes based on SQL auditing alerts using SQL Server transaction logs
Using tracing for a SQL Server audit log
- How to ensure continuous auditing of SQL Server with zero audited data loss
- Using SQL Server traces for SQL Server auditing – Part 1 – The default trace
- Using SQL Server traces for SQL Server auditing – Part 2 – Querying a SQL Server trace
- Using SQL Server traces for SQL Server auditing – Part 3 – The out-of-the-box solution
- SQL Server true detective – Solving the case of the broken database
SQL Server audit log Compliance standards
- How to easily pass SQL Server audits using a third-party software solution
- Security and compliance in SQL Server
- SQL Server compliance requirements
SQL Server audit for HIPAA compliance
- HIPAA Compliance for SQL Server DBAs
- How to meet requirements of HIPAA compliance as a part of a SQL Server audit
- How to implement HIPAA regulatory standard for SQL Server – Part 1
- How to implement HIPAA regulatory standard for SQL Server – Part 2
- How to implement HIPAA regulatory standard for SQL Server – Part 3
SQL Server audit for CFR 11 compliance
- SQL Server compliance auditing for Title 21 Code of Federal Regulations Part 11 requirements – Part 1
- SQL Server compliance auditing for Title 21 Code of Federal Regulations Part 11 requirements – Part 2
SQL Server audit for PCI compliance
- PCI Compliance for SQL Server DBAs
- Meeting PCI compliance requirements with SQL Server
- How to implement compliance with the PCI DSS regulatory standard for SQL Server – Part 1
- How to implement compliance with the PCI DSS regulatory standard for SQL Server – Part 2
- How to implement compliance with the PCI DSS regulatory standard for SQL Server – Part 3
- How to implement compliance with the PCI DSS regulatory standard for SQL Server – Part 4
SQL Server audit for SOX compliance
- SOX survival kit for the SQL Server DBA
- Meet SQL Server auditing requirements of Sarbanes-Oxley (SOX)
- How to implement SOX compliance requirements for SQL Server – Part 1
- How to implement SOX compliance requirements for SQL Server – Part 2
SQL Server audit for General Data Protection Regulation (GDPR)
- General Data Protection Regulation (GDPR) compliance for SQL Server
- How to implement compliance with GDPR for SQL Server
- GDPR survival kit for SQL Server DBAs – SQL Server auditing and best practices
SQL Server audit for FERPA compliance auditing
SQL Server audit for Basel II compliance
SQL Server audit for GLBA compliance
Change Data Capture (CDC)
- What is SQL Server Change Tracking and how to set it up?
- How to read SQL Server Change Tracking results
- SQL Server Change Data Capture (CDC) – Introduction
- How to enable and use SQL Server Change Data Capture
- How to analyze and read Change Data Capture (CDC) records
SQL Server Audit
- SQL Server Audit feature – Introduction
- How to ensure continuous auditing and reporting in SQL Server
- SQL Server database auditing techniques
- How to set up and use SQL Server Audit
- How to analyze and read SQL Server Audit information
- How to ensure a tamper-proof auditing
- SQL auditing tools overview
- Auditing SQL Server data changes – the centralized solution
- Top features you need in SQL Server auditing solution
- How to create a database auditing trail
- How to protect sensitive data in SQL Server
- Top critical events in any SQL Server audit strategy
Database auditing
- Database auditing – control and monitor sensitive data access in SQL Server
- How to track data changes using database auditing techniques
- How to configure SQL auditing data central repository automatic backups
Reporting solutions
- Extract SQL Auditing data into Power BI
- How to automate event data extraction using SQL audit reporting API
