Updating file author attribute with vb

22 May

Filestream allows us to store and manage unstructured datain SQL Server more easily.

Initially, the accounts of FILESTREAM assumed prodigious powers of concentration and cognition, and we mortals all recoiled numbly.

If the SQL Server 2008 instance is already installed without FILESTREAM feature, it can still be enabled following the steps explained later in this section.

The easiest way to enable FILESTREAM feature is to do so as part of the installation process.

The default installation of SQL Server 2008 disables FILESTREAM feature.

The property page will show an additional tab labeled ‘FILESTREAM’, which looks exactly the same as the FILESTREAM configuration page shown as part of the installation wizard.

The other approach is to store the unstructured data as disk files and store the location of the file in the table along with the other structured data linked to it.

This approach was found to be good in terms of performance, but does not ensure transactional consistency.

The FILESTREAM feature allows storing BLOB data (example: word documents, image files, music and videos etc) in the NT file system and ensures transactional consistency between the unstructured data stored in the NT file system and the structured data stored in the table.

Storing BLOB data in NT file system, allows SQL Server to take advantage of the NTFS I/O streaming capabilities and at the same time, maintain transactional consistency of the data.