Ahooi

Jan 09

Dates … don’t you HATE dates in databases / SQL?

Ok so today I had to move the odd million records into a SQL database. A couple of thousand jumped across happily and then it all went wrong! The error message complained of wrong data types, but my dates seemed perfectly happy and the fact that they came from a date field in another database gave me confidence that that is not the case. 

It turns out that SQLServer installs itself with US date systems, which is fine if you live in Yankland, but if you sit on freezing island called the UK then it causes headaches…

So to fix it I ran the following command:

sp_configure 'default language'

 sp_configure 'default language', 1
   reconfigure with override

Which  sets you up for the UK. If you need the codes for other countries - Google is your friend!

Hope it helps someone - I know I will probably refer back to this page soon enough!

Nov 27

Taken with instagram

Nov 16

[video]

Oct 31

metroa greece - Google Search -

Next Bankholiday destination

(via Splashes - a set on Flickr)

Sep 27

Digital Dead Sea Scrolls

Sep 26

Some more Whackhead -

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090121.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090706.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090707.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090709.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090710.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090713.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090714.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090715.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090716.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090717.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090720.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090721.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090722.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090723.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090724.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090727.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090728.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090729.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090730.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090731.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090803.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090804.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090805.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20090806.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20100915.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20100916.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20100917.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20100920.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20100921.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20100922.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20100923.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20100927.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20100928.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20100929.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20100930.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101005.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101006.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101007.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101008.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101013.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101014.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101015.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101018.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101019.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101020.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101021.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101022.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101025.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101026.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101027.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101028.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101029.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101102.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101103.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101104.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101105.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101109.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101110.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101111.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101112.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101115.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101116.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101117.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101118.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101119.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101122.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101123.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101124.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101125.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101126.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101129.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101130.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101202.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101203.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101206.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101207.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101208.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101209.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20101210.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110110.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110111.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110112.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110113.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110114.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110117.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110118.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110119.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110120.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110121.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110124.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110125.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110126.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110127.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110128.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110201.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110210.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110211.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110214.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110215.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110216.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110217.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110221.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110222.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110223.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110224.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110225.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110228.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110301.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110302.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110303.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110304.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110307.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110308.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110309.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110310.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110311.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110314.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110315.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110316.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110317.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110318.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110322.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110323.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110325.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110328.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110329.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110330.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110331.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110401.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110405.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110408.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110412.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110413.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110415.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110420.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110421.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110505.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110506.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110509.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110510.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110511.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110512.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110513.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110516.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110517.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110520.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110523.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110524.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110525.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110526.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110527.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110601.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110602.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110603.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110606.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110607.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110608.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110609.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110610.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110613.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110614.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110615.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110620.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110621.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110622.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110623.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110624.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110627.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110628.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110629.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110711.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110712.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110713.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110714.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110715.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110718.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110719.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110720.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110721.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110722.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110725.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110726.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110727.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110728.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110729.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110802.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110803.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110804.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110805.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110808.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110809.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110810.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110811.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110812.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110815.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110816.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110817.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110818.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110819.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110822.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110823.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110824.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110825.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110829.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110830.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110831.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110901.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110902.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110905.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110906.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110907.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110908.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110909.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110912.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110913.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110914.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110915.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110916.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110919.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110920.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110921.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110922.mp3

http://www.pod947.co.za/podcast/whackhead/Whackheadswindow20110923.mp3

Sep 19

[video]

[video]

Sep 14

Whackheadswindow20110906.mp3 (audio/mpeg Object) -

Man this made me laugh today!

Here’s some more Whackhead Simpson clips:

Aug 30

(via Taga Bike Is So Cool It Makes Me Want to Have Kids)

Aug 23

[video]

Aug 19

(via Bike’s Round Booty Makes for a Smooth Ride)

Aug 17

[video]

Aug 12

(via Scosche myTrek Keeps Your Heart in Check While You Exercise)