FILESTREAM Data in SQL Server 2008

We have been covering the new features in SQL Server 2008 in some of our blog posts. In some of those, we had also discussed the new data-types in that release. You can search for SQL Server 2008 on this blog site to get to all those posts. In today’s blog post, we will discuss what can be done for designing and implementing FILESTREAM storage in SQL Server 2008. Prior to SQL Server 2008, storage of items like documents, images was typically done by storing a link in the table column and storing the documents and images in a particular mapped out location on the SAN or other storage device. For images, some people also used to store it in the imsage data-type but that was not always the most performant solution.

Read More >>