The answer to both questions is Extended Events. That's what it's there for. Why would you NOT use it?

There is SQL Server Audit for the logins (not query calls),...

Without more information, it's hard to say. An INSERT requires exclusive access while a SELECT can used shared access, or, if you have it enabled, snapshot copies of the data....

one specific object common.

We have Object A which is common in some database, will have to retrieve the current row of  Object A in all databases and insert the...

CHECKDB is actually a series of commands. Just break down the commands and do them separately. The documentation is online and elsewhere.

Your prod and non-prod databases have to be...

So any object in common or a specific object in...

I'd look into the Activity Logs then. That's going to be the best bet from what I can see.

Honestly, I don't know that I'd be knocking down the door today to move from 2017 to 2019. Mostly, 2017 is just working great. Mostly, 2019 is an awesome upgrade,...

When you say "mask the data"...

Personally, I'd put powershell to work. Make a list of your servers. Provide that list to Powershell. Run a query against every server to get the list of databases. Done....

Yeah, give the permission of a given role to a given schema and be done. Sounds like you're trying to dig a hole.

There is no single switch you can throw to make DBCC faster. None. It's going to take the time it takes. If you're seeing 95% CPU when you run it...

I have to admit that I foolishly used the MSDB method (i'm no ssis expert, but i'm the best we have at our company) and...

Thanks! Appreciate the kind words.

I think it's a fine thing that you have to justify the move. I suffer from "new shiny" syndrome and would be upgrading constantly if someone...

Why go with triggers? Use Extended Events. I don't have a blog post on tracking creation of logins using Extended Events available. Here's one on auditing database changes. You...

How about positive changes to our Recovery Time Objective? That alone would do it for me when you add in all the other improvements that have occurred since...