A couple great questions came up last week when discussing FILESTREAM with some people within the Microsoft field which I thought were worth sharing.

 

Q: Will SQL Server 2008 Express edition support FILESTREAM?

A: It sure will!

 

Q: Will the 4GB limit of Express apply to data stored in the FILESTREAM?

A: Nope...  Go ahead and store large binary files!

 

As you may have noticed I'm really excited about binary data becoming a first class citizen in SQL Server 2008.  Once you dig into it I think you will agree.