Chop Shop

Finally got around to posting my first article to CodeProject.com. I’ve found the site to be quite useful, and I’ve been wanting to contribute to it for some time now. I figured I could fill a niche related to saving and retrieving files to/from a SQL 2005 and above database.

Check it out here – http://www.codeproject.com/KB/database/sqlFileExample.aspx

I have gotten a few comments about the FILESTREAM storage new to SQL 2008. This MSDN technical article shows a nice chart comparing various ways to store files used with a database application – http://msdn.microsoft.com/en-us/library/cc949109%28v=sql.100%29.aspx.

And the comments are correct – FILESTREAM is nice, but only works with SQL 2008. I will be planning to add a short section to my article, explaining FILESTREAM. Check back for updates soon!