• Great editorial Grant!

    This reminded me of the demise of my checklist. I used to think database tuning was a matter of checking off items on my checklist, in order, as I made corrections. I believed this until some of my changes took a server to its knees.

    Investigation revealed the checklist wasn't the problem - my faith in it was the problem.

    I'd built the checklist from experience. I went back to that experience and instead documented the methodology I'd used to gather measurements and create tests. This methodology replaced my checklist.

    :{> Andy

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics