Here's a wide shot (60s at 800 ISO) - the Plough is mostly obscured by the tree, but Alkaid is the bright star about to sink into the centre of the roofline of the extension and Mizar/Alcor are just disappearing into the tree above and to the right.
M101 and the supernova are pretty much dead centre of the image but aren't visible in this wide shot:
This one is a very heavily processed 60s, 1600 ISO exposure of the tiny piece of sky I'm interested in. The random dots are noise in the camera chip, it's the diagonal trails we're looking at:
The AAVSO have a nice image of the supernova (they designate it SN2011fe) in the starfield which helps when locating this kind of thing:
And here's my image overlaid with the one from the AAVSO website, just so you don't have to take my word for it that I managed to grab a few photons at the end of their 21 million year journey :-)