Writing My Next Question Of The Day

Andy Warren, 2014-04-07

I ran into a simple error last week and saved it to convert to a question. It’s another one where if you saw the error, it’s an easy fix. Minus the error it challenges you to visualize and understand how thing work. Overall I spent about an hour on it over the weekend and reviewing it today before submitting. I put a lot of effort into thinking about solution paths people might think of and deciding if I wanted to encourage each path or stop it (by adding a clarifying detail). I struggled to come up with what felt like were good but wrong answers. I tried to picture a beginner approach (who I think will find this a hard question) and the experienced approach (I think, if I got my clues right, will figure out the answer by elimination then say aha, but maybe it will just be aha). I swear I agonized over every word! And probably still got some wrong. I may at some point try to get a few people to vet my questions before I post (certainly smart to do so), but for now I’m enjoying the challenge of trying to get it right just doing it alone.

I’m looking for patterns, so I’ll call this one a “Question From Error Message” pattern.

My process was to use the error to decide on the final right answer, then start writing a scenario that would cause the error to occur. Then I wrote a couple wrong answers and that made me go back and add some clarifications so that the final right answer was (I hope) the only alternative if you sorted through it all. I was short of good wrong answers so I added some that would seem reasonable if you were new or desperate. Then back again,thinking what would I ask, what would I think? I found some gaps, but it’s hard to get them all.

It will probably be a week or two before it’s published, I’ll post a note here when it goes live.





Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

Robert Davis


1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

Andy Warren


1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

Andy Warren


360 reads