|
|
[ Back to Diary Page ]
General Meeting
|
Location:
|
Auditorium, Library 2nd Floor
|
|
Date:
|
Monday, February 20, 2006
|
|
Time:
|
7:00 to 9:30 pm
|
|
Topic:
|
Developing Managed Code in the Database with SQL Server 2005
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.
|
[ Back to Diary Page ]
|