I also use a NCV more or less the same way as Fungus mentioned: go/no-go immediately before and after cutting power to the circuit, either via a breaker or a light switch. I also have a simple dual pole voltage tester to take with me, especially to weird places where access is limited as it is quite portable. However, it also does not give information about if a wire is live or not if you simply plug them between neutral and live - I have seen and been exposed to weird installations where a live at 240 or 380V was properly cut off by its breaker but, due to imbalances on a crap installation, the neutral was in a weird high voltage of around 100V. The tester was happily showing zero volts between live and neutral, but a test between live and ground and neutral and ground is what saved my bacon.
Also, for the regular outlet or lighting fixture around the house, I take my old and trusty neon screwdriver. Yes, people freak out about it but, as long as it is properly inspected and well built, it reliably shows if a wire will in fact shock you.