Blog - Page 8 of 15 - @daharveyjr

Fixing Page Size Issues Caused by Jetpack for WordPress

Recently when analyzing my own web site I discovered that the pages sizes on my web site were coming in at around 1.2 MB to 1.5 MB total in size. These page sizes completely shocked me! I don’t use an overabundance of graphics, nor did I consider my content to be extremely heavy, so I was a little concerned about what was causing the increased bloat. So, to begin, I started looking at the possible culprits, and worked to identify what was causing the insanely high page sizes, and I encountered a shocking find. A single plugin was contributing to the shocking page sizes, and that plugin was Jetpack for WordPress.

Database

Create a CSV Field (String Aggregation) with Recursive SQL for DB2

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 aggregate multiple results together into a single string with a delimiter.

Security

Setting up and Using OpenDNS on Your Router

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 which works great to block unwanted adult content.

General

Subscriptions Now Enabled!

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 have enabled subscriptions.

Database

Remove Duplicate Records from a DB2 Table

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 in my unique index. As a result I found a need to remove duplicate records from my table, and decided to share the code I used to do so below.