Untrusted Foreign Keys and how to fix them
Untrusted Foreign Keys are something that is often an overlooked performance issue.
Let's fix that "easily".
Idempotent SQL change script
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.
Database Mirroring to offsite server
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.