SQL Server 2008 Delayed until 2H

| | Comments (2)

Just ran into this announcement/blogpost on CNet's Newsblog (when did a blog entry start qualifying as an announcement?).

Looks like SQL Server 2008 has been delayed until the second-half of 2008!  What does this mean for us?  Well, it means we can hopefully delay the inexorable thrust to getting the latest and greatest database technologies in-house, and actually develop really mature standards around the existing and in-production database platforms that we have running.

The SQL Admins might have a better statement on that front, but basically, we're still in the throes of a migration from SQL 2000 to SQL 2005, so thinking of how to migrate from 2005 to 2008 seems quixotic.

Here's a link to Microsoft's SQL Server 2008 Product Overview.  While I'm a little removed from the compelling developer/application-centric features of the SQL-sphere, as a Sysadmin, I'm liking the sound of the: Resource Governor, backup and database compression, and transparent data encryption.

What new features in SQL 2008 are you looking forward to the most?

2 Comments

Thanks for the links, Joe.

From a practical development standpoint, I'm most excited about the T-SQL improvements. At long last, we can pass in table variables to stored procedures. Hard to believe it took this long.

Some other features that are exciting but won't impact daily life in the cube:
- Geography data types
- Star join query optimization (for fun, maybe we should redesign WISP as a star schema datamart!)
- Grouping sets...an intriguing extension to the group by clause

What I didn't see in the product overview but really hope to see in the final version of SQL 2008:
- Improvements to the PIVOT capability that first appeared in SQL 2005. Great idea, but not really useful unless you resort to building a query string and executing dynamic SQL. PIVOT could be so much more!

And finally, I am very happy that SQL Server users everywhere will, at long last, be able to "drive actionable insight." [insert eye-rolling emoticon]

I drive actionable insight all the time, Becky!

;)

Leave a comment

About this Entry

This page contains a single entry by Joe Cruz published on January 27, 2008 11:48 AM.

Juno makes me want to work harder. Weird. was the previous entry in this blog.

What happened to my Shift-Tab? is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

Powered by Movable Type 4.3-en