Snapshot or Backup AWS RDS SQL Server
Going to be away at Orlando’s SQL Saturday this weekend and one of my company’s
DBA Tasks
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
SQL LOGIN PASSWORD MANAGER
Right before I went on vacation, in an audit, we discovered that occassioanlly there was
SQL TABLE PI DATA CLEANING SOLUTION (PART 2)
In Part One I set up the solution that cleans our data. In this part
SQL Table PI Data Cleaning Solution (Part I)
Today at work the “auditors” wanted to see evidence that all of my company’s PI
SQL Server Audit Daily Email
Not so long ago my company acquired another subsidiary. Each morning I’ve been receiving an
SELECT @@SERVERNAME on AWS RDS
I have a lot of legacy code that uses SELECT @@SERVERNAME and then performs an
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