Voice of the DBA

Category: Editorial

  • Finding Separation During WFH

    Work life isn’t the same for all of us. In fact, as I read through this HN thread, I find that work is more varied than I often consider. I haven’t worked for any of the big tech firms (FAANG or MSFT), but I have worked for companies that had a variety of perks, including food, gyms, childcare, and more. I’ve taken advantage of, and not been interested in, these perks at different times in my life.

    Many of us are working from home (WFH) for the first time in an extended fashion. I’ve been quite fascinated in the differences amongst my co-workers. Most of them love this and are looking forward to the remainder of the year at home. Some don’t like it, and feel trapped. I’ve been WFH for nearly 20 years, but I’ve often been able to change my environment through travel or working in public spaces, which aren’t really a good idea right now, even if possible. So I’m perhaps struggling to cope more than I expected.

    Now that we’re four months in for most of us, I wonder how many people are coping, and maybe more importantly, how are you achieving separation from work in your life? Are you setting work hours or shutting down your work communications? Perhaps you have some other technique?

    I have tended to pop into my office often in the past, most every day, even weekends. The flip side if I often pop out of the office during the week for the gym or to do some personal task. I’ve also started to avoid even going into my office on the weekends, using my laptop if I need to browse the Internet for some knowledge, without opening Slack/Outlook/Twitter/etc. Trying to completely disconnect on the weekends.

    If you are coping, or perhaps not coping, feel free to drop a note in the discussion, give a tip, ask for advice, or just let us know what you like or don’t like about your environment.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • Security for 2FA

    I got a new mobile device recently and despite the restore from backup, I still had to perform quite a few setup chores. Reconnecting various apps to services by logging in was time consuming, but simple. A password manager was useful here, since I have different passwords everywhere. I set that application up first and then proceeded from there.

    The only trouble I really had was with Outlook and mail. I have an IMAP provider for one account and Outlook doesn’t make it easy to figure out where to change the settings for this. The second issue was with my corporate mail, which is secured with a 2FA connection through Duo.

    This is a technology that doesn’t use text, but has an application on devices and pushes a notification to them. I get a push when I log onto corporate assets from my PC, and I have to approve a login from my mobile. This prevents sum of the sim hijacking that can occur, where someone might have access to my SMS messages. It also prevents a lazy guy with Google Messages from getting a code on the same device rather than walking to the other room to get my phone an ensure I have it.

    I had to get help from our admins with the new device, despite having the old device connected and able to approve the connection. I had thought this would work, but there was some issue with Duo. On one hand, maybe this is good that it isn’t simple and I can’t quickly approve a new device, in that it prevents someone from stealing my identity on a cloned device. On the other, in an organization of any size, where mobiles might change constantly, this feels like a time sink.

    This might not be an attack vector to be worried about, but I think it’s better to be safer here than we might need. I do think that good security is worth some hassle. I don’t really complain about having to periodically re-authenicate, the requirement for strong passwords, and I love having 2FA enabled on many services. I hope we continue to find more and stronger methods of protecting individual and corporate data, along with more respect for the rights of humans whose data is being captured and used by most organizations. I also hope that we continue to improve the security options in SQL Server, including adding 2FA.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • Seeing the World Differently with a Coach

    I ran across an article recently that got me to stop and really think about how I proceed through life and who my coaches, confidants, and mentors are in the world. There are a few people I lean on, and while I don’t get the same advice from them as in this piece, I did find this to be a series of things in this post that made me stop and think.

    Leo Widrich is a coach to CEOs, founders, and executives.  Last year he coached 101 people and wrote about a few takeaways. It is an interesting read, and paints many of these executives with feelings, emotions, insecurities, and other frailties that I have. I suspect many others feel the same way in their lives.

    Each of these items made me think a bit, but perhaps the one that had the most impact on me was to think about non-attachment. I think this might be my biggest struggle, to accept difficult situations, and not lash out or get upset, but let the emotions wash over me, experience them, and then let them go. I struggle to do this without some sort of reaction, or most often, overreaction. I have recognized this a few times as I get older and gotten better at experiencing things without a out sized emotional response, but I still have work to do.

    Maybe the best quote for me was at the top: “… people have heard me say that I think it quite reckless and silly for founders and other executives to go through their life and business world (when you can afford it) without a trusted mentor, coach, advisor or therapist.” I actually think this is something most people need, especially those in stressful situations. I don’t know you need to pay a life coach, though a therapist is often a good idea. A good adviser, someone trusted and with your best interests at heart is invaluable as you go through life. I think I have a couple of them, and I’m glad I do.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • Real World DevOps

    One of the more interesting aspects of my job is talking about building software with customers. As I do more of this over time, the discussion have changed from “what is DevOps?” to “how do we get started in DevOps” to “how do we improve our DevOps process?” These days so many customers have bought into some aspects of DevOps that the last one is quite common. There are still a number of companies trying to get started with DevOps in some way, but very few people I speak with have no idea of what DevOps is or how why it can improve your company.

    Of course, I’m not sure there’s a great standard definition of DevOps. I often lean towards Gene Kim’s Three Ways or Microsoft’s broad view of the principles. Ultimately, most of the practical things that I find myself discussing are how to smooth the process of integrating code from developers and getting it transferred to production. Everyone wants this to go smoother, with mistakes caught earlier, and with compliance with whatever internal rules, regulatory mandates, and customer demands exist.

    Grant had an interesting conversation with a few customers recently and wrote a blog about the conversation. There are a few items that resonate with me, and things that I like to emphasize to customers. The experiences from Stuart and Chris are common in any journey to improve your software process.

    People need to test and measure. While testing has gained traction in the application development world, it’s still fairly new to database people. However, as people try to reduce mistakes and problems, often from simple issues, they adopt more testing. They also start to realize that having instrumentation to help measure the impact of changes is important to learn what to test and watch out for.

    Starting small is important as well. While there are many, many commonalities in all my customers, the way they solve these with their teammates, and the order in which they solve them, varies. Even if you were to end up with the same VCS, build process and deployment script as someone else, the journey will be different. The challenges from internal people and processes, the evolution of habits in your team with vary. You need to find your own path.

    So start small, with a few people, let them learn and then teach others. Let them build up knowledge, habits, and skills that others can adopt. That’s how most things work in the world. A few people discover something and then many follow their footsteps. If you want to build a better software process, find someone to start doing it. When they find something that works, the rest of the organization can stand on their shoulders.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.