Update / Change Password via PowerShell
Today the password rotation for my Service Accounts in Active Directory (AWS MS AD) is
Basic TSQL
File Copy and Delete Using TSQL
Today I want to copy a file on a physical drive of my server to
SQL Logins and SQL Users
Code snippets for creating new LOGINS and USERS. Remember LOGINS are at the server/instance level
SQL PERFORMANCE MONITOR – PART 6: Outputting Metrics to a CSV File (SSIS)
I WILL NEED Visual Studio with tools for SSIS installed on my local workspace. I’m
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