SQL server 2008 Filestream

32 minutes, 25 seconds
Close

Download

How do I download the videos?

  • To download, right click the file type you would like and pick “Save target as…” or “Save link as…”

Why should I download videos from Channel9?

  • It's an easy way to save the videos you like locally.
  • You can save the videos in order to watch them offline.
  • If all you want is to hear the audio, you can download the MP3!

Which version should I choose?

  • If you want to view the video on your PC, Xbox or Media Center, download the High Quality MP4 file (this is the highest quality version we have available).
  • If you'd like a lower bitrate version, to reduce the download time or cost, then choose the Medium Quality MP4 file.
  • If you have a Windows Phone, iPhone, iPad, or Android device, choose the low or medium MP4 file.
  • If you just want to hear the audio of the video, choose the MP3 file.

Right click “Save as…”

Filestream is a  new feature in SQL server 2008, that allows storage and efficient access to BLOB data, using combination of SQL Server 2008 and NTFS file system.

It provides  an easy way of handling BLOB data with database transactional consistency, integrated management, security and excellent streaming performance.

It basically maintains transactional consistency between the structured and unstructured data.

Some of the highlights:-

  • Different forms of data.
  • Support/Implementation of unstructured data prior to SQL server 2008.
  • Considerations to Store BLOB data
  • Overview of Filestream
  • Limitations of FileStream
  • Enhancements

Presented By: - Keerthi deep ,SE,Microsoft GTSC

Follow the Discussion

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.

Related entries

Creative Commons License

© 2014 Microsoft. Except where designated as licensed by
Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 License,
Microsoft reserves all rights associated with the materials on this site.