SQL Server 2005, SP2 CTP Available

Get it while its hot!

Whats New

Download Page (this will be live later today)

I know a lot of people wanted more issues addressed in SP1 but there are all sorts of complex timing issues when it comes to planning an SP, especially on a new code base like SQL2005. This SP has a LOT in it, the focus areas were around integration with Office 2007, Vista support and accumulated customer feedback some highlights for me;

Support for Vista

Office 2007 BI Integration for SSAS and SSRS

Support for Hyperion Essbase in SSRS

Support for Oracle in SSRS Report Builder

SSAS Perf - LOTS

Maintenance Plans - LOTS

NEW Datatype in SQL Server Database Engine vardecimal, a compressed decimal type

Common Criteria support in SQL EE

Reports in SSMS, customizable, more perf, easier to discover

Scripting in SSMS, drops as well as creates, richer options

SSMS Express, support for reports, support for SQL Server Compact Edition

Graphical Showplan, better use of space