FileStream set-up + PowerShell Load + Full Text Search Demo ...

  • Article

I have just put here (see attachement) an english version of the second part of the demo I did the 2nd of October for the SQL Server 2008 Launch. Video (in french but with the full demo) can be seen here : https://www.microsoft.com/france/Vision/MsDays/webcast.aspx?EID=4d5aa109-73cb-449a-84b9-b610e862bff9 fr

This demo consisted on three parts :

  1. setting up a filestream table and database
  2. loading it with media (videos and text) files stored on a directory using a powerShell script
  3. creating a full text search index on the text doucments

then I was able to demonstrate :

    1. File streaming of video files
    2. Full-text search on textual files (including .txt, .docx, .doc, .pdf - corresponding iFilter installation is needed for this part to work)

For video files, I am sure you can find any on your disks.

For text files, you can find great books here in electronic format : https://www.gutenberg.org/wiki/Main_Page

Here are some sample full-text search requests you can issue on documents store using the FILESTREAM mode :

  • Files wtih the word "Paris"FS 1
  • Files with the words "fenètre" and "fenêtre" (aka window)FS 2
  • Files with the words "église" and "church"FS 3
  • Files with the words "fenêtre" and "church" with several weights     FS Req FS 4

FILESTREAM + PS + FTS.zip