Working on a recent project, I had a task that required me to number the rows of result set; however, I needed to reset the numbering based on the distinct value of a field, or group of fields. I accomplished my task by leveraging ROW_NUMBER() and PARTITION BY.
[ Read More ]
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.
[ Read More ]
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.
[ Read More ]
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.
[ Read More ]
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.
[ Read More ]
