SQL CLR Integration
I've been listening to heaps of the TechEd sessions from San Diego while driving around in the car. Just finished listening to Mahesh Prakriya and Ramachandran Venkatesh in DAT318 on .NET CLR programming in the database. Interesting session - reiterated much of what's in the white papers but I picked up a few gems I wasn't aware of.
If you use VS2005 to deploy a SQL Server project to the server and are in Debug release mode, the assembly, the pdb files and the source code all get deployed to SQL Server. I haven't looked at how you retrieve them from there yet but it certainly opens up some interesting possibilities, such as a roll-your-own server-side recompile of the assembly.