Nice article:)

I It's mentioned that orphaned users do no exist in Windows logins, This is true for the same domain, but if you restore the database to another domain, I...

Comment on the original article:

When deciding to enforce relations using FKs or not, this should be compared with using application logic . not with simple deletes or updates.