All posts by Mark Jacobsen

Windows Batch File (.bat) Not Running

If you’ve ever accidentally set batch files to open in a text editor, and now are unable to run them anymore you have to use the registry editor instead of the Control Panel file associations. As pointed out in this article

  1. Click on “Start”->”Run” and type in “REGEDT32” and press Enter to start the Registry Editor.
  2. Find the following key: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.BAT\UserChoice
  3. Delete the key named “UserChoice”
Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...

My Evernote Wishlist

I’ll admit right off the bat that I love Evernote. It has a ton going for it and is extremely flexible. I’ve been a premium subscriber for 3+ years now so I think have a good handle on the things I would really love to see integrated into the platform.

  1. Recurring Reminders – It’s nice to be able to get a reminder, but what about that weekly status report?
  2. iCal Integration – I get it, you want to keep people on the platform but if I can’t see reminders on my calendar there’s less chance of me opening up the app in the first place (prob even more true for new users)
  3. Differentiate between overdue and future reminders. When I look at my reminders all I see is a huge list until I do the mental processing to say “oh, that’s not due until next week”
  4. Stop clearing my iPhone reminder notices. As soon as I open up the app, and close it I have no more visual indicator that I have something in there waiting for me. My suggestion would be to give users a couple options for what they want the little red counter to represent:
    • Due Today and Overdue Reminders
    • Overdue Reminders
    • Include Unread Chat Count
  5. Email tasks – I’ve sent this one in a number of times, but I’ll list it here to. I love the Evernote email integration, but why can’t I email myself a task? It could be as simple as all “[]” get converted to task checkboxes. (ex: “[] Pick up milk”)
  6. Improved search – I get it. The natural language and search in docs/images is great! But why can’t I easily search for all my overdue reminders? Or things due between this date and that? I don’t want to have to go to notes and click on the reminder icon that keeps moving but doesn’t show up unless your in snippet view. I should just be able to search “due:overdue” or “due:today”. Check out RTM, Gmail, etc. There’s a ton of companies doing this so not sure why you can’t.
  7. Web merge / multi-edit – One of the things I like the most about the desktop client is the ability to select multiple notes and merge them or edit (add tags, move to a notebook, etc). Would love this ability from the web client!
  8. Email clipper – When work doesn’t allow it or you’re on the go, to be able to send an email with a subject like “clip:http://freedomre.com” to my Evernote email address and have it clip the site/article to my account (instead of just creating a note w/ the link) would be awesome!

Oh, and I’d also like to report what appears to be a bug. If I email multiple tags with a reminder the first tag and reminder get set, but the 2nd tag gets put in the note title (ex: “This is a note @_Inbox #tag 1 #tag 2 !tomorrow” gets turned into a note with the title “This is a note #tag 2”).

While this may seem like a bunch of complaints you’ll notice most of it has to do with reminders and tasks. The rest of the platform is awesome and I love that I can use it across all my devices (Windows, Mac, Chromebook, iPhone, Android, Kindle, etc). I’d highly recommend giving it a try, and if you haven’t already, just click on this link to get a free month of Evernote Premium.

Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...

Screen Capture Open Menus

I know I posted a link to this on SM the other day, but wanted to add the abbreviated version here for my reference.

If you’ve ever had the need to capture a screen shot, but also capture a menu that may be open (like File -> New…) you can still use the build-in Windows “Snipping Tool” to grab what you need.

  1. Run the “Snipping Tool”
  2. Press the Esc key
  3. Open the menu you want to screen shot
  4. Press Ctrl+PrtScr
  5. Click “New” on the “Snipping Tool” and pick what you want to grab

Here’s an example:

screen-capture-example

Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...

DB2 Stats vs Actual

Ever have a DB2 query that all of a sudden went from performing just fine to being dog slow? If so, there may be an issue with the stats on one or more of the tables being used in the query. To check, run the SQL below replacing XX and TABLE_NM with your appropriate schema and table in 2 places…

-- What DB2 thinks the table count is
SELECT  'Stats' AS TYPE_X,
        CARD AS COUNT_NB,
        STATS_TIME AS UPDATED_TS
FROM    SYSCAT.TABLES 
WHERE   TABSCHEMA = 'XX' 
        AND TABNAME ='TABLE_NM'
    UNION
-- Actual table count
SELECT  'Actual' AS TYPE_X,
        COUNT(*) AS COUNT_NB,
        CURRENT_TIMESTAMP AS UPDATED_TS
FROM    XX.TABLE_NM
FOR READ ONLY WITH UR

… if the record counts are way off, have your DBA do a runstats on the table in question followed by a rebind of any stored procs that use the table.

Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...

Do I have 32 or 64 bit Java Installed?

Hopefully by now you’re familiar with…

java -version

… to determine what version of Java you have installed, but sometimes you may want to know if you’re running a 32 bit or 64 bit version because you get an error like this…

Can't load AMD 64-bit .dll on a IA 32-bit platform

… to find out just run this variation of the command…

java -d64 -version

… if you have a 64 bit version you’ll get typical output. If not, you’ll get an error similar to this…

This Java instance does not support a 64-bit JVM.
Please install the desired version.
Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...

DB2 Recursive Query

If you’ve ever had to do a recursive query in DB2 to get a hierarchy of records, feel free to use this as a starting point…

WITH LINKS (PARENT_ID, CHILD_ID, UPDATED_TS) AS 
    ( 
    SELECT  ROOT.PARENT_ID, ROOT.CHILD_ID, ROOT.UPDATED_TS 
    FROM    XX.EVENTS ROOT 
    WHERE   ROOT.CHILD_ID = '234ASDFASDF' 
        UNION ALL 
    SELECT  CHILD.PARENT_ID, CHILD.CHILD_ID, CHILD.UPDATED_TS 
    FROM    LINKS PARENT, XX.EVENTS CHILD 
    WHERE   PARENT.PARENT_ID = CHILD.CHILD_ID 
    ) 
SELECT  PARENT_ID, CHILD_ID, UPDATED_TS 
FROM    LINKS 
ORDER BY UPDATED_TS 
FOR READ ONLY WITH UR

… yes, newer versions of DB2 have this ability built in but you’re not always using the most recent version are you??

Thanks to this page for pointing me in the right direction.

Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...

Remove Duplicate Lines in Notepad++

If you’ve ever had the need to remove the duplicate lines from a long list of entries like so…

hi
bye
hi
guy
bye
hi

… and are looking for this…

hi
bye
guy

You can use the find/replace feature in Notepad++ to do it if you use the regex funcationality. Here’s the find string…

^(.*?)$\s+?^(?=.*^\1$)

Just replace with a zero length string.

If you’d like to read up on the details I found this tip here

Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...

Photo Journal for 3/26/2015

 

It’s an interesting and exciting time to be getting into real estate. Shouldn’t you have one of the most tech savey agents in the area on your side? 

Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...

Linux ls output colors

If you’ve used linux much and your terminal is set to display files and directories in color, you know how frustrating it can be to have dark blue text on a black background like so (I’ve seen it much worse too)…

dirColorBefore

If you would like to modify the output so the colors are a bit more readable, you can add the following to your .bashrc file…

alias ls='ls --color'
LS_COLORS='di=33:fi=36:ex=31'
export LS_COLORS

which will produce an easier to read version like so (with directories yellow, files a crayon/teal, and executable files red)…

dirColorAfter

As pointed out in this article

The first line makes ls use the –color parameter by default, which tells ls to display files in different colours based on the setting of the LS_COLORS variable.

The second line is the tricky one, and what I have worked out so far has been by trial and error. The parameters (di, fi, etc.) refer to different Linux file types. I have worked them out as shown

di = directory
fi = file
ln = symbolic link
pi = fifo file
so = socket file
bd = block (buffered) special file
cd = character (unbuffered) special file
or = symbolic link pointing to a non-existent file (orphan)
mi = non-existent file pointed to by a symbolic link (visible when you type ls -l)
ex = file which is executable (ie. has ‘x’ set in permissions).

The *.rpm=90 parameter at the end tells ls to display any files ending in .rpm in the specified colour, in this case colour 90 (dark grey). This can be applied to any types of files (eg. you could use ‘*.png=35’ to make jpeg files appear purple.) As many or as few parameters as you like can go into the LS_COLORS variable, as long as the parameters are separated by colons.

Using trial and error (and a little bash script I wrote… my first one ever! 🙂 I worked out all the colour codes, at least my interpretation of them –

0 = default colour
1 = bold
4 = underlined
5 = flashing text
7 = reverse field
31 = red
32 = green
33 = orange
34 = blue
35 = purple
36 = cyan
37 = grey
40 = black background
41 = red background
42 = green background
43 = orange background
44 = blue background
45 = purple background
46 = cyan background
47 = grey background
90 = dark grey
91 = light red
92 = light green
93 = yellow
94 = light blue
95 = light purple
96 = turquoise
100 = dark grey background
101 = light red background
102 = light green background
103 = yellow background
104 = light blue background
105 = light purple background
106 = turquoise background

Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...

Photo Journal for 3/17/2015



Had a great time outside today. Nice to be on the swings again even if a hat and mittens were necessary. 

Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...