ApexSQL Audit 2023 – Product update alert

ApexSQL Audit 2023 has been released

About ApexSQL Audit: ApexSQL Audit is a SQL Server auditing and compliance tool with a wide range of features for auditing access, changes, and security on SQL Server instances, databases, and objects. It audits queries, DDL and DML operations, security events (authentication changes, permissions changes, and attempted logins), events on stored procedures and functions, and provides out-of-the-box compliance templates such as HIPAA, GDPR, PCI. ApexSQL Audit saves captured information in a centralized auditing repository and provides comprehensive reports.

For more information, visit the ApexSQL Audit product page

About this release:

Enhancements:

  • Additional logging is available by activating Debug mode.
  • Additional processing of files from the ActiveSessions folder after encountering 3rd party parsing errors
  • Creation of zipped files containing details about the queries which could not be processed
  • Optimization of the Before-after trigger installation process for databases with a large number of Primary Key indexes.
  • Support for hosting the Central Repository and auditing events for SQL Server 2022.

Improvements:

  • 28 bugs fixed

Changes:

The column order of Before-after reports has been modified and is now displayed in alphabetical order. This modification enables a significant performance improvement both during the initial setup and when updating the configuration for Before-after auditing.

See also:
Release notes
Download

June 21, 2023

ApexSQL Unit Test 2022 – Product update alert

ApexSQL Unit Test 2022 has been released

About ApexSQL Unit Test: ApexSQL Unit Test is a SQL Server Management Studio add-in, to maintain and run SQL database unit tests. It allows you to create unit tests and organize them in test classes. In addition, a single test case can be executed, as well as all tests from a single class or all tests against a single database with just a single click. Test execution can be automated using the CLI, along with exporting test execution results to XML, SQL script, or SQL database table.

October 10, 2022

ApexSQL Source Control 2022 – Product update alert

ApexSQL Source Control 2022 has been released

About ApexSQL Source Control: ApexSQL Source Control is a SQL Server Management Studio add-in to version control SQL databases and objects. It integrates with all major source control systems and allows database developers to work together on a shared or a dedicated database copy. ApexSQL Source Control provides full object versioning features such as object locking with team policies management, detailed view of changes history, conflict resolution, labeling, and more.

October 10, 2022

ApexSQL Script 2022 – Product update alert

ApexSQL Script 2022 has been released

About ApexSQL Script: ApexSQL Script is a SQL Server tool that scripts database objects and data into a SQL scripts, C# solutions and executable installers. It can export live databases directly to source control and can automate and schedule the migration processes.

October 10, 2022

ApexSQL Pump 2022 – Product update alert

ApexSQL Pump 2022 has been released

About ApexSQL Pump: ApexSQL Pump is a tool that can import and export data from SQL Server database to 13+ commonly used data formats (CSV, Excel, Word, XML, JSON, etc.) and it can be used to migrate data between systems. The tool allows users to configure data export by offering many options that can be saved as a template. The import and export process can be run directly from command-line interface.

October 10, 2022

ApexSQL Generate 2022 – Product update alert

ApexSQL Generate 2022 has been released

About ApexSQL Generate: ApexSQL Generate is a tool that can populate SQL databases with test data using multiple generators for each column. It supports a full range of SQL data types and can recognize them in a loaded SQL database and provide real-world test data based on contained data types. It can generate randomized test data using the Random generator and various options and using the Regular expression generator, sequential data using the Incremental generator, and much more.

October 10, 2022

ApexSQL Enforce 2022 – Product update alert

ApexSQL Enforce 2022 has been released

About ApexSQL Enforce: ApexSQL Enforce is a best practices enforcement tool for SQL Server database objects and scripts. It comes with an integrated editor featuring code auto-complete for writing custom rules and has more than 100 out of the box rules covering SQL best practices, naming conventions, potential configurations and more.

October 10, 2022

ApexSQL Doc 2022 – Product update alert

ApexSQL Doc 2022 has been released

About ApexSQL Doc: ApexSQL Doc is a documentation tool for SQL Server instances, databases, objects, SQL Server Integration Services packages, SQL Server Analysis Services cubes, SQL Server Reporting Services reports, Tableau server sites and SharePoint Server farms. It generates comprehensive documentation in a number of formats including CHM, HTML, Microsoft Word’s DOC and DOCX, PDF and Markdown.

October 10, 2022

ApexSQL DevOps toolkit 2022 – Product update alert

ApexSQL DevOps toolkit 2022 has been released

About ApexSQL DevOps toolkit: ApexSQL DevOps toolkit is a set of open-source PowerShell cmdlets for automating workflow pipelines to integrate database changes, test and deliver to production. It supports integration with Bamboo, Jenkins, TeamCity, AppVeyor, GoCD, CruiseControl, Hudson, Visual Studio Team Services, Team Foundation Server, and other CI/CD servers. It contains predefined Continuous Integration (CI) and Continuous Delivery (CD) PowerShell script templates for standalone use where all pipeline steps can be customized, reordered, added and removed. It also contains a native TeamCity, a native Atlassian Bamboo, a native Jenkins continuous integration server, a native Azure DevOps Server (TFS) / Azure DevOps Services plugin and a standalone Web dashboard for configuration and execution of CI and CD workflow pipelines via point and click graphical interface.

October 10, 2022

ApexSQL Diff 2022 R2 – Product update alert

ApexSQL Diff 2022 R2 has been released

About ApexSQL Diff: ApexSQL Diff is a SQL Server and Azure SQL database comparison and synchronization tool which detects differences between database objects and resolves them without errors. It compares and synchronizes live databases, native or natively compressed database backups, database snapshots, scripts in source control and script folders and generates comprehensive reports on the detected differences.

October 10, 2022