Windows Tips

This post was inspired by a recent arti­cle over at Life­Hacker. But before I get into the tips, I’m going to bore you with a slight digression.

Life­Hacker is one of the very few blogs that I actu­ally check daily for new con­tent. And I’m not talk­ing about using an agre­ga­tor, I will actu­ally pop up a web­browser to hit them up. I read their site so often it wasn’t until today that I real­ized my por­tal page didn’t1 link to them. As a gen­eral rule, the arti­cles there are inter­est­ing and/or use­ful. I don’t have a Mac, so some arti­cles don’t always help me, but over­all they have a really good mix. I sup­pose given how much use I’ve got­ten out of their site, I should be a bit nicer about this.… But the tip posted today was so shock­ingly lame that I feel the need to com­pile my own list of tips for win­dows users. Sorry, jus­trick but this one shouldn’t have made it past the editor’s desk!

Right that’s more than enough com­plaints, here’s my favorite Win­dows tips (in no par­tic­u­lar order)

  • Refor­mat your dri­ves and load your favorite linux dis­tro (I sug­gest either Kubuntu or Open­SuSE).2
  • Use the Win­dows Key shortcuts:
    • Win + E: Launches Win­dows Explorer
    • Win + D: Pressed once, shows your desk­top. Pressed twice, restores your win­dows to their prior posi­tions. The same effect can be achieved with Win+M and Win+SHIFT-M, but Win+D takes less effort.
    • Win + R: Launches the Win­dows Run Box. True, this isn’t as pow­er­ful as the Linux cli but you can do some good tricks with it (I’ll cover some of those later).
    • Win + L: Locks your com­puter, good for cor­po­rate environments.
    • Win + BREAK: Launches the Sys­tem Prop­er­ties window.
    • Win + F: Launches the Win­dows Explorer Sear­ach func­tion, use­ful in locat­ing files3. Of course, if what you’re really look­ing for are other com­put­ers on the net­work then you could use Crtl+Win+F.
  • If you use the Win­dows Com­mand Prompt fre­quently, then set­ting up some aliases for your most com­monly used com­mands is help­ful. the one I like to do on evey Win­dows machine I use is to cre­ate C:\Windows\X.BAT. This batch file con­tains only one com­mand and that’s EXIT. Since the batch file is in the Win­dows direc­tory, it’s in the sys­tem path on a default con­fig­u­ra­tion. When I’m ready to close any com­mand prompt, I just hit “x” (minus the quotes) and I’m out.
  • If you don’t have a fancy key­board with extra keys for macros or launch­ing other pro­grams, 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 Win­dows Notepad acces­sory, great for edit­ing small text files or mak­ing quick notes to your­self. the other app I fre­quen­tally launch this way is the Win­dows Cal­cu­la­tor (use “calc” instead of “notepad”).
  • If your Quick Launch bar is over­flow­ing but you still need quick access to more pro­grams and you don’t have a fancy macro­ing key­board, then you can setup short­cut keys for your pro­grams by right-clicking on their icon/shortcut, select­ing Prop­er­ties, click­ing in the Short­cut Key field and press­ing the key combo you want to launch the pro­gram. For example…
    1. Go into Start -> Accessories.
    2. Right-click on Paint and select Properties.
    3. Click in the Short­cut Key field and press Crtl+Alt+P
    4. Now when­ever you press Crtl+Alt+P Microsoft Paint will launch. Keep in mind that this can cause prob­lems with other pro­grams if you try over­writ­ing a key­board short­cut that the other pro­gram already uses (e.g. Ctrl+C).

Those are all of the Win­dows tips that imme­di­ately come to mind. If any of my read­ers have addi­tional ones they like, please post them in the comments.

1 As soon as I real­ized this, I added the link.
2 If this tip offends, I’d apol­o­gize but you should know by now from read­ing this blog, that I vastly pre­fer Linux.
3 Though installing Google Desk­top and using hit­ting Crtl twice is eas­ier over­all and GD does a bet­ter job searching.

How To Buy Your First Home

In my younger days due to var­i­ous employ­ment sit­u­a­tions, I ended up mov­ing about once every five years. For­tu­nately, ever since I went to col­lege I’ve pretty much put a stop to that by liv­ing in the same town for twelve years. As men­tioned pre­vi­ously, 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 buy­ing part of this was a new and rather ter­ri­fy­ing exhil­a­rat­ing emo­tion­ally drain­ing expe­ri­ence. And as I hate to be fly­ing blind in any sit­u­a­tion, I did what I could to pre­pare myself. Mostly, this con­sisted of hit­ting up the pub­lic library for every book writ­ten in the last 5–7 years talk­ing about home buy­ing, mort­gages, house inspec­tions and any­thing else I could think of to look at. Those books included: The Vir­gin Home­owner: The Essen­tial Guide to Own­ing, Main­tain­ing, and Sur­viv­ing Your HomeMort­gages For Dum­mies, 2nd Edi­tion, Kiplinger’s Home­ol­ogy: How to Be Sure the House You Buy Is the Home You Really Want, and House Inspec­tion: A Homebuyer’s Homeowner’s Guide: With a Spe­cial Sec­tion on Older or His­toric Homes.

I’ll talk more about those books later, but I’d like to dis­till the knowl­edge I got from read­ing them into a few handy bul­let points for future first time buy­ers to think about:

  • Start plan­ing and SAVING as soon as pos­si­ble! Per­son­ally, I’d rec­om­mend start plan­ning out your pur­chase 5 — 10 years before you ever look at a house. Every “expert” in home buy­ing rec­om­mends hav­ing a min­i­mum down pay­ment of 20% of the pur­chase price of the house you want to buy. Hav­ing that much saved up gives you sev­eral advantages:
    • Banks/Lenders will be more likely to take you more seri­ously when you can demon­strate both finan­cial sta­bil­ity and prudence.
    • They will also be more likely to offer you a bet­ter loan when you have that much money up front.
    • The down­side to hav­ing the 20% is it could dis­qual­ify you from some of the first-time buyer pro­grams out there. Then again while I am a first time buyer and I do qual­ify for some of those pro­grams; it made more sense for me to NOT use them1.
  • If your credit his­tory is either short or bad, work to improve it. This means bor­row­ing money for things like a car or using credit cards and being extremely care­ful to pay back what you owe in a timely man­ner (e.g. no late pay­ments). The bet­ter your credit his­tory, the more likely a bank/lender will want to work with you and pos­si­bly offer you a bet­ter inter­est rate.
  • If you are young and unde­cided on what you want to do for a living/career; con­sider real estate sales and/or being a lawyer spe­cial­iz­ing in real estate/property law. When you start going to the banks and real­tors, they are going to dump tons of paper­work loaded with legal­ize on you. If you have the skills to under­stand what they are talk­ing about; you’ll stand a much bet­ter chance of get­ting the house you want at a price (and a mort­gage pay­ment) you can live with.
  • Fig­ure out exactly why you’re buy­ing a house:
    • Are you sim­ply sick of renting?
    • Do you want to have the addi­tion­ally pri­vacy of not directly shar­ing a wall with your neighbor(s)?
    • Are you look­ing for a long term, non-liquid investment?
  • Fig­ure out how long you want to stay in the house:
    • 5 years?
    • 10?
    • 20?
    • More?
  • Fig­ure out what kind of house you want:
    • A 3 story brick man­sion with a dozen acres of man­i­cured gardens?
    • A 2 bed­room, 1 bath condo?
    • A turn of the cen­tury bun­ga­low built and dec­o­rated in the Arts & Crafts style.2
    • A 1950’s ranch in need of major renovation?
    • An envi­ron­ment friendly under­ground bomb shelter?
  • Fig­ure out how much you can afford to spend:
    • Based on your sav­ings, credit his­tory and monthly income deter­mine how much money you can afford to spend on a house. Note that the amount a bank will preap­prove a mort­gage for you is the max­i­mum amount they feel com­fort­able lend­ing to you and is not, I repeat NOT a fig­ure you want to be pay­ing off for the next 30 years.
    • When try­ing to deter­mine this amount, you should be think­ing about more than just the mort­gage. You should also include your util­ity bills (e..g elec­tric, nat­ural gas, water, etc..) and insur­ance costs.
  • Start look­ing 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 neigh­bor­hood are going for, so you can have some idea of what you might have to spend.
  • Like­wise attend any open houses in the right area and get a good look at the houses.

Once you find a house that you are inter­ested in, take another walk through it (either at an open house or arrange a time with the real­tor. When you go through the house, you should poke in every closet. Also you should try every door, toi­let, faucet, lightswitch and any appli­ances that are included with the house. Look for any­thing that doesn’t work or that per­haps works but not eas­ily. These are things you can either ask the home­owner 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 sit­ting in my pub­lish­ing queue for far too long already. If any of my read­ers have addi­tional ques­tions, then can either post them here and I’ll try answer­ing them. Or then can read one of the books I linked to above.

1 Due to the inter­est rates being offered by the banks being bet­ter than that offered by the pro­gram.
2 Yes, yes, yes, yes please! :)

MySQL Tips?

Nearly 2 months ago, I started a new job that requires I play with MySQL all day long. Mostly, I use MySQL’s Query Browser (part of their GUI-Tools pack­age). I was curi­ous if any of my read­ers would hap­pen to have favorite tips, tricks or sites related to MySQL? If so, please make a note in the com­ments on this post.

Thanks!

THANK YOU!

This post is a thank you to all the friends and fam­ily who showed up to help us move to our new house over the weekend.

Thanks peo­ple, we wouldn’t have made it with­out all your help!

Moving Day

Those of you who know me per­son­ally have prob­a­bly heard I’m mov­ing. Well, tomor­row is the big day! Due to the move, it’s unlikely I’ll be online much1 for the next few days. If you must get in con­tact with me, your best bet is to send me a note via my Gmail account. If you’re not sure what that email addy is you can try using .

1 We won’t even have work­ing Inter­net ser­vice at the house until Tues­day at the earliest.