How Do I: Use the Filestream Data Type to Store BLOB Data?
In this podcast speaker speaks about how to configure Windows and SQL Server to enable the Filestream data type. After configuring SQL Server to support the Filestream, he creates a new database and table that uses the Filestream data type. The Filestream data type is new in SQL Server 2008 and enables storing Binary Large Object (BLOB) data like pictures and music as a file on a share to efficiently store the data while treating it as an integral part of the database so backup and restore operations include the Filestream data as well. Filestream allows SQL Server to efficiently manage the rich data that today's applications demand.