Knowledgebase articles round-up – July 15th, 2014

Here is a summary of our latest knowledgebase articles:

General usage and the common Command Line Interface (CLI) switches for ApexSQL tools – All ApexSQL applications that support Command Line Interface
This article explains general usage of the CLI in ApexSQL applications, format of CLI switches, and the common CLI switches for all ApexSQL console applications.

How to restore a database backup from a network path – ApexSQL Restore
This article explains how to restore a database backup from a network path of a remotely stored database to a local SQL Server instance in ApexSQL Restore.

SQL transaction details in ApexSQL Log – ApexSQL Log
This article describes GUI elements in ApexSQL Log for finding specific information about SQL transactions.

How to save and reuse the ApexSQL Log grid data via SQL BULK – ApexSQL Log
This article explains how to save results from ApexSQL Log grid for later analysis into the database table by using the Export to SQL BULK option.

Setting up project options in ApexSQL Clean – ApexSQL Clean
This article explains project options in ApexSQL Clean.

Resolving external references and filtering SQL database objects in a project – ApexSQL Clean
This article describes how to resolve external references in ApexSQL Clean and speed up the process by filtering objects for analysis.

How to improve query performance and avoid syntax errors by expanding wildcards in SQL statements – ApexSQL Refactor
This article describes the ApexSQL Refactor option for wildcard expansion and SQL Server query design best practices for improving query performance.

Avoid implicit name resolution of objects in queries by qualifying object names – ApexSQL Refactor
This article describes the ApexSQL Refactor option for qualifying object names and benefits of avoiding implicit name resolution.


July 15, 2014