SQL Server 2005/2008 provides .NET developers with the ability to embed their assemblies in stored procedures, functions, triggers, and user-defined types. The value of this model is that functionality can be brought to the SQL platform that is not natively supported by SQL Server or simply out performs the T-SQL way of achieving a task.

Implementing a .NET assembly in SQL Server is both powerful and surprisingly simple but this new tool is not the answer for everything. A little knowledge of when to use it, when NOT to use it, and a good working relationship with your DBA will go a long way towards making your efforts with SQL CLR successful.

This talk will address the nuts & bolts of writing, ʽregisteringʼ, and running your assemblies from within SQL Server as well as the essential role of the DBA in this collaborative effort.

Presented by Matt Fritz

Applications Manager/Developer, Empire Merchants, LLC