Daharveyjr - daharveyjr.com - @daharveyjr
General Information:
Latest News:
Create a CSV Field (String Aggregation) with Recursive SQL for DB2 31 Jul 2013 | 03:34 am
I was recently working on a client project where I had need to create a delimited field from multiple SQL rows returned for a query. To accomplish this I used a recursive SQL query that allows me to a...
Setting up and Using OpenDNS on Your Router 20 Jul 2013 | 06:59 am
I’ve always promoted making your own personal network safe, and have been recently been working with family members to enable OpenDNS on their own networks, specifically the OpenDNS Family Shield whic...
Subscriptions Now Enabled! 31 May 2013 | 12:00 am
As I have seen the audience and traffic grow for this web site, I have wanted the ability to better stay in touch and inform visitors and readers of new articles, updates, and other news. Therefore, I...
Remove Duplicate Records from a DB2 Table 21 May 2013 | 03:21 am
I was recently trying to add a unique index on a table, and it gave me an error that the index could not be created because the table contained duplicate records across the fields I was trying to use ...
Fighting WordPress Comment Spam with a Nonce 3 May 2013 | 10:15 am
In addition to blocking the comment spam bots that don’t include a HTTP_REFERER header indicating the request came from your web site, as indicated in a previous posting Fight Back Against WordPress C...
Block Bad Search Bots and Spiders Using mod_rewrite 2 May 2013 | 10:42 pm
There are many search bots, spiders, and content scrapers out in the internet. Some are completely legitimate like Google and Bing; however, there are also many that are overly aggressive or are simpl...
Force a Log File Rollover on WebSphere Application Server 29 Apr 2013 | 08:19 pm
Do you ever get in the middle of development, or attempting to diagnose a problem on a server, and wish you could just clear out the logs without having to stop your server? I do all the time! As a … ...
Fight Back Against WordPress Comment Spam with a HTTP_REFERER Check 25 Apr 2013 | 03:08 am
For those that use WordPress, comment spam is a huge problem. There are lot of good ways to combat comment spam, and many plugins that help with the issue; however, they don’t always stop the spammer ...
Disabling or Limiting Post Revisions in WordPress 18 Apr 2013 | 03:09 am
One of the great features that WordPress has to offer its users is revision management. WordPress will automatically create a new revision every time you save a post, or whenever you preview it. For m...
DB2 Maintenance Script (RUNSTATS, REORG) 12 Apr 2013 | 12:04 am
I had a local copy of a WebSphere Commerce database that was performing horribly, and I decided to create a script that would retrieve a list of all available tables for all non-system schemas, and pe...
