What’s next in ApexSQL Complete R5 – Go to object form, Copy query as XML/CSV/HTML, workspace saving, and more

The upcoming R5 release of ApexSQL Complete 2014 brings improved usability and quality, along with brand new features.

In this release, we are working on improving the Go to object form, to improve usability of finding of certain objects. The Copy query as XML, CSV, and HTML option allows users to copy the results from the SSMS results grid and paste it into one of three mentioned formats. Auto-aliasing options will be enhanced to include Auto-aliasing customizable case. The last, but not the least, is the Workspace saving option which allows users to restore saved queries during the session, or if an unexpected crash occurred.

What’s next in ApexSQL Doc 2014 R3 – SSMS add-in, page orientation, additional customization, and more

ApexSQL Doc 2014 R3 will be the next version of our SQL database and SSIS package documenting tool. In the upcoming release, we will continue to work on customizing options for the output documentation files, and to make it more user friendly. We’ll add an options to choose page orientation and page size for the .doc and .docx output formats, an option to add an image in the header/footer of the output document, and make the header/footer customization more user friendly. In addition, we’ll add an option to include/exclude extended property for the specific object type. ApexSQL Doc will be integrated in SQL Server Management Studio as an add-in.

ApexSQL Build 2014 R2 – Product update alert

ApexSQL Build 2014 R2 has been released

Type: Maintenance release

About ApexSQL Build:ApexSQL Build is a SQL database deployment tool that builds new databases or 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, enables executing SQL scripts against multiple SQL Servers simultaneously, and more.

ApexSQL Data Diff 2014 R2 – Product update alert

ApexSQL Data Diff 2014 R2 has been released

Type: Maintenance release

About ApexSQL Data Diff: ApexSQL Data Diff is a SQL Server data comparison and synchronization tool which detects data differences and resolves them without errors. It compares and synchronizes live databases and native or natively compressed backups and generates comprehensive reports on the detected differences.

ApexSQL Comply 2014 R3 – Product update alert

ApexSQL Comply 2014 R3 has been released

Type: Maintenance release

About ApexSQL Comply: ApexSQL Comply is a SQL Server auditing tool with a wide range of possibilities 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. ApexSQL Comply saves captured information in a centralized auditing repository and provides comprehensive reports.

ApexSQL Clean 2014 R2- Product update alert

ApexSQL Clean 2014 R2 has been released

Type: Maintenance release

About ApexSQL Clean: ApexSQL Clean analyzes SQL Server database objects’ dependencies, the impact of potential deletions on your SQL database, determines objects’ interrelationships within the database, between external databases, scripts and even applications.

ApexSQL Manage sneak peak – part 2

All existing schedules can be found in the Schedules tab which also displays individual schedule details. From here, the user can edit schedules, identify those that have failed as well as manually re-run individual scheduled jobs which were not successful or just need fresh run:

ApexSQL Manage sneak peak – part 1

We are announcing the upcoming release of a new enterprise tool – ApexSQL Manage that enables you to manage and automate backup jobs while preserving the backup chain for easy point-in-time restoration (database rollback). In addition, it offers automation of restore and log shipping jobs. ApexSQL Manage also increases backup security by automatically performing backup verification.