Voice of the DBA

Category: Editorial

  • Remote Data Challenges

    With many of us working remotely now, security is going to be a concern for many organizations. While some might have company provided hardware, many of us will use our personal equipment to connect to data and systems. This brings even more challenges to ensuring security than we’ve had in the past. This might be especially true for organizations that have (or are) scrambling to get everyone connected and ensure access.

    There are a number of areas in which this might affect us as data professionals. First, we should ensure our devices are patched. Windows, OSX, Android, iOS, whatever platform you run, you ought to be properly patched. This might be especially disconcerting for some home users that run older versions of host platforms. This might be especially true for networking stacks, which have grown more secure over time. It is important for most of us, especially when using privileged accounts, to have fully patched devices.

    There’s also the issue of viruses, ransomware, and more transiting from home systems to work platforms. I know some companies are doing lots of work through remote access, but that’s not practical for many of us. I do think the idea of separating out traffic to production systems is a good one, and requiring some sort of remote terminal to a jump box might be preferred. Having some sort of PAW is a good idea as well, though not always easy to set up, especially right now.

    There are still the actual access rights and least privilege principles we want to maintain. Even as people struggle to get work done remotely, opening up all resources to users that want them can be a poor choice in many companies. We want to maintain adherence to good practices while working in an unfamiliar environment.

    There is also the idea of good data protection. This piece talks about DR and data protection, something that many of us data professionals think about regularly. I don’t know if organizations want to add home machines as remote backup targets, but we should certainly ensure that documents, code, and other information is protected. Workstations and laptops are going to fail, as we want to minimize data loss. Having version control for developers and default save locations that are remote are good practices for remote work. I know I keep most of my data in remote git repos, Dropbox or OneNote drives, or some other shared location that will persist if my hardware has issues.

    While many of us try to keep moving forward at work, and our management certainly wants us to do so, we should keep in mind the security and data protection are still important parts of our jobs.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • Choosing Sequences Over Identity

    When I was building software as a full time job, the choices for automatically generating surrogate keys were the identity property and the NEWID() function. At that time, GUIDs were too cumbersome to deal with, and I often used identity values in tables. I looked for natural keys, but often these were secondary keys for me and I preferred to use numerical values in many tables as PKs and FKs.

    In the last few years I’ve run into a few customers that prefer sequences, which are a separate object in your SQL Server database. There are some challenges with sharded systems and using deployment technologies like SQL Compare, which is one reason I’ve avoided them. However, I was reading Dr. Greg Low’s blog recently where he noted that he prefers sequences to identities. He gives a good comparison of the reasons why sequences can be easier to manipulate, with some advantages because these are a separate object. I think he makes a good case why we might always want to consider sequences over identity values in new development.

    He’s convinced me, though now I need to learn a new habit and build new skills to quickly and easily develop sequences for table keys instead of relying on identity values. This is a big change for me, with nearly 30 years of writing identity properties in CREATE TABLE statements.

    Learning to adopt new techniques and changing habits of the ways that we grow and change, and certainly how we build better software. That’s a tenet of DevOps. Experiment and learn. This is a place where I’ll start to grow and see what I think as I build demos and PoCs for customers, giving sequences a chance. I wonder how many of you might rethink using identities in the future as well.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • May the Force Be With You

    I’ve never done much more than give a passing smile when I see all the posts and notes about May 4th from geeks around the world. I was a huge Star Wars fan as a child, and the original is still probably the movie I’ve seen more times than any other. Life has moved on, and while I haven’t been a s big a fan as an adult, being shut in at home has me thinking about Star Wars today, and the good luck saying, “May the force be with you. Always.”

    I loved the original trilogy growing up, was disappointed, but slogged through the prequels with my oldest. I watched the Force Awakens in Cape Canaveral with my middle son in the theater after seeing SpaceX launch and successfully recover their first reusable rocket. We were both a little disappointed in that one, not from the effects and action, but more from the writing, which seemed to drag on.

    Since that time, I haven’t seen any of the other films in the theater. In fact, I’ve watched most of them on an airplane, traveling from one place to another. Since I’m not traveling now, I’m thinking to actually go re-watch some of these films on a larger screen, with better lighting. I’m hoping some immersion in a series of films will take my mind away from some of the stress and strangeness of the real world.

    I’m sure some of you are big fans to this day, some may not have seen all (or any) of the films. Today, as we start another work week, I’m taking a little break from the technical world I’ll spend most of the day in and looking at a fantastic, highly technologically advanced, geeky Star Wars universe. Do you have favorite films or technology? Any films or characters that stand out to you? I have to admit I was always a big fan of the land speeder, though the pod racing in The Phantom Menace was exiting to me.

    On this Star Wars day, with a world we might want to forget, share some Star Wars memories today.

    Steve Jones

     

  • Are You Ready To Change Your Work Environment?

    It’s Friday, it’s been a long few months, and I’m wondering what you think of work now that many of us are telecommuting. This week, I’m wondering if you want to answer one of these questions?

    • If you are telecommuting full time for the first time, do you want to continue doing so?
    • If you are telecommuting full time for the first time, are you ready to go back to an office?
    • If you’ve been working from home for some time, are you ready to go back to an office with people around?
    • Do you just need a variety in your working environment?

    These are questions I’ve asked myself many times across the last few decades. My thoughts and answers have changed a bit over the years, and even now they’re different than they used to be a few months ago. Right now, I want to go back to an office more often than I used to go. I usually go to the Redgate Cambridge office four times a year, and the US offices rarely. I think after this, I’d like to get to each office in the US a couple times a year and four times in Cambridge. I miss talking to live co-workers. I might feel differently when this shut in ends, but I miss having some people around.

    For almost ten years, I drove to an office every day while my wife worked at home. I was jealous, and wanted to telecommute full time, but none of my management would allow it. Then for almost another ten years I worked at home with my wife. She traveled quite often, and I struggled with the loneliness of being by myself. I often went to lunches with friends or sat in a Starbucks and worked, just to have some other people around. The third phase of my work environment has me at home alone often, but also on the road regularly, so I haven’t struggled with the times I’ve been alone in my office for weeks.

    I don’t know how things will move forward from here. I’m sure something will change, and I look forward to societies finding ways to open things up over time. I know we’ll adapt and cope, but I also know that even the most introverted of us is a social creature and we do need some contact with others. Today, I wonder if your views of how we want to work have changed.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.