Search Server Express 2010: Trial period for this product is about to expire

Recently I did a Search Server 2010 Express deployment. Everything went without a hitch. Preflight, Installation, configuration, and first few crawls all worked the first time. (As they should!)
After 48 hours I cycled back to check the status of the system and found an issue. Specifically in Central Administration > Review Problems and Solutions > All Reports I found under the Configuration Category “Trial period for this product is about to expire.
Diving in for further detail I saw that the actual source of the error was that “The licensing information not available.” After a little bit of further researching I confirmed that to fix it all you have to do is:
  1. Go to “Central Admin” => Monitoring => “Review Rule Definitions”
  2. Click on “Trial period for this product is about to expire” rule under configuration
  3. Edit it
  4. Uncheck the “Enabled” checkbox.
  5. Save
Useful links

Searching an entire database for a Guid or Unique Identifier

Searching an entire database for a Guid or Unique Identifier can be a bit of a tricky proposition. However a little bit of T-SQL can help…

DECLARE @GUIDHunted nvarchar(60)
SET @GUIDHunted = ‘0A24EC0C-65EE-4519-89DF-ABD3DD24F7EF’

SELECT *, ‘UNION ALL SELECT ”’ + s.name + ‘.’ + ao.name + ”’, count(*) FROM ‘
+ s.name +’.[‘ + ao.name + ‘] WHERE ‘ + ac.name + ‘ = ”’ + @GuidHunted + ””
FROM sys.all_columns ac
JOIN sys.all_objects ao
ON ac.[object_id] = ao.[object_id]JOIN sys.schemas s
ON ao.[schema_id] = s.[schema_id]where user_type_id = 36 — UniqueIdentifier
and s.name != ‘sys’

Here is the output result for a fictional database (just copy the results into a new query window, delete the first UNION ALL and execute).

UNION ALL SELECT ‘myschema.Objects’ , count(*) FROM myschema.Objects WHERE ObjectID = ‘0A24EC0C-65EE-4519-89DF-ABD3DD24F7EF’

UNION ALL SELECT ‘myschema.Objects2’ , count(*) FROM myschema.Objects2 WHERE ObjectID = ‘0A24EC0C-65EE-4519-89DF-ABD3DD24F7EF’

This assumes that programmers weren’t storing guids in nvarchar types or that the programmers didn’t create other user types using unique identifiers.

Free SEO Toolkit From Microsoft

Search Engine Optimization (SEO) Toolkit is a free tool from Microsoft forimproving a website’s relevance in search results.

Features:

  • full-featured crawler engine
  • query builder interface that allows you to build custom reports
  • display of detailed information for each UR
  • ability to manage robots.txt file
  • ability to manage sitemap.xml file
  • It requires an IIS7 enabled computer to run which is basically Vista, Windows 7 or Server 2008. After that it can analyze any local or remote website.

SEO Toolkit can be installed easily using the Microsoft Web Platform.

Google Caffeine Beta: a not quite review

Google released a developers preview of their new search tool, Caffeine, which they claim will improve Google search’s

  • Speed
  • Accuracy
  • Size & Comprehensiveness

The developers version is pre-beta, which really means absolutely nothing when in context with Google, and is fully functional so I took it through a few hoops.

  1. Speed
  2. Accuracy
  3. Index size

1. Speed
I searched for “SharePoint” and got the following results:

Caffeine:

  • Results 1: 110 of about 21,100,000 for SharePoint. (0.20 seconds)
  • Results 2: 110 of about 21,100,000 for SharePoint. (0.10 seconds)
  • Results 3: 110 of about 21,100,000 for SharePoint. (0.12 seconds)

Current:

  • Results 1: 1 10 of about 17,200,000 for SharePoint. (0.14 seconds)
  • Results 2: 1 10 of about 17,200,000 for SharePoint. (0.09 seconds)
  • Results 3: 110 of about 17,200,000 for SharePoint. (0.12 seconds)

Conclusion
Looks like keywords, and their strings, relevancy just increased. As did the index which may explain the almost consist lag in speed, though that could be a resource issue too. All told, possibly just a useless exercise as it is after all, still in “Beta”… However, I do look forward to the imminent deluge of posts that will compare Caffeine to Bing and invariably delve into fanboyism.