We had an IT exec who also wanted to write code, especially SQL. He would take nice compact stored procedures and turn them into a nightmare. Not only did he rewrite 75 % of the stored procedures, he bypassed our content control system doing it so none of it was documented. He had procedures that would take minutes to hours to run and return very little data. We have so far cleaned up enough of his work that we can shrink our databases by 25 %, remove about 9 million rows of unnecessary data, speeding up the overall performance of our database and web servers. We have since added controls that will prevent circumventing change control parameters as well. Lesson learned: execs don’t write code.