What’s new in ApexSQL Defrag


ApexSQL Defrag is database administrator tool used for SQL Server index management. It represents all around solution for SQL Server index monitoring, analysis and maintenance.

January 4, 2017

ApexSQL Backup 2017 R2 – Product update alert


ApexSQL Backup 2017 R2 has been released

About ApexSQL Backup: ApexSQL Backup is a SQL Server tool for SQL Server that enables management and automation of backup jobs while preserving the backup chain for easy point-in-time restoration (database rollback). In addition, it offers automation of backup, restore, and log shipping jobs, stores details of all backup activities and enables easy cross server backup management and maintenance. ApexSQL Backup offers instant backup creation, as well as instant backup restoration, and backup security is enhanced by automatically performing backup verification. All captured metric values and backup activities are automatically stored in a central database repository.

December 29, 2016

ApexSQL Source Control 2017 – Product update alert


ApexSQL Source Control 2017 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 provides full object versioning features, without the need for an additional source control client.

December 28, 2016

ApexSQL Complete 2017 R4 – Product update alert


ApexSQL Complete 2017 R4 has been released

About ApexSQL Complete: ApexSQL Complete is a SQL Server Management Studio and Visual Studio add-in, that speeds up coding by automatically completing SQL code statements, filling in SQL code fragments and more.

December 26, 2016

ApexSQL Unit Test 2016 R3 – Product update alert


ApexSQL Unit Test 2016 R3 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.

December 15, 2016

ApexSQL Propagate 2017 – Product update alert


ApexSQL Propagate 2017 has been released

About ApexSQL Propagate: ApexSQL Propagate is a SQL Server development tool that can execute multiple SQL scripts on multiple SQL databases, located on any SQL Servers, with one-click. Before execution, it can parse SQL scripts to check if their execution will pass or fail. Execution results can be exported into Text or CSV files.

December 13, 2016

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


Common SQL Server database auditing goals include the ability to

  • achieve compliance regulatory standards,
  • perform data flow checkups, complete internal/external investigations of who changed what,
  • perform post-disaster analysis when data is unintentionally changed and to discover why did it occur, when, etc.
  • maintain history of data changes (before-after auditing)
December 12, 2016