Archive for 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

Using Picasa to organize digital photos.

Picasa

SEC Suspends Trading Of 35 Companies Touted In Spam Email Campaigns
Advanced Powerline Technologies Inc. (APWL) -spammer!
America Asia Petroleum Corp. (AAPM) -spammer!
Amerossi Int’l Group, Inc. (AMSN) -spammer!
Apparel Manufacturing Associates, Inc. (APPM) -spammer!
Asgard Holdings Inc. (AGHG) -spammer!
Biogenerics Ltd. (BIGN) -spammer!
China Gold Corp. (CGDC) -spammer!
CTR Investments & Consulting, Inc. (CIVX) -spammer!
DC Brands International, Inc. (DCBI) -spammer!
Equal Trading, Inc. (EQTD) -spammer!
Equitable Mining Corp. (EQBM) -spammer!
Espion International, Inc. (EPLJ) -spammer!
Goldmark Industries, Inc. (GDKI) -spammer!
GroFeed Inc. (GFDI) -spammer!
Healtheuniverse, Inc. (HLUN) -spammer!
Interlink Global Corp. (ILKG) -spammer!
Investigative Services Agencies, Inc. (IVAY) -spammer!
iPackets International, Inc. (IPKL) -spammer!
Koko Petroleum Inc. (KKPT) -spammer!
Leatt Corporation (LEAT) -spammer!
LOM Logistics, Inc. (LOMJ) -spammer!
Modern Energy Corp. (MODR) -spammer!
National Healthcare Logistics, Inc. (NHLG) -spammer!
Presidents Financial Corp. (PZFC) -spammer!
Red Truck Entertainment Inc. (RTRK) -spammer!
Relay Capital Corp. (RLYC) -spammer!
Rodedawg International Industries, Inc. (RWGI) -spammer!
Rouchon Industries, Inc. (RCHN) -spammer!
Software Effective Solutions Corp. (SFWJ) -spammer!
Solucorp Industries Ltd. (SLUP) -spammer!
Sports-stuff.com Inc. (SSUF) -spammer!
UBA Technology, Inc. (UBTG) -spammer!
Wataire Industries Inc. (WTAF) -spammer!
WayPoint Biomedical Holdings, Inc. (WYPH) -spammer!
Wineco Productions Inc. (WNCP) -spammer!

One of my favorite tools I use often is called ColorPic. It is especially useful for web design. If you see a color you like, you can grab it and save it as a paint chip. Just hover your mouse over any color on any part of you screen. I’ve used this program for a long time and has become one of my favorites. This is a must-have for any web designer. Yes it is FREE.

ColorPic