I want to connect to sql server from my home computer to my servers sql server.
I know people say this is a security issue, but rackspace cloud sites seems to be allowing it? :)
Anyhow, how hard is it to do?
You don't mention the SQL Server version, but here goes:
In both cases, you may need to Configure the Windows Firewall to Allow SQL Server Access
You need to have the SQL server port opened through your office firewall. The SQL port is usually 1433.
At your office firewall they need to open the port, and forward it to the IP address of your SQL server.
In your SQL connection, you then use the IP address (or the FQDN if it has one) of your office internet connection.
As for how hard this is, this depends on whether or not you have access to the firewall yourself, or if you have to convince a sysadmin to do it!
If in any doubt, please see this MS KB article.
If you open up a live chat from the link on their page (clicky) I can pretty much guarantee someone will do their best to help you. That's what they pride themselves on.