Monday, October 26, 2015
The following pragma settings will greatly enhance transactional insert performance in SQLite.
posted on Monday, October 26, 2015 5:01:28 PM (South Africa Standard Time, UTC+02:00)  #    Comments [0] Trackback
 Monday, March 24, 2014
Some days you need to clone complete databases, clear out all the current data and reseed the indexes before making use of it. If you're having one of those days, the script below will make short work of the task
posted on Monday, March 24, 2014 4:14:09 PM (South Africa Standard Time, UTC+02:00)  #    Comments [0] Trackback
 Thursday, March 13, 2014
If you need to cache static content in one of your sub folders use the following snippet of code placed into an htaccess file.
posted on Thursday, March 13, 2014 6:22:13 PM (South Africa Standard Time, UTC+02:00)  #    Comments [1] Trackback
Now for those robots which are bad and do not adhere to your robots.txt's rules, you'll need to add specific htaccess code.
posted on Thursday, March 13, 2014 6:18:02 PM (South Africa Standard Time, UTC+02:00)  #    Comments [0] Trackback
If you need to block all bots except for those that matter, look at this modified robots.txt snippet.
posted on Thursday, March 13, 2014 6:12:35 PM (South Africa Standard Time, UTC+02:00)  #    Comments [0] Trackback
 Tuesday, May 14, 2013
I recently got allocated a subscription (20 cores) to the Windows Azure cloud, yay! What dawned on me was that I have all these virtual cores but I have no idea how powerful they are. How many effective servers could I construct out of 20 cores? Which lead to me to ask, just how much power am I given with each core? Having some time on my hands, I decided to find out.
posted on Tuesday, May 14, 2013 2:02:59 PM (South Africa Standard Time, UTC+02:00)  #    Comments [0] Trackback
 Monday, April 29, 2013
Open Logic has made available a 64bit distribution of CentOS 6.3 specifically for Windows Azure. Now right off the bat, ZPanel (and other software) will have issues installing on this version primarily because Open Logic's distribution does not include the kernel header packages.
posted on Monday, April 29, 2013 12:45:48 AM (South Africa Standard Time, UTC+02:00)  #    Comments [0] Trackback
 Friday, February 15, 2013
I'm releasing code in CSharp for the comprehensive reading of SMART registers of a HDD (via WMI) similar to what Crystal Disk or HD Tune report it in. The code below will return the SMART registers for all hard drives, the HDD serial, interface, model numbers and each attribute's current value, worst value, and threshold value including the status of each (OK/BAD) register.
posted on Friday, February 15, 2013 1:38:15 PM (South Africa Standard Time, UTC+02:00)  #    Comments [8] Trackback
 Monday, October 15, 2012
If you are dealing with a large scripted databases and having difficulty restoring it with SSMS, follow the instructions below.
posted on Monday, October 15, 2012 11:04:19 AM (South Africa Standard Time, UTC+02:00)  #    Comments [1] Trackback
 Tuesday, May 29, 2012
In this post I share a quick way of updating your SQL Server Backup and Restore locations to reduce the time it takes you to do manage your DB server.
posted on Tuesday, May 29, 2012 12:24:09 PM (South Africa Standard Time, UTC+02:00)  #    Comments [0] Trackback