Can I install MS SQL, Counterstrike, etc.?

Yes, your server is your server! You are free to install any software on your server that you desire. Please keep in mind that we cannot offer support or assistance in installing or configuring applications.