The HOPS site was looking very dated and for legal compliance reasons they needed to update it with some specific information.
I suggested they use WordPress as basic brochure site, and using the WordPress CMS functionality to allow their existing non-IT staff up populate it with the pages they needed.
This was initially a basic WordPress installation, with a theme selected by the client, blogging and comments turned off, and a few security plugins installed to keep the system safe.
Later they needed a plugin developed to authenticate users against authorisation data stored on their MS SQL database. I achieved the connectivity to MS SQL using the freetds Linux library together with PHP. After some fiddly configuration, the link to MS SQL was reliable and fast. The PHP WordPress plugin was able to easily fire SQL queries to the MS SQL database, authenticate users, and grant or deny access to restricted pages.