The Debugger Mindset

Today I want to talk to you about a serious mental disorder that affects far too many programmers. The symptoms of this disease are many: Frantically saying “It’ll work this time” Randomly adding +1 and –1 to integers Inability to see the forest Irritability Irrational paradoxical statements like “I am sure this is impossible, but I don’t know how it …

Step 1: Reproduce the Problem

I’ve spent a good deal of my programming life “spinning my wheels.” I don’t like to admit it, but I have spent countless hours trying to solve problems I didn’t fully understand. When you sit there trying to fix a defect or solve a programming problem without first reproducing it you are like a bicycle thief hopelessly spinning the dials …

apollo 13 image to show why complicated sql should be checked

Using SQL to Check Complicated SQL

Complicated Queries I frequently find myself in the position of having to write fairly complex SQL queries in order to get a list of data that matches a certain criteria.  One problem with complicated SQL queries is that it is very hard to know if the result you have is correct, especially when your query involves multi-table joins and sub-selects. …