John McCormack DBA

SQL Server Databases and AWS Cloud Solutions

How Multi-AZ Works For SQL Server on RDS

By Leave a Comment

How Multi-AZ Works For SQL Server on RDS

This is a short video about How Multi-AZ Works For SQL Server on RDS. I didn’t feel a demo was needed this time jsut for the sake of it. Enabling Multi-AZ is a click of a button or one line of PowerShell or CLI.

Important: Please read this post for further information. I’ve highlighted some key points in my presentation but there is no point in me simply listing out everything or reading the post verbatim. There is some really great info in this post however so it is well worth reading.

Download slides

Course Homepage | Next video

Backup and restore for AWS RDS SQL Server

By Leave a Comment

Backup and restore for AWS RDS SQL Server

In this video, we talk about backup and restore for AWS RDS SQL Server. One of the great benefits of Platform as a Service (PaaS) is that your cloud hosting company will handle the backups for you. And they’re really good at it. In this case, AWS will allow you to restore to any point in time within the last 35 days, and all with no administration effort on your part.

This video dives a bit deeper into the non default options such as backing up and restoring using native backups and how you can keep those backups way beyond the 35 days.

Download Slides | View T-SQL Script

Course Homepage | Next video

Automating SQL RDS With PowerShell

By Leave a Comment

Automating SQL RDS With PowerShell

Introduction to AWSPowerShell, for managing SQL Server RDS instances. Learn how to create, restore, take snapshots and start/stop instances for cost optimisation reasons.

Apologies that this video is 16 minutes, I really wanted to keep all of the training videos under 10 minutes but there was so much to say about PowerShell. (And I only scratched the surface).

Download slides | View PowerShell script

Course Homepage | Next Video

Advanced configurations using RDS Parameter Groups

By Leave a Comment

Advanced configurations using RDS Parameter Groups

In this video, we take a look at how to set advanced configurations using RDS parameter groups. Due to permissions restrictions, some parts of the usual DBA toolkit are disabled such as setting trace flags or amending the sp_configure settings. With parameter groups, you can still make these changes where necessary.

Course homepage | Next video