It’s been a day or two

It’s been a while since I last updated this site. Between my professional and personal life, I’ve had ZERO time to post any updates.  Thankfully, that has changed and I am going to be updating on a regular basis.

I miss writing the How-To’s the most.  The problem with How-To’s is that there are so many already out there.  I’ll just have to find a way to make mine stand out.

Obstacles are those frightful things you see when you take your eyes off your goal. - Henry Ford

17.Apr.09 General Comments (8)

Tech support humor

Check out this video. It’s a mash-up of tech support calls that makes for almost 10 minutes of funny.

The Website Is Down

NSFW language so be sure to turn your speakers up.

28.Jan.09 Humor Comments (0)

Direction determines speed

See if this makes sense to you.  I was driving to a client’s house yesterday to fix a computer. As soon as I turned on one of the roads, there was a speed limit sign showing 35 (north bound traffic).  Almost a mile after passing that sign, another speed limit sign is on the other side of the road showing 45 mph (south bound traffic).  There was no sign on the northbound side showing 45 mph.

What the hell?  I wonder if anyone on the south bound side has ever been pulled over by a cop sitting on the north bound side for speeding even though they were going 45?  I played it safe and took a different road home (one that has the same speed limit on both sides).

Before I forget: Happy New Year!

If you break your neck, if you have nothing to eat, if your house is on fire, then you got a problem. Everything else is inconvenience. - Robert Fulghum

01.Jan.09 General Comment (1)

Watch the dot

You have to be careful when typing commands.  One character out of place can cause strange problems or even total break down.  So is the case of a recent SQL backup scheme.

One of the other DBA’s I work with had a problem.  They were trying to run full backups of a live database but the backup drive kept filling up.  The reason it would fill up was because the old backup files (*.bak) were not being deleted when the next backup ran.  One backup file takes up 20+ gigabytes of space (heavily used database).  My coworker had tried different commands to make it work but nothing was fixing the issue.

I opened up SQL Server Management Studio and took a look at the Maintenance Plan being used.  The maintenance plan had two subplans.  The first subplan made a full backup of the database at 3 a.m. every day.  The second subplan made a transaction log backup every two hours.  I opened up the first subplan in order to review the tasks.

Everything looked normal at first.  When I opened up the first task in order to view the details, I saw the problem.  The first task, a maintenance cleanup task, is the one set to delete old backup files.  My coworker had set it to search the backup folder for the .bak extension.  The problem is that you can’t add the dot before the file extension to be found.  I removed the period, saved the subplan and launced the full backup job.  We knew it was working when it immediately deleted the old backup files and then created the new backup.

One other piece of advice I gave him about the backups was the frequency.  This database is used about 18 hours a day.  Currently, a database failure at 2 a.m. would lose a full days worth of data.  I suggested that he perform differential backups at least every 2 hours and leave the full backup as it was.  We did the calculations for the drive space needed and found that he had more than enough room for running differential backups every hour if he wanted.  That will definitely help to keep Murphy at bay.

I don’t know the key to success, but the key to failure is trying to please everybody. - Bill Cosby

22.Dec.08 Microsoft SQL Comments (0)

Finding the cause of the problem

Since implementing the Cisco NAC, I’ve had a few fun calls that could have been avoided with a little more troubleshooting.  The calls always start with, “Hey, we’re having some NAC issues here.” and go down hill from there.  Here are a few issues initially blamed on the NAC with the true cause of the issue in parentheses.

There are a few more in the ever growing compilation list to be posted later.  I get at least two calls a weeks that are very face-palm worthy.  I’m thinking about setting up a wall-o’-shame at work.  Let the guilty party step forth.

Sometimes it’s more important to be human, than to have good taste. - Brecht

09.Dec.08 Humor, Networking, Security Comments (2)