Evil Science

Hotcorners for Windows

andy — Sat, 10 Jul 2010 20:49:24 +0000

Add Mac OSX hotcorners to Windows with this handy, freeware, app.

Your App’s Website Sucks

andy — Thu, 24 Jun 2010 07:58:07 +0000

An insightful, if somewhat cynical look at how not too design a website which accompanies your App Store app.

Hell yes!

andy — Wed, 19 May 2010 21:48:53 +0000

Clone your XP/Vista bootcamp partition

andy — Sun, 02 May 2010 12:14:12 +0000

With WinClone which you can find here.

Christian sex therapist Gary McFarlane loses appeal bid

andy — Thu, 29 Apr 2010 22:27:33 +0000

A relationship counsellor’s bid to challenge his sacking for refusing to give sex therapy to gay couples has been turned down by the High Court.

Gary McFarlane, 48, from Bristol, was sacked by Relate Avon in 2008. He claimed the service had refused to accommodate his Christian beliefs.

Lord Justice Laws said legislation for the protection of views held purely on religious grounds cannot be justified.

He said it was irrational and “also divisive, capricious and arbitrary”.

Continued in this BBC article.

Party Cat

andy — Sat, 24 Apr 2010 16:20:22 +0000

Party cat likes to party.

Mac: download google books

andy — Wed, 24 Feb 2010 20:55:40 +0000

By using this splendid application.

MacBook Pro Battery Life Tips

andy — Sun, 21 Feb 2010 16:08:16 +0000

Save your battery life by taking at look at GiantMike.com’s helpful article.

Get the first day of the week from a datetime

andy — Fri, 12 Feb 2010 10:31:29 +0000

select 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

andy — Fri, 12 Feb 2010 10:26:00 +0000


select 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.