Connecting a satellite tuner card to a dish is dead easy, you just get the equivalent cable and connect it to the socket on the wall - you can then get services like freesat (in the UK) or similar.
For sky though I think you'd have to use an analogue capture card and an IR blaster - it's really not the nicest of setups but I don't know of any TV tuner card that can decrypt the sky channels directly.