Experience working with MSSQL or MySQL to query databases
Sam Hardy | Sunday, March 22nd, 2020
HEE had a number of MySQL databases covering TIS.
Our team leveraged his significant experience of querying databases:
-Created SQL scripts to manually load National Insurance numbers into TIS.
-Used custom SQL queries to identify process issues in current ESR code.
-Wrote comparison SQL script for pilot testing.
-Helped HEE staff troubleshoot SQL issues.
-Conducted Neo4J (Graph Database) PoC; improving slow query performance on main TIE pages.
This resulted in National Insurance number load reduced manual work for approx 50,000 rotations. PoC reduced the runtime of a query from ~15 seconds to under 400ms on a low powered machine.