Monthly archives: November, 2018

The principle of recent change

Recently, I’ve been writing about hypothesis generators – techniques you can use to generate problem-solving ideas if you get stuck. The next hypothesis generator is the principle of recent change.   You can use this one if you are looking at system that worked at one time, but is not working now.   The principle of recent …

Make it look like this!

In my last article, I introduced the first of the hypothesis generators – techniques you can use to generate problem-solving ideas if you get stuck. The next hypothesis generator to consider is “Make it look like this”.   You can use this one if you have two separate deployments of the same software system where one …

Poke the box

The scientific method gives you a powerful framework for organizing your troublehacking activities.   When applying the scientific method, you formulate hypotheses and then your work focuses on proving or disproving the hypotheses. But just how do you go about formulating a hypothesis?   Sometimes all it takes is a few minutes of brainstorming, but what do …

Understanding the performance of SQL statements in Oracle

Introduction Sometimes, a performance problem appears rather suddenly. One day, performance is reasonable but the next, operations are much slower. This can sometimes be caused by a change in behavior in the database layer. Oracle, for example, may change execution plans for SQL statements after updating statistics. In this article, I’ll look at why that …

In practice

In theory, there is no difference between theory and practice. But, in practice, there is. Jan L. A. van de Snepscheut as quoted by Doug Rosenberg and Matt Stephens (2007) Use Case Driven Object Modeling with UMLTheory and Practice p. xxvii Most of the TROUBLEhacker site discusses the theory of troubleshooting.  There is material on …

The coffee machine

I was recently reminded about the difficulty in seeing what’s there by my coffee machine.  My mental model of the coffee machine is pretty simple:   I put in the grounds, I add water, and I press a button to make coffee.  My machine has some other features and some other buttons, but I don’t care …

Put your experience to work!

Do not fall into the error of the artisan who boasts of twenty years experience in his craft while in fact he has had only one year of experience — twenty times. Trevanian in Shubumi:  A Novel. I genuinely enjoy problem solving.   But there is one thing I hate:   solving a problem more than once.    …