CoffeeBear.net

Linux CLI Tip

Sometimes when you're staring the bash prompt, you want to be able to see if a specific program is currently running. There are a couple of ways to do this; generally I run:
ps -ef | grep ProgramName

However I once saw a tip for doing something similar with top but I lost the link and for a long time couldn't find it again. Truth be told, I still haven't found that specific link but I did some googling and found the right cli switches to do it. Since I want to make sure I remember in the future, I'm posting it here:
top -b -n 1 | grep ProgramName

Tags: cli, linux, tips

Problems with Norton AntiVirus 2006 and ODBC Connections

While I run Kubuntu as my primary OS on all my home machines, my work machine has Windows XP on it.  Recently our IT dept installed Norton AntiVirus 2006 on all our machines.  Some people had problems with this immediately, while others (like myself) had not noticed any problems.  Then today I tried to export some data out of Microsoft Access to a MySQL server via an ODBC connection; only the window to select which connection to use never came up.  One of my co-workers had this problem last week and it quickly escalated into something of a nightmare causing her to get stuck with the office's loaner machine.  I did some googling and found a simpler solution to the problem:

1. Double-click on Norton AntiVirus in the systray.
2. Click on the Norton AntiVirus tab.
3. Click on Settings.
4. Click on Virus And Spyware Protection Options (under Additional Options)
5. Click on Miscellaneous under Advanced Options.
6. Uncheck Turn on scanning for Microsoft Office documents.
7. Click Ok.
8. Restart your computer.

And that's it.  Simply disabling Norton's Office plugin fixed the problem for me.

Tags: antivirus, norton, odbc, tips

Web Design for Business Owners

In my day job, I deal with massive databases of business listing information. Occasionally, I am required to go through those listings to review the sites attached to the listings. And for the love of god, people you're making my eyes bleed. In hopes that some of you out there find this blog post and are willing to fix your site, here's a few tips.

Give your homepage the title of your company.

When you build your site, make sure your company's name is the title of your home page. It should not be things like: "Welcome!", "email", "under construction" or "index". This makes your site both more professional and easier for search engines to properly index your site.

Do not use massive amounts of Macromedia Flash/Javascript/Animated Gifs.

Some truly amazing things can be done with Flash. Using it to animate your navigation is not one of them. Flash is best used sparingly as it limits your audience, blocking the blind for your site and users of mobile internet devices (e.g. cellphones).

Likewise, javascript should be sparingly and the site should degrade gracefully when a user without javascript visits. Which is to say if your navigation or other major site features break without javascript; then you've done something wrong. So go back and fix it!

The occasional animated gif can add impact and interest to your site; while dozens are annoying and look amateurish.

Color is important, but try not to blind your site visitors.

When you blind your site visitors with odd bad color choices; they will move on to your competitors. Along the same lines if you have overly complicated background images behind the text of your website; you are marking it harder for people to read what you have to say. Keep it simple for maximum impact.

Make sure all your links have logical names.

Naming your various pages as: "Page 1", "Page 2", etc... might seem simple and easy, but it makes those links useless to your visitors. How can anyone other than you know that "Page 1" is the page where you sell dildos or whether it is the page where you're selling balloons? They can only find out by clicking the link.

Avoid Comic Sans MS

While Comic Sans MS may seem like a fun, cheery sort of font to you; it's been greatly overused and most people find it annoying/unprofessional.

So faithful readers that's my list of big tips for the small business owner who wants a web presense. Did I miss one of your hot button issues? If so, please add it in a comment!

Updated: 2007-03-19

Kind readers have added some extremely good tips that I should have remembered in the comments on this post!

Tags: flash, tips, WebDesign

Windows Tips

This post was inspired by a recent article over at LifeHacker. But before I get into the tips, I'm going to bore you with a slight digression.

LifeHacker is one of the very few blogs that I actually check daily for new content. And I'm not talking about using an agregator, I will actually pop up a webbrowser to hit them up. I read their site so often it wasn't until today that I realized my portal page didn't¹ link to them. As a general rule, the articles there are interesting and/or useful. I don't have a Mac, so some articles don't always help me, but overall they have a really good mix. I suppose given how much use I've gotten out of their site, I should be a bit nicer about this.... But the tip posted today was so shockingly lame that I feel the need to compile my own list of tips for windows users. Sorry, justrick but this one shouldn't have made it past the editor's desk!

Right that's more than enough complaints, here's my favorite Windows tips (in no particular order)

• Reformat your drives and load your favorite linux distro (I suggest either Kubuntu or OpenSuSE).²
• Use the Windows Key shortcuts:
  • Win + E: Launches Windows Explorer
  • Win + D: Pressed once, shows your desktop. Pressed twice, restores your windows to their prior positions. The same effect can be achieved with Win+M and Win+SHIFT-M, but Win+D takes less effort.
  • Win + R: Launches the Windows Run Box. True, this isn't as powerful as the Linux cli but you can do some good tricks with it (I'll cover some of those later).
  • Win + L: Locks your computer, good for corporate environments.
  • Win + BREAK: Launches the System Properties window.
  • Win + F: Launches the Windows Explorer Searach function, useful in locating files³. Of course, if what you're really looking for are other computers on the network then you could use Crtl+Win+F.
• If you use the Windows Command Prompt frequently, then setting up some aliases for your most commonly used commands is helpful. the one I like to do on evey Windows machine I use is to create C:\Windows\X.BAT. This batch file contains only one command and that's EXIT. Since the batch file is in the Windows directory, it's in the system path on a default configuration. When I'm ready to close any command prompt, I just hit "x" (minus the quotes) and I'm out.
• If you don't have a fancy keyboard with extra keys for macros or launching other programs, you might want to use things like:
  1. Press Win+R
  2. Type in "notepad" (minus the quotes)
  3. Press enter or click ok. This will launch the Windows Notepad accessory, great for editing small text files or making quick notes to yourself. the other app I frequentally launch this way is the Windows Calculator (use "calc" instead of "notepad").
• If your Quick Launch bar is overflowing but you still need quick access to more programs and you don't have a fancy macroing keyboard, then you can setup shortcut keys for your programs by right-clicking on their icon/shortcut, selecting Properties, clicking in the Shortcut Key field and pressing the key combo you want to launch the program. For example...
  1. Go into Start -> Accessories.
  2. Right-click on Paint and select Properties.
  3. Click in the Shortcut Key field and press Crtl+Alt+P
  4. Now whenever you press Crtl+Alt+P Microsoft Paint will launch. Keep in mind that this can cause problems with other programs if you try overwriting a keyboard shortcut that the other program already uses (e.g. Ctrl+C).

Those are all of the Windows tips that immediately come to mind. If any of my readers have additional ones they like, please post them in the comments.

¹ As soon as I realized this, I added the link.
² If this tip offends, I'd apologize but you should know by now from reading this blog, that I vastly prefer Linux.
³ Though installing Google Desktop and using hitting Crtl twice is easier overall and GD does a better job searching.

Tags: tips, windows

How To Buy Your First Home

In my younger days due to various employment situations, I ended up moving about once every five years. Fortunately, ever since I went to college I've pretty much put a stop to that by living in the same town for twelve years. As mentioned previously, my wife & I have bought our first house and have since moved in. While doing the actual move didn't frighten me in the least, the buying part of this was a new and rather terrifying exhilarating emotionally draining experience. And as I hate to be flying blind in any situation, I did what I could to prepare myself. Mostly, this consisted of hitting up the public library for every book written in the last 5-7 years talking about home buying, mortgages, house inspections and anything else I could think of to look at. Those books included: The Virgin Homeowner: The Essential Guide to Owning, Maintaining, and Surviving Your HomeMortgages For Dummies, 2nd Edition, Kiplinger's Homeology: How to Be Sure the House You Buy Is the Home You Really Want, and House Inspection: A Homebuyer's Homeowner's Guide: With a Special Section on Older or Historic Homes.

I'll talk more about those books later, but I'd like to distill the knowledge I got from reading them into a few handy bullet points for future first time buyers to think about:

• Start planing and SAVING as soon as possible! Personally, I'd recommend start planning out your purchase 5 - 10 years before you ever look at a house. Every "expert" in home buying recommends having a minimum down payment of 20% of the purchase price of the house you want to buy. Having that much saved up gives you several advantages:
  • Banks/Lenders will be more likely to take you more seriously when you can demonstrate both financial stability and prudence.
  • They will also be more likely to offer you a better loan when you have that much money up front.
  • The downside to having the 20% is it could disqualify you from some of the first-time buyer programs out there. Then again while I am a first time buyer and I do qualify for some of those programs; it made more sense for me to NOT use them¹.
• If your credit history is either short or bad, work to improve it. This means borrowing money for things like a car or using credit cards and being extremely careful to pay back what you owe in a timely manner (e.g. no late payments). The better your credit history, the more likely a bank/lender will want to work with you and possibly offer you a better interest rate.
• If you are young and undecided on what you want to do for a living/career; consider real estate sales and/or being a lawyer specializing in real estate/property law. When you start going to the banks and realtors, they are going to dump tons of paperwork loaded with legalize on you. If you have the skills to understand what they are talking about; you'll stand a much better chance of getting the house you want at a price (and a mortgage payment) you can live with.
• Figure out exactly why you're buying a house:
  • Are you simply sick of renting?
  • Do you want to have the additionally privacy of not directly sharing a wall with your neighbor(s)?
  • Are you looking for a long term, non-liquid investment?
• Figure out how long you want to stay in the house:
  • 5 years?
  • 10?
  • 20?
  • More?
• Figure out what kind of house you want:
  • A 3 story brick mansion with a dozen acres of manicured gardens?
  • A 2 bedroom, 1 bath condo?
  • A turn of the century bungalow built and decorated in the Arts & Crafts style.²
  • A 1950's ranch in need of major renovation?
  • An environment friendly underground bomb shelter?
• Figure out how much you can afford to spend:
  • Based on your savings, credit history and monthly income determine how much money you can afford to spend on a house. Note that the amount a bank will preapprove a mortgage for you is the maximum amount they feel comfortable lending to you and is not, I repeat NOT a figure you want to be paying off for the next 30 years.
  • When trying to determine this amount, you should be thinking about more than just the mortgage. You should also include your utility bills (e..g electric, natural gas, water, etc..) and insurance costs.
• Start looking around the area you'd like to buy a house in, keep an eye on any "For Sale" signs and watch for open houses. You want to get an idea of how much the houses in the neighborhood are going for, so you can have some idea of what you might have to spend.
• Likewise attend any open houses in the right area and get a good look at the houses.

Once you find a house that you are interested in, take another walk through it (either at an open house or arrange a time with the realtor. When you go through the house, you should poke in every closet. Also you should try every door, toilet, faucet, lightswitch and any appliances that are included with the house. Look for anything that doesn't work or that perhaps works but not easily. These are things you can either ask the homeowner to fix in your bid on the house. Or you can ask them to knock some money off the price of the house so you can fix it yourself.

There's undoubtably tons more advice I could put into this post, but it's been sitting in my publishing queue for far too long already. If any of my readers have additional questions, then can either post them here and I'll try answering them. Or then can read one of the books I linked to above.

¹ Due to the interest rates being offered by the banks being better than that offered by the program.
² Yes, yes, yes, yes please!

Tags: finances, home buying, tips