I use Microsoft SQL Server Desktop Engine 2000 for all my personal projects including the blogs. It is free and comes with the most important features of SQL Server like views, stored procedures, backup etc. It has some limitations in terms of performance when there are many parallel queries but that is not a problem for my small projects. The only thing that bugs me is that it cannot be administered from remote.
Or, it used to bug me, until I found the trick that allows remote access and administration of MSDE:
Click Start, Run
Enter svrnetcn.exe too run the "SQL Server Network Utility"
Select "TCP/IP" from the Disabled protocols and click "Enable >>“ ...