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

See next feature

Statement auditing

View any SQL statement that was executed

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

See next feature

Login auditing

Review failed login attempts

See next feature

Security change auditing

Investigate permission, SQL login, user, password, and role changes

See next feature

Tamper-proof design

Determine if and when anyone attempted to tamper with the captured auditing data

See next feature

Alerts

Get notified of data and system events on specified SQL Server instances, from email notifications and the alert history dashboard

See next feature

Manage alerts

Easily manage alerting configuration – create, edit or remove alerts

See next feature

User friendly alert wizard

Create or edit alerts with ease using an intuitive wizard with powerful features

See next feature

Built in custom reports

Filter data by using a powerful expression editor. Choose audited data columns such as server name, query text, login, etc. to include in a custom report and save a report template for later use

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

Create custom reports via a web-based interface

See next feature

Custom web reports

Define custom reports via a web-based interface

See next feature

Custom alerts

Schedule execution of any SQL script to gather information like database size, amount of assigned memory, stored procedures results etc. and be alerted if the value is above some threshold

See next feature

Advanced filter

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

See next feature

Before-and-after auditing

Audit before and after data for Insert, Update and Delete data operations

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 2015 R1 Released ApexSQL Audit 2015 R3 Released ApexSQL Audit 2015 R4 Q4 ApexSQL Audit 2016 R1 Q1 ApexSQL Audit 2016 R2 Q3
Reporting
Custom reports in GUI
Statistical reports
Multiple simultaneous data sources
Reports on accessed columns
Auditing
Simple filter
Choose table columns (sensitive columns)
Advanced Filter
Filter by login
Filter by application name
Filter by operation
Filter by time
Filter by object name
Filter by object type
Filter by operation category
Filter by operation subcategory
Filter by database name
Filter by server name
Filter by transaction ID
Filter by schema name
Matching operators: like, not like, greater than and less than (in simple filter each value can be turned on or off, meaning that it is only equal or not equal matching operator)
The 'starts with' and 'ends with' operators
The 'is Null' and 'is not NULL' operators
Include/Exclude query text
Configuration templates
Trigger based Before-and-after auditing
CLR based Before-and-after auditing
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
Check data integrity on archived databases
Option to ignore specific detected tampering
CLI
CLI for exporting report
Alerting
Server management
Data alerts
Advanced alert filters
Sensitive columns alerts
Alerts on historical data (aggregated alerts)
Custom threshold
Custom SQL script alerts
Alerting options
Alert history date filter
Alert history severity filter
Notification editor (highlight and insert variables)
E-mail recipient list
Alert rule changed by
Log alert management changes
Import/export alert rules
Alert actions
Action templates
ApexSQL Audit log entry
Windows event log entry
Execute external application
Execute SQL script
Stop/restart auditing process
Archive central repository database
General
AlwaysOn Availability Group support
ApexSQL Audit 2015 R1 Released ApexSQL Audit 2015 R3 Released ApexSQL Audit 2015 R4 Q4 ApexSQL Audit 2016 R1 Q1 ApexSQL Audit 2016 R2 Q3

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)

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

See more solution center articles

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