Create Server Audit with Specification
First we will create the SERVER AUDIT. Next we create the SERVER AUDIT SPECIFICATION and
David Speight
https://www.linkedin.com/in/davidspeight/
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