Marshall's Weblog

Have you ever needed a list of the foriegn keys of a table but didn’t want to parse out the contents of sp_help? Well I did and here is what I came up with

create proc sp_GetKeysForTable@objname varchar(100)asselect @objname ForiegnKeyTable, col_name(r.fkeyid, fk.fkey) ForiegnKeyColumn,object_name(r.rkeyid) PrimaryKeyTable, col_name(r.rkeyid, fk.rkey) PrimaryKeyTablefrom sysreferences r join sysforeignkeys fk on r.constid = fk.constidjoin sysobjects [...]

[Read more →]

IBM has a cool article about using Java and cellular automata to create music.

[Read more →]

I just registered the domain http://www.updateyourcomputer.com. I plan on creating a web site devoted to helping people keep their computers up tp date with security patches and virus updates.

[Read more →]

Novell announced today that they have released Ximian’s Connector, a program that allows linux to interact with Microsoft’s Exchange server, under the GPL. Here is the Press Release
Last night I watched an inde film on PBS called Refugee. It was about 4 guys who grew up in a bad part of San Francisco going back [...]

[Read more →]

PearPC is “an architecture independent PowerPC platform emulator capable of running most PowerPC operating systems”. It is released unter the GPL too. Unfortunately
Due to the nature of emulation, PearPC is quite slow (the client will run about 500 times slower than the host). Note that only the CPU is that slow, the speed of [...]

[Read more →]

OSNews has an interview with Miguel de Icaza which discusses how the “Rest of the World to Eventually Force US Into Linux”

[Read more →]

Just got done upgrading to wordpress version 1.0.2. The admin interface is a lot nicer. During the upgrade I found this backup script which I think should be included in the default install. The upgrade did not solve my <pre> problem so I am going to have to dig deeper into the source code. Browsing [...]

[Read more →]