Library
This isn't so much an article as it is a library of technical links that I find interesting and useful. It's starting small, but it will grow over time.
Microsoft's article on designing data access components
Scott's Ultimate Tool list.
T-SQL Coding Standards.
T-SQL Error Handling with Nested Stored Procedures and Transactions