SQL Server 2008 has arrived


By:   |   Updated: 2007-06-06   |   Comments   |   Related: More > Upgrades and Migrations

Problem
Too many changes, not enough time.  Here we go again, another new version of SQL Server ready to be launched sometime in the near future.  Microsoft has officially named the next version of SQL Server as SQL Server 2008, so based on the official name I would assume we will see the RTM release sometime in 2008.  This release was previously known as "Katmai", but this week Microsoft has released the first CTP version available for download.  As far as the clients that I work with, most are still running SQL Server 2000, so does this potentially mean a double jump like a lot of people took from SQL Server 6.5 to SQL Server 2000?

Solution
The details are still a little sketchy about what the differences are in this new version, but Microsoft has made available a download of this new version so you can see this in action for yourself. 

Here are some links to this new version:

Based on the information on the website here are some of the new features that are available in this next release:

  • Additional security enhancements
  • Development change to work with business entities vs tables and columns
  • Ability to use any data type
  • Enhanced reporting capabilities
  • New encryption options
  • Improved auditing
  • Failover improvements
  • Automatic recovery from corruption
  • Database mirroring compression
  • Hot add CPU
  • New declarative management framework
  • Data compression
  • Resource governors
  • etc...

Take a look at this document for further insight as well as taking a look at the TechEd webcast.

Nest Steps

  • Download and install the SQL Server 2008 June CTP and see what you think
  • Send us your feedback, so we can let the rest of the MSSQLTips community know what you think.  Send feedback to [email protected].
  • If you have any other information about this new version, let us know so we can inform the MSSQLTips community.


Last Updated: 2007-06-06


get scripts

next tip button



About the author
MSSQLTips author Greg Robidoux Greg Robidoux is the President of Edgewood Solutions and a co-founder of MSSQLTips.com.

View all my tips
Related Resources





Comments For This Article





download


Recommended Reading

Downgrade from SQL Server Enterprise Edition to Standard Edition

Migrate a database from SQL Server 2008 to 2016 and use new features

SQL Server Database Migration Checklist

SQL Server Upgrade Methods In-Place Upgrades and Differential Restore Upgrades - Part 2

Choosing a SQL Server Upgrade Method - Part 1





get free sql tips
agree to terms


Learn more about SQL Server tools