This is a serie of 4 interesting articles discussing better ways to handle BLOB with SQL Server.

Part 1  http://www.databasejournal.com/features/mssql/article.php/3719221
           where definitions are given and where you will find a pointer to a search article : To BLOB or Not To BLOB
Part 2      http://www.databasejournal.com/features/mssql/article.php/3724556
 

where you will find how to insert a BLOB directly in the Database :

INSERT INTO BLOBTest (BLOBName, BLOBData)
 SELECT 'First test file', 
    BulkColumn FROM OPENROWSET(
    Bulk 'C:\temp\nextup.jpg', SINGLE_BLOB) AS BLOB
Part 3 http://www.databasejournal.com/features/mssql/article.php/3732256
  where you will build a sample application to upload  the BLOB :
Part 4 http://www.databasejournal.com/features/mssql/article.php/3738276
  where the application is completed :

 

image