SELECT @@SERVERNAME on AWS RDS
I have a lot of legacy code that uses SELECT @@SERVERNAME and then performs an
SQL Server
AWS RDS SQL Agent Job Backup and Scripting
(Originally created September 9, 2020) Help! My boss just told me we’re moving our database
SSRS EMAIL SUBSCRIPTION FOR OFFICE 365 (AWS RDS)
Last fall, I configured our AWS RDS SSRS server for email subscriptions using SES (Amazon
SQL SERVER BACKUP VERIFICATION EMAILER
Today I wanted to consolidate the half dozen emails I get each morning regarding backups
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
Setup New User for AWS RDS SSRS Access
This post will assume that you work in IT OPS and have access and permission
SQL PERFORMANCE MONITOR – BONUS: Power BI Dashboard
LEVEL: 300 – This quick article assumes that you already have at least one (1)