Install and Configure AWS CLI on Windows EC2 Machine

Here are step-by-step instructions: Installation of AWS CLI Validation of AWS CLI setup To check the version of the AWS CLI installed on your Windows machine, open a command prompt or PowerShell terminal and run the following command: aws –version This will display the version number of the AWS CLI installed on your machine, along … Read more

Recovery Model in AWS SQL RDS

Recovery Model is the most important concept in Microsoft SQL Server. Recovery model controls type of backups taken for a database. It can also control transactional log truncation and Point-in-Time Recovery of a database. On any full-fledged SQL server instance deployed on a physical server or a virtual machine, we can have various databases with … Read more

Find Account and Region details for an AWS EC2 Instance

One of my DBA friend was troubleshooting some issue on a SQL database server hosted on AWS EC2 Windows Instance. He was able to take remote desktop connection of EC2 instance. But as part of troubleshooting, he needed to see various details for that EC2 instance on AWS portal. He was able to login on … Read more