Untrusted Foreign Keys are something that is often an overlooked performance issue.
Let's fix that "easily".

Today I had a small chat with one of our developers, about adding a column to a table "the right way". I told him, that depending on how they needed to deploy it, it might be beneficial to make it idempotent.

Using SQL Server Database Mirroring to offsite servers, can at times be tricky, as latency becomes an issue.
At a recent engagement, they where experiencing that their mirror got suspended several times a day.