I cannot find out how do I install SharePoint Foundation 2010 with full SQL Server 2008, it seems that installation wizard forces me to use Express edition. Is there a way to use Foundation with normal SQL Server?
What option are you picking during install? Single server and then all defaults? I don't have an installer at hand but picking single server limits your options. Select server farm even if you only have one server. That should allow you to use your SQL 2008 install.