ApexSQL Build 2018 – Product update alert

ApexSQL Build 2018 has been released

About ApexSQL Build: ApexSQL Build is a SQL database deployment tool that builds new databases and updates existing ones by packaging SQL scripts, SQL script folders, database snapshots, and scripts under version control into a single deployment SQL script, a .NET solution, or an executable installer. It allows specifying the objects to be created or updated, ensures error-free deployment, and more.

February 27, 2018

ApexSQL Source Control 2018 R2 – Product update alert

ApexSQL Source Control 2018 R2 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.

February 20, 2018

ApexSQL Decrypt 2018 – Product update alert

ApexSQL Decrypt 2018 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.

February 7, 2018

ApexSQL Plan 2018 – Product update alert

ApexSQL Plan 2018 has been released

About ApexSQL Plan: ApexSQL Plan is a SQL query analysis and optimization tool. It identifies performance issues and deadlocks, analyzes stored procedures, SQL Server query issues and query execution plans, and helps you understand query performance characteristics.

February 6, 2018

ApexSQL Audit user interface re-design aka face-lift

ApexSQL Audit is an enterprise level product with a ton of features. Although this is good, users can sometimes fail to see the proverbial forest for the trees, in navigating the user experience. One key impediment has been the implementation of panels on the interface, without segmentation.

This is a summary of panels (SDI) vs forms (MDI) research and proposals of a new design for configure auditing in ApexSQL Audit.

February 5, 2018

ApexSQL Build 2018 – Screen shot tour

When the application is started, the main window is shown, along with the Home tab, that contains actions which are grouped in the Projects, Database, Script, Data source and Tools sections:

February 1, 2018

ApexSQL Defrag 2018 R2 – Product update alert

ApexSQL Defrag 2018 R2 has been released

About ApexSQL Defrag: ApexSQL Defrag is an 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.

February 1, 2018

ApexSQL Decrypt 2018 – Screen shot tour

When starting the application, the Connect to SQL Server window is shown where we can select Server and the Authentication type we want to use to load the databases for object decryption:

January 31, 2018

ApexSQL GDPR Compliance Relief Program

The ApexSQL GDPR Compliance Relief Program is designed to help organizations that use SQL Server for processing and holding personal identifiable information (PII) reduce the cost of complying with GDPR.

GDPR will take full legal effect on May 25, 2018 and is intended to protect personal identifiable information (PII) of EU citizens. It applies to all organizations, in or outside the EU, that handle, process, collect and store personal identifiable information of data subjects residing in the European Union.

January 29, 2018