I reread your comment 5 times more - it does not say anything about "beginners and programmers who find themselves coding t-sql".

Not a word. Not a hint.

Intead - you put the blame on triggers and called to avoid them.

Pretty stupid call.

Sorry.

I've seen .Net developers bringing dows 2 pretty powerful servers down by misusing remote calls in procedures.

And exausting server tresources by using front-end formatting in views.

What should we avoid here - remote calls, procedures, view?

Because we won't avoid stupidity and incompetence - it's ours everything!