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

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