Zach and I just spent a couple of days figuring out how to make use of the new FILESTREAM support in SQL Server 2008 and we thought we'd share a little bit about the experience in hopes it might save somebody some time.

There's a ton of information out there regarding FILESTREAM, but in case you need more detail you can check out some of the SQL Server 2008 CTP content on Connect.  FILESTREAM support will be enabled in CTP5.  From the perspective of user experience, FILESTREAM is going to enable some interesting scenarios.

 

image

 

The following is here : http://blogs.msdn.com/rdoherty/archive/2007/10/12/getting-traction-with-sql-server-2008-filestream.aspx

and here :

http://blogs.msdn.com/zowens/archive/2007/10/11/sql-server-2008-filestream-and-wpf-mediaelement.aspx

Parts 2 and 3 yet to be published...