Knowledgebase and troubleshooting articles round-up – July 3rd, 2014

Here is a summary of our latest knowledgebase and troubleshooting articles:

Knowledgebase:

Document SSIS packages and SQL databases using ApexSQL Doc CLI – ApexSQL Doc
This article lists the Command Line Interface switches in ApexSQL Doc, and provides examples of their usage.

ApexSQL Log – Permissions and requirements – ApexSQL Log
This article gives information about software requirements and permissions for ApexSQL Log.

How does ApexSQL Log work? – ApexSQL Log
This article describes how ApexSQL Log reads operations (both DDL and DML) and shows information from SQL Server database transaction logs.

Exporting options in ApexSQL Log – ApexSQL Log
This article explains available exporting options in ApexSQL Log.

When to use ApexSQL Log – ApexSQL Log
This article describes auditing, security, and restoring scenarios where ApexSQL Log can be used.

How to activate ApexSQL Log on remote SQL Server instances – ApexSQL Log
This article explains the remote activation process of ApexSQL Log.

How to create an undo/redo script in ApexSQL Log – ApexSQL Log
This article explains how to use ApexSQL Log for creating scripts to rollback or reconstruct transactions recorded in the transaction log.

How to add servers to ApexSQL Monitor – ApexSQL Monitor
This article describes how to manually add servers for monitoring with ApexSQL Monitor.

ApexSQL Monitor alerts – ApexSQL Monitor
This article explains how to configure alerts settings in ApexSQL Monitor.

ApexSQL Recover – Permissions and requirements – ApexSQL Recover
This article gives information software requirements and permissions for ApexSQL Recover.

ApexSQL Restore – Permissions and requirements –ApexSQL Restore
This article gives information about software requirements and permissions for ApexSQL Restore.

How to perform custom object mapping in ApexSQL Data Diff – ApexSQL Data Diff
This article explains how to map the specific objects in a database for comparison and synchronization in SQL Server by using the Object mapping feature in ApexSQL Data Diff.

How to manage queries by using ApexSQL Complete – ApexSQL Complete
This article describes code and objects navigation features in ApexSQL Complete.

Tips and tricks for using ApexSQL Refactor SQL formatting options – General options, Capitalization and Comments – ApexSQL Refactor
This article describes the General, the Capitalization, and the Comments T-SQL code formatting options in ApexSQL Refactor.

Tips and tricks for using ApexSQL Refactor SQL formatting options – Schema statements, Data statements, Joins, and Flow control – ApexSQL Refactor
This article describes the Schema statements, the Data statements, the Joins, and the Flow control T-SQL code formatting options in ApexSQL Refactor.

Troubleshooting:

I cannot activate ApexSQL Monitor, the Hardware ID field is empty
This article describes what to do when you get an “incomplete info” message when activating ApexSQL Monitor.

July 3, 2014