Read the manual about the d3d_alphatransparency variable: this is the normal solution. You'll need a different color than black for the background, then. Another solution is the mentioned sprite effect on the Wiki.

While TGA files with alpha channels, or the nofilter flag would solve this problem too, they are not recommended due to their disadvantages.