Troubleshooting and Knowledgebase articles round-up – July 12th, 2013

Here is a summary of our latest KB and TS articles

Troubleshooting:

What to do if you’re experiencing performance issues with Visual Studio / SQL Server Management Studio while using ApexSQL add-ins – This article explains what to do if you’re experiencing performance issues with Microsoft Visual Studio/SQL server Management Studio while using (or just having installed) ApexSQL add-ins
Applies to: ApexSQL Complete, ApexSQL Refactor, ApexSQL Search

Nothing is being captured – This article explains how to resolve the problem if ApexSQL Audit’s Web console shows no audited information as nothing is being captured; what to check and how to fix any individual cause
Applies to: ApexSQL Audit

Craniate ERM Diagram “Component Licensing” dialog is shown when graphical dependencies are included – This article explains what to do when the ”Component Licensing” dialog appears with the message “ERM Diagram 4.1. You have xx days remaining of your evaluation” when using the Visual dependencies feature
Applies to: ApexSQL Doc, ApexSQL Search

Knowledgebase:

ApexSQL Audit – Permissions and requirements – This article provides information about required permissions and software requirements for ApexSQL Audit installation
Applies to: ApexSQL Audit

How-to: licensing and activation of ApexSQL Audit – This article describes everything that you need to know about licensing and activation of ApexSQL Audit. It enumerates what you get when you purchase a license
Applies to: ApexSQL Audit

Deploying ApexSQL Audit – This article describes how to deploy ApexSQL Audit
Applies to: ApexSQL Audit

ApexSQL Audit limitations – This article describes limitations you should consider when working with ApexSQL Audit
Applies to: ApexSQL Audit

ApexSQL Audit database audit reporting module – The ApexSQL Audit web-based reporting module allows you to access reports from any computer, including remote. It provides a range of built-in reports and a custom report designer. Reports show the audited records captured in the Central Repository Database using filtering and sorting you have specified. Besides showing reports in an Internet browser, you can export them into several common formats
Applies to: ApexSQL Audit

ApexSQL Audit Central Repository Database design – This article describes design and structure of the ApexSQL Audit Central repository database
Applies to: ApexSQL Audit

ApexSQL Audit Tamper-evident design featuresApexSQL Audit stores all configuration and audited data, from local and remote SQL Server instances in a centralized auditing repository. i.e. Central Database Repository named ApexSQLCrd. The packages with captured data are transferred automatically and safely via network, read and data is stored into the central repository database. With this approach, it is easier to backup and protect captured data
Applies to: ApexSQL Audit

ApexSQL Audit custom queries and reportsApexSQL Audit provides a range of built-in queries in a reporting module that cover most common user reporting requirements. For more specific reporting requirements, we have provided a possibility to create custom SQL Server auditing reports by using a drag-and-drop technique. If this still doesn’t provide the specific information you need, thanks to the fact that ApexSQL Audit stores all audited data in SQL tables, you can create queries and reports of your own using T-SQL
Applies to: ApexSQL Audit

July 15, 2013