Category: Blog

  • Daily Coping 21 Feb 2022

    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 look back at the pandemic; what are the strangest memories you have?

    I wrote this tip because I ran across some old pictures from the last two years. Here are a few things that struck me as strange.

    I found myself doing yoga on the front lawn because the gym was closed.

    20200519_130614_HDR (1)

    I had really taken it for granted that I could go to the gym every week. Maybe not every day, but I’d get there and be able to take a class or use weights. While I could do yoga alone, and I had some videos out in the yard, I was surprised that a) I didn’t have other options, and b) it worked out pretty well. I enjoyed being out there in the spring and am looking forward to it periodically this year.

    I’ve traveled a lot for years, and I’ve seen plenty of people in masks in airports and on planes, albeit a minority. I still can’t believe that we got so many people to wear masks, we had regulations, and I coached in one with kids playing sports in one.

    20201121_164505

    I’ve enjoyed some online gatherings, but I can’t believe that I was a part of multiple online classes for cooking or cocktail making. If you had asked me my interest level in 2019 for this, I would have said zero. The last two years I’ve looked forward to a few.

    Exav7IGVgAA9oRI orig

    I’ve lived in America for most of my life. This is the land of plenty, and often, excess. I’ve lived in places with hurricanes and blizzards, and seen shops quite empty at times because the demand far exceeds the supply, at least for some items.

    I was surprised to see so many empty shelves, especially a lack of toilet paper, early in the pandemic. A very strange time for me.

    20200314_163948(1)

    In line with that, I remember coming out of volleyball practice one night and going to the store to get things for the next day, only to find it closed. All stores were closed around 8 or 9pm. Quite an experience for me.

    Perhaps one really strange thing for me was a lot of time with horses. Not just around them, as that’s normal, but on them. I never look to ride very often, but I will if my wife asks. We plan some trips, but around the house I’m usually busy or traveling myself.

    In 2020, I ended up taking more rides with my wife around our property and the local area because there wasn’t much else to do. No distractions, nothing open, no work trips, so I spent a lot of time on horseback.

    Well, not a lot, but a lot for me.

    20200814_153603

    Overall the pandemic was not that hard for me. In some ways, it was enjoyable as life slowed down, more time with family, I had all my kids some again for a period of time, and I used all my vacation.

    Maybe that was the best part. Usually work gets in the way of too many personal trips, but in I managed to get out, camp and travel a bit, using up all my vacation with family.

  • Getting Started with TeslaMate

    This is part of a series that covers my experience with a Tesla Model Y.

    One of the things that a Tesla car does is make a lot of data available. From the mobile app I can not only control the car, but I get see where it is an how fast it’s going. There is more, but it’s a neat idea that I saw lightly implemented in my BMW X5, but in a very crude, 2000-era way.

    Tesla is gathering a lot of data, and they’ve made it available to owners. You can log in with your Tesla account and get access to data. In fact, quite a few people are offering services, like StatsTezlab, and TeslaFi. I tried a couple, but really I didn’t like the idea of my data flowing out to third party services. There’s already been a hack with one.

    Then I found TeslaMate, a project that a Tesla owner built, allowing you to run your own service, capture data in a PostgreSQL database, and run your own dashboards in Grafana. There’s a lot of setup here, but I decided to run it in Docker, which was easier. My plan is to move this to the cloud at some point, but for now it’s on my home machine.

    This is what I did.

    Setup

    I have Docker Desktop running, so pulling the container down was easy enough to do. Then the instructions have you set up a docker-compose file. If you’ve never done this, it’s basically a YAML description of the containers and options you want to run. In this case, I’m configuring four containers: the teslamate service, the mosquito message broker, the granada site,  and one for postgres.

    I set up a folder on my machine and put the docker file inside of it. I changed the config with my own passwords and left the port alone. I left the volumes along, which was a bit of a pain as I had to track down the location for the data to back it up. Not hard, but a pain.

    I then downloaded the Tesla Tokens app, which allows me to see the tokens that the Tesla website will return to me when I log in. This took a little googling around the Internet to figure out, but once you have this, then your container can log into your account and access data.

    Then I built a CMD file, which looks like this:

    2022-02-12 13_53_02-teslamatestart.cmd - sqlsatwebsite - Visual Studio Code

    I set this up in the Task Scheduler to run whenever the machine boots. This ensures that if I restart, my containers are running. Overall, this ensures I get most data.

    Once I had it running, I can connect to port 4000 on my local machine. To make this easier, I set up DNS entries (since I own a domain) that map from a name to 192.168.100.200 (I have a different internal network). This makes it easy to get to the dashboards.

    The View

    Once I had the containers running, I can go into the Overview, and I’ll see things like this:

    2022-02-12 13_38_19-Overview - Grafana — Mozilla Firefox

    I have this list of dashboards:

    2022-02-12 13_55_53-Overview - Grafana — Mozilla Firefox

    Each of these has different sets of data available for me to view. For example, I can geofence my house, and then enter the cost of charging at home. This lets me see my charges:

    2022-02-12 13_56_46-Charges - Grafana — Mozilla Firefox

    I can also see my drives and get an idea of how much it costs me in power to go places. Here’s one of the recent ski trips I wrote about.

    2022-02-12 13_57_35-Drives - Grafana — Mozilla Firefox

    There’s a lot more data to analyze, and most of it I don’t care about, but I do like to see how much power I’m using on average and where I’m going often. It’s not that helpful, but it is interesting. One thing I could have guessed is how temperature affects things, but living in Denver, the most efficient times are the majority of the weather here.

    2022-02-12 14_00_05-Efficiency - Grafana — Mozilla Firefox

    I like the ability to gather my own data, and analyze it. At some point, I want to move the containers into AKS or another cloud service and monitor from there.

    Of course, I back up my data periodically, and need to get an automated system running (I do have BackBlaze). Something for another day.

  • Daily Coping 18 Feb 2022

    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 support a local business with a positive review or friendly message.

    I like supporting local people, and try to do it regularly. Recently we were on vacation in the Colorado mountains, in a place we go often. There are a few restaurants that we visit often, like the Dam Brewery or Dos Locos.

    This time, as we were driving around, I saw a new place, the Eclectic Bar and Grill. I pulled in, thinking to just try a new place.

    It was fantastic, and quiet on a late afternoon. We ended up talking with the manager and praising the menu and food, which was great. I also took time to drop a review on Google. Hopefully they get popular enough to stay in business.

  • SQL Saturday Colorado Springs 2022

    In just over a month, SQL Saturday comes back to Colorado Springs. On Mar 19, SQL Saturday Colorado Springs 2022 is taking place at the local library. This is a chance ot meet in person and see other data platform professionals in the local area.

    If you are in the Denver/Colorado Springs area, please pass the word. Data Professionals, Developers, everyone is welcome that wants to come out to a live event. It’s a one track event, which I find to be a fun type of conference. Everyone sees the same thing, and we have a collective experience.

    I won’t be there, sadly, as I have previous plans to visit my daughter in NY. I’m sad to miss the event, but I hope a lot of you make plans to go and enjoy the chance to get together.