Voice of the DBA

Author: way0utwest

  • Tough Interview Questions

    Many of us know that interviewing someone and evaluating their skills is a tough job. There have been all sorts of techniques tried by various companies, some of which require creativity, but many are related to technology and practical skills. All in all, I’m not sure any of these really predict if someone will be a valuable employee.

    I’ve seen a lot of senior technology people lament the quality of the candidates they interview. I suspect some of this is that most of the really talented people aren’t out there interviewing regularly. Instead, there are many people applying for jobs, some with narrow sets of experience that might not match what you are looking for. Some may be applying for jobs that are beyond their skills, hoping to get through an interview and get an offer. Maybe others rub the interviewer the wrong way, and create a negative impression that doesn’t represent how the person might work with others.

    I ran across an article that listed a number of SQL Server interview questions, most of which are aimed at experienced developers. It’s not a long list, but it does cover some topics that aren’t necessarily things that you use often in SQL Server. While I have written an INSTEAD OF trigger, I haven’t often and might not give a great answer for someone that is looking for deep knowledge. I would like to think I can give a decent explanation of what this is and where you might use it.

    Perhaps that’s the intent, however, to see if an experienced person has touched a lot of different features in SQL Server. Maybe this is a breadth more than a depth list? I’m curious if you think that is the case. Maybe you have an opinion you’d like to share on these, or other questions, which might help you determine the experience of a candidate.

    Finding a great candidate for your organization is hard. It doesn’t matter if you are looking for junior people that can grow, or senior ones to lead. Often interviews result in an impression that is a bit of a coin flip. After a year ,you may or may not feel that you made the right decision.

    Steve Jones

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

  • Daily Coping 5 Feb 2021

    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 write down hopes or plans for the future.

    I sure hope the world gets to a more normal place. In the meantime, I can just dream.

    Recently I was reading Brent Ozar’s Epic Life Quest.  I hadn’t followed this for awhile, so it was nice to catch up and see how things are progressing. Especially with his move to Iceland. It got me thinking about things I want to do. I used to keep a “life list”, but I stopped at some point. My wife and I have both been talking about redoing our lists.

    Here are a few items for my future dreams:

    • Return to New Zealand and hike Milford Sound
    • Hike Machu Piccu – if it opens again
    • Visit Japan and tour around
    • Build a cabinet for the house that my wife allows me to hang
    • Build a cabin of some sort by hand
    • Work for a charity full time

    Hopefully I’ll accomplish a few of these in the coming years.

  • Do it. Try it. Fix it.

    “Do it. Try it. Fix it.” – Sam Walton

    That quote is interesting, and while I don’t think Sam Walton was thinking about software, this is the loop that I, and many others, follow. We see a problem, and we try some things. If they work, we move on, if not, we fix things.  At least, that’s the approach most of us would like to take when we see an issue. Sometimes management gets in the way of us following a simple process.

    The key part of that quote is the first part, the part Sam Walton talked about was acting in some way. Doing something, making a positive move towards improving something. Many of us want to take action, especially when we see a problem. Again, however, management can get in the way if the problem isn’t prioritized.

    There’s one part in DevOps and software development that comes after the “fix it.”. We need to ensure we don’t repeat that type of mistake. This means that when we find a solution, especially a better pattern of building something, we share it. We use the feedback loops and learning ideas in DevOps to ensure others in our organization don’t need to do their own “Do it. Try it, Fix it” loop and repeat our work.

    One of the hardest things to convince smart (or very busy) developers to do is change their work habits and patterns to implement something new. While it can slow things down, or create other work, in the long, or even medium term, we can all be more productive if we take the time to share what we’ve learned. We also need to take the time to learn what others share.

    Of course, proving your way is better can be a challenge. You need to be sure of yourself, gather evidence, and learn to present a convincing reason why someone else should change. If you can do that, you will have more success.

    Steve Jones

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

  • Daily Coping 4 Feb 2021

    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 ask other people about things they’ve enjoyed recently.

    It seems like I’m stuck in a loop of the same thing every week. I to get to see some people with coaching and volleyball, but it’s just a few people, and things repeat.

    Recently I went with a friend skiing for a day. We’ve both been working from home, with fairly minimal contact outside of family. So we decided to drive up together and enjoy a day together.

    The drive was good, but I really enjoyed our chats, about life, kids, etc. Hearing how they’ve coped with some of the pandemic changes and what they’re doing was good and gave me perspective on how to better cope myself, as well as appreciate the things going well for me.