Thread-safety with SQL Server 2008

The subject of thread safety is often overlooked by even experienced developers. When designing an application or service to be utilized by multiple internal and external threads, one must account for potential issues arising from concurrent access to shared data.