August 2008 Entries



SQL Server 2008!

SQL Server 2008 is now RTM!  Truth be told, I have not kept up on the changes now bothered with the betas.  The article that mentioned it was RTM had a link to this article of a quick overview of changes in SQL Server 2008:

http://technet.microsoft.com/en-us/magazine/cc434690.aspx

http://blogs.microsoft.nl/blog_van_mark_voermans/archive /2008/07/15/sql-server-2008-ships-in-august.aspx

 

A few things that jumped out at me:

  • Compression at row or page level
  • Merge - Insert/Update rolled in one (no more check to see if record already exists and the update if it does, otherwise insert the new row, it is all handled by this one TSQL command)
  • LINQ Provider (allowing direct LINQ queries against SQL Server 2008 tables/columns)
  • Date and Time enhancements
  • Filestream data type
posted @ Thursday, August 07, 2008 1:14 AM | Feedback (0) | Filed Under: ** All Categories   Databases