Looking for a killer SQL Server 2012 demo?

Well look no further!  I’m pleased to announce that the MySemanticSearch Sample is now available on CodePlex at:

mysemanticsearch.codeplex.com

MySemanticSearch allows a user to upload Word documents into a SQL Server 2012 table, then visualize the semantic content of the documents in it using tag clouds that are automatically built by semantic search. The user can then find similar documents by comparing their tag clouds.

As seen in Quentin Clark’s Day 2 Keynote at PASS Summit 2011, this simple but elegant content management application shows off the power of several key improvements in SQL Server 2012 including:

• Database blob storage (FILESTREAM)
• Database blob storage file sharing (FileTables)
• Full-text search
• Semantic search

Go ahead and give it a try!  Post your feedback and comments on CodePlex.

Comments

• Anonymous
  October 30, 2011
  Superb - I have been blogging about Semantic Search recently and have only been testing the basic features and also pushing the performance of the engine. This sample demo is excellent. Will give it a go on a number of document collections of various sizes. Thanks for sharing it. Can you tell me if Keyphrases are working in CTP3 not just keywords?

• Anonymous
  October 31, 2011
  @sqlartist: I'm pretty sure semantic search is based upon term extraction only, not phrase extraction.  For that you would probably need to use standard full-text search.

• Anonymous
  November 05, 2011
  The comment has been removed

• Anonymous
  November 16, 2011
  i received this error: "Invoke operation 'CheckServerConnection' failed. [HttpWebRequest_WebException_RemoteServer] Arguments: NotFound Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See go.microsoft.com/fwlink could somebody help me please? regards!

• Anonymous
  January 22, 2012
  Awesome  Application Does it support HTML documents instead of WORD documents ? What languages are supported for indexing text ? Regards

• Anonymous
  February 10, 2012
  Is there anything I need to do to get it to work for Excel Speadsheets? select * from Documents returns one row for test1.xlsx and one for test1.csv SELECT *    FROM semantickeyphrasetable(Documents, *) returns null SELECT name, document_key, keyphrase, score    FROM semantickeyphrasetable(Documents, *)    INNER JOIN Documents ON stream_id = document_key    ORDER BY name, score DESC returns null Following the SQL Server 2012 Training Kit. I replaced word documents with the Excel Spreadsheet, but it doesn't seem to work. How do I check for Excel Filters?

• Anonymous
  March 15, 2012
  I tried RTM, I still can only see word from Semantic Search not phrase. I think if a Semantic Search can't return phrase, it is useless.

• Anonymous
  January 03, 2013
  Looks great! How is the tag cloud realized / visualizied ? What is the technology behind the tag cloud ? Best regards!