DBA Tasks

AWS CLI AWS RDS DBA Tasks PowerSHell 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

By David Speight / March 21, 2023

AWS CLI AWS RDS DBA Tasks PowerSHell SQL Server SSRS

Last fall, I configured our AWS RDS SSRS server for email subscriptions using SES (Amazon

By David Speight / March 13, 2023

AWS RDS DBA Tasks SQL Server

Today I wanted to consolidate the half dozen emails I get each morning regarding backups

By David Speight / February 2, 2023

Basic TSQL DBA Tasks SQL Server

Last week a colleague texted, wondering how to ALTER a COLUMN NAME because they were

By David Speight / January 9, 2023

DBA Tasks PowerBI SQL Server

LEVEL: 300 – This quick article assumes that you already have at least one (1)

By David Speight / November 8, 2022

DBA Tasks SQL Server SSIS

Code snippets for shrinking database and database log files for EC2 and OnPrem. This will

By David Speight / October 19, 2022

AWS RDS DBA Tasks SQL Server

AWS Cloud Formation allows you to programmatically create a template that you can use to

By David Speight / October 18, 2022

AWS RDS DBA Tasks SQL Server SSRS

Today I am putting together my SSRS dashboard. This will be an OVERVIEW page that

By David Speight / October 12, 2022

AWS CLI AWS RDS DBA Tasks PowerSHell SQL Server SSIS

In this part (7) I will continue building my performance monitor by setting up a

By David Speight / September 26, 2022

AWS CLI AWS RDS Basic TSQL DBA Tasks PowerSHell SQL Server SSIS SSRS

I WILL NEED Visual Studio with tools for SSIS installed on my local workspace. I’m

By David Speight / September 17, 2022