Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Coming In August

By Steve Jones,

An announcement was released yesterday on eWeek from the Microsoft Worldwide Partner Conference that said SQL Server 2008 will come in August. This means that the RTM must be very close since we're almost halfway through July now. There is also a blog entry from the Database Platform Insider.

While there still could be a delay or two, it appears the SQL Server team will make their goal of shipping a new version within 3 years with plenty of time to spare. Please join me in congratulating them in meeting this goal.

I've recommended for some time that you should really consider SQL Server 2008 if you are looking to upgrade older servers, and now that it's ready to be released, I continue to urge you to consider it over SQL Server 2005. This is my opinion, but from what I've seen, the changes from SQL Server 2005 to SQL Server 2008 are all additions to the product without much change in functionality. This means that any testing you've done on SQL Server 2005 should be valid for 2008 as well.

And think about all the great new features in SQL Server 2008 that you might consider. Some of the ones I think will have a great impact are:

  • Resource Governer - I've sent this to SQL Wish for years, perhaps a decade and I'm glad to see it finally coming. There's some learning and knowledge that needs to come from those of us in the community as we use this feature, but it's a fantastic addition to the product.
  • Policy Based Management - It organizes rules and somewhat replaces DDL triggers, and it's a tool that I was really looking for as a production DBA. Not all the features work with downlevel servers, but you can defintitely run many of your rules against SQL Server 2005 and 2000 servers and find those that are out of compliance.
  • Compression - It's Enteprrise only, but seeing the data compression features make me wish I had a terabyte sized system.
  • Date and Time!! - They're finally separate so you can query as salesdate > '2008/07/09' instead of salesdate > '2008/07/09 00:00:00'.

I'm not sure about other features like TDE ( I foresee lots of lost keys), Sparse columns, Spatial, etc., but the great thing is that you don't have to use them if you don't need them.

Now that things are very close, look for more SQL Server 2008 content moving forward.

 

Total article views: 2084 | Views in the last 30 days: 1
 
Related Articles
ARTICLE

SQL Server 2005 Feature Survey Results

A week ago, we solicited readers to let Microsoft know which of the SQL Server 2005 announced featur...

BLOG

Tobias Ternstrom’s Great Denali Preview

Tobias Ternstrom from Microsoft gave a great talk at Tech Ed regarding upcoming features of SQL Serv...

FORUM

SQL Server Features

SQL Server Features Implemented

ARTICLE

Give us all the features

The mix of hardware and feature limits in SQL Server varies by edition. Steve Jones thinks it should...

ARTICLE

Great Developers

A great developer is worth more than an average one, but how much more? Steve Jones has a few though...

Tags
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones