I personally would use SQL Server Express 2008 R2. You can download it for free from Microsoft
here[
^]. This is a free version that will let you have databases up to 10G in size. Of course if you are looking for something smaller, or embedded where you don't have to be running a separate server, then SQL CE would be good. SQL CE is installed with Visual Studio.