AWS RDS SQL Agent Job Backup and Scripting
(Originally created September 9, 2020) Help! My boss just told me we’re moving our database
AWS RDS
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
File Copy and Delete Using TSQL
Today I want to copy a file on a physical drive of my server to
WORKSPACE SET UP for AWS RDS SSRS ACCESS
Before I can login and access the AWS RDS SSRS server from a workstation or
Setup New User for AWS RDS SSRS Access
This post will assume that you work in IT OPS and have access and permission
SQL Logins and SQL Users
Code snippets for creating new LOGINS and USERS. Remember LOGINS are at the server/instance level
Create RDS database with Cloud Formation
AWS Cloud Formation allows you to programmatically create a template that you can use to
SQL PERFORMANCE MONITOR – PART 9: SSRS DASHBOARD
Today I am putting together my SSRS dashboard. This will be an OVERVIEW page that
SQL PERFORMANCE MONITOR – PART 7: PULL METRICS INTO DATA WAREHOUSE
In this part (7) I will continue building my performance monitor by setting up a