How to setup an e-mail alert system for ApexSQL tools

Applies to
All ApexSQL console applications with Command line interfaces (CLI)

Summary
This article describes how to create e-mail alert system for ApexSQL tools using PowerShell in order to send e-mails upon executed ApexSQL tool providing the necessary information.

Formatting option mockups and examples

Applies to
ApexSQL Refactor

Summary
This article describes the ways in which you can format SQL code using ApexSQL Refactor features and options. ApexSQL Refactor is a free add-in with over 200 formatting options and nearly 15 code refactors.

How to create custom SQL Server performance reports – Part 1 (Performance and status metrics)

SQL Server performance reports are important for analyzing current and historical SQL Server performance.

ApexSQL Monitor gathers and stores all collected performance data into a single central repository database that is used for creating the reports that are part of the application. But this repository be queried against for custom SQL Server performance reporting. The repository data is not human readable in most cases, so to convert the raw data to helpful information that can be viewed and utilized by end users, a set of SQL Server “helper” functions was created and will be presented in the article. These easy to use functions will translate the underlying data into useful query results and even reports. Once the functions are created in the repository database, those can be used as part of this custom SQL Server performance solution.