SQL Server 2008 November CTP is now available here.
This CTP introduces new functionality across all of the core themes of SQL Server – Trusted, Beyond Relational, Dynamic Development, and Pervasive Insight. For example, it helps manage a mission critical and productive data platform with key features such as compatibility with Windows Vista and Windows Server 2008 as well as Resource Governor, Declarative Management Framework and Transparent Data Encryption.
The CTP is also the first to help customers store and consume any type of data including new FILESTREAM data types and to provide support for spatial data. New business intelligence enhancements include improved performance, usability, and data visualization.
You can also read the first 3 customer case studies on SQL Server 2008:
You can find lots more info on http://www.microsoft.com/sql/2008
Finally, if you're in Ireland are want to try out SQL Server 2008, are interested in joining the list of case studies, or simply want development resources for BI or info on Application Compatability with SQL Server 2008 do contact me.