Sebastian Jacob, Aelterman Sven. The Art of SQL Server FILESTREAM

Simple Talk Publishing, 2012. — 487 p. — ISBN: 978-1-906434-88-5A Quick Start Guide for developers and administrators.
This book attempts to guide you, step-by-step, through every phase of FILESTREAM
implementation, from enabling the feature, to creating FILESTREAM tables, to manipulating
FILESTREAM data through the streaming APIs, to handling FILESTREAM data in
simple ASP.NET web pages, to complex N-tier .NET applications.
It also covers, in detail, administration and troubleshooting of FILESTREAM databases
and tables. Alongside the advantages offered by the technology, it tries to cover
some of its shortcomings, and to offer practical advice on workarounds, or possible
alternative solutions.The primary audience for this book is the SQL Server developers who have to deal with
more than relational data. It will help them to get started with FILESTREAM-enabled
databases, and it provides a very detailed coverage on accessing FILESTREAM data
through the .NET and Win32 APIs. We have provided a reasonable number of examples,
sample code, and labs that demonstrate how to access FILESTREAM data from C#.NET,
VB.NET and C++. In addition, there are several labs demonstrating FILESTREAM access
from common application platforms/tools such as ASP.NET, Silverlight, SSIS, SSRS (SQL
Server Reporting Services), Entity Framework, LINQ to SQL and so on.
The secondary audience for this book are any SQL Server administrators and technical
project managers on projects requiring the storage and retrieval of BLOB (Binary Large
Objects) data. The second half of the book is dedicated to FILESTREAM database administration-
related topics covering almost everything you might need to know when dealing
with FILESTREAM-enabled databases.Chapter 1: Storing and Managing Unstructured Data
Chapter 2: Getting Started with FILESTREAM
Chapter 3: Accessing FILESTREAM Data from Client Applications
Chapter 4: FILESTREAM with Entity Framework and LINQ to SQL
Chapter 5: FILESTREAM with ASP.NET and Silverlight
Chapter 6: FILESTREAM with SSIS and SSRS
Chapter 7: FILESTREAM Database Administration
Chapter 8: Backup and Restore for FILESTREAM Databases
Chapter 9: Investigating FILESTREAM Databases
Chapter 10: Integrating FILESTREAM with other SQL Server Features
Chapter 11: FileTable
Chapter 12: Planning, Configuration and Best Practices
Appendix A: Configuring FILESTREAM on a SQL Server Instance