matt.goodwin's blog

Add the KeeneYPN calendar to your Google or Outlook calendar.

Posted Thu, 12/31/2009 - 14:05 by matt.goodwin

Keep forgetting about the Young Professionals Network events like me?

Add the KeeneYPN calendar to your Google or Outlook calendar.

Here's how:

Google Calendar

  1. Go to the Keene YPN website’s event calendar http://www.keeneypn.org/event
  2. Right click on the iCal icon in the bottom right corner and save the link. It should look like this: http://www.keeneypn.org/event/ical/all/all
  3. Go to your Google Calendar https://www.google.com/calendar/render?tab=mc

Google Analytics as a service offering

Posted Thu, 09/24/2009 - 13:49 by matt.goodwin

Here's how you can create value as a webmaster using Google Analytics as a service offering.

  • Setup & Configure Google account
  • Train Client on how to utilize reports and perhaps create them on their own
  • Support Clients with training and empowering them to administer GA on their own
  • How to implement it? You paste a snippet of Javascript that Google provides us into their site template

What does it give me

  • GeoTargeting - determine what geographic area the client's customers are coming from

How do I recover my Windows Administrator password

Posted Fri, 04/03/2009 - 10:30 by matt.goodwin

Windows password recovery tool

If you need to recover the passwords from a Windows XP or Windows Vista Machine, the easiest thing to do to retrieve your password is to use OPHCrack live CD.

I inherited a Dell Precision 340 the other day with Windows XP on it. It had been sitting in a PC graveyard for some time before being shipped to me.
This is how I was able to recover the administrator password to get this machine setup.

Download OPHCrack from sourceforge.
Windows XP:

Use Derived Tables instead of Temp Tables in SQL Server

Posted Wed, 03/18/2009 - 15:03 by matt.goodwin

Use Derived Tables instead of Temp Tables in SQL Server

The biggest benefit of using derived tables over using temporary tables is that they require fewer steps, and everything
happens in memory instead of a combination of memory and disk.
The fewer the steps involved, along with less I/O, the faster the performance.

Here are the steps when you use a temporary table:

1) CREATE the temporary table (write activity)
2) SELECT data & INSERT data (read & write activity)
3) SELECT data from temporary table (read activity)
4) DROP TABLE (write activity)

From the command line you can check your MX records using dig

Posted Tue, 02/17/2009 - 12:13 by matt.goodwin

From the command line you can check your MX records using dig

I’m sure there are other ways but I’ve recently learned a method to check your MX records using the dig command.

Dig is a pretty powerful command to have in your arsenal. Perhaps, I’ll provide a more complete tutorial someday but for now I’ll stick with this example.


$ dig ttamniwdoog.com MX

; <<>> DiG 9.2.4 <<>> ttamniwdoog.com MX
;; global options: printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 60650
;; flags: qr rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 0

Google Advanced Search Operators

Posted Mon, 12/22/2008 - 21:29 by matt.goodwin

Here are some examples of how to use Google's Advanced Search Operators
http://www.google.com/help/operators.html

Ever want to see who links to your website?
link:worldhealth.net

Ever want to search for a keyword but restrict your results to a specific site?
site:linkedin.com anti-aging

Ever want to search for specific keywords in the title?
allintitle: content king god

mySQL table contains single quotes

Posted Fri, 12/05/2008 - 09:37 by matt.goodwin

I have a mySQL database with a table of email addresses but some of the email addresses have single quotes for some reason.
I'll need to add some validation to my form eventually.
I need to find them and fix them now.
Here's the SQL

select * from tbl_email where LOCATE("'",user_email) > 0

Stringing Together Linux Commands

Posted Thu, 12/04/2008 - 11:08 by matt.goodwin

If you're lazy or you're trying to optimize your time by being more efficient with your keystrokes, here's a tip for you.

To execute multiple commands in a single line you can concatenate them together by using the semi-colon.
Example: To see the date and time stamp and then look at your mail queue count you could do this:

$ date; qmailctl queue |wc -l
Thu Dec 4 11:07:26 EST 2008
11178

Remove powered by ubercart footer message

Posted Fri, 11/21/2008 - 14:37 by matt.goodwin

As much as I like Ubercart, I didn't want anyone to know which cart I was using.

I was hoping that I wouldn't have to monkey with any code. I have recently been learning theming in Drupal.

Ubercart makes removing the powered by Ubercart footer messages easy.

First go to /admin/store/settings/store/edit/display

Next, you'll see the options for displaying the Ubercart footer messages.

Finally, select the option to not show any and submit the page.

5 Essential Firefox web development add-ons

Posted Wed, 11/19/2008 - 21:46 by matt.goodwin

ColorZilla — Advanced Eyedropper, Color Picker, Palette Viewer and other colorful goodies for your Firefox

FireFTP — FireFTP is a free, secure, cross-platform FTP client for Firefox which provides easy and intuitive access to FTP servers.

FireBug — Hands down best tool to debug CSS, HTML, and JavaScript within your browser.