SQL CLR in SQL 2005
Here is a list of resources on SQLCLR that I have compiled. Hope you find them useful.
To understand the nuances of SQLCLR, I would suggest that you start with this article. This article delves into the comparison of SQLCLR vs traditional T-SQL, its advantages and the usage scenarios where it is most beneficial - a must read.
The best way to learn about SQLCLR is by developing a Hello! World application. And this article walks you through setting up your very own first SQLCLR application, giving best practices recommendations along the way.
https://msdn2.microsoft.com/en-us/library/ms131052.aspx
As we all know, at times the applications that we develop may or may not work as expected. As a result, it is also important to learn about debugging techniques for SQLCLR. This article does a great job at explaining debugging.
https://msdn2.microsoft.com/en-us/library/ms131096(SQL.90).aspx
At the same time, there are special considerations for deploying your SQLCLR applications on a production server. Learn more about them here.
https://msdn2.microsoft.com/en-us/library/ms345099(SQL.90).aspx
Another great article to mark as a favorite is this one.
NOTE - for everything SQLCLR, including the ones above, refer to this link https://msdn2.microsoft.com/en-us/library/ms131102(SQL.90).aspx
WEBCASTS
I love webcasts and the interactive delivery format, along with the ease of use. I thought I will share some webcast links as well.
SQL Server 2005 Essentials: SQL/CLR
T-SQL vs. the CLR in SQL Server 2005- How Should You Choose?
BLOGS
The development team that wrote SQLCLR in SQL 2005 has its own blog. If you are really interested in the esoteric implementation details and concepts of SQLCLR, this blog is a must read.
https://blogs.msdn.com/sqlclr/default.aspx
Other Resources
For other important developer features introduced in SQL 2005 (like XML support etc.), refer to this article which provides further resources on each topic.