Windows Remote Desktop Connection for just a single window (or a single program)

This is a feature offered by Terminal Services RemoteApp on Windows Server 2008 and greater. However, your system administrator needs to set this up and publish the app for you.

A poor man's implementation of this would be to run a remote desktop session in a smaller-than-fullscreen window, then maximize the app you want inside that.