I am an NSR sturgeon rookie as well, and always like to hear tips and tricks from the guys who have had success...
I tried it out twice last fall in NSR. I launched my boat at Goldbar and tried a couple nice holes (11-15' deep) between Goldbar and Rundle Park. I've done a couple guided sturgeon trips with success on the Fraser River in the past and tried to employ a similar tactic that I learned there.
I've just been using a 7' heavy action rod, 30lb braid on a standard baitcasting reel. I rigged up my line with a 3-way swivel. On the bottom, a 3oz pyramid weight, and on the business-end an 18" floro leader with a 4/0 circle hook. As for bait, I've tried large dew worms and smelts. I know on the Fraser we used salmon roe-bags and just simple fresh cut-bait and it works like a charm.
I didn't have any luck yet, but when I can get back out on the NSR I'm going to try some different baits. Everyone seems to have their favorites, but I tend to think that if you have a bait near the bottom at the right time, a sturgeon will take almost anything. I managed to catch a big Sucker with my setup (estimated 10lbs), so I know my rig is in the right zone.
One day I will get lucky I hope.
.