Author: way0utwest

  • The Backlog

    Software development is complex these days. Maybe it’s always been complex, but the shorter timelines and greater vision of what is currently happening in development teams mean that we can see a lot is going on at any particular time. Really, once you get beyond a handful of developers, the coding changes look like a chaotic ballet that may (or may not) be in sync across developers. Modern work tracking tools make this easier, and for any particular developer, it isn’t too hard to look at a Kanban board linked to a git repository and track the changes that have taken place.

    There is always more work to tackle than can be done at the current moment, so it is important to add new tasks to a backlog. Building those, and tracking what is needed, is a bit of an art. What do you write down, how much detail, and what level of effort is needed. Paul Andrew wrote a good post on what makes a good backlog story, using an example from his work. He looks at the need for infrastructure in this case, but that would be a common request these days when DevOps and the cloud require some blurring of the line between code and the resources it runs on.

    I like the completeness of this request, and I do think this level of detail is important, with the inclusion of criteria to measure the work and test that it is done. I just don’t know if this is required when we add the work to a backlog. The rapid changes in our software, as we adapt and work with customers’ feedback, mean that we might get many more ideas (or issues) than we ever build. In fact, some requests/suggestions/desires that get sent to developers or project managers might be no longer needed or forgotten by the time they reach the coding stage. I know I’ve certainly requested some features at SQL Server Central that I later decide aren’t important or needed.

    My view is that ideas ought to be captured, and triage ought to include enough detail to estimate how important and hard the work may be. Once we get to the point of actually performing work, then we need to flesh out details on what constitutes done and what tests can verify this. For very small levels of work, this might be just a few light tests, but even noting that a new column is in a table and associated stored procedures can help developers remember to check for dependencies and avoid simple mistakes.

    Building software and managing the process across a team and over time is hard. It is easy to lose control, and it can be hard to make decisions about what to build and what to defer. A backlog is critical, and managing that backlog with regular review and attention to detail is important. However, just as we don’t necessarily want to prematurely optimize code, I also don’t know that we need to build out the complete story when someone has a request. Grow your stories as you grow you code with an agile approach over time.

    Steve Jones

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

  • Daily Coping 8 Apr 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 think of two people you know for the next 10 seconds, and think to yourself “I wish for that person to be happy.”

    TJay Belt posted this recently and I thought it was a nice coping tip in life for me.

    So, I sent my wishes out for 10 seconds to TJay and my nephew to be happy. TJay has a great life, and I see him smile often, so might not have needed this, but he certainly makes me smile.

    My newphew is in a gap year after high school, working, doing some traveling, and I wish that he is happy and enjoying his life.

  • Speaking at SQL Saturday Jacksonville 2022

    SQL Saturday is coming back to Jacksonville this May. I’m excited to go as I’ve like the city, but I’ve never been to this particular SQL Saturday. On May 14, 2022, I’ll be in town for the first live SQL Saturday of 2022.

    I’m delivering a couple sessions on DevOps topics, but there is quite a spread of OLTP and BI topics listed. Some impressive speakers are coming, and I’m looking forward to seeing a few sessions. I’m also looking forward to catching up with John Sterrett and Jay Falck, who I haven’t seen in some time.

    There are some pre-con sessions available for all day training on Friday, May 13. If you are missing the chance to learn in a live environment and not online, check those out.

    You can get more details at: https://sqlsaturday.com/jax and register today.

    Come join us as we get back to in-person events, learn a few things, and network with other data professionals in the north Florida area.

  • Daily Coping 7 Apr 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 discover joy in the simple things in life.

    I work in tech, like many of you that read this. We use various tools to do our jobs, some of which we appreciate and enjoy. Some are innovative, and certainly some of us are blessed with more resources and access to things.

    When I saw this tip, I thought of a few simple things that I enjoy.

    I have a few wireless chargers: one on my desk, one on my nightstand, and one in the Tesla. I think it’s amazing I can drop my phone onto a surface and it charges. That’s one little tech thing that makes me smile on a regular basis.

    My office gets chilly at times. I’m near the garage and dog door, and at times I get a bit of a draft. I can wear more clothes, but I got a chair massager/heater, and I use the heat often on cold days. It reminds me of the seat heaters in the cars, which I also enjoy often.

    The last thing I enjoy regularly is having a wireless mouse. I had to use my kid’s laptop to do something recently and noticed he had a plugged in mouse. I have a wireless one on my desk, and I carry one when I travel. Batteries seem to last for years, and the convenience of moving it around, the smooth optical tracking, and lack of a wire getting in the way bring me joy every day.

    Bonus, I have a custom mouse mat with pictures of my kids. I love that as well.