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

ApexSQL Complete 2017 R3 – Product update alert

ApexSQL Complete 2017 R3 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 7, 2016

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

Auditing of SQL Server changes on both server and database levels is not only recommended but also an obligatory task in many companies. In addition to many existing compliance standards which ensure the transparency of data and changes on the information for many different spheres, most companies also impose internal auditing specifications to track changes on the SQL Server databases to ensure that changes on important database tables are fully transparent for the purposes of general auditing, troubleshooting, investigation, disaster recovery etc.

December 1, 2016

ApexSQL Defrag 2017 – Product update alert

ApexSQL Defrag 2017 has been released

About ApexSQL Defrag: ApexSQL Defrag is enterprise SQL Server tool used for analyzing, monitoring and managing SQL Server index fragmentation. The application allows detailed index fragmentation analysis on server, database and table level. With ApexSQL Defrag you can rebuild or reorganize fragmented indexes in real time, as well as create policies and apply them to multiple databases or servers.

December 1, 2016

ApexSQL Refactor 2016 R6 – Product update alert

ApexSQL Refactor 2016 R6 has been released

About ApexSQL Refactor: ApexSQL Refactor is a SQL Server Management Studio and Visual Studio formatting and refactoring add-in for SQL Server with nearly 200 formatting options and 6 refactors such as table partitioning, safe rename, wildcard expansion and more.

November 24, 2016

ApexSQL Search 2016 R4 – Product update alert

ApexSQL Search 2016 R4 has been released

About ApexSQL Search: ApexSQL Search is a SQL Server Management Studio and Visual Studio add-in for SQL object and data text search, extended property management, safe object rename and object dependency visualization.

November 23, 2016

ApexSQL Decrypt 2017 – Product update alert

ApexSQL Decrypt 2017 has been released

About ApexSQL Decrypt: ApexSQL Decrypt is a SQL Server development tool that can decrypt SQL objects from multiple SQL databases, located on different SQL Servers. Before decryption, the original DDL script can be previewed in the Query window as the CREATE or ALTER script type. Decryption can be done directly on a database, or by creating one SQL script for all objects or one SQL script per object.

November 21, 2016

ApexSQL Complete 2017 R2 – Product update alert

ApexSQL Complete 2017 R2 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.

November 8, 2016

ApexSQL Backup 2017 – Product update alert

ApexSQL Backup 2017 has been released

About ApexSQL Backup: ApexSQL Backup is a tool 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.

November 7, 2016