Great discussion! All the replies are meaningful. I have used tags like below

Name - value would be typically resource name

Division - value would be name of the division or the...

Believing you can is certainly one of the big parts of the battle. Your story of stair climbing is inspiring. I climbed Eiffel tower two stories with a teenager and...

Hello Admingod,

I am thinking Backup and Restore is not an option as there is no backward compatibility for this. I have not tried it.

Looks like SQL 2019 has not done...

I am not sure about CMS either. But if you are looking for getting sizes of all databases from a single SQL server, I would use dynamic sql. I have...

Hello Steve,

The sys.sysusers  view still works in SQL 2019-both on premise and on azure sql.  sys.database.principals is a better view with more information. It depends what information you are looking...

abdalah, what is the listener name in the AG? Is the listener showing as synchronized?

The distribution database AG needs to have a listener. When the publisher adds the distributor, it...

Why do you need to use report builder? most of the tasks can be done without it. Are the reports and datasource visible on the ssrs site? can you see...