SQL PERFORMANCE MONITOR – PART 4: AWS BUCKET & IAM USER SET UP
AWS CONFIGURE S3 BUCKETS [1] CREATE BUCKET on each AWS account where files will be
Month: August 2022
SQL PERFORMANCE MONITOR – PART 3: SQL DATABASES
In this part of our SQL PERORMANCE MONITORING project we are going to create the
SQL Performance Monitor – Part 2: Active Directory User
This is Part 2 of my plan to set up SQL Monitoring between AWS accounts
SQL Performance Monitor – Part 1: Overview
This is an overview of an AWS multiple account, multiple company, SQL server performance monitor
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