I had to add a column to a database table on an MSSQL server today. It had to have the most recent update/insert time that the row was inserted/updated. MySQL has a very easy way of doing this with a TIMESTAMP column type, with a DEFAULT value of CURRENT_TIMESTAMP, and then also an additional ON …
Category Archive: Sysadmin
Feb
26
Dec
30
Hoops in the Air -OR- How I managed to upgrade Adobe Air to Version 1.5 on Ubuntu 8.10 and still get to use my favourite Air applications
UPDATE: I recently had issues with Air and Twhirl again, and thanks to @smmehadi I found there was two steps I didn’t do to *completely* get rid of all traces of Air. I added that step into the list below. For reference, here’s the official Adobe Air Linux troubleshooting page. Adobe recently released the final …
Aug
06
Fixing Windows MBR with Ubuntu 8.04.1 Live-CD
UPDATE: This works on Ubuntu 8.10 Live-CD too, just boot the livecd and execute the install-mbr command I’ve fixed MBRs before, using both the Windows install CD, and also using grub from an Ubuntu Live-CD. Today, neither of these worked on an HP 6710b laptop, where an Ubuntu partition (which contained grub) was removed (In …
Apr
11
Perl, FreeTDS and Cron issues
While converting some dodgy nagios-commands into cron scripts today, I came across an age-old issue when scheduling the final script in cron: The script works perfectly when running it on the command-line, but fails miserably when cron runs it. The usual answer here is “Check the environment variables”. The error I was getting was from …