Constrained Execution Regions

Constrained Execution Regions is an interesting post by Brian Grunkemeyer on how SQL Server deals with failures in managed code.