You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 
Audit all SQL database and security activities
Meet compliance requirements e.g. HIPAA, PCI
Out-of-the-box and custom Win and Web reporting
Securely store audit data in a tamper-evident repository
Fully customize all auditing, alerts, and reporting
Who, what, where, and when type auditing
Deploy on SQL Server Failover Clusters
Easily manage auditing on multiple servers

Features

SQL Server activity auditing

Audit all operations performed on your SQL instances including DML and DDL changes, select statements as well as login, user, and permission related activities. Learn more

See next feature

Statement auditing

View any SQL statement that was executed. Learn more

See next feature

Who, what, from where, and when auditing

Find out the name of the login, computer, and application used as well as the time when the activity occurred. Learn more

See next feature

Login auditing

Review failed login attempts. Learn more

See next feature

Security change auditing

Investigate permission, SQL login, user, password, and role changes. Learn more

See next feature

Before-and-after auditing

Audit before and after data for Insert, Update and Delete data operations. Learn more

See next feature

Tamper-evident design

Easily determine if there was any tampering of collected data. Learn more

See next feature

Alerts

Get notified of data and system events on specified SQL Server instances, using email notifications and the alert history dashboard. Learn more

See next feature

Out-of-the-box reports

Quickly review captured information leveraging 10+ easy to use built-in reports

See next feature

Web reports

Define custom reports via a web-based interface. Learn more

See next feature

Advanced filter

Set up a powerful expression editor to filter audited data, reports results, and alert conditions. Learn more

See next feature

Roadmap

Before and after auditing

Show full audit trail including data as it existed before and after a change

Advanced archive

Choose to archive from specific time: last week, last month, last year or just by specific date

Improved reports

Export reports using CLI. Generate reports from multiple simultaneous data sources.

See our entire roadmap

The roadmap does not show maint only releases


ApexSQL Audit 2016 R2 Released ApexSQL Audit 2016 R4 Q4 ApexSQL Audit 2017 R1 Q1
Reporting
Custom reports in GUI
Multiple simultaneous data sources
Predefined reports for HIPAA, SOX, FDA and PCI standards
Statistical reports
Reports on accessed columns
Dedicated before-after report
Scheduler for exporting reports and data collection
Relative date filter
Filter before-after events by column and value
Auditing
Simple filter
Choose table columns (sensitive columns)
Advanced Filter
Configuration templates
The 'starts with' and 'ends with' operators
The 'is Null' and 'is not NULL' operators
Include/Exclude query text
CLR trigger based Before-and-after auditing
Database encryption for before-after data
Saving configuration to file system
Custom trace file size
Custom package file size
Statistics & Status
Advanced system status
Detailed info about each auditing instance
Detailed info about central instance
Aggregate preview on collected data per system and per instance
Graphical preview on collected data per system and per instance
Health information - diagnostic window, allows detecting system wide issues and suggest possible solutions
Archiving & Purging
Choose to archive from specific time: last week, last month, last year or just by specific date
Purge data from specific time range
Remove or backup database on uninstall
Data integrity
Option to ignore specific detected tampering
Alerting
Data alerts
Sensitive columns alerts
Alerts on historical data (aggregated alerts)
Custom threshold
Alerting options
Notification editor (highlight and insert variables)
E-mail recipient list
Import/export alert rules
Alert actions
Windows event log entry
General
AlwaysOn cluster support
Automatic auditing instance deployment
ApexSQL Audit 2016 R2 Released ApexSQL Audit 2016 R4 Q4 ApexSQL Audit 2017 R1 Q1

Content

SQL Solution Center articles

Auditing SELECT statements on SQL Server

Track SQL Server database security changes

SQL Server database auditing techniques

SQL Server database security and compliance

HIPAA Compliance for SQL Server DBAs

SQL Server auditing – how to get notified about an event

Security and compliance in SQL Server

Tracking SQL Server object usage

Auditing security changes in SQL Server

How to meet requirements of HIPAA compliance as a part of a SQL Server audit

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

Meeting PCI compliance requirements with SQL Server

Meet GLBA compliance requirements for SQL Server

SOX survival kit for the SQL Server DBA

SQL Server auditing and compliance for FERPA

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

How to audit SQL Server to comply with Basel II

Methods for auditing SQL Server data changes – Part 1 – Change tracking

Methods for auditing SQL Server data changes – Part 2 – reading the Change Tracking results

Methods for auditing SQL Server data changes – Part 3 – Change Data Capture features

Methods for auditing SQL Server data changes – Part 4 – Change Data Capture set up

Methods for auditing SQL Server data changes – Part 5 – reading the Change Data Capture records

Methods for auditing SQL Server data changes – Part 6 – the SQL Server Audit feature

Methods for auditing SQL Server data changes - Part 7- the SQL Server Audit feature set up

Methods for auditing SQL Server data changes - Part 8 - reading the SQL Server Audit information

Methods for auditing SQL Server data changes – Part 9 – the centralized SQL auditing solution

How to audit your auditing in SQL Server – tracking when triggers are disabled

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

PCI Compliance for SQL Server DBAs

GLBA Compliance for SQL Server DBAs

Basel II Compliance for SQL Server DBAs

How to ensure continuous auditing of SQL Server with zero audited data loss

SQL Server database security auditing

Before and after auditing in SQL Server

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

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 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 before and after auditing of DML/data changes

SQL Server compliance requirements

See more solution center articles

ApexSQL Audit datasheet

Check out what ApexSQL Audit has to offer in order to meet the increasing demands DBAs face for auditing and compliance requirements.
Learn more about the most used features and advantages of ApexSQL Audit

Advantages of ApexSQL Audit

This blog article provides an overview of some important ApexSQL Audit advantages over similar tools and insight in some unique features specific for ApexSQL Audit

PCI compliance checklist for ApexSQL Audit

This article describes the PCI DSS compliance requirements for SQL Server database administrators and describes whether, how, and to what extent ApexSQL Audit can help an organization fulfill these requirements

HIPAA compliance checklist for ApexSQL Audit

This article describes the HIPAA compliance requirements that concern SQL Server database administrators and describes whether, how, and to what extent ApexSQL Audit can help an organization fulfill these requirements

SOX compliance checklist for ApexSQL Audit

This article describes the SOX compliance requirements that concern SQL Server database administrators and describes whether, how, and to what extent ApexSQL Audit can help an organization fulfill these requirements

Title 21 CFR Part 11 (FDA) compliance checklist for ApexSQL Audit

This article describes the FDA compliance requirements that concern SQL Server database administrators and describes whether, how, and to what extent ApexSQL Audit can help an organization fulfill these requirements

FISMA (NIST800-53 rev. 4) compliance checklist for ApexSQL Audit

This article describes the FISMA compliance requirements that concern SQL Server database administrators and describes whether, how, and to what extent ApexSQL Audit can help an organization fulfill these requirements

Testimonials

A word of congratulations. I think that your suite is some of the best stuff I have ever used. I had to add auditing to an existing SQL Server and your ApexSQL Audit product did that effortlessly and flawlessly. The client loves the solution I am also impressed by your rapid response to issues and feedback. Keep up the good work

Cameron Townshend

Executive Consultant

ISG Technology

See all of our

Killer tools for SQL
Server auditing

ApexSQL Audit

Fault tolerant auditing, centralized storage and reporting

ApexSQL Log

Forensic auditing using the SQL transaction log

ApexSQL Trigger

Trigger based data auditing for client apps

Save a bundle

ApexSQL Audit is included in ApexSQL DBA

6 ApexSQL server tools

Priority support

1 year free support and upgrades

New products added for free

Combined 65% savings

For only $800 more