mark 4643 (10/22/2016)
that might work when all queries are within one database, but when nearly every query is cross database (bad design on 3rd party vendor product) it's not good
I think you missed the part where I said
All block databases reference the others when required through the use of synonyms (which is also done on PROD)
in one particular "block" one of the databases is the entry point for all queries by the users - this database has views -> synonyms to at least another 5 databases.