Here's a basic query. It produces rows, but you get the ROWs and LOG information for each database.
SELECT d.name AS databasename,
   f.type_desc,
   SUM(size) AS totalsize

Some of these have nothing to do with clustering or AGs.

1. What's your RPO/RTO? In other words, how much data loss and how long can you be down?...

If you are trying to backup the database, it must be available. If you have log shipping, you cannot make a backup of a database in standby or norecovery mode....

I wouldn't write this anymore. It's too hard to manage the data, keep the queries up to date, and it becomes a job. I would rather use a tool of...

Definitely check IO, as Sue suggested. The system is having trouble reading drives. I'd also run DBCC CHECKDB ASAP on this database. There might be other issues. If you have...

I don't quite know how this works. It was surprising to me as well. i suspect this is some strange holdever from the past, perhaps some poorly designed behavior in...

Glad you liked it and learned.

Not that I've seen. Feel free to experiment and write this one up

We are doing work on a new site now. I've asked if this is in there, but I might suggest forwarding notifications with a rule to work and leaving the...

OK, you weren't clear in the explanation.

If you are loading data from staging to target, not updating,but new data, there shouldn't be many locks. You might have minor...

I'm not sure I'm ever going to forgive the PoSh builders for using -eq instead of = or ==. I just lost 30 minutes trying to debug a script that...

Ah, sorry, Rod. There are two places for subscriptions. You're looking at the ones for the forums. I assume those are the emails you're not getting? Nothing I've seen has...