Introduction
In this article, we shall imagine that we were just recruited by a new company and handed over a new Amazon RDS SQL Server instance. Our first job would be to understand the instance and key databases, tables, and other server-level and database-level objects in the instance. Just for fun, we are going to do this purely using T-SQL from beginning to end. Here are some of the basic checks we shall do:
Database list Size of databases Busiest databases Backup History Top tables by size Connecting to the Amazon RDS Instance Using Azure Data Studio
In