An Introduction to Custom Managed Database Objects

The capability to run managed code presents a world of possibilities, yet these features must be leveraged appropriately. The meaning of appropriate will ultimately be the result of ongoing dialogs between database administrators and the developers who want to use the .NET Framework in SQL Server.

Just like SQL Server’s capability to host web services (covered in Chapter 48, “SQL Server Web Services”), this feature set begins to blur the line between SQL Server as a database server and SQL Server as a lightweight application server.

.NET assemblies are built using Visual Studio or the command-line compilers and then literally uploaded into the database and loaded into memory on the same physical ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.