January 2006
Here are some factors to consider when deciding whether to use traditional T-SQL or a .NET language such as Visual Basic .NET or C# for writing stored procedures, triggers, and UDFs.
SQL Server Magazine
January 2006
Take advantage of SQL Server 2005's new ability to use classes written in .NET languages.
SQL Server Magazine