SQL Performance Monitor – Part 1: Overview
This is an overview of an AWS multiple account, multiple company, SQL server performance monitor
Year: 2022
Create Server Audit with Specification
First we will create the SERVER AUDIT. Next we create the SERVER AUDIT SPECIFICATION and
COALESCE to Format a List
In this example we want to list services followed by a service code.
Select Between Multiple Instances
Here is an example demonstrating how to SELECT between two separate SQL Instances. This assumes
Alphabetize List Between Two Columns
This will alphabetize your list of items, split between two (2) columns.
Lag Examples
Here is an example of using the LAG function in SQL 2012. A more detailed