SQL Server has been upgraded to MSSQL Server 2014 for all our existing clients. No changes should be required in your scripts and everything should work as it is, if you have any issues please contact support.
To connect to SQL Server remotely you need to Download Microsoft SQL Server Management Studio which is available free from Microsoft site, then use the remote database server IP, database username and database username's password to connect.
Incase of any issues, please raise a support ticket with your database name and we will assist you.