Date:
Monday, February 20
Topic:
Developing Managed Code in the Database with SQL Server 2005
Speaker:
Barry Gervin, ObjectSharp Consulting
In this session, we will learn how SQL Server 2005 (code name Yukon) acts as a host for the CLR in a secure and reliable manner. The SQLCLR provides good performance for executing managed code that queries the database within the same process as the database engine. We will learn the techniques for creating optimal queries in stored procedures and triggers, and learn when it is appropriate to use T-SQL vs Managed Code. We will also investigate the creation of your own user defined data types using managed code. These types will be able to be used in functions, tables, and SQL queries, including the ability to perform aggregations on custom data types.
For more information please visit the TVBUG website.