I talk about multiple ways NOLOCK can seduce you into basing update decisions on faulty data.

I demonstrate a procedure I wrote to script SQL Server Agent jobs idempotently, avoiding GOTO labels and schedule spaghetti.