Speeding up database access
This is a very thorough article on ways to speed up a SQL database by Matt Perdeck Speeding up database access – Part 1: Missing indexes
This is a very thorough article on ways to speed up a SQL database by Matt Perdeck Speeding up database access – Part 1: Missing indexes
You can back up VMware VM for free using ghettoVCB.sh script. Everything you need is here: https://github.com/lamw/ghettoVCB I was unable to download it directly to the the VMware server because wget v1.19 refused to download form https:// url. Instead I downloaded the file to my Windows machine and used WinSCPPortable to upload the file to … Read more
A series of videos about growing strawberries:
This is a pretty informative video about pruning raspberries and prepare them for the winter:
Use the free SSL Server test from Qualys Inc to see how secure is your web site: SSL Test
Delete all files with given extension recursively: find . -name “*.dll” -print0 | xargs -0 rm -rf Find the number of .jpg file in the current folder and all sub-folder recursively: find . -name “*.jpg” -print | wc -l Move all .m2ts files to /mnt/backup/m2ts folder: find . -iname “*.m2ts” -type f | xargs -I … Read more
A good guide is available here: Freenas 9.2.0 with Transmission and Couchpotato/Sickbeard as a DLNA-Server
There is a great tutorial on how to set up FreeNAS with Transmission on the FreeNAS forums: [How-To] Transmission & FreeNAS Shared Mount Points
Recently I had to rescue a data from NTFS partition for somebody. It was a totally messed up laptop that could not boot the OS. It comes with a hidden partition from which you can restore the system and in theory to preserve the existing user data. I did not want to take any risks … Read more
I recently had a problem with IIS on Windows 7 where trying to access http://localhost on the default port 80 was giving me an error: “HTTP Error 503. The service is unavailable” I spent several hours trying to find the cause and trying different things without any success. Finally I came across this post that … Read more