I don't know specifically about Russia but in general it does not make a difference and I would be a little surprised if it did. Being a resident somewhere can exempt you from some requirements (e.g. transit in the UK if you have a US green card) but typically not add some. Similarly, having Canadian citizenship can help you qualify for some exemptions but not make a visa necessary if you already qualify in another way. Basically, you can show one of your passports to benefit from the most advantageous rules.

What could happen in some cases is that border guards notice you are a Canadian resident (because you come from Canada without a visa - if you are a citizen - or have a long-stay visa or stamps in your passport - if you are not) and question you about that (it's more likely to happen with a country they consider sensitive for some reason, which Canada usually is not).

Do citizens of Hong Kong living in Canada - still need a visa to enter Russia for <2 weeks?
In the tie-in of SG-1 and Atlantis, they had to use a ZPM to power the gate, and use an eighth chevron to travel to the Pegasus Galaxy. It was (so I thought) common knowledge that they could only travel to gates within our own galaxy unless they had met those requirements. 

Now, I recently rewatched the movie, in which the probe traveled to the Kaliam Galaxy, or as Catherine put it, "the other side of the known universe." So, why the limitation on the TV show? And why were they able to travel back to that planet in the first episodes?
