Create an Audit for Data Using a Temporal Table
Recently someone has been changing data in a table on a legacy application written more
Basic TSQL
Directly Import data from AWS S3 to SQL Server 2022
Today I wanted to show my team how we might be able to use one
SELECT @@SERVERNAME on AWS RDS
I have a lot of legacy code that uses SELECT @@SERVERNAME and then performs an
Cannot Alter Column Because it is Replicated Error
Last week a colleague texted, wondering how to ALTER a COLUMN NAME because they were
Update / Change Password via PowerShell
Today the password rotation for my Service Accounts in Active Directory (AWS MS AD) is
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