Session Summary

•Challenges for using unstructured data

•The Filestream Feature - An Overview

•Filestream and T-SQL

•OpenSqlFilestream

•System.Data.SqlTypes.SqlFileStream

•Filestream access patterns

•Filestream transactional semantics

Session slides:

DAT203.zip

Session labs/demos:

Demo 1 – FileStream Setup

Demo 2 – FileStream Programming T-SQL

Demo 3 – OpenSQLFileStream – Native

Demo 4 – SqlFileStream - .Net – Read operation

Demo 5 – SqlFileStream - .Net – Insert Operation

Demo 6 – FileStream LoadBalancing

Demos.zip

Fell free to raise questions, comments or any other suggestion regarding this session.