Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

SQL Server 2008 v WinFS

SQL Server 2008 v WinFS

  • Comments 3
  • Likes


My colleague James has been hassling me for not posting anything of use to him...

A long time ago in a land far far away there was a cunning plan to develop a new file system around a database called WinFS.  This created quite a lot of positive reaction and there was a lot of flak when the project was taken out of Windows server 2008.  I am not going to argue the rights and wrongs of the approach or the decision to abandon it, but in my opinion that capability is alive and well and inside SQL server 2008. 

One of the goals of SQL server 2008 is "beyond relational".  This will show up in a number of the features:

  • The filestream data type will allow any file to be stored in a filegroup like the filegroups used to hold relational data but also to treat the insert, update etc. as a normal transaction i.e. with commit and rollback.  However the file can be streamed quickly into an application as it will be in the file system and the current limit of 2Gb for varbinary(max) will no longer apply.
  • The Spatial data type will allow geographic and location data to be stored
  • Full text search has been overhauled
  • Hierarchy ID allow the relational database to understand relationships between rows in the same table far better than a parent child relationship.
  • Encryption will allow all of this data to be secured.

Add to this the access privileges that work in much the same way and inter-operate with active directory and the the fact that SQL server is behind SharePoint.

So SQL Server 2008 - a file system within an operating system. 

  • Ooooh I love friendly jibes amongst the team :-)

  • Can you post a more detailed SQL 2008 vs. WinFS list?  I'm more curious about the WinFS specific features such as rich relationship types, RAVs, rules, native store support for complex schemas (vs. EF mapping to standard SQL tables).  I have heard bits and pieces about how SQL 2008 is going to be great for the Entity Framework however all of the EF features I've seen so far work fine with SQL 2005 (maybe I've missed some features).  Is SQL 2008 going to include some of the WinFS functaionlity I mentioned above and/or add richer functionality to EF?  I keep hearing "WinFS is alive and well in ADO.NET and SQL Server."  However, EF is not WinFS and the major SQL 2008 features I've read about also are not what made WinFS attractive.

    I, as many were, was very excited about WinFS and was disappointed when it seemed to fizzle out.  I feel like I'm being teased by hearing anything about WinFS.


  • Ike

    Not sure what features you are missing, I did also find this post about winFS

    and I know the team that were doing the work are the same people doing Filestream and the Remote Binary Storage features.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment