Sql Server Express Edition

I’ve been keeping my eye on this for a while now.  A couple months ago I installed it on my desktop at home to start developing my dad’s new website PBJ Unlimited and also installed a technology preview of the SQL Management Studio Express, which looks to be just as featureful as the non-express version.

A couple days ago I checked to see if they had released a new version of the management studio and was greeted with the download for the Advanced Services  – which includes full text indexing.   All Free.  Free to use, free to redistribute.  Fantastic.

Some of you may be familiar with Chef, the recipe/kitchen application I wrote about a year ago.  Its current database is Postgres, which was chosen for a number of factors: stored procedures; full text indexing; transactions; runs on linux (I didn’t have a windows server at the time); free.  Well, now that I have a nice new Windows server, and SQL Express now supports full-text indexing, I’m porting the database to SQL Server and will rewrite the app from .Net 1.0 to .Net 2.0.

Last night I got the database ported.  It really only took an hour or so, including the 20 minutes to get full text indexing enabled and configured on my tables.