Here’s a simple stored procedure I find myself using for MySQL over and over again. If you use a person’s email address as a database key, you may need to occasionally update their email address, and as such, you should update all references. Here’s a simple stored procedure to accomplish this:
DELIMITER $$
DROP PROCEDURE IF EXISTS [...]
Some economists are estimating the final government bailout number to be around 3 trillion dollars when all is said and done, with stop reserves going out to 7 trillion. According to census information, the total U.S. population is around 300 million. So, if for some reason the government decided to give the taxpayers back their [...]
I’ve come up with a plan to help main street while helping wall street at the same time. No one wants to give anyone (mainstreet or wallstreet) a complete get out of jail free card, but the necessary evil is that something must be done, or we must struggle through an enormous recession and downturn [...]
Sometimes more than just connection strings need to be stored to a settings or configuration file of some kind. If you are building a mult-tier application and your project is a class library with no run-able code, you can’t just throw settings into an app.config file. Likewise, you wouldn’t want to put your tier-specific settings [...]
In working with SQL server 2005, I came across this useful query which will loop through every table and every field in a database searching for specified text. This can really come in handy when you’re debugging someone else’s un-documented database and you know the text, but you’re not sure where it is stored in [...]
It’s been my experience lately that there’s two main circumstances in which developers can inccurr a significant amount of unhealthy work-related stress:
Nothing to do. This doesn’t sound stressful, but when you go to work and don’t have anything to do it is extremely unfullfilling. Not to mention the temptation to pull up inappropriate material from [...]
Firefox version 3, Release Candidate 2 is now available for download! The immediate improvement I noticed: speed. Version 3 appears to start up a bit faster, load pages faster, and handle javascript-laden pages faster. Also nice to see were the numerous tasteful UI enhancements. Firefox has always had a simple UI before, and I’m glad [...]
SSHFS is a Fuse-based Linux filesystem that allows you to connect to an SSH server, and mount it as you would any other mountable device. The difference is… this “device” is a remote server using an SSH connection. At Holley Grove, we use SSHFS on all of our servers, SSHFS might be something you should [...]
I am not a smoker, but I can identify with those who are… I would imagine lighting up your first cigarette of the day would be a lot like having your first triple ventii soy chai latte (or whatever the case may be). It’s a bad habit, yes, but for many it is almost impossible [...]
When looking for new hires, many companies make the mistake of requiring all candidates to complete a simple skill test. At first, these tests seem like a good idea, and a quick way to eliminate a huge chunk of possible applicants who aren’t as technically proficient as you need them to be. However, often times, [...]