How to connect to SQL Server, VS TFS, etc using Windows Authentication when computer is not on Active Directory Domain

I often move around between different clients, and never join their domains, simply because my machine would get cluttered with policies and logon scripts, so I've encountered this problem before.

To access a fileshare, you just map using

net use \\machinename\ipc$ /user:domain\user

This does not work for connecting to SQL Server with Windows Authentication though. I found this neat little trick to accomplish this:

runas.exe /netonly /user: "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\ide\SqlWb.exe"

This runs Management Studio as the domain user, which can then authenticate to SQL Server using Windows Authentication.

The original article can be found here