• New Years Day TimeStamp

    calendar May 5, 2008 · 1 min read · mysql  ·
    Share on: linkedin copy
    New Years Day TimeStamp

    Some work I’ve been involved with (see here and here) with UNIX Timestamps threw up another challenge today- getting the timestamp for midnight on January 1st of the current year. This is what I came up with: SQL (using MySQL 5.5) 1mysql> SELECT UNIX_TIMESTAMP(DATE_FORMAT(NOW(),'%Y-01-01 00:00:00')); …


    Read More

  • Clean Hard Drive

    calendar Apr 29, 2008 · 1 min read · it support  ·
    Share on: linkedin copy
    Clean Hard Drive

    This is a Fujitsu Hard Disk which a user has tried to “clean” of any sensitive data by dipping it in hot soapy water (no, seriously). Unfortunately it is likely that the data is still recoverable from this, and because the disk is wet we don’t want to do any kind of formatting which would involve connecting it to a …


    Read More

  • Electric Nuts

    calendar Apr 29, 2008 · 1 min read · it support  ·
    Share on: linkedin copy

    A strange support report, obviously someone hasn’t been following the Tufty club code when crossing the busbars: “Customer has had serious power problems all day as a result of a squirrel munching on an 11KVA feeder, resulting in total power loss, then missing phases, and aircon problems resulting in high machine room …


    Read More

  • Saucy Support Request

    calendar Apr 29, 2008 · 1 min read · it support  ·
    Share on: linkedin copy

    The following email came in from the manager of the company coffee shop: Hi I’m not sure if you are the right people to email but I have a problem with the handset on our phone, its been dropped in strawberry sauce and no longer works.


    Read More