Archive for January, 2008

Why on Earth do Business Schools Teach Microsoft Access?

Sunday, January 27th, 2008

I have been around business schools a fair bit and have noticed a few disturbing trends. For one, it seems that the majority of undergraduate business programs include at least one core course involving Microsoft Access. Sometimes Access is taught in labs or tutorials outside regular class, but the question remains, why?

I have received two answers to this question:

  • We’re not teaching “Microsoft Access,” we’re teaching fundamentals of database. We just happen to be using Access to do that.
  • Microsoft Access is a widely used program, so we’re giving our students skills that are in high demand
  • These answers are bullshit.

    First, “fundamentals of database” includes at least two things. The first is database design. The second is SQL. If the B-Schools are teaching fundamentals of database, why in the hell are their students using Access’s proprietary query builder instead of writing SQL, and what is this bullshit about Access’s “forms” and “reports.” You won’t see this crap in Oracle, DB2 or MySQL. Furthermore, I haven’t seen much education on database design in these intro classes, and assignments rarely include design activities because they can’t be graded quickly.

    Second, I can’t find a shred of evidence that Access is heavily used. I don’t know anyone who uses Access professionally. A quick search on Craigslist (Vancouver) brought up 95 jobs requiring Oracle, 122 jobs involving SQL Server, 157 jobs involving MySQL and 7 jobs involving MS Access.

    So, my question remains… why does it seem like most schools are teaching not only Access, but also the proprietary wizards and features of Access?

    How to get Dragon NaturallySpeaking to dictate into OS x applications

    Friday, January 11th, 2008

    iListen is bullshit. There, I said it. The accuracy rate isn’t nearly as good as Dragon NaturallySpeaking. So, I was determined to get Dragon working under OSx, and not just in virtualization. I wanted Dragon to dictate into Camino, Pages, Adium, etc. This how-to explains how I did it. Please bear with me, this is my first how-to.

    Warnings

    1. If you are a newbie, you may need help for this. A lot of things can go wrong, and this is not the most detailed how-to.
    2. I have tested this on exactly 1 hardware setup: mine. I have an Intel-based Macbook connected via ethernet cable to a router. I am using a USB Logitech headset.
    3. I admit, the resulting set up is a little buggy.

    What you will need

    1. OSx Leopard (this may work in other versions, but I have not tried it)
    2. VMware Fusion (I use the full version, not the demo)
    3. Windows XP installation disk
    4. Dragon NaturallySpeaking 9 (Again, may work with other versions)
    5. Win2VNC
    6. At least one gig of RAM

    Part one: installing Dragon

    0. Turn off Time Machine (under system preferences –> Time Machine)
    1. Install VMware Fusion (this should be pretty simple)
    2. Create a Windows XP virtual machine inside VMware fusion, and install Windows XP in it. This should be pretty straightforward
    3. When the installation is over, shut down the Windows XP OS, but don’t close VMware
    4. go to Virtual Machine-> settings-> memory and set the memory allocated to the virtual machine to at least 512 MB. If you only have one gig of RAM, don’t go any higher.
    5. Restart the Windows XP virtual machine
    6. Plug in your headset. If it is a USB headset, it will show up at the bottom of the VMware window as a little USB connection symbol. Click on the symbol to assign the headset to the VMware window. When the symbol turns blue, the headset is connected.
    7. Put the Dragon CD in the drive. (If you have the CD as an ISO, you can mount it in OS X and then access it from within the virtual machine, as long as it’s shared.)
    8. double-click ISScript1050.MSI. you need to install this before you install Dragon. When it’s done,
    9. double-click Dragon NaturallySpeaking 9.MSI (it took me a couple tries to install Dragon, as the installation crashed; however, it picked up where it left off and installed without issue the second time.)
    10. go through the Dragon set up. If you have audio quality problems, and you have a USB microphone, make sure it’s plugged directly into the computer. Plugging a USB microphone into a USB hub can increase distortion. If you still have audio quality problems, look around the web for pointers. You’re not the first person, and you won’t be the last.
    11. You’ll have to read at least one train story (I think) to get started.
    12. Once Dragon is configured, open up WordPad and give it a whirl — if it doesn’t work within the virtual machine, it won’t work outside, so make sure you can dictate within VMware before going on.

    Part two: dictating into OSx applications

    1. In OSx, go to system preferences –> sharing, and turn on screen sharing
    2. Click computer settings, and make sure both boxes are checked - don’t forget to enter a VNC password. Leave the screen sharing panel open
    3. In VMware, click on the network icon on the bottom right-hand server, and select the bridge option. This connects your virtual machine directly to your home network, and is necessary to get into Win2VNC working.
    4. Install Win2VNC.
    5. Start Win2VNC, and copy the server info from the OSx Sharing Panel. Only enter the numbers. E.g., mine read vnc://192.168.0.52/, so I entered 192.168.0.52 into Win2VNC. Press enter
    6. It should ask for a password. Enter the password you used in the os x sharing panel.
    7. If it connects, a little symbol will appear in the task bar. You can change the settings of Win2VNC by right-clicking this symbol.
    8. Start Dragon and turn the mic on (the virtual taskbar mic that is)
    9. Move your mouse slowly to the right edge of the screen. When the mouse gets to the edge, it will jump to somewhere on the OS X screen (don’t run VMWare in fullscreen mode)
    10. Open your favorite OSX editor and start talking.
    11. Turn Time Machine back on, if you must.

    Known Bugs

    1. While using this setup, I find that the Apple VNC Server is very processor intensive, which I suspect indicates some kind of infinite loop going on.
    2. Once you’ve started Win2VNC and moved your mouse back to OSx, you’ll have to disconnect the VNC client (by clicking the icon in the OSx menu bar) to get back to the VMWare window.

    Conclusion

    If you try this, please let me know (in the comments) how it goes. If you figure out what’s causing the above bugs, or how to fix it, by all means share it with the rest of us.

    I dictated this entire tutorial into Camino using Dragon NaturallySpeaking configured as described. Good luck.

    It’s not Commitment that Men are Afraid of

    Sunday, January 6th, 2008

    Recently, several of my female friends have been complaining that their significant others are afraid of commitment. Men are not afraid of commitment — well, a few are, but mostly “commitment” is not the real hang-up. So ladies, he here’s what he’s really afraid of:

    1. You will stop wanting sex with him, then

    2. You will stop having sex with him

    3. You will get fat

    4. You will stop wanting to go out and have fun

    5. You will throw out, or make him get rid of, his favorite shirt, chair, porno, etc.

    6. You will ignore him to spend time with the kids, because

    7. You will love the kids more than him

    8. You will stop getting all dressed, just for him

    9. You will become crotchety and bitchy

    10. You will stop taking care of yourself

    11. You will start ordering him around

    12. You will blame everything on him

    13. You will try to change him

    14. You will make him (explicitly or implicitly) stop hanging out with the guys

    15. You will start buying your underwear at Walmart

    16. You will stop having sex with him (did I mention that already?)

    And why is it that men are afraid of these things? Look around. If you live in North America or Britain at least, you won’t have to look very hard for your answer.