Voice of the DBA

Category: Editorial

  • Taking Stock of Your Career

    Yesterday was Thanksgiving in the US, a day where families typically celebrate together and many people give thanks for what is going well in their lives. It’s also one of the days when more businesses and services are closed than any other day of the year.

    This is the time of year when most businesses look forward and plan the future. It’s also a time when lots of individuals may do the same thing, getting ready to make resolutions or attempt to change their lives in the new year.

    Today, I want to do something a little different. Rather than taking stock of your career and looking forward, let’s look back and find gratitude.

    Is there a situation, a person, a job that you were grateful for that helped your career for the better? Who would you thank? What helped you become the person you are today? It doesn’t matter if you are an older professional like me or someone starting your career. What are you grateful for in your past to put you where you are today?

    For me, there are lots of things to choose from. I’ve been very blessed and lucky. I’ve worked hard to take advantage of opportunities, but things have worked out well. There are a few things that stand out in my mind.

    First, I got a job interning at a nuclear power plant while in graduate school. That job changed my life. Someone recognized my value and gave me a chance to program, to learn how to run a network, and helped me learn SQL Server (on OS/2). I also met my wife there, so perhaps that’s the situation I’m most grateful for in my life.

    The other situation was the job that moved me to Denver. It allowed my family to change locations and my kids to grow up in a wonderful place. The job wasn’t great, long hours, and I slept in my office far too many nights, but I learned how not to do a lot of things. From poor management, poor software processes, and bad operations practices. It was a tough period of growth that I still value today.

    What are you thankful for in your career? Let us know in the discussion today.

    Steve Jones

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

  • A Strange AI Achievement

    We are seeing AI and ML becoming used in more and more industries, but one that seems to be a place where it is embraced with some success. From speech recognition and transcription to analyzing imaging, computers have helped medical professionals improve the care they give to patients.

    Just as CAD has helped manufacturers, AI systems are being used in medical research, trying to model and screen medications to try and determine which ones are potentially useful in treating various diseases. We also have used them to better tailor treatments for certain diseases, like some cancers. It seems that applying computing against vast troves of data is proving itself beneficial.

    What if an AI were able to develop something new and it were awarded the Nobel Prize? That’s the premise in a scenario published in the Economist. The article opens with the controversy of how the guidelines for the prize are interpreted, paving the way to award the prize to the AI. Perhaps even more interesting in the scenario is that the effort is the result of a poor software upgrade that allowed the AI to read more medical papers that it was previous given access to examine.

    It’s an interesting idea. Who gets the credit? Certainly, the humans that help train the model and put it to work deserve some credit, but they are really the assistants. If they were to use the prize for more research, do we think they could replicate the innovation? Maybe it doesn’t matter. Not many people win the Nobel prize twice. Perhaps using the prize to continue allowing the AI to conduct research would make the most sense, though I don’t know if the humans around the system would accept that.

    I don’t think AI systems are more intelligent than humans, but they can consider and try more possibilities than humans, given enough data. They might notice something that we’d miss, and they can remain more focused on a problem than we can. After all, we need to rest and care for our bodies.

    I don’t know if this will happen in the 2030s, as the scenario imagines, but I do think this is a possibility as we start to use computing to search for new innovations in research. I just hope that as these discoveries take place, they are used to better the entire world, and not just enrich a few humans.

    Steve Jones

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

  • The Complexity of Modern Systems

    I am a big advocate of version control and testing for your software. The main reason is that modern systems are incredibly complex, and capturing what has been done (and what is happening), along with looking for potential issues, is important. It might be critical for ensuring you have success in building software.

    Part of the reason is this post on software complexity. Now I don’t think the complexity is killing software developers. I do think it adds to developers’ stress, and in poorly managed environments, the complexity makes for a poor job experience for many.  While I do think most people are smart, and they find ways to overcome this, they just don’t enjoy the process.

    This is part of the reason, IMHO, that we are starting to see lots of people move to a new role, often in a new company. With remote work, there are more options, and for people with talent, they can easily leave. My recent job searches seem to show more remote job options and more demand for mid and senior level people. I think some of this is looking to get better talent in your company, and some are because experienced people are tired of poor work environments and poor code.

    Modern software is big, and I don’t think any system of consequence is built by individuals anymore. There are still good projects and applications being built by a person, but once they start to grow, a team of developers is needed. This means that we have to learn how to better work together. We need to adhere to standards. We need to communicate and collaborate both in code as developers and together as humans.

    While someone may understand how the entire system works, it’s unlikely that many of our staff does. If the system is large, it’s unlikely anyone completely understands, and then our ability to function as a team is incredibly important to be sure that we are building something that works well together.

    To me, the complexity of modern systems emphasizes the need for teamwork and collaboration, the thing that many companies adopting DevOps struggle to emphasize.

    Steve Jones

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

  • Where is the Puck Going?

    During the PASS Data Community Summit last week, Brent Ozar delivered the day 3 keynote, and it was great. I really enjoyed the format and topic, and I look forward to how someone else might be creative next year with the time. I’d certainly love to do the keynote, though not sure I’d be eligible. I’m hoping a few others get interested and compete for the slot in 2022.

    One of the things Brent mentioned was about looking for skills to focus on, primarily for “builder,” or those that develop new applications. He used a quote from Wayne Gretzky: “I skate to where the puck is going to be, not where it has been.” The reference is to pick things that will be relevant in the future (where the puck will be), not where things are today.

    Lots of people ask questions and wonder about this when we look at technology. What should I learn? Where is my best investment for the next ten or twenty years? There also is plenty of fear that you might learn to be an expert in something like Notification Services (dead after 2005) or Database Mirroring (deprecated in 2012). The other day I heard a few people say “graph is dead” in SQL Server, and I might agree. The features exist, but are they really growing and improving enough to compete with a graph platform? I’d argue no.

    I don’t have a crystal ball to tell you what will be popular. I have a magic 8 ball, but that’s less helpful. Here are a few things I’d suggest to help you think about this. Please, if you have specific questions, engage in the discussion, and I or someone else can try to help.

    First, the ability to work in a team is important. The skills to communicate well, debate a point, and collaborate in how you work are important. Not critical because plenty of people can get by without these skills, but when we look to hire new people, often we want to bond. If I find 10 qualified candidates and get along well with 2 in an interview, I’m likely picking one of the two. Learn to speak in small groups, summarize your thoughts, advocate your position, and appreciate others’ views. Also learn to accept defeat gracefully when things don’t go your way.

    Second, learn more about the choices your employer has made. Brent mentioned this a bit, but honestly, if your employer is focused on SQL Server on premises or in a VM, learn to run that well. Learn more about how it works and how to solve problems or tune it. If they want to use AWS RDS or Azure SQL Database, focus on those. Spend spare time, or quiet time at work, becoming more proficient with the platform. Read about it and practice on it. It will help you enjoy your current job, increase promotion and raise chances, and give you some confidence if you do need to change jobs.

    Third, learn to learn. Always be learning, and follow the advice above, or even pick the things that pique your interest. The important thing here is that if you need to pick something up, you want to be comfortable with those skills. How do I search out info on the Internet. Can I find videos or articles to consume and can I take sample code and stat using it? Can I set up new environments? Am I comfortable poking around a cloud portal or digging into a programming API? Maybe most importantly, can I sit through and absorb information from a Pluralsight (or other) course? All good skills.

    Lastly, part of skating to where you want to go is writing a resume/CV that gets you an interview. I’ve given this advice, and Brent did as well. Include keywords on your resume. If you decided to use Snowflake, I’d find a way to mention Synapse and Redshift on my resume. If you are good at Snowflake, you are likely going to be good at Redshift and Synapse. What you aren’t going to be good at is convincing a non-technical, HR person searching for your resume that these are synonyms if they aren’t included in your resume. Maybe you only want Snowflake jobs. That’s fine, decline the interview. Maybe you need a new job, and in that case, don’t limit yourself. Get past the AI or human filters.

    Actively managing your career takes some work and effort, and it takes some knowledge. Improve your skills, but take advice from those of us that have walked the paths. Ensure you represent yourself well, both with your avatar (the resume/CV), and in person for the interview. These won’t ensure you get a job, but they to help increase your chances.

    Steve Jones

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