Category: Blog

  • Daily Coping 28 Jul 2020

    I’ve 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.

    Today’s tip is to remember that if you can’t change it, change the way you think about it.

    The last couple weeks I’ve been struggling a bit. Not as badly as in late March and April, but the sameness, the lack of travel and changing my environment has been tough on me mentally. I enjoy coaching, and have been getting to the gym 2-3 times a week, but I think I’m struggling with the realization that this isn’t going to get better after summer. We’re in this for the rest of this year.

    I knew that, but it’s sinking in. I can’t change that.

    I’m trying to remind myself that this isn’t that bad, there are people in worse situations, and things could be worse. I have a family, some financial security, and I have more time to do things around the house, chores and hobbies, than in the past. I should appreciate the this change in the world gives me some things that I’ve wished for in the past.

    That helps, though I think I need to keep reminding myself to change my view on a regular basis.

  • Building an Azure Architecture Diagram

    One of the challenges I have at times is illustrating how I’d set up a particular system. Not the technical details, the visual ones. I can use boxes and simple shapes in PowerPoint, and include some logos, but this always feels fairly unprofessional.

    Fortunately Redgate has some icons and images I can use to illustrate how things work. I saw recently that Microsoft makes these available as well. There is an Azure Architecture Icons page.

    The icons are svg, so while they work in PowerPoint, adding them to something like this post in OpenLiveWriter doesn’t work. However, I could make a quick diagram and capture an image of it.

    2020-07-21 12_57_56-Presentation1 - PowerPoint

    Not great, but it shows I can put icons on a page with arrows.

    I would hope they’d make similar icons available for products and perhaps other features, like Azure Boards, Pipelines, and more. I haven’t seen official ones like this, but I hope I do.

  • Daily Coping 27 Jul 2020

    I’ve 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.

    Today’s tip is to make a list of three things that you can feel hopeful about.

    1. Success against COVID

    There are a number of drug trials showing some early success, but more importantly, there are a number of trials. We, as a world species, are trying lots of things. Hopefully something works and we share.

    2. We can exercise with masks

    Colorado implemented a mask order just after a volleyball practice a couple weeks ago. My gym for working out, and the one for coaching, both adhered to this. I held a practice after this, and the sixteen 13/14 year old girls wore their masks without complaint. They got pulled down once in awhile, but for the most part they wore them.

    At the same time, I see lots, most people, in my workout gym wearing masks while working out. I tried it while lifting, and while not something I like, it’s not that bad.

    3. My daughter will hang out longer

    My daughter is a starting volleyball player in college. Last year, other than a couple matches missed for injury, she played every point as a freshman. It was quite exciting, traveling to watch her play live in New York, as well as streaming games from London, Sydney, and around the US. I was really looking forward to that again.

    However, her conference suspended fall sports. They might move to spring, but for now, no sports. As a result, she is thinking that she doesn’t want to go back for the fall. It’s a lot of money, and if she can’t hang out with friends and is watching a screen, she would rather stay here, save some money, which might get her another season of play, and work for my wife.

    I like having her around.

  • Saving My Garmin Data

    With the Garmin outage, I was a little worried about my data. As a result, I wanted to ensure I could get information off of my device and at least save files. I posted a note on Twitter, and got a link to the DC RainMaker, with a procedure to get your files from a device. Since I have a watch that connects to a mobile, I wasn’t sure which device to connect, so here’s the experience of getting my data.

    First, what’s the extent of the issue. I started a walk workout on my watch when I took the dogs out. This was a short one, and I was able to complete and save the workout.

    When I got back to my desk, I opened the app on the old mobile. I saw the data for my heart and steps, which matched the watch, but no workout.

    20200724_133805

    I then went to my watch and clicked “sync”. I got this for awhile, and while it said that things were being transferred, I don’t have any way of knowing this is working.

    20200724_133745

    My understanding is that this data goes to Garmin Connect and then that syncs with my phone, rather than going through my phone and then to Garmin Connect. Since there are people that might not use the app on their phone, this makes sense.

    I know I can’t get data at Garmin Connect.

    2020-07-24 13_41_53-Window

    I also don’t see any updates on their blog.

    2020-07-24 13_42_47-Window

    OK, I know what I can’t do. What can I do?

    Connecting My Watch

    I’ve never connected the watch to this computer. I’m not likely to get the Garmin app to work if I install it, so let’s get the cable that came with my watch. I connect it to my computer and …

    Nothing. Nothing detected as a device. No new USB devices. No notifications.

    This was with a USB hub, so let’s take that out of the equation. I do connect some data devices through here, but why not try something. I get up, walk around, and plug the watch into the motherboard USB slot.

    2020-07-24 13_59_23-Window

    That’s interesting. Glad I tried that. Next I browse and find two storage areas.

    2020-07-24 14_00_09-Window

    I tried media first, since that’s the first one. Nope, no activities under Garmin.

    2020-07-24 14_00_15-Window

    Let’s try the primary storage. This looks more promising.

    2020-07-24 14_10_21-Window

    I don’t see Activities, as in the DC Rainmaker post, but I do see “Activity”. In there, I find the fit files.

    2020-07-24 14_10_36-Window

    These are binary files, so there goes any quick SSIS/ADF upload of data somewhere else.

    2020-07-24 14_12_03-Window

    I suspect there’s a way of doing this and a few searches show some libraries that might help, but those are for another day.