Date: Monday, February 20
Time: 7:00pm
Place: North York Central Library (North York Centre subway station)
Room: Auditorium (second floor above the Library)
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.
Time: 7:00pm
Place: North York Central Library (North York Centre subway station)
Room: Auditorium (second floor above the Library)
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.