Category: Editorial

  • The Challenges of Changing Software Tools

    Years ago I set up an email account for my son using Gmail, periodically forwarding things I thought he might find interesting. One day I was with him at his PC and asked if he’d seen something from me. He said he hadn’t and opened his mail. He had dozens of emails, many of them marketing. I asked him why he didn’t delete some of the obvious marketing ones that he didn’t care about. He pointed to the sidebar, where the usage of his account was listed. It showed a few percent of the 10GB he was assigned in use. He said if the usage got too high, he would. For now, he would rely on search to find things.

    That was fascinating to me. I’d grown up with limited space, used folders for organization, and pruned out anything old or useless. It was an eye-opening conversation to me on the difference in how generations looked at computing. That same thing is happening on a larger scale. As this piece shows, newer generations are approaching the way they use computers in a completely new way. They don’t even necessarily know how to find items on their computer by browsing, which is strange for older users. It’s a trend that vendors embrace. In Windows, Microsoft surfaces “Documents”, “Pictures”, “Music”, etc., and I find many people have no idea where those folders actually are in the file system.

    I used to worry that we were losing skills that were needed. However, now I’m not so sure. The scale of items we might save has grown. In many ways, why would we care where they are on a system. Really, we need a way to access them, and linkages, search, and other techniques might be better than relying on our memories of how we’ve filed things. As I think about it, many of the problems of deploying software over the years have been because of incorrect paths. Why should developers manage that? Why don’t projects and compilers just sort this out for us? How many times have I had to add an entry to my PATH variable? Shouldn’t executable software solve that for me?

    Certainly someone needs to care about locations and security and various other details, but for most people using a system, these are unnecessary details. I don’t know “where” stored procedures or functions reside. SQL Server ensures they exist somewhere and the various Object Explorers in tools put them in a place I can find.

    I embrace these types of changes and encourage our industry to make installing and using software, as well as the management of files and other items easier and more autonomous.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher, Spotify, or iTunes.

  • Republish: IoT Pros and Cons

    I’m at SQL Bits today, the last day of the conference. I need to write an update to this one, but you can re-read IoT Pros and Cons for now.

  • Republish: The (Former) Complexity of PowerShell

    I’m at SQL Bits today, teaching a pre-con with Grant, so I’m republishing The (Former) Complexity of PowerShell

  • Using Technology for Health

    I’ve been fairly healthy and fit for most of my life. While I’ve always had a few extra pounds, I do try to eat better than average and I exercise regularly. That didn’t stop age and some pandemic laxity from catching up with me. My annual checkup last December had my doctor (and me) slightly concerned about a few things. I made a goal of exercise for January and better eating in 2022.

    I thought about how I’ve used technology to help me with this after reading Robert Cain’s post on his efforts to get more healthy. Robert is a friend and I enjoy seeing him at various events. I’m looking forward to our next meeting and seeing the changes in person.

    He uses an Apple Watch and his iPhone, as well as a few devices to measure and track different aspects of his health. He can review his progress towards goals and export data for his physician. The post provides some recommendations and explanations of how technology helps. I found it interesting, as well as a contrast to what I do.

    Technology is more of a substitute for my memory, giving me a view into how I work on my health and fitness with a light touch. I don’t track food, but I have been on a fairly limited diet, which means I have a rough idea of what I consume and the calories involved. I don’t track hydration, but I started to fill 4 water bottles, about 120oz, and empty them each day. I use my watch to log exercise and heart, but I mostly glance to see if I am working hard enough and if my long-term trend for heart rate changes. I do track my weight, but I step on a scale every day or two and record the value in an app.

    It’s common for people working at desks, especially in technology, to lead a less than healthy lifestyle. While I go to the gym often, my wife is probably healthier because she works outside and is active most every day. Technology can help some of us improve our health. The gamification and community aspects of technology apps definitely change how we may approach the challenge. Various devices also lower the effort of data entry.

    If you are looking to improve your health, or you struggle with making changes in diet or exercise, read Robert’s post and think about harnessing some of the power of tech devices to help you improve your life. If you do use some technology, write about it and maybe you’ll inspire others.

    As for my goals? From Jan 4 to Mar 2, I exercised on 48 different days. Not every day, but good enough for me. I have lost about 15 pounds and my long-term resting heart rate has dipped below 50bpm. Technology didn’t really make this happen, but it helped, and I am glad that I can easily see some incremental progress, which isn’t always apparent when I rely on my memory of what my stats were a month ago.

    Steve Jones