PASS Community Summit 2008: Program Session (Application Development)

SQL Server CLR

Shawn Weisfeld

Session Details

The .NET CLR inside of SQL Server allows developers and DBA's to utilize the power and flexibility of .NET languages (C#, VB.NET) from inside of the SQL Server Relational Engine. These managed languages provide untold opportunities for the developers and DBA's to fully leverage the power of the data they have in their SQL Server to do things that TSQL was not designed or capable of doing. All of this without the need to pull the data out of the database and into the application tier. In this talk we will discuss and give examples of all the different types of objects (Stored Procedures, Triggers, Functions, and User Defined Types) you can build with the .NET CLR inside of SQL Server. We will also discuss the pros and cons of the CLR vs. TSQL. We will conclude with a discussion of the security model surrounding the .NET CLR in SQL Server.

Register Now for PASS Community Summit 2008!