Yukon

Hosts the CLR in-process for greater control. Your stored procedures will be written in managed code. Must be verified managed code. This means greater flexibility while maintaining security and server stability.

• Takes over CLR memory allocation
• Yukon takes all the memory for caching, and then provides it back to the CLR as needed.
• Takes over CLR exception handling
• Takes over CLR security model
• Takes over thread scheduling
• Runs fibers, not threads, so MS SQL server schedules them.
• Inspects managed code before it is loaded
• There are security overrides to get unmanaged code to load.
• Prefers no static data.
• Aborts/Terminates user code at the slightest provocation
• This includes infinite loops or any process that takes too long.

User defined data types and aggregates will be supported.

MS SQL Server only works with .net 2.0

Borland has a new database that runs completely in process with 100% managed code. It is based on JDataStore. More details on that as they become available. Called NDataStore, runs on the compact framework. Only has a 1 mb assembly, smaller for the compact framework.

Yukon is Microsoft's attempt to enter the enterprise.