blog.apexsql.comBlog - Product announcements, promotions and other ApexSQL news

Solutions Products Downloads Prices Support 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 ApexSQL Compare and Sync 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 What's new What's nextDatabase administration Automate critical tasks for database administration Auditing and compliance Database backup Disaster recovery Forensic auditing Index defragmentation Inventory management Load testing Object level restore Query optimizationServer compare SQL job automation SQL Server monitoring Transaction log reading Transactional replication Database development Integrate database changes and automate deployments Continuous delivery Continuous integration Data compare Data import/export Data masking Database DevOps Database documentation Database modeling Dependency analysis Developer productivity Development best practices Documentation Multi-DB script execution MySQL data compare MySQL documentation MySQL schema compare Object decryption Object refactoring Packaging and deployment Schema and data scripting Schema compare Script comparison SharePoint documentation SQL formatting SQL Server documentation SQL source control SQL unit testing SSAS documentation SSIS documentation SSIS package compare SSRS documentation Statement auto complete Static code analysis Test data generation Text and object search Solution centerBlog 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 3 rd 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...