You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

Tools for Security and Compliance ApexSQL Security and Compliance Toolkit for SQL Server
Tools for DBAs and Operations Engineers ApexSQL Operations Toolkit for SQL Server
Tools for SQL Server Professionals ApexSQL Fundamentals Toolkit for SQL Server
Tools for Developers and DevOps Engineers ApexSQL DevOps Toolkit for SQL Server
Tools for MySQL Professionals ApexSQL Fundamentals Toolkit for MySQL Server
Spotlight Cloud hosted SQL Server monitoring and diagnostics
LiteSpeed High-speed SQL Server backup, compression and restore
 

SQL Server audit and compliance

Meet SQL Server audit and compliance requirements for all instances across your enterprise

ApexSQL Audit header image
ApexSQL Audit
Features Resources Gallery Compliance Compare
Free trial
Audit all SQL database and security activities
Meet compliance requirements e.g. HIPAA, GDPR, PCI
Out-of-the-box and custom reporting
Securely store audit data in a tamper-evident repository
Fully customize all auditing, alerts, and reporting
Who, what, where, when and before-after auditing
Deploy on SQL Server Failover Clusters
Easily manage auditing on multiple servers
User access management
Easy-to-use API for reporting

Features

Built in reporting API

Extract raw data using the built-in reporting API and analyze it with Power BI or other solutions. Learn more

fancy
See next feature

Automatic database auditing

Automatically include newly created databases for auditing with predefined auditing configuration. Learn more

fancy
See next feature

Group managed service account support for agent deployment

Access the audit administration using managed domain account with automatic password management. Learn more

fancy
See next feature

Sensitive columns auditing and classification

Automatically detect columns with sensitive data and audit the read access to them. Learn more

fancy
See next feature

Customizable auditing and compliance templates

Use existing out-of-the-box templates to configure SQL Server instance auditing and ensure that the auditing configuration includes all SQL Server and database level events required to meet HIPAA, SOX, PCI, FERPA and other compliance standards. Customize existing templates or create your own and apply them to multiple SQL Servers with a single click

fancy
See next feature

Who, what, when and how auditing

Identify, track and receive alerts when specific objects are accessed or data was viewed. Find out the name of the login, computer, and application used to access audited objects as well as the time of the event. Learn more

fancy
See next feature

Before-and-after auditing

Audit data changes from insert, update and delete operations. Investigate and compare original values to the new ones. Include additional columns in reports for tracking. Learn more

fancy
See next feature

Application and login level auditing

Audit operations executed by specific users, including high privilege users, or choose to perform full auditing of database changes from specific applications

fancy
See next feature

Customizable and out-of-the-box reports

Quickly review captured information by selecting from a library of built-in reports. Create new, custom reports from any existing report

fancy
See next feature

Low overhead

Minimal or negligible impact on performance while SQL Server events are being audited and processed into the central repository database

fancy
See next feature

Tamper-evident repository design

Automatically detect any changes or on the audited data, or auditing and alerting configurations. Receive alerts, in real time, based on any suspicious activities. Learn more

fancy
See next feature

User security

Assign different roles to specific users or groups to increase application and data security

fancy
See next feature

High filter granularity and precision

Use logical conditions and group them, per configuration requirement, to create audit filter configurations, reports and even alerting with high precision and maximum granularity

fancy
See next feature

Custom alerting

Get notified and alerted, in real time, when important events occur on audited SQL Servers including critical auditing events and data changes or configuration updates. Utilize existing alerts or create custom ones. Write alerts to the windows event log or send via email. Learn more

fancy
See next feature

Threshold alerting

Utilize custom scripts to check for important thresholds. Get alerted on any threshold breaches in real time

fancy
See next feature

Login auditing

See all successful or failed login attempts on audited SQL Server instances and view login access history. Learn more

fancy
See next feature

Security change auditing

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

fancy
See next feature

SQL Server activity auditing

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

fancy
See next feature

Ease of use

Quickly install and configure auditing filters to setup an auditing plan in minutes

fancy
See next feature

Automatic deployment

Components are automatically installed and deployed to all machines that host SQL Server instances that are audited, removing the need for any additional manual installation or implementation tasks on user's side

fancy
See next feature

Audit data archiving

Archive data without interrupting ongoing auditing. Choose the frequency, detach and transfer old repositories to storage safely and easily. Restore old repositories to read archived audited data

fancy
See next feature

Automatic reporting

Schedule report generation on a desired frequency. Have your daily, weekly or monthly reports automatically created and available per pre-defined schedules

fancy
See next feature

Visual themes

Customize the visual appearance with interface themes. Learn more

fancy
See next feature

Resources and support

Generating custom reports for a SQL Server audit trail Configuring database auditing with SQL Server audit software Overlooking SQL Server audit on multiple SQL Server instances Be alerted on specific events found in the SQL Server audit log Achieve tamper-proof database environment with SQL Server audit software Configure a SQL Server audit with the highest precision Receive email notifications on critical events to meet SQL Server audit specifications Investigate the complete history of audited events in a SQL Server audit log Analyze the SQL audit data using Power BI

ApexSQL Audit 2018 – Screen shot tour

This article represents a screen shot tour of ApexSQL Audit features with a brief description

How to configure before-after auditing in ApexSQL Audit

This video explains how to configure ApexSQL Audit to track before and after changes on insert, update and delete operations and how to investigate change details including who made them, how and when

How to configure ApexSQL Audit for security auditing

This video explains how to configure ApexSQL Audit, a SQL Server auditing and compliance tool, to audit all security related events on both SQL Server and database levels

Advantages of ApexSQL Audit

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

ApexSQL Audit vs. SQL Server Change Data Capture (CDC)

This blog article provides detailed information on SQL Server auditing with bot ApexSQL Audit and SQL Server Change Data Capture (CDC) and showcases key advantages of ApexSQL Audit

How to install ApexSQL Audit

This video provides an explanation of ApexSQL Audit components and guides users through the different installation scenarios

Capturing who saw what in SQL Server

This article describes how to configure and quickly investigate audited results in order to find out who saw what, when and how, connection and access attempts and more

Before and after auditing in SQL Server

This Solution center article describes two different approaches and solutions to before and after auditing

Auditing SELECT statements on SQL Server

This article describes how to use ApexSQL Audit to capture all SELECT statements and discover who and when is accessing the data

SQL Server database security auditing

This article provides detailed guide on how to configure ApexSQL Audit to track all security changes on SQL Server instances, on both server and database levels

SQL Server auditing – how to be alerted about important auditing events

This article describes how to configure ApexSQL Audit to alert DBAs or other users on important auditing events and send automatic email notifications on specific auditing events

Tracking SQL Server object usage

This article provides detailed guide on how to use ApexSQL Audit to track object usage in order to optimize schema or performance and ensure transparent security monitoring on object access

ApexSQL Audit installation guides

This article provides key information and links to all important ApexSQL Audit installation articles

See more

Compliance

ApexSQL Idera®
SQL Server version
      SQL Server 2008 - 2019
      SQL Server 2005
SQL Server edition
      Express
      Standard
      Enterprise
Auditing
      Add databases automatically
      Apply configuration to multiple instances
      Audited servers/databases overview
      Before-After data auditing
      Configuration and data filtering
      Configurable auditing session settings
      Predefined regulation templates
      Sensitive data auditing
      Resilience for log write failure
      Advanced filters
      Detection of new SQL Server instances
Repository
      Archiving
      Custom data purge and repository maintenance
      Schedule archiving
      Tamper-evident
Alerting
      Custom alerts for auditing events
Reporting
      Custom reports
      Exporting
      Predefined regulation templates
      Scheduling
      Built-in API
Features
      Central management UI
      Web console
Account management
      Application roles and privileged users
Other
      High performance Extended Events based auditing
      Remote access
Interface
      GUI themes
      High DPI and 4K resolution support
      Microsoft standard iconography, colors and other visual effects

ApexSQL Audit 2021.01

Idera® SQL Compliance Manager 5.8.1


Comparison was conducted on December 15, 2021

Disclaimer: All product and company names are trademarks™ or registered® trademarks of their respective holders.
ApexSQL is not affiliated, associated, authorized, endorsed by, or in any way officially connected with other companies listed or any of their subsidiaries or affiliates

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

One of the problems with so many tools on the market today, to accomplish audit and compliance, is the complexity of use. ApexSQL Audit is straightforward and easy to configure, I was able to set-up our audit and compliance in minimal time using this tool.

Gary Fry

Senior Database Administrator

Cox Industries, Inc.

ApexSQL Audit is great. This product will allow me to show non-technical users audit trails for SELECT, INSERT, and UPDATE statements in a graphical manner that I can explain quickly.

Robert R.

Macro Integration Services

Implementation Specialist

Software

What's supported

Requirements

Testimonials

Sales

Support plans

Renewals and upgrades

Licensing

Help

Support

Resend keys

News

Blog

Gold Partner
Video  LinkedIn  Twitter  Facebook  Blog Newsletter

© 2022 Quest Software Inc. ALL RIGHTS RESERVED.   |   GDPR   |   Terms of Use   |   Privacy