Wednesday, May 10, 2006

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)

Tuesday, May 09, 2006

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

GitHub Projects