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







 

Comments (3)

  1. Matias Nino says:

    Thank you muchly sir!

    CDW is now able to successfully select my database to copy from my shared hosting commercial provider without erroring out due to the other databases on the server.

    Works like a charm!

    Long live SSMS! :)

  2. Leon Nel says:

    Just installed the Management Studio CTP SP2, and the handling of the tabbed windows is just as crap as before.  On the support forums, this was an issue that Microsoft said they will sort out in the next service pack.  Seems not.

  3. Leon Nel says:

    You’d think this would be easy to fix in SP2, come on Microsoft. What is the use of having a feedback centre and doing nothing about it.

    http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124680

    http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124480