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.

How to create an auditing profile to track “users” in a custom system using a single SQL Server login

Applies to
ApexSQL Trigger

Summary
his article explains how you can determine exactly which user made a change on an audited database, even if all the users of the system access to SQL server via only one SQL user account. An example would be a web application that connects to the SQL Server via a connection string using a single SQL Server user. The system has its own custom system to manage users by user name and password. The modification, described in this article, will reconcile the custom “users” with the actual changes made to data in SQL Server