Blog

Now on Twitter, too

Just really a matter of generating random rubbish on the net. Let’s see what the fuss/hype is all about 🙂 Twitter is now using the OAuth method for new registration of applications (either desktop client or browser); some good implementations and code examples are over at http://toys.lerdorf.com/archives/50-Using-pecloauth-to-post-to-Twitter.html and http://www.jaisenmathai.com/blog/2009/03 ...

Create a new certificate for Ubuntu the easy way (but you knew that already)

For the self-signed certificate: sudo a2enmod ssl wget http://librarian.launchpad.net/7477840/apache2-ssl.tar.gz tar -zxvf apache2-ssl.tar.gz sudo cp apache2-ssl-certificate /usr/sbin/ sudo cp ssleay.cnf /usr/share/apache2/ sudo mkdir /etc/apache2/ssl cd /etc/apache2/ssl sudo apache2-ssl-certificate -days 365 sudo cp /etc/apache2/sites-available/default /etc/apache2/sites-available/ssl sudo ln -s ...

Copying files from one server directory to another (without sapping resources)

cp just saps resources when transferring large volumes of data between directories. Especially on old machine memory usage spikes when the process is started and the machine becomes almost unresponsive. That’s on large volumes of data (and old hardware). Enter rsync stage left. OK, none of this is new (you know all this already) — it’s really just to have in one spot: No mess no ...

Shrinking LDF files (SQL Server 2000 etc)

Some really nifty tips on huuuuuge LDF files I encountered (56G a pop) and came down to 212MB as a result of this process: In SQL Server 2000 Query Analyzer run the following command (doesn’t matter what db you are in): backup log [database name] with truncate_only (don’t include the square brackets) Open Enterprise Manager and navigate to your database: –Right click on the data ...

Backup and Restore in Firebird [and Interbase] (but you knew that already)

Always nifty to have it all in one spot 🙂 Of course, this works for Interbase, too… all in the documentation. Where dbserver = 127.0.0.1 (if it’s on localhost) and /databases/dbfile.fdb could be x:\DIR\FILE.[gdb|fdb] etc… A “normal” Backup ?View Code BASHgbak -v -t -user SYSDBA -password masterkey dbserver:/databases/dbfile.fdb c:\backups\dbfile.fbk Backup with outpu ...

USB Power Management

This is quite useful – if your USB connector times out your device connected to the Ubuntu machine (from here) – determine the idea using either lsusb or lspci It’s pretty self-explanatory… 105 The user interface for dynamic PM 106 --------------------------------- 107 108 The user interface for controlling dynamic PM is located in the power/ 109 subdirectory of each USB d ...

Wine and MSI files (but you knew that already)

So you’ve downloaded UltraEdit v14, arguably one of the best text-editing and code-editing environments in the Windows World (ok, so no IDE, but for that you’d use a Zend Studio offering), and you want to run it in Wine. Now, assuming you’re running Wine 1.0 (ideally 1.1.0 or later), this is not a problem on Ubuntu. Just the cursor keeps jumping… The ue_english.zip (or oth ...

Over a trillion unique URLs in Google (but you knew that already)

On the Google Blog, they’ve been going on about the size of the Google index that’s grown at such great speed over the time of Google The first Google index in 1998 already had 26 million pages, and by 2000 the Google index reached the one billion mark. Over the last eight years, we’ve seen a lot of big numbers about how much content is really out there. Recently, even our searc ...