Tech sexy #1

ClearContext
An inbox manager that you can use with a GTD method or not. I had the intention of using it with GTD, but find I get by just fine without the Next Action concept, which I find does not always allay my stress in a multi-step process.

ALOT, if not all, of what this program does can be replicated by slapping Outlook around in some not too difficult ways, but I just don’t have the time and I am attracted by shiny colors.

Top features that I enjoy:

  • Instantaneously converting an email into a task (which you can also do by dragging an email to the tasks tab - but this program INCLUDES the attachments in those messages while Outlook would not)
  • Filing an email with the click of a button
  • Highlighting related items for a message such as “Have I scheduled a follow-up for this?”, “Have I made a task for this?”

And one that I have yet to use but would love to:

  • Defer - schedule an email to reappear as new in your inbox at a later date. Fuck yeah.

Tech sexy #2

Case statements in SQL

Here are some articles explaining its greatness:

Oh case, where have you been all my life?