By using this splendid application.
Mac: download google books
February 24th, 2010MacBook Pro Battery Life Tips
February 21st, 2010Save your battery life by taking at look at GiantMike.com’s helpful article.
Get the first day of the week from a datetime
February 12th, 2010select dateadd(d ,-(datepart(weekday,getdate()-1)), getdate())
This is straightforwards: the patepart function extracts the weekday from the date, we remove one from that value, turn it to a negative number and then add it back the datetime. Simple.
Remove the time part of a TSQL datetime
February 12th, 2010select cast(floor(cast(getdate() as float)) as datetime)
Basically, we cast the datetime to a float, floor it and convert it back to a datetime. The first step produces a float representation of the datetime in which the date is to the left of decimal place and the time to the right, floor reduces it the lowest whole number and the last cast makes a datetime again.
Too stupid to understand science?
February 8th, 2010Do you think Mac Time Capsule hourly backups are a little excessive?
January 24th, 2010Change the frequency of Time Capsule backup by editing the following le with your text editor of choice
/System/Library/LaunchDaemons/com.apple.backupd-auto.plist
And looking for the section
<key>StartInterval</key>
<integer>3600</integer>
The value 3600 specifies the backup interval in seconds (i.e. 1 hour). Change this value to whatever you see fit – I have changed it to 14400 (or 4 hours).
Needless to say, proceed with caution when editing you Mac’s system settings, and if you do mess up it’s nothing to do with me, right?
Why has this movie not been made?
January 17th, 2010…a fictional 2006 FIFA World Cup Finale between Germany and Netherlands. When the team from Germany loses, they send out as revenge a Zombie invasion
Why? God dammnit why?
My airport shuttle never rendevoused at the extraction point, leaving me defenceless behing enemy lines
January 14th, 2010You came to the wrong neighbourhood…..
January 13th, 2010How homeopathy works
January 7th, 2010Click the image below to embiggen. Another picture from those lovely people at b3ta.com.


