Programming SQL Server 2005 with .Net

Slides are can be downloaded here .     Download Code Samples

SQL Server 2005 (code name Yukon) opens up the opportunity to run .Net code right inside SQL Server Engine on a par with T-SQL. This gives the programmer an expanded choice of programming language. This presentation shows you how to write C# or VB.Net routines and execute them in SQL Server as one of the supported SQL object types:

• Stored Procedure
• Scalar or Table User-defined Function
• Trigger
• User-defined Type
• User-defined Aggregate

Each of these objects has its own requirements .Net code to work in SQL Server. Included in the presentation are two key factors that must be accounted for in all SQL/.Net code:

• Using SQL Types and .Net Types
• Working with the SQL Server managed data provider

The presentation also touches on high level topics such as:

• When is it appropriate to use .Net code versus T-SQL
•  A preliminary look at performance of .Net code.

Scheduled Presentations: