Processing large data volumes
So a compressed text file that ends up being 72GB sounds like a lot, right? Especially if you have to data-churn it with per-line processing. Fine. Wow. A lot. That pales in comparison to the (reporte ...
Tag Archives: administration
nginx on Windows Vista / Windows 7 with php
You can get the latest stable version of a Windows compile of nginx (0.7.64) here. Setup is quite straight forward; you’ll need the php-cgi.exe downloaded (copy the libmysql*.dll to the Windows ...
Zombie postings with Captcha automation
Just got another comment posting request relating to a version 5.0 release of automated forum/blog spamming software which is guaranteed to get your customers ‘closer to your products’ by ...
And we’re on 2.8.6
Another quick upgrade to make it safe — 2.8.6 fixes two security problems that can be exploited by registered, logged in users who have posting privileges. Not really pertinent here but good to ...
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. ...
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 unresponsiv ...
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 ma ...