Archive for the ‘Technology’ Category

Changing auto_increment on MySQL

Thursday, December 6th, 2007

From time to time, when programming with MySQL, I have needed to change the auto_increment value to something other than the default (Typically it starts counting with 1 and goes up from there). To change this, simply use the following command:

mysql> ALTER tablename AUTO_INCREMENT=new_number

There you go, it is that easy to change the auto increment value for MySQL.

NOTE: I have discovered that MySQL will not allow you to set the auto_increment value to a number smaller that what is currently set. The data must be truncated and then set to get it to work properly.

MMORPG Intelligent Load Leveling

Monday, November 5th, 2007

Companies in the game development industry are constantly attempting to keep up with the demands of consumers to provide more elaborate environments to inhabit. Games such as EVE Online, World of WarCraft, Planeshift and The Lord of The Rings Online are fun and enjoyable, yet have huge limitations. (more…)

Cisco Password recovery

Saturday, October 27th, 2007

I was given a Cisco router a few weeks back, so that I could practice for the Cisco CCNA exams. The only problem is that I had now idea what the passwords on it were. After some good old hard work, and lots of searching I finally figured out how to reset the password and set the router back to the defaults. This allowed me to start from a clean slate and start the process of learning how to manage and maintain a Cisco router. (more…)

Reset FreeBSD root password

Tuesday, August 21st, 2007

I have always attempted to have strong secure passwords, I usually pick something 12-15 characters long with a mixture of letters (both uppercase and lowercase), number, and symbols all mixed together. This makes my password quite difficult to guess. One problem that I have found is that I don’t have to deal with my servers on a daily basis. Since my password are so complex, I usually forget what they are. Now, I simply keep a server log (a 3 ring binder) that keeps track of all my passwords. But until then, I kept needing to reset my passwords.

(more…)

Touchscreens – The new computer interface

Friday, July 27th, 2007

I am surprised by all of the technology that is coming out. It is interesting to me, that we are still living in the stone ages though. I mean, think about it… Processor speeds grow at a nearly exponential rate, memory is growing just as fast, hard drive sizes are as well. With all of these advances, do we still use the arcane method of a mouse and keyboard. Sure, the have finally started adding finger print scanners to laptops to use instead of passwords, but there is a serious lack of innovation when it comes to user input. (more…)

Fighting Spam

Thursday, July 19th, 2007

I started having a lot of troubles with my mail server when it started getting spammed pretty bad. I have
Postfix using Amavis to push the email through ClamAV and SpamAssasin. My server was brought to it’s knees. It was running at 98-99% processor load and it would take hours for email to go through. So here is what I did to fix the problem: (more…)

The Model/View/Controller (MVC) Mindset

Wednesday, July 11th, 2007

Being a programmer that works on our clients websites, my eyes have been opened to the fact that there are some really BAD programmers out there. A current project that I have been working on is a total mess. Our customer outsourced the programming to some company in Russia. This company never finished the project and so our customer contacted my company in hopes we could complete the project. (more…)

Blu-Ray VS HD-DVD

Monday, July 9th, 2007

In another never ending battle, Blu-Ray and HD-DVD seem to be in a bitter struggle of survival. Which will win? Which will die, never to be seen again? Everyone seems to have an opinion, and as of yet, it seems that no decision has been made, or is it simple to early in the race to decide? (more…)

Price gouging or simple economics

Wednesday, June 6th, 2007

“The price of gasoline is ridiculous!” is a phrase that I hear all of the time. I am starting to get tired of people complaining about how expensive gas is, and how the Oil Companies are evil because they are making record profits. Sorry to inform you, but when people demand something, with a low demand prices go high. Everyone says that this is wrong in the case of gasoline, but how? (more…)


Switch to our mobile site