Voice of the DBA

Author: way0utwest

  • Building Helpful Commit Messages

    Using a VCS (Version Control System) is important in any modern software development environment. I still can’t believe that both application and database developers are using a VCS at less than the 95% level, but surveys constantly show this. I’m not sure if this is because of laziness, ignorance, stubbornness, or something else, but it’s a bad idea. Start using a VCS. Talk to your management, and let them know Git is free and can be run on premises, much like a file share for code, except it’s better.  Even if you hand craft scripts (or use the SSMS GUI), just start saving those scripts in a VCS.

    There are lots of tutorials and examples of how to use git (or any VCS), and this is a skill you want to build over time. To start, just learn to build a habit of committing code to the repo as you make changes. This is fairly easy, but there is one skill you need to develop over time: how to write a good commit message.

    When we commit code, we usually need to enter some comment. This is a bit of an art, and should be designed to quickly convey information to the next developer (who may be your own future self). While people may have their own view on what to include, my thought if usually to include the “why” of the commit. This helps me to go back later and understand what I was thinking. I don’t need “what” was changed, because a quick diff of the file will explain that. If possible, I like to relate a commit to a specific request, like a Work Item, a help ticket, or some place that describes the requirements in more detail.

    I ran across a nice post that describes the art of the commit, and I think there are some good ideas here. Certainly being brief and understanding that often your message is a headline is good advice. The most important parts of the post, for me, are the need to understand that I’m working with others, and it’s important that my message help them and vice versa.

    Learning to use a VCS is a critical skill for anyone working in the technology field. We know most application developers need this, and slowly I find more database developers doing the same. However, as we move to GitOps and Configuration and Code, as compliance becomes more impactful with more auditing requirements, as we try to do more with less, the infrastructure staff and others need to learn how to capture their changes in a VCS as well.

    Do yourself a favor and start learning how to use a VCS. Git makes it easy or you can play with Azure DevOps in the cloud. Just start saving some files and building skills. Your career will thank you. Learn to write good commit messages and your team will appreciate you.

    Steve Jones

     

  • Learning More about Kubernetes (K8s)

    I know a bit about this, but I’m always looking for more. I had the chance to see Brendon Burns recently and I was impressed. That is one seriously smart dude. In any case, I saw a link from Microsoft: 50 days from zero to hero with Kubernetes. It’s at this link: aka.ms/learnkubernetes

    I decided to dig in a bit, because it’s a complex subject in some sense and going through some resources can help solidify how this works.

    Day 1

    It’s a children’s story of a visit to a zoo, with an attempt to explain what pods, replica sets and other items. The first few items made sense to me since I’d worked with K8s slightly before.

    However, as the story delved into more complex subjects, like Ingresses and Daemon Sets, I had a vague idea of what ese were, but not really. I’m not sure I could explain back what some of these do. I hope future days will help me understand.

    Day 2

    Day 2 is a video on Containers from Brendon Burns. He talks about the history of VMs and then lightly on what a container is and how this fits together. Since I’ve watched some of Nigel Poulton’s courses at Pluralsight, this makes sense and reinforces what I know. It also gives me another way to explain things.

    However, for others, I wonder if this makes sense to them. It’s a very high level, but fast view of containers. Worth watching if you want to know more.

    I’ll continue on with the series as I get time, likely a very sporadic look at this technology.

  • More Linux than Windows

    Not for me. I definitely have more Windows running than Linux. Well, at least if you count minutes. If we’re counting instances of kernels, there might be times I have more running with Linux kernels in containers. However, on most days I have 1 or 2 Linux systems running and 3-4 Windows ones.
    That’s not the case in Azure, where the majority of instances are on Linux, not Windows. Microsoft announced this recently, noting that the use of Linux is growing for them. If you follow their work in the development area, this isn’t surprising. They are doing more and more OSS integration with their products or with other work. We have VS Code and Azure Data Studio, as well as .NET Core, running on Linux.
    We’ve had PowerShell on the Windows platform for over a decade. In that time, it has improved and grown, and become a default way for many people to manage their systems at scale, or certainly, in a consistent way. I’ve been surprised with how pervasive PowerShell has become. That’s why I’ve been surprised in the last year at //build/ and other conferences when I see Microsoft employees promoting bash as the new thing.
    I have nothing against bash, though I was more a korn shell person in University. I do like working in it at times, and I find myself doing that more and more. What I don’t like is a push away from PowerShell, especially as I’ve just started to get comfortable with -eq and -gt. I hope that as Microsoft moves towards more Linux versions of tools that they continue to keep PoSh as a first class citizen, on all platforms.
    Linux lost the desktop war. I’m pretty sure that’s the case, as I haven’t seen a Linux laptop or desktop in years. I see lots of MacOS, but more Windows, especially with the amazing hardware advances manufacturers have made in the last 4 years with the 2-in-1 format. However, I start to wonder if Linux will win the server war, or at least, become a much larger percentage of the back ends in the next ten years. I think it might, handling .NET and SQL Server loads in many cases.
    Steve Jones

  • Summer Break

    This feels like a strange day in the summer, with a holiday yesterday (Fourth of July) and the weekend starting tonight. This is similar to the Friday after the US Thanksgiving holiday, which is usually a day when very little gets accomplished in most offices. I’ll be a little more productive at home than I would be in an office, but I’ll still have a bit of a holiday lull from yesterday and a weekend coming up. Actually, maybe I’ll get plenty done since I’m sure my body is tired after working on driveway maintenance and (hopefully) rebuilding a trailer hub. (If you haven’t guessed, I’m writing this before the break)

    It’s the start of the second half of the year and a time when many people take holidays. Schools are usually on break, so families often look to travel somewhere. Some of us might take a staycation, catching up on projects at home. I know I’ll be doing that a bit this summer as a busy first half of the year has me way behind on a number of maintenance items and projects.

    We all need a break, so this week I’m asking you what things you might do this summer with friends and family that provide a welcome distraction from work. I’m assuming you’ll have some time off, even if it’s just a weekend, so share a fun event or activity you’re looking forward to enjoying.

    With my kids getting older, we rarely get together. Even on some of the smaller holidays, my son won’t come home from university. If we do get together, it’s often just a meal, though we did have a fun afternoon of bocce after my daughter’s graduation from high school. Maybe we’ll get out this weekend and do that again.

    My wife, kids, and I love music. Some of us play instruments, some of us sing, but we enjoy hearing music all the time. We also enjoy movies, and last year my family when to see Bohemian Rhapsody, which was amazing. The music is great and I recommend this entertaining and enjoyable film. We also saw Rocketman recently, a good, but sad film for me to watch. Perhaps we’ll all go see Yesterday this weekend since we enjoy the music of The Beatles. We’ve been Marvel fans, so I’m sure Spider-Man is on our agenda. This particular reboot is my favorite so far, so that’s a possibility as well. We might have a bit of a debate on which to go see or just go see both.

    I’ve gotten away from most sporting events and live concerts at event centers due to the time commitments (and cost). These days my wife and I may go see a local musician or a comedy act, but more often than not a movie (at home or out) is a way we escape from some of the pressures of life.

    Hopefully you have something you’re looking forward to, so let us know today how you’ll brighten up your summer months.

    Steve Jones

    Listen to the podcast at Libsyn