SQL Server 2008 Katmai,

Today I had attended first webinar on SQL Server 2008.  Eventhough the net was slow and voice was breaking somehow I managed to follow that.

 

Some of the key concepts are:

 

1. Enterprise Data Platform

2. Beyond Rational

3. Dynamic Development

4. Pervasive Insight

 

 

Links:

1. To download the SQL server katmai CTP:

    http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx

 

2. SQL server best practices:

    http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx

 

Some of the Features that are very interesting:

1.FileStream data type : We can save word, excel, audio, video files etc. into sql server itself. In SQL Server 2005 to achive the same functionality we need to sql varbinary(MAX) data type which stores everything in binary format.

With the help of filestream format we can handle File System objects in sql server itself & sql server supports ACID properties on this.

 

2. Separate date & time datatypes along with the existing datetime data type, and also a new datatype called datetime2 to store maximum dates.