The latest SQL2K8 CTP is finally available. Download it here.

This CTP contains a ton of work. Here's the not so brief list of areas. You can read the details in the "What's new" doc for the November CTP.

• Data Collection and Performance Warehouse for Relational Engine
• Service Broker Enhancements
• Registered Servers Enhancements
• Synchronous net-changes change tracking for SQL Server
• T-SQL IntelliSense
• Declarative Management Framework (DMF) Enhancements
• Geo-spatial Support
• Analysis Services Query and Writeback Performance
• Robust Report Server Platform
• Integration Services - Lookup Enhancements
• Analysis Services MDX Query Optimizer - Block Computation
• Analysis Services Aggregation Design
• Analysis Services Cube Design
• Reporting Services Scale Engine
• Transparent Data Encryption
• Resource Governor - Limit Specification
• Backup Compression
• Plan Freezing
• Fully Parallel Plans Scale on Partitioned Tables