SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

The Journey to Katmai

I wrote an article recently on the Journey To Katmai, looking at some of the new features that are coming in SQL Server 2008. I've actually got a second part almost done, so I'm trying to learn more about this next version of the platform to finish it. From what I've seen, things aren't feature complete and there are some blog references to changes that have already occurred since the June CTP was released.

So I was interested to see this course on SQL Server 2008 and took the time today while kids are playing amongst themselves to check it out. As you might expect, it's a gross overview, but there is some sample code and there are some cool features explained a little. Some that caught my eye:
  • Auditing - with a new AUDIT keyword.
  • The ability to uninstall service packs as well as package the entire install as a transaction
  • The Resource governer
  • A separation in ADO.NET to allow developers to work with "entities" instead of tables. Kind of an Object-relational mapping.
At this point, given what I've seen with versions of SQL Server over the last decade and a half, I'm going to recommend you NOT upgrade your systems to SQL Server 2005. You'd be better off learning more about the platform, practicing skills and changing applications to take advantage of new features and upgrade to SQL Server 2008 next year.  

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest


No comments.

Leave a Comment

Please register or log in to leave a comment.