Change Field Order in MySQL Table Structure using phpMyAdmin
Monday, October 19th, 2009 Posted in tech tips | No Comments »Sometimes a database admin wants to change the order of fields in their table. I find it handy when I want SELECT * to return the fields in a particular order. While there are no buttons to change the field ...
XML-RPC with Windows Live Writer vs. Wordpress FCKeditor
Thursday, October 15th, 2009 Posted in tech tips | No Comments »If you frequently blog, you may be frustrated by the built-in editor for Wordpress: FCKeditor. It has its limitations, but it is actually a pretty good web-based rich text editor. However, there is another choice. If you want to write ...
Data Matchbacks in SQL, mySQL, Access
Wednesday, October 14th, 2009 Posted in tech tips | No Comments »To better understand where your customers come from and the value of your marketing investment, you can use a data matchback. For example, let’s say that you sent an email to a list of leads that you purchased and now ...
The 20 Minute WordPress Installation and Configuration
Friday, October 31st, 2008 Posted in tech tips, webdev | 1 Comment »So, every time I follow the famous 5 minute WordPress Installation Guide, I do a few things differently. These extra steps make the installation take around 20 minutes (if I rush), but I am writing this note, primarily for myself ...
Pulling a Random Sample in MS Access
Monday, October 27th, 2008 Posted in tech tips | 1 Comment »I have a database with 500,000 records and I need to pull 12000 random records for analysis. The WHERE clause is not necessary for the random sampling. It is just part of the query that was used in this ...
Splitting LASTNAME,FIRSTNAME columns in Excel
Wednesday, May 14th, 2008 Posted in tech tips | 1 Comment »Too often, office workers have to manipulate improperly structured data that comes from mega-systems. For example, if a person wanted to do a mail merge intro line, stating, "Dear <firstname>" but the name field held LASTNAME,FIRSTNAME, they would have a ...