An SQL solution for The Energy Saving Trust: Ballard Chalmers Ltd App Development project at Qualified.One

An SQL solution for The Energy Saving Trust by Ballard Chalmers Ltd

Some details


DECC (formerly DEFRA) and the Energy Saving Trust concluded that their third party hosted software did not allow the level of control needed to maintain the software to the most current level, and that the current architecture did not truly promote a high availability model.

The aim was to move the hosted solution to a more cost effective internally hosted model, combined with upgraded

infrastructure and a more robust redundancy model, allowing true high availability. 



Ballard Chalmers was appointed to handle the Energy Saving Trust project, based on their reputation and expertise with Microsoft SQL Server and Microsoft IIS. 

Ballard Chalmers undertook consultations with the website developers at EHS Brann and the Network and Infrastructure teams at EST, to ensure that the hosting transition was detailed to meet the planned move date of January 30th 2009. 

A single instance SQL cluster was built to host the working SQL Server database, with storage being provisioned by the EST SAN solution.Two independent website servers were built, fronted by a Radware load balancer to host the working website. 


The solution was completed successfully and being a predominantly Oracle House, DBA Training was also provided to allow the DBA Team the ability to build, monitor and maintain the Microsoft SQL Server solution on an on-going basis.

“Thanks for your support … We are looking at moving more applications to Microsoft technology and we view you as our Microsoft Partner of choice for future work.” - IT Project Manager at the Energy Saving Trust.

Our key services