All posts by Mark Jacobsen

Update modification timestamp on DB2 table automatically

Ever want to update your modification timestamp field any time an update is made to the row without having to add application logic? Well, DB2 makes it relatively painless…

alter table XX.MY_TABLE add column last_updated_ts timestamp not null
generated by default for each row on update as row change timestamp

Check out these resources for additional information…

  • https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0051498.html
  • https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000888.html
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...

Stop Stealing Dreams (by Seth Godin)

If you’ve ever read or listened to anything by Seth Godin you know he has a knack for asking thought provoking questions, and challenging conventional wisdom. As such, he recently did a three part series on his Akimbo podcast about what school is for that I found fascinating. Hope they make you stop and think too.

S 3 E 9 Stop Stealing Dreams

S 3 E 10: Connect the DotsQ&A about Stop Stealing Dreams

S 3 E 11 Getting In (to a Famous College)

Find more at www.stopstealingdreams.comPlease 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...

Is it time to quit social media?

As I read this article what was running through the back of my mind was, “is it time to quit social media?”, and to be honest… but for being involved in real estate and a large bulk of that requiring being “engaged” I’m not sure I have much use for it. Never before has it been easier for marketers to target and connect with their “target audience”. You do realize that’s what social media has become right? The proverbial barrel where the fish are to shoot.

So, is it possible to take back the social networks? I’m not sure it is – at least with the current companies. Built from the ground up, or under a completely different model – maybe. But as the article linked to above points out it would be to the detriment of the “bottom line”.

Would I like a feed where I only see posts from my family, and maybe some other groups at my leisure? Of course, but unless I’m paying for that the only recourse I have is to a platform that has the resources to provide it based on the party that is willing to pay for it – the marketers.

So what would this “social media” service of the future look like? Number one, it should be built on a privacy, no-advertising first model. Second, I believe it should be decentralized, but speak a standard protocol – just like how email service is provided. Then, organizations like companies, teams, or even families could manage their own little groups and individuals could determine what they want to see or who they want to connect with…

And yet, as I sit here writing this, I wonder if it’s even possible or needed. After all, I’m able to run my own little blog right here. You can share it on social media if you so choose. In fact, I’ll probably post it to my account – and try not to look at the “likes” or “comments” that fuel the FB “engagement” engine.

So, while I may have just rambled for a number of paragraphs, let me finish by encouraging you to consider your use of social media, and at a minimum strongly consider turning off your notifications and moving the app to a sub-folder on your phone (just those two things alone have made a huge difference in my life). I would also encourage you to look into downloading and using Signal Messenger in place of text messaging and especially in favor of the social media messaging platforms.

Until we figure something out, you can always find me right 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...

Including the version in a Maven artifact

Recently I wanted to include the version of an artifact generated by a Maven build into a text file in that artifact. As Google and and good friends will help you with, I was pointed to this article that was exactly what I wanted.

Basically, create a /src/main/resources/version.txt file with the following content…

${project.version}

… then including the following snippet in your “build”…


<build>
  <resources>
    <resource>
      <directory>src/main/resources</directory>
      <filtering>true</filtering>
      <includes>
        <include>**/version.txt</include>
      </includes>
    </resource>
    <resource>
      <directory>src/main/resources</directory>
      <filtering>false</filtering>
      <excludes>
        <exclude>**/version.txt</exclude>
      </excludes>
    </resource>
  </resources>
</build>

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...

Schooling – The Minimalists Podcast

You have to listen to this! If you don’t think you have time, start at 45 minutes. T.K. Coleman makes some great points.

Schooling – The Minimalists PodcastPlease 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...

A Day In The Life of my Supposedly Frugal Stomach

Another good post by Mr Money Mustache. Probably the biggest thing that jumped out at me was this…

A cost difference of just $1.50 per person per meal, multiplied over a four-person family’s 372 meals per month makes a difference of $558 per month, or about $96,000 per decade after compounding.

Which, even if you don’t compound is around $65,000 in a decade.

A Day In The Life of my Supposedly Frugal StomachPlease 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...

25 Productivity Tips and Hacks That Actually Work

Listen to/watch the video for details on all the below items, but this is a great list!

  1. Be proactive about being productive
  2. Outsource the Small Stuff
  3. Batch Similar Small Tasks
  4. Don’t Watch Too Much TV
  5. Focus on the 80/20 Rule
  6. Never Sit Down Without Knowing What You’re Going to Work on
  7. Time-Block Activities
  8. Wake Up Earlier
  9. Don’t Multitask
  10. Stop Paying Attention to the News
  11. Have a Dedicated Work Space Free of Distractions
  12. Focus on Being Effective, Not Just Efficient
  13. Sharpen You Ax
  14. Say No a Lot More – “Every yes is a no to your wife and kids”
  15. Reduce Social Media Usage
  16. Shorten Your Deadlines
  17. Review Your Goals Regularly
  18. Don’t Anwer Your Phone
  19. Do What You Love
  20. Find More Ways to Get into Flow
  21. Moderate Your Screen Time
  22. Hire a Coach
  23. Join a Mastermind Group
  24. Track the Things that Matter
  25. Get Really Good at What You Do

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...

Stop Using WhatsApp If You Care About Your Privacy

Yet another reason to use Signal

Stop Using WhatsApp If You Care About Your PrivacyPlease 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...

Moments That Change Lives with Dan Heath

Love the idea of creating peak experiences. In fact, I’m reading the book now.

The EntreLeadership Podcast: #259: Dan Heath—Moments That Change LivesPlease 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...

This Week in Tech 663 Reasonably Miserable

You need to listen to this Twit episode.

This Week in Tech 663 Reasonably Miserable | TWiT.TVPlease 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...