emis health

technical support consultant · leeds · december 2015 to september 2016.

impact

• t-sql deployment configuration spanning 90% of the clinical systems in england and wales. the nhs’s patient records kept running.

the organisation

emis health supplies the clinical systems most gp practices in england and wales run on. a change to its deployment reaches the patient record of most of the country.

what i did

the sql that configured the deployments. it was written to run fast on systems that could not be slow.

what it meant

i wrote sql that had to be right the first time and fast every time. i learned everything there is to know about relational databases at nhs scale.