Programming Filestreams in SQL Server 2008
SQL Server 2008 provides a new storage model called filestream storage. Using filestream storage, a large value (blob) in a table is stored as a file on the file system, rather than in the database directly. Accessing the blob can be accomplished by using Transact-SQL or by using transactionally-consistant, optimizes streaming-style APIs. This talk covers the aspects of defining and programming filestreams in SQL Server using Transact-SQL, ADO.NET, OLE DB, and ODBC.