Using the .NET Framework for SQL Server Programming
Microsoft SQL Server 2005 features the integration of the common language runtime (CLR) component of the .NET Framework for Microsoft Windows. For SQL Server programming, this means you can write stored procedures, triggers, user-defined types, user-defined functions, user-defined aggregates, and streaming table-valued functions using any .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#.
SQL Server Programming Articles and Columns
Webcasts | SQL Server Programming Resources in Books Online |