Exams and Recent Work

The two most exciting things to happen are that (a) I passed my Grade 4 AMEB Cello exam a few weeks ago, and (b) I passed my TOGAF 9.2 certification exam the other day. The Azure and Architecture Certifications project page has been updated with my new badge. The cello exam certainly ended up being a bit stressful. First of all, my teacher of 2 years has developed a shoulder injury and could no longer teach from November, so I had to find someone new....

July 2, 2022

Five SQL Optimisation Techniques

I do enough MS SQL Server work every day that I thought it was worth spending a little bit of time writing about five optimisation techniques that I think about every time I need to work on a query. Very often I see code that doesn’t consider these issues and it can make a huge difference to the runtime of a stored procedure, the memory/CPU usage, and even the time it takes you to test things....

June 6, 2022

Temporary Table Name Conflict

This was an error I encounted the other week at work and I thought it worth sharing as it’s a bit of a gotcha. You normally expect that temp tables are fine to share names across sessions since they are designed to be temporary. However, there are a few times when conflicts can occur. See this post on MSSQL Tips for more details. Basically, if we don’t do any of the things that disallow caching, then trying to re-use a temp table name in a “inner” called stored procedure will cause a conflict....

March 19, 2022

Personal Book Review: Stumbling on Happiness

This was an interesting book - not a guide to happiness as you might think at first, but an explanation of some of the psychological reasons why we are bad at predicting what will make us happy. He has some tips at the very end, but mostly it’s a jaunt through the interesting things our brain does to try to help us, and when those things can backfire. This is part review, part me-keeping-notes-for-the-future....

February 27, 2022

Personal Book Review: The Secret Life of Groceries

I thought I’d start making better notes on non-fiction books I read and post them here as a bit of a reminder to myself for lessons learnt, and a sort of tracker for interesting books I’ve read. Thankfully, the local library has quite a large selection. First is The Secret Life of Groceries: The Dark Miracle of the American Supermarket. This is one about the food supply chain in the US....

February 12, 2022