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