We have the really nasty stored procedure for the product I’m working on at the moment. I have most of it decoded in my head, but I’m leaving the team soon so we figured that I should start ‘training’ people up on it.
Seems ridiculous to have to train people up on how a stored procedure, a bit of SQL!, works, but it has gains an air of mystique about it over the last year or so which has resulted in a reluctance to let it into your head!
Nevertheless, I set about adding copious amounts of comments to the sproc, but even then it just wasn’t clear that the sproc is essentially three sections, and really not that complicated!
I tried drawing it on the computer, but it just wasn’t doing it for me. So, it was time… Time to crack out the A3 and black sign pen, and start drawing!
Why didn’t I do that sooner! It took about 45 mins and there it was, in black and white scribbled glory! The infamous stored proc that has struck fear into the heart of many developers over the last couple of years was now laid bare, it’s structure exposed for all to understand. It’s once mystical qualities blown away…
Ok, perhaps that was a bit dramatic, but you get the gist.
Not a long blog post this one, but I guess I wanted to say, sometimes you just need to draw!