Joel Spolsky mentioned that he is using the full-text search feature of SQL Server and that it required a manual job to re-index the database.

In fact, SQL Server 2000 will monitor a table for changes to a table that is included in a full-text index. The sp_fulltext_table procedure has parameters to 'Start_change_tracking' and 'Start_background_updateindex'.

As I wrote in Joel's discussion board, I have a script I could share that enumerates all indexes on a server and sets the change tracking for all tables in the index.

I didn't plan on being political on this blog, but this quote from Wonkette just cracked me up.

We're Just Glad They're Not Using 9/11 for Political Purposes
Wonkette (http://www.wonkette.com) Sep. 8, 2004

A lot of places are noting the release of a service pack for WSS, but the Admin Guide has been updated as well.

Windows SharePoint Services Administrator's Guide

Weather Forecast ASP.NET user control from Mikhail Arkhipov

When you're incapable of providing leadership or exercising good judgment, substitue an inflexible policy.

Bob Lewis, “KJR” Archive, 8/16/2004

I often use a web page to convert C# code to VB to help me understand it. Sometimes, that is overkill when trying to understand a keyword or two.

MSDN has this page to help in this situation: Keywords Compared in Different Languages

A community site, Attune Systems, has the PowerSearch tool installed. Type “experts” in the search box (top-right for the unfamiliar).

My debugging method of choice is the ASP.Net trace feature. In web config, I set the trace options:

    <trace enabled=”true” pageOutput=”true” localOnly=”true” />

This will dump a bunch of information at the bottom of the page. (WARNING: Do not do this on a publicly accessible machine. It will compromise security.)

In my web part, I include a call to Context.Trace.Write at the beginning of each routine. In the catch blocks, I call Context.Trace.Warn(ex.ToString). This puts the entire exception into the trace output. Plus, it avoids the WSS error page (“The [Name] Web Part appears to be causing a problem.“)