As with all other types of fishing, success comes with knowledge and time. I myself have just had limited success this year (also being my first year). As eimaj mentioned a trophy sturgeon special or similar rod will do the job great, I have that one and a Shimano Taldora that work quite well both have abu 7000s loaded with 100lb braided line. You will need some sturgie leaders (80lb) and some big hooks (7/0 - 9/0). As for weights, it is like barfishing where it all depends on the current, having said that I tend to stick with 16 or 18 oz weights, but I tend to stay in the lower fraser. As for baits you can use course fish, oolies, worms, roe(fresh I hear works good), ditch eels (apparently you can't get them legally though). I have heard some people use chicken a lot, I haven't tried it yet.
There are a lot of guys on here that know more than me, but I am good at regurgitating information I have accumulated from them and my local shop. As for locations, if you have a boat you are better off, but there are still some spots from shore that you can fish from, however I can't help you there as I am in the boat exclusively.