One of the fundamental things that we do as DBAs is write T-SQL code and longtime author here, Michael Coles, has written a new book on programming practices in SQL Server 2005. Just released is Pro T-SQL 2005 Programmer's Guide, providing comprehensive and detailed coverage of the major features in T-SQL, including:
- stored procedures
- triggers
- user-defined functions
- dynamic SQL
- the new XML data type
- SQLCLR
- and more!
You can see a sample chapter here. Download Chapter 14: SQLCLR Programming.
Download the sample code for the chapter as well and get started building your own assemblies.
You can purchase the book online at Amazon or in your local bookstore.