Avoid the adapter that you linked. I have the same since I wanted to try it but I figured out that it doesn't work as intended. First of all it's slower than the CF solution and most important it supports MAX 2GB of SD card. Everything larger than 2GB and either the system won't boot or card isn't recognised from 3.9 HDToolBox.
Pyrre's adapter in the link is totally different and since he stated he tested it... you should go in that path if you need an SD card as opposed to CF.
Imho CF is better in every aspect (than the price ofc), since it doesn't use any conversion nor any chip to drive it. It's an 1-1 IDE replacement which makes it very compatible.