If you don’t have the money to buy a digital SLR you inevitably have to deal with digital noise (digital SLRs have vastly larger and better imaging chips). So far, I used to work with Neatimage, which I recommended here a while back. The other day, John P. brought Noiseware to my attention. Having processed about three dozen photos I think Noiseware is indeed a bit better.

Update: Mark T. told me about another tool called Noise Ninja.