Wednesday, October 9

Bluetooth keyboard lag in Windows

If your Bluetooth keyboard takes a little while to get started typing try the following: 1. Open Device Manager 2. Find your Bluetooth radio device, it will likely start with the name of your computer manufacturer or Quallcom, Broadcom or similar. Ignore the 'Mircrosoft xxx' ones. 3. Right-click, select 'Properties' then 'Power Management' 4. Un-check the 'Allow the computer to turn off this device to save power' option. Obviously this is just a 'Works for me' solution but may save you some time re-installing device drivers/taking the keyboard back to the shop etc. Hope it helps.

Sunday, January 20

OData vector logo

OData logo Vector vs Raster

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

Friday, May 11

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.

Thursday, January 19

Anti-pattern 123

Trying to update a password on 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'


Friday, September 10

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

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

Wednesday, January 20

American Pixels

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

American Pixels

Wednesday, December 23

Grouping SQL by month, week etc.

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


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.