For all you fans who haven't heard of these sites yet, here you go:
www.gateworld.net
www.stargatealliance.com
The first site offers a load of information regarding all 9 episodes [yes, I correctly said NINE] as well as spoilers and screenshots.
The second site gives information about the upcoming game Stargate: The Alliance [yes, I correctly said GAME]. It includes screenshots as well as video previews and wallpaper. Very in-depth.
Seasons 1-7 are out in DVD sets. I don't know about when Season 8 will come to the shelves and Season 9 will only come in TV somewhere around mid July.
Simviation Forums
Flight Simulator and other chat
Ramos