If you want a list of tables as in the SSMS Object Explorer, then you need to apply (import) the DACPAC to a database. The SSMS OE is just reading...

With my luck, the HOU backup with throw 4TDs for 150 to Hopkins and I'll get blown out again by 30 pts.

Replication shouldn't need to know the PK name unless there are query hints or you are sending DDL changes through. I haven't tested, but it should work fine. Obviously have...

Will work and a creative solution. I've done something similar with a real table, but using a SPID column to ensure I can load values from a report for a...

I've used views like this, but don't like it. I'd +1 for the schema in the 3rd party db with no linkage/dependency on their objects.

I'd be curious what the trigger issue is for you.

There isn't a general alerting system, as any type of change isn't necessarily tracked. Extended Events does some...

This page: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-environment-variables

list MSSQL_COLLATION as a parameter. Perhaps that's it?

I'm not sure what the question is here. You're asking if something should happen. I think your question is must this happen, not should. This is a service account like...

Just beware of performance with AT TIME ZONE. You want to treat this more like a function and be careful of where it's used.