March 2007


Ever wanted to convert your access database to mysql? This excellent piece of free software will do it for you quickly with an easy to use interface.

Bullzip Access to MySQL 

MS Access to MySQL

The program takes your access database and creates an SQL file that can then be imported into a MySQL database. The program has worked perfectly for me each time. This has been a huge time saver for me as I used to hand write scripts to pull the data out of access and create .sql files. Now it all happens in only a few clicks.

This assumes your default file is default.asp. If it is not default.asp, then you will need to change it. This is important to prevent endless looping.

Change example.com on line 7 to your domain name. This will do a permanent redirect to the non-www version of your domain. Place this at the top of your file.

<%
PATH_INFO = lcase(Request.servervariables(”PATH_INFO”))
if PATH_INFO = “/default.asp” then
PATH_INFO = “”
end if
HTTP_HOST = lcase(Request.servervariables(”HTTP_HOST”))
if instr(HTTP_HOST, “www.”) = 1 then
newurl = “http://example.com” & PATH_INFO
Response.Status = “301 Moved Permanently”
Response.AddHeader “Location”, newurl
Response.End
end if
%>

So why would I want to do this?

  1. If you prefer to use the non-www version of your site. (http://example.com)
  2. Consistent URL referencing is a basic key to good SEO (search engine optimization).

A fun way to surf the web at work. If you work is restrictive about using the internet at work, you should check out. www.workfriendly.net

Compare the versions of fark.com below. Which one do you think you could easily get away with reading at work? (The top one is the original, the bottom one is by workfriendly.net.)

Save for Work!

A very cool web-based utility to automatically shuffle through your favorite web sites. Login and setup your website list in the database, then each time you open your browser or hit your “home” button it bring up the next site in your list. It really grows on you. I find I just hit “home” and let it go through my sites to quickly bring me up to speed for the day. Yes, it is a free service.

WhatPage

WhatPage Logo

TCP View is one of my “must have” utilities. I use this quite often to watch connections or for trouble shooting. Everyone should have this on their computer. It is one of the best security tools you can use. TCP View will instantly show you who is connected to you and who you are connected to. If you see something unusual in the list, you should check into it. I would recommend for most usage to uncheck the “show unconnected endpoints” for any troubleshooting purposes. This will then show only the current connections happening, you can watch them connect and disconnect as they happen.

Connected Endpoints

TCP View Information Page and Download.

TCP View Screen

Next Page »