Fed up with blogger

I am going to move my blog. Blogger keeps loosing my account so I can't log in.

Typing games

I currently type at a speed of around 50 words a minute and an error rate of about 4%. That isn't too bad, but I hate the constant backspacing I feel I am doing. I went looking for some online typing tutors... they are all pretty boring. Some fun online typing games though can be found at http://2addicted.com/words and http://2addicted.com/letters

Rojo the feed reader

I have been looking for a good online feed reader. At the moment I am using Rojo. It seems to do most of what I want. Check it out at www.rojo.com (and yes it's free)

How to change the logical file names in MSSQL

Just incase this is valuable to anyone else, here is a script to change the logical file names in an mssql database.

declare @n1 varchar(100)
select @n1 = name from sysfiles where name not like '%_log%'
declare @n2 varchar(100)
select @n2 = name from sysfiles where name like '%_log%'

exec ('ALTER DATABASE [Test] modify file (NAME =''' + @n1 + ''', NEWNAME = ''Test_Data'')')
exec ('ALTER DATABASE [Test] modify file (NAME =''' + @n2 + ''', NEWNAME = ''Test_Log'')')

select name from sysfiles -- just to check

Assumptions:

• 'Test' is the database name
• You have two files
• The log one ends in _log
• The other one doesn't

Share what you love

I read recently something along the lines of 'Doing what you love does not lead to wealth unless you also share what you love with others.'

It really seems to ring true for me. If you love sport, but spend all day watching it alone then you are not going to get rich. If you spend all day sharing your love of sport with others (coaching, compeating, or commentating) then yes you can make money at it. Infact the more people you share it with the more money you can make.