Blog

  • Silver Beach

    It was unusual for only two of us to be at the lodge at any one time, and strictly speaking, it was not allowed, but that’s the predicament Denise and I found ourselves in that weekend.

    The year was 1999 and gas was high at $2 a gallon. We were both working at Michiana Christian Summer camp and while I lived there full time, she was only there during the day.

    Erich Mowing

    I worked in maintenance, which meant that I not only had to clean the cafeteria/gym and bathrooms 3 times a day, I had to fix whatever broke, and do all of the landscaping work.

    Denise worked in the office on a computer. It was air conditioned. I would see her when I went into the office to take out the trash and vacuum the carpet. She was always nice to see.

    Denise and Erich

    We would all eat together in the staff area of the cafeteria. Some days I’d pour my water on her head just for fun. It was fun. At night she’d run the concession stand near the pool.

    That Saturday morning I asked her if she wanted to go to the beach. To my surprise, she said, “Yes”. We drove up from Niles to St. Joseph, Michigan where US 31 ends, and Lake Michigan begins.

    There was a bend in the road near Berrien Spring where Denise made a cross sign on her chest as we passed. Her friend had died there the year before. She wanted to stop to test drive a new vehicle.

    Silver Beach

    I helped her look at the SUV she had been eyeing and then we continued on to Silver Beach. When we got there I realized I didn’t have any swimming trunks so we went to a shop there on the beach.

    I picked out a green pair of swimming trunks and asked Denise what she thought. She didn’t care. I asked her if she was going to swim. She was not. She sat on the beach while I plunged into the water.

    Silver Beach Train

    On the way back to the car a train came. I asked her if I ran to get on the train if she would go with me. She said she would. I didn’t run.

    We stopped at McDonalds on the way back to camp, but she wouldn’t let me buy her lunch. “It wasn’t a date,” she said. And I knew that.

    Erich and Denise

  • Microsoft SQL Primary Keys

    I’m in the process of learning SQL and in so doing have started learning Microsoft SQL using Microsoft’s SQL Management Studio. It’s a free program that’s used to open, manage, and edit Microsoft SQL databases stored on a server running Microsoft SQL (quick note: SQL is a database language used to store data in tables that can be accessed from programs or websites).

    2014-05-16 11_26_21-Connect to ServerWhen you first load the program (I’m running SQL Server 2005, which is not free), if you haven’t already opened a database, it will prompt you to connect to one. If or once connected to a database, it will appear in the left menu.

    The places you’ll be working in the most are under the “Database” folder: Tables, Views, and Programmability > Stored Procedures. For this post I will be focusing on Tables and specifically, creating Primary Keys.

    Table Best Practices

    To create a table, right-click on the Tables folder and select “New Table”. SQL will automatically append a “.dbo” to the front of the table name, but to keep things clear later on, add your own “tbl” or something similar to the beginning of a table name.

    Once you have created a table, create a new column to use as a primary key, then change the type to INT for integer. This will create a way to identify rows that are unique to the table, which allows all sorts of other functions to work correctly later on.

     

  • Business Thinker and Rational Architect

    I just took a new career finder test at Shobia after reading about it on Hacker News. I had my wife take it first as a control. She got “Business Interactor”, which means she may, “like interacting with other people, especially when it is in a professional work setting like in a company,” and she probably wants, “a job where you’re talking to people in order to make things happen. You might enjoy being a business development associate or political campaign manager.”

    Business ThinkerWhen I took it I got, “Business Thinker,” which means I, “like work dealing with companies and financial topics that involve thinking and coming up with ideas. You want to deal with questions like how a company can become more efficient. Careers you might enjoy include business consulting or being a corporate attorney.” Well they were almost right. They asked for feedback so I told them, “I wouldn’t like to be a corporate attorney”.

    Back in January I took the DiSC Personality Profile. The feedback it gave was very long, but in short, I’m an “SC” (Submission and Compliance), which means I’m analytical, systematic, even-tempered, and patient. I “show steadiness and consistency, and I tend to be conscientious and reliable. Overall I probably want to be known as someone people can count on. Compared to others, I have more patience for routine projects. Most likely, I plan ahead, allowing enough time to complete my responsibilities at the pace I prefer.”

    That’s also true. Nice job, tests! Ready for one more? Back in 2010 I took the Keirsey Temperament Sorter and found I was an ENTJ (The Executive), but after taking it today I found I was a INTP (Rational Architect – I’ve always wanted to be an architect!). The primary difference between the two is the movement from thinking “extroverted” to thinking “introverted” and from “judging” to “perceiving”. If this interests you, see my other online career tests and what I found out about myself.

  • The Content Carousel

    What’s the hook gonna be?

    When I was in college I used to wish I could be the guy who made up the headlines for the local newspaper. I had no idea how much it paid, but I was sure that everyone at the newspaper wanted that job and it was incredibly hard to get. Little did I know that within a few years everyone would be running their own “newspapers” via their blogs, social networks, and podcasts – all of which require writing great headlines.

    While Copyblogger says to always write the headline first, I find that when I’m writing the post, I don’t always know what it’s going to be about until I’m done. However, when I’m asking other people to write posts for me, I write the title first so they write about what I want them to. For this post I just copied and pasted a title I had used for the subject of an email (which is another area where the right “headline” matters a lot).

    The Content Carousel

    Email as a marketing tool

    Email is one of the newest forms of networking, which has always been an important aspect of business development. Modern tools like social media have made connecting easier than ever before, but that hasn’t reduced the value of email, nor has it meant that writing emails is easy. The art of creating powerful emails and subject lines is still a fine skill.

    It may seem like you’re just going around and around The Content Carousel. Some days you’re up and some days you’re down. When you get done, you’re right back where you’ve started. The more you get content out, the more you have to make. And then it’s Publisher’s Clearinghouse Day and the barcode scanner breaks. Okay, maybe it’s not that bad, but is there an end?

  • Things Change

    After making fun of his mom (like kids in 6th grade do) he stood up, pushed me, and we both ended up in the principal’s office. That summer Joey Harless stole his dad’s car, wrecked it, and killed himself with his dad’s gun.

    My sophomore year of high school Molly Gibson dug her fingers into my arm after she found me looking at the brush she’d left outside the pool locker room. Driving home one night our senior year she was hit by another car and died.

    On August 11th, 2011, I took this picture of my daughter Magdalena in front of the Hardee’s in Tipton that had been there 20 years:

    Hardee's

    A month later, it was torn down and a Casey’s General Store was being built there. This is what it looked like in December of 2011 (with Carmina and Samuel):

    Casey's

    That same day (August 11, 2011) I took this picture of a window in a home in Tipton:

    Tipton

    By April 21, 2012 it looked like this:

    Photo-Apr-21,-6-43-44-PM

    On January 7th, 2012, I took this picture of my son, Samuel in front of a building at the corner of Main and Dearborn in Tipton, IN:

    Samuel

    The next month (February) the building was demolished:

    Fayes

    In the summer of 2012 I walked through some woods behind Starbucks on Old Meridian in Carmel by Meijer:

    Carmel

    The next time I drive by, bulldozers have tore everything down to bare ground and they were putting in a new apartment complex.

    One night when I was running the paper route in 2010 I took a picture of an old farm house in the middle of a corn field. The next morning (around 3 AM) a semi-tractor trailer had wrecked right in front of the old house – police cars were everywhere.

    Last fall (2013) I was driving on 96th Street in Indianapolis across from HH Gregg headquarters and thought, “I should take a picture of that scenic, tree covered drive,” but I didn’t stop. The next time I drove by, the trees had been bulldozed to put in a parking lot.

    I learned from my mistake. When I saw this house along US 31 in Westfield I pulled over and took this picture.

    Westfield

    The next time I drove by it was gone.

    I walk on a strip of grass in Greenfield, Indiana for the first time, the next month they pave over it with a brand new sidewalk. I update a customer’s website copyright date as a courtesy, only to find out hours later they are closing their business. I think of a coworker I haven’t thought of in a while and email my boss about him – he gets fired hours later.

    None of these things are related. Things change. People die. Old buildings get torn down. Businesses close and people get fired. That’s life. Sometimes you’re there to document it one last time before it goes. Sometimes you get to have a visceral interaction with someone before they go so you remember them longer. I still think about Joey and Molly sometimes.

    I wish there was a way to know you’re in the good ole’ days before you’ve actually left them.” -Andy Bernard

    Epilogue

    Being that Joey Harless died before the World Wide Web (<1993) and that he was a minor at the time, I couldn't find any information about him online, but you can donate to Molly Gibson's memorial, Pooh Bears for Molly. It still makes me sad to this day. Whenever I have a life event I think about Molly. At first it was the senior prom. Then it was graduation. Then it was going to college. Then getting married, graduating college, and having children. She is missed and still thought of. As the father of a daughter getting ready to be Joey’s age I can’t imagine losing her and I can’t imagine what it would be like for his parents – or Molly’s parents – and I hope I never have to find out. All we can do is love the people we’re with while we’re with them and pray for the best.

  • Market Sophistication Levels

    Market Sophistication Levels are about selling differently based on competition level and the degree of public sophistication about your product and market. They are based on a book called Breakthrough Advertising by a copywriter named Eugene Schwartz. Vishen Lakhiani popularized it in his video (below).

    Market Sophistication Level

    Market Sophistication has 5 levels. To get people to buy or use your product, you need to get a gauge of what level of sophistication your market is at. You do this by looking at the messaging your competitors are using, like PPC ads, home pages, TV commercials, radio commercials, and landing pages.

    Market Sophistication Level 1

    You are just introducing a new thing to the world. There is no need to differentiate your solution. The public is unaware of anything close to your product because it is a radically new invention. You simply lead with the declaration that your product exists (ie. “The World’s First Car vs. A Mechanical Horse”)

    Market Sophistication Level 2

    Once you have competitors, your job is to outbid them by making outstanding claims about how your product or service is different and better. They are aware of several of your competitor’s products, then emphasize the most powerful benefits of your product (ie. “The Fastest, Safest Car Ever Created”)

    Market Sophistication Level 3

    They’ve seen many competitor products, then emphasize the mechanism that makes your product unique from the others (ie. “The New Engine That Makes X The Best Car In The World” Emphasize different sections of your marketing copy to best capture their interest and desire in your product or service.

    Market Sophistication Level 4

    Keep elaborating the features, not the product. Focus on the mechanism behind the product or service. They’ve already seen several competitor products that use your same mechanism, then emphasize the most powerful benefits of your mechanism (ie. “The Quietest Engine Luxury Can Buy”).

    Market Sophistication Level 5

    Finally everyone has a new feature and the audience becomes jaded of all of the advertising and are familiar with all of your competitors’ claims. Instead, emphasize identification with your prospect. (ie. “The Only Luxury Car Exclusively Driven By The World’s Best Business Leaders”).

    Marketing Strategy for Great Marketing Plans

    When you’re doing initial market research into how to market your product or business, it can pay to start off figuring out your market sophistication level before making your marketing strategy or marketing plans. But it’s not only about products or services – any page from a job posting to an About page to a Contact page can be optimized using market sophistication levels. “To sell is human“, and you should always be closing.

  • The Top 5 Best USB Backup Power Sources for Your Mobile Devices

    Having an iPhone, Android smart phone, ebook reader like a Kindle, or other type of mobile devices can make you more efficient, more in tune with your friends and family, and keep you up to date.  But what happens when you are running low on power for your device and you aren’t able to charge it?  USB Batteries are external battery packs and chargers that will power and recharge your devices anywhere without access to an electrical outlet.

    They 4 key things to look for in a mobile device battery pack are:

    • Power – How much power do they store?
    • Size – Will it fit in the space you have for it (in a bag, attached to device, etc)
    • Connections – Will it connect and power your device?  How can you recharge it?
    • Durability – These things will travel with you and need to be durable

    Based on these criteria, here are our top five USB battery chargers for your mobile devices:

    USB Battery5 – First up is the Splash Intense 5400mAh External USB Battery Pack. This small unit weighs in at providing 5400 mAh of power which is going to be several recharges for today’s smartphones.  This unit has two output USB ports to charge two devices at once which is a great feature when you need it.  The battery pack also comes with a wealth of charging tips for many popular phones and includes the standard USB options to power things like Blackberries, Kindles, Nooks, and other e-reader mobile devices.  This unit recharges via your USB port on your computer and lets you know instantly what the current charge is via blue L.E.D.s on the front of the unit.  This is great to be able to know before that upcoming trip if you need to top the battery pack off.  This is easy to use, has a large power capacity, and is a stylish unit to carry around  with the many connection tips that are included making it a great buy.

    xpal USB Battery XP20004 – Next on our list is the Energizer XP2000 Universal Rechargeable Power Pack.  This tiny unit has lots of things going for it.  Weighing it at only 2.4 ounces, this certainly isn’t going to weigh you down.  It packs 2000 mAh of backup power which isn’t a ton but enough to get a full recharge on most devices except for tablet computers like the iPad or iPad2.  This unit is recharged via usb and comes with six cell phone tips including Apple (iPhone, iPad, iPod), LG, Samsung, Balckberry/HTC/Motorola (Mini USB), Micro USB and Nokia.  A very cool program that Energizer is rolling out is the Free Tips for Life program which enables you to instantly qualify for two FREE phone charging tips per year for the life of your product.  This is a great add-on to ensure the USB battery pack is useful for years to come.  The XP2000 also comes pre-charged and holds its charged for up to a full year utilizing Energizer’s great low-discharge battery technology.  This is a great solution to get and put away for occasional or emergency use without having to worry that it has lost it’s charge while sitting unused.

    3 – Coming in at number three is a versatile power charger: the ReVIVE Series Rapid GoCharge 2000mAH External Battery Pack featuring USB Batterytwo USB charging ports, a handy visual battery meter, four (4!) ways to charge including AC, DC – Car Charging, Micro USB, and mini USB.  It even comes with a built-in L.E.D. flashlight!  This is a great unit for those who need an occasional extra boost to their iPhone, iPad, Kindle, or other mobile device and aren’t sure if they are going to be outdoors, in a car, or by a computer when they need it.  The trade off for this type of flexibility and extra options is the amount of power the battery pack stores.  This will provide one good recharge for a phone or e-reader and then pretty much be ready to be recharged itself.  This is great to get topped off or provide an all-in-one emergency solution for backup battery power.  Considering it’s price (under $30), it’s a great solution and is top-rated for light power needs users.

    USB Battery2 – Our runner-up for the best backup power source is the New Trent iCruiser IMP1000 11000mAh External Battery Pack and Charger.  This black piano finished device is not a small unit but packs a huge punch!  This is the heavyweight when it comes to backup power.  The IMP 1000 will get you an extra 50 hours of iPhone 4 charge – that can get you through an entire vacation without needing to recharge!  At 11000 mAh of power, this device can store over 7 times the battery capacity that a typical android smartphone can deliver.  Coming with a handy drawstring bag so you can keep the battery pack and it’s many connection options together is another nice touch.  For travelers who can go quite a while without a reliable power source for their phones, e-readers, or GPS units, this is the way to go!

    1 – Coming in at number one is the superb New Trent iDual-Port External USB Battery New Trent iDual-Port Pack IMP50D 5000mAh External USB Battery Pack and ChargerPack and Charger.  This is a sleek and small (think deck of cards) pack with two usb ports to charge two devices at the same time.  Now charging your phone and your GPS at the same time is easy to do.  This unit has tons of power (5000mAh to be exact and has enough juice to charge an iPhone 4 three times over!  Then, when it’s time to recharge the battery pack, simply plug it in to your USB port on your computer, and it’s ready to go.  This unit is very affordable for the power and features it provides which is why it ranks at #1 on our list here at USB-Battery.net.

  • Business Plans – Are They Worth It?

    I’m not a big fan of business plans, but apparently that’s not always been the case. In my Google Drive there is a folder called “Business Plans”. Inquisitively I clicked on the folder to see what it contained.

    Business Plans

    My last modification was on April 10, 2008 (6 years ago). None of the five businesses listed are still in existence and only two of them ever made money. I thought it’d be fun to open them up to see what I wrote.

    Able Trainers

    The idea was to create courses on basic computers, the Internet, and Microsoft Office applications. Our target market was “small businesses and suburban schools.” Phonebooks. Business cards. Paper flyers.

    Comp LubeComp Lube

    This business plan contains a logo and the words, “Sustainable computer repair.” I’m not sure what that means. I ended up giving the rights to this company to a former employee, who never used those rights.

    Telablue

    This plan is 9 pages long, 2,250 words. The objective was, “User-friendly, professional, sites with personality based on customer needs and desires. Generate Profit. Grow at a challenging and manageable rate.”

    Turn FilmTurn Film

    Like Comp Lube, this plan is nothing more than a logo and the words, “Film editing and conversions.” At least it actually described what it did. The idea was a “VHS to DVD” service, which dates it pretty well.

    Watershawl

    Watershawl was a “new media company specializing in computer services and design.” That’s pretty much true to what it was. I did a lot of web design and IT work, but what I loved doing was process management.

    Are Business Plans Useful?

    Planning is useful, but I’m not so sure the actual document is useful. It can be used as a way to flesh out ideas, but it doesn’t have to be a long document. One page should be enough to state what you’re doing, how you’ll make money, and who your target audience is.

    A business plan is usually all made up numbers, but it’s easy to feel like you’re building your business by writing a business plan instead of actually trying to Sell First. Customer development is one way to figure out whether or not someone will buy what you are selling.

    I’ve spent the last year and a half helping one of my customers develop a business plan while another customer has already sold tens of thousands of products. Not all companies can be bootstrapped I realize, but the sooner you can validate your idea, the better.

  • How I Use Google Analytics for Business

    There are 6 main areas that I check in Google Analytics to get a feel for how a site is performing, where the traffic is coming from, and what the people are interested in.

    Audience Overview

    2014-04-08 09_29_03-Audience Overview - Google Analytics

    While some may view these as “vanity metrics”, they give you a baseline comparison month over month and year over year for how your site is trending over time.

    To give you some context, a starter site should aim for 200 visitors a month, then 200 a day. A good bounce rate (user visits one page and then leaves) is less than 60%.

    Acquisition Referrals

    2014-04-08 09_32_38-Referral Traffic - Google Analytics

    There are multiple views under Acquisition (overview, channels, traffic), but I focus on “All Referrals” as it is the most specific category. It lists specific referring sites.

    Organic Keywords

    The other category under Acquisition I review often is “Keywords > Organic”. It can give some insight into what search terms people are using to find the site.

    If your top keywords are your brand name, don’t fret. Congratulate yourself. That’s a sign of success. It means people are searching for your brand name specifically.

    Search Engine Optimization Queries

    If your top Organic Keyword is “(not provided)” you can still get the keyword information as long as your site is connected to Google Webmaster Tools.

    Under Acquisition > Search Engine Optimization > Queries will tell you the keyword, impressions, clicks, and average position for each search query.

    Site Content

    Under Behavior > Site Content > All Pages, Google Analytics lists the top pages on the site by pageview, time on page, and bounce rate.

    I use this in combination with the keyword data for content marketing to determine what to write about when creating new blog posts and pages.

    Advanced Analytics

    There is much more that Google Analytics can do from A/B testing to automatic reports to goal and conversion tracking to automatic alerts.

    If you are interested in learning more about the insights Google Analytics can give your business, contact me or leave a comment below.