Here is a summary of our latest knowledgebase and troubleshooting articles:
Knowledgebase:
ApexSQL Log CLI support – ApexSQL Log
This article explains and gives examples how to use ApexSQL Log command line interface (CLI) and create output files.
How to optimize data recovery results in SQL Server using ApexSQL Recover – ApexSQL Recover
This article describes necessary actions to maximize the chances for successful recovery of lost SQL Server data using ApexSQL Recover.
ApexSQL Monitor licensing – ApexSQL Monitor
This article explains ApexSQL Monitor licensing.
Setting up SQL database documentation – ApexSQL Doc
This article explains how to set up the SQL database documentation settings, filter objects for documentation, and add database objects to documentation in ApexSQL Doc.
How to speed up the process of a T-SQL coding using ApexSQL Complete – ApexSQL Complete
This article describes how to use ApexSQL Complete options to manage the auto-complete hint-list, using and managing T-SQL code snippets and aliases, and how to autocomplete SQL statements.
How to encapsulate code as a new stored procedure, a function, or a view – ApexSQL Refactor
This article describes the benefits and how to use the Encapsulate as feature in ApexSQL Refactor.
How to refactor SQL databases with ApexSQL Refactor – ApexSQL Refactor
This article describes ApexSQL Refactor’s SQL refactoring options: Safe rename, Split table, Add surrogate key, Change parameters, and Replace one-to-many relationship.
Troubleshooting:
ApexSQL Recover doesn’t recover all lost data – ApexSQL Recover
This article explains scenarios when ApexSQL Recover cannot recover all lost data due to overwriting data necessary for recovery in the post incident activities and when a database is in a simple recovery mode.
The synchronization script is generated with errors when synchronizing a specific database with an empty database as a destination – ApexSQL Diff
This article describes an issue with the generated synchronization script in ApexSQL Diff when a database that contains a table or an indexed view with a FULLTEXT INDEX is synchronized with an empty database.
The application adds columns in the synchronization script when creating a clustered columnstore index – ApexSQL Diff
This article describes an issue when the synchronization script is generated with the wrong syntax when creating a clustered columnstore index in ApexSQL Diff.
June 16, 2014
