Technology Insights

Search Term Suggestions & Statistics: Alternatives To The Overture Keyword Selector Tool

A long time ago I used to use the Overture Keyword Selector Tool to review keywords I was running ads for. The Overture Keyword Selector would allow you to type in a keyword or group of keywords to see how many times that keyword(s) or like keywords had been searched in a specific time period. This can be useful not only for ads that you may be running but it can also be useful for content in articles that you write. The more you use keywords that are popular the more traffic you can generate. The Overture Keyword Selector Tool is no longer available so below are two alternatives that provide a similar service.

Technology Insights

Scramble the BSSID in a Wireless Capture to Keep Your Self Anonymous

I have had lots of people email me and ask if there is anyway to make it impossible for a attacker to recover your mac address from a capture file. If you are using one of our tools like the WPA Cracker in our tools section, you may be hesitant to upload a clients capture data because a skilled attacker could use the capture and the online Wiggle database to pinpoint your location assuming your area has been mapped by wardrivers. Although we run a secure site there is no way for you as the client to know this.

Technology Insights

Mount Shared Drives using Active Directory and a Log On Script

I recently completed a job were the company insisted in powering down the work station every night. This caused a problem because there were shared drives on the server which did not reconnect a boot time. The drives would appear to be disconnected with red X’s however when the user clicked on them they would connect. So although they were working the fact that they did not auto connect was annoying.

Technology Insights

Stop Amazon Jungle Disk Backup Application From Starting Automatically On Windows 7

I have been using Amazon’s Jungle Disk as a backup application for awhile now and have been really satisfied by how it has worked to date. I first used Jungle Disk on Windows XP primarily but now I have it configured and working properly on Windows XP, Windows Vista, and Windows 7. I not only was using the backup portion of Jungle Disk but I also had the online drive configured as well on multiple computers but I found that I rarely used the drive so I have been investigating the configuration and resources that the application uses.

Technology Insights

No operator matches the given name and argument type(s). You might need to add explicit type casts.

When working on writing some directions for someone at work I ran into a PostgreSQL command line query error. I have much more experience using MySQL so my initial Postgres commands always mimic what I would do in MySQL. Anyhow when attempting to run a SELECT statement matching contents of a specific column I received the error below. After a little research I came up with the answer fairly easily but wanted to note here to help others out and serve as a reference point if I forgot the proper PSQL query in the future. Below I describe the query that caused the error, the error returned by Postgres, and the proper query to use when attempting to match a variable in a Postgres SELECT statement.