OData vector logo

I couldn't find a vector version of the OData logo anywhere (2 minutes searching to be fair...) so I thought I'd knock one up.

Hopefully not treading on any toes here - if there is an 'official' logo - feel free to let me know and I'll link to that instead.

Files: .svg | .eps

Getting rid of “there was a problem sending the command to the program” without compromising security

Rihan Meij has a clear write up and step by step solution to a niggling problem with Visual Studio I've been facing for about 4 years without ever getting round to solving it.

Anti-pattern 123

Trying to update a password on 123-reg.co.uk it turns that they only allow EXACTLY 8 character long passwords.

yet the form allows you to enter any number of characters. They have a strength check but no clear indication (people don't read instructions...) you can't submit a password without 8 chars until you click 'Change Password'

Bizarre.

Dating site users can't write above 9th grade level

And other useless but nonetheless fascinating stats sourced from OkCupid's online profiles

http://blog.okcupid.com/index.php/the-real-stuff-white-people-like/

American Pixels

I'm not sure why I love these pixtures...

American Pixels

Grouping SQL by month, week etc.

Excellent summary from Jeff Smith on how best to group data by time periods.

Quickhint:

If in doubt, the ‘go-to’ technique is to use

GROUP BY dateadd(month, datediff(month, 0, SomeDate),0)

replacing ‘month’ with any of:

• year


• quarter


• month


• dayofyear


• day


• week


• hour


• minute


• second


• millisecond


• microsecond


• nanosecond

Read the article for a great write up on the whys and wherefores and as always your mileage may vary – testing the various techniques with your own data is the only sure way of getting the performance you need.

It’s good to talk

Whilst trimming your nose hair apparently….

Shopping for an answer machine, amazon was really helpful.