To be honest, I think you should really be asking yourself what you want to build first. If you know what you want to build, be it Front-end or Back-end. You'll have a clearer direction on where you want to go and I'm sure people can then recommend the best languages to get you started in achieving what you want to do. Many people start programming without a cause and think that it's easy but in reality without the right motivation to learn i.e. an end goal it's a lot harder. That being said I would probably start with HTML and CSS as a foundation course to help you get started. For this I would recommend: www.codecademy.com

Thanks Jeff, That's very informative. Unfortunately the reason for SQL Server is that our company already uses this server for other applications internally. We're seeking the best route to get certain data out on the web at the moment such as Customer Product Search but through secure means of course. I didn't know about tedious so i'll definitely look into this!