T-SQL General

SQL Server Magazine - 11/2005
Solve Sudoku Puzzles with T-SQL - Handling Sudoku puzzles with T-SQL is a great way to practice logic and logic programming at the same time.

The Register - 9/27/0225
ANTs: a strange name for a database - What's more, this facility is not limited to Oracle but also applies to Sybase and SQL Server with support for Transact-SQL and T-SQL.

SQL Server Magazine - 9/2005
Snare Those Errors - Error handling is an essential part of all T-SQL code, but many developers regard it as at best a nuisance or at worst irrelevant.

Error Handling in T-SQL: From Casual to Religious - Error handling guidance for both DBAs and database application developers.

Microsoft SQL Server Developer Center (T-SQL) - Get more information on using Transact-SQL (T-SQL) to work with SQL Server data.

Monitoring with Transact-SQL Statements - Microsoft SQL Server provides several Transact-SQL statements and system stored procedures that allow ad hoc monitoring of an instance of SQL Server. 

MSDN Library - Accessing and Changing Relational Data Overview - Accessing and Changing Relational Data deals with fundamental aspects of building and executing Transact-SQL statements and processing results in the form of relational (or tabular) result sets.

Running Transact-SQL Statements Interactively Using osql - You can use the osql utility interactively to execute Transact-SQL statements in a command prompt window.

T-SQL Coding Standards - Coding standards are often overlooked when it comes to T-SQL programming, but they're a crucial component of a smoothly operating development team.

Using Transact-SQL Debugger - SQL Query Analyzer comes equipped with a Transact-SQL debugger that allows you to control and monitor the execution of stored procedures.