Category: Blog

  • Daily Coping 3 Aug 2021

    I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag. 

    Today’s tip is to reach out to a family member, friend, or colleague.

    I did this recently for a trip. I actually took a business trip, the first one since 2019. Before I did so, I sent a few notes out to friends I know in the company, but I also reached out to a friend who lives in the LA area. I wanted to check on him, as it’s been months. I also was hoping he might be free for dinner.

    He was, we got together, and it was wonderful.

  • Daily Coping 2 Aug 2021

    I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag. 

    Today’s tip is to be a realistic optimist. Think about what could go right.

    I’m usually positive in life, but often I anticipate or think about potential problems and issues first. I think that was part of what helped me think critically about building or managing software, as I looked for problem spots early.

    However, as I get older, I know that often there aren’t likely to be big problems. There could be smaller ones, and we do need to try and mitigate those, but really, I ought to appreciate and think of the good things first.

    My daughter is driving herself back to college with a friend. It’s a long trip, 1775 miles, and she’s never done anything like that herself. As I’ve told a few friends, they all seem to worry first, or ask me about concerns.

    While I did think about ensuring she had a car that would make it, mostly I thought this was a great opportunity for her. A chance to experience the world with a friend, enjoy a long trip, manage her gas/food/restroom breaks along the way, and embrace a new challenge in life.

    I loved long trips when I was younger, and I still enjoy driving to cities. I think this will be a great event for her, the first time she’s taken a long road trip by herself.

  • Goal Progress for July 2021

    I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2021.

    As I look at goal progress for 2021, I’m going to follow a similar pattern as last year. I’ll give myself a current grade and report on overall progress in of the areas where I set goals.

    This is a two month update. I forgot to publish June, so here I am including both months together.

    Current Grade: C

    June was vacation month. I spent a few days in the Florida Keys, and then another week in Orlando coaching. In between, I was trying to get work done. Not as much progress as I’d like, especially as a lot of non-work time was spent catching up on chores around the ranch. An unusual level of things to fix.

    July was slightly better, but not a lot. I ended up with a couple trips away from home, lots of chores around the ranch, a business trip, and a bit of stress from a home renovation. As a result, I read a bit but fiction. I also tried to take a bit more time away from the computer.

    In any case, I’m still not pleased with progress for the most part, but I am learning that maintaining steady progress across the year is hard, even with relatively few goals..

    Reading

    The goal was 4 books (3 non-fiction, 1 tech).  I finished one in early July, and found a few more to add to the list. I haven’t been sure what to read, but I found a few career books. Now I need to find a tech book for the second half of the year.

    Here’s the current progress:

    I started with Lights Out as I think it’s easier to read.

    I’ll put a short review of the Project to Product book out in August month as well.

    Technical Skills

    I’m solving the Advent of Code three times.  I’m also studying for certification.

    In terms of work here, I did little with vacations. I should have spent a little time on Azure, but really, I didn’t do much. A little, but not much. For coding, I’ve just hadn’t put in much time. I started on day 7, but got a little stuck, and hadn’t completed the challenge in SQL, which is where I started. I should have started with Python or PoSH, as this is a recursion issue. I also hate recursion, and I’ve been avoiding this.

    For certifications, I started watching some videos, but I find myself getting too distracted with other things. So I’ve not been focused on more programming, which is really a state of where I am in my career. I should have done less here goal wise.

    Update:

    • Certification –  AZ-900 – 5%
    • Certification – DP-200 – 0%
    • Skills – T-SQL – 2020 Advent of Code – 5/25
    • Skills – Python – 2020 Advent of Code – 6/25
    • Skills – PowerShell – 2020 Advent of Code – 5/25
    • Skills – TBD

    Projects

    Little things are moving forward. I did send a note to the 2 groups near me offering to speak. The other one appears to have stopped meeting during the pandemic. I have scheduled a talk at one for August. Not sure about the second.

    I did a little more work on my volleyball report, and started to structure the data store in Excel better to ensure I can easily publish this early next season for the next team. I also started to write about how I’m doing this, so I think this is further along than it was before.

    • SQL Saturday Inc – 90%
    • Support events: I spoke at another event and a couple user groups
    • Speak at the 3 local user groups, at least one live presentation – 15%
    • Help organize a Denver/Colorado event, live or virtual – 20% (more conversations)
    • Complete my Power BI Volleyball report – I know lots of kids will use this, so I need to get it done – 70%
    • SQL Memorial – 90% – I updated this, sadly, as someone passed. I need to move this to straight GitHub Pages and get the custom domain set.
  • A Speedy Digital Overreaction

    I lost my wallet a few weeks ago. I realized that I didn’t have it on a trip to town and was able to use my phone to pay for something. I assumed I’d left it at home in another pair of pants or on my desk.

    We were leaving for a trip the next morning, and I was a bit stressed about it being misplaced. I kept looking around the house, thinking I set it somewhere, checking clothes, bags, etc. I even called a the volleyball gym and asked them to look for it. I checked my accounts, and the cards hadn’t been used, so I turned them off and kept thinking I’d misplaced it.

    Eventually I had to give up and just go, without any forms of payment for the road. Fortunately my wife had her card, as my daughter forgot to bring hers. We had a fun weekend of sharing a single card as we tried to navigate a world that is mostly card based in the US. We forgot the card one afternoon and couldn’t go to a museum, which only accepted cards.

    On the way down, while going through many emotions, I finally accepted that a few hundred dollars were gone and my cards needed replacing. I was traveling in 6 days, so I needed to start preparing. I was able to replace my bank cards and my license online, getting replacements shipped out the next day. It was amazing how quickly and easily I could get this accomplished using my mobile.

    An Interesting Recovery

    Even though I’d accepted the loss, I kept thinking about my wallet. My best guess was that I’d set it down at home and then it fell behind or near a place I didn’t check. I also kept thinking it was strange that no one had tried to use a card if I’d left it in a public place.

    Eventually one of my kids suggested I call Wal-Mart. That was the last place I’d used it, and perhaps they had it. I called them, and surprisingly, a manager called back to say it was there. I drove down, trying not to get my hopes up.

    They did have it, and I recovered it, all cards and cash intact. A relief, and somewhat amazing. Fortunately all my cards arrived quickly, and I was able to travel with all the cards I expected to have, albeit with new numbers that I hadn’t memorized.

    Lessons Learned

    The big lesson is that I should pay more attention to my wallet. I don’t know if I left it on the self-checkout (most likely) or in the cart (less likely), but I can’t let my attention wander.

    The second one is that there are good people out there, and I should remember that.

    Third, I need a wallet inventory. There were a few things, like insurance cards, that I didn’t consider with regards to replacement. That might prove problematic, so I’m grabbing digital images of these cards to keep around, just for my knowledge.

    Fourth, the use of digital NFC payments is by no means universal. Even getting cash out of an ATM isn’t smooth here. Especially once I’ve cancelled the cards. I should have left one enabled, but turned off. I could always turn it on for a few minutes to get cash..

    Fifth, I should keep some sort of phone/email identifier in my wallet. If someone were to find it, at least they could attempt to contact me.

    Sixth, I’m going to try a tracker of some sort. This isn’t the first time I’ve misplaced my wallet, though it’s usually somewhere in the house or in a family member’s car. I don’t know how well these work, but I’m not in the completely digital world, so we’ll see if this helps me to stop losing things.