Right now

This is my first post, and I thought that I'd write about what I'm working on right now. SQL 2008 just came out, and I've decided to try to test it out with our server, hoping that it might fix some virtual memory issues we were having with replication (http://forums.microsoft.com/msdn/showpost.aspx?postid=296390&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=0). So far, it seems to work great, except that you need windows installer 4.5 to run it, and they don't have bootstrapper packages for either that or SQL 2008 express.

Visual studio SP1 just came out a few days ago too. Theres documentation on how to create a bootstrapper package for .Net 3.5 SP1 here http://download.microsoft.com/download/A/2/8/A2807F78-C861-4B66-9B31-9205C3F22252/VS2008SP1Readme.htm#Product%20Issues
but I guess they don't have anything similar for 4.5 or SQL 2008 yet.

The decision to use SQL express was made a long time ago, and it was pretty misguided. I'm planing on updating to SQL Compact pretty soon, and that at least should take care of that problem. The only issue I've had with SQL CE though is that I can't get web replication to work over SSL. I keep getting the error "A request to send data to the computer running IIS has failed.". When I look for solutions to that error, most seem to mention running the SQLCE client on a different domain than the server can cause problems (which they are in my case), but no real solution to fix the issue.