Voice of the DBA

Tag: career

  • T-SQL Tuesday #189–AI and your Career

    I’m late to the party this month. Taiob Ali has a great invite for a topic that is likely on most people’s minds: AI and your career. I constantly hear people asking about this (well not lately, I’ve been on sabbatical).

    I love the T-SQL Tuesday blog party and hope more people participate. Spread the word, ask others to write, and help promote this on socials.

    AI and My Career

    I’ve been a bit skeptical that AI would really help me. For the last 15-20 months I’ve been using AI in different ways, experimenting with things and seeing where it might be useful. A lot of my use has been in VS Code and Copilot, where I do some coding, and a lot of markdown/HTML management. Across that time I’ve found AI to be more and more useful with reformatting or suggestions completions.

    More importantly, I’ve learned to “see” the hints and suggestions quicker and have AI save me time in little ways. None of the items are big, and it hasn’t built me a big piece of code, but I have found it to be very useful in saving minutes. Saving minutes multiple times a day starts to add up in the week and months.

    My Outlook

    I think AI will help me in my career in two big ways. First, there is the time saving and assistance it gives me that lets me be more productive. I look forward to more agents that can be configured to handle some tasks for me and just get things done. I haven’t been a big Siri/Hey Google person with setting appointments and small tasks, but I can see some of this starting to be more useful over time. I bet I can get some services and agents to do some work for me with natural language that eases my job.

    I also think this GenAI tech (and other AI) will help me learn new skills and techniques. I’ve seen some people talking about using an AI to help them learn and I need to do some experimenting here. I tried to get it to build some web apps for me and it didn’t go as smoothly as I’d like, but I’m anxious to see if I can get it to help me learn how to better code in new ways as well as generate code for me.

    It’s important to be able to judge if the AI is making good decisions, and that requires knowledge. In some cases, I have that knowledge. In others I don’t, but maybe AI can help me learn.

  • Carrots and Sticks

    Often,  we work on projects that might span a significant amount of time. Weeks, months, even years can be devoted to working on one system, or the same system. We may find that our motivation rises and wanes at different times. We get excited and motivated to get things done, and also become discouraged or distracted when challenges arise. Not all of us, or not all the time, but it is hard to maintain a high level of productivity and motivation over time.

    For managers, it can be a challenge to keep a team moving over time and focused on achieving goals. Life gets in the way, people take vacations, staff changes, and other things are all issues that can distract a team. Keeping a team focused and productive can be a challenge for many managers. Perhaps especially challenging when someone hasn’t received enough training on how to manage and motivate others.

    As tech workers, we could be motivated in a few ways. Perhaps there are goals, achievements, or rewards that spur us on to work harder. There could also be penalties or consequences if we don’t get enough done. There is always the threat of termination, but in practice, I see this as a last resort. More likely are subtle punishments such as boring assignments, more on-call work, or perhaps difficulties in getting vacation approved.

    As a worker, do you want more carrots or sticks? Is the possibility of a reward or the threat of punishment a bigger motivator?

    I’d like to say that carrots motivate me more, but as I think about it, I’m not sure. The carrot has to be significant to get me to change how I work. I think the stick also has to be fairly severe to force a change, but I think I’m often more motivated by the negative side of things than the positive. I’m sure that’s somehow from my childhood, but if I’m honest with myself, that’s what gets me moving more quickly. Though if there is too much of a stick, I’m quick to look elsewhere.

    What about you? Carrots or sticks?

    Steve Jones

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

    Note, podcasts are only available for a limited time online.

  • IT Unionization

    I’ve been reading an interesting book that looks at some of the ways that we can better build software in enterprises. One of the side notes in the book is that the tech companies have the funding and the ability to disrupt many other types of businesses, not just technology. Google, Amazon, Microsoft, and others have delved into other types of industries, potentially pushing others out.

    We see Amazon becoming as much a shipping and logistics company as they are a retailer. There was a unionization vote, which passed in 2022. Recently, another one failed. Amazon continues to fight these efforts, trying to prevent workers from collectively negotiating the terms of their employment.

    I’ve wondered in the past if tech workers would ever unionize. In general, we are paid well and have lots of options for work. There has often been no shortage of opportunities for talented workers, though this year is proving tough for our industry. There are lots of people out of work and struggling to find new jobs. While I’m sure some would prefer a union that might better protect them from layoffs, many tech workers are against the idea.

    There is a growing number of tech workers looking to unionize. Inside Google, there is a union for some workers, but not all. That’s unusual, as often all workers in a category are part of a union at a company. To gain employment, you need to join the union.

    I don’t know if I’d want to join a union. I’ve had lots of success and haven’t seen the need, but I do know that I’ve also seen lots of other tech workers pressured and pushed to work long hours, to skip vacations, and other practices that are good for the employer, but not so good for the employee. I’ve seen many people not know how to negotiate with employers, and perhaps a union would benefit most people.

    Would you want to be part of a data professionals’ union? It might give some security and more benefits for many, though not quite as much pay as you might otherwise receive. Maybe more than you get now, as it depends on where you sit in the salary scale at your company. Let me know what you think about unions today.

    Steve Jones

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

    Note, podcasts are only available for a limited time online.

  • Helping Students with a Data Professional Career

    At a recent event, I had a student ask about how to get started as a data professional. What types of things should they do? What platform should they work on or learn? Where should they focus time? What tools are available?

    Those are all good questions and many of you likely have your own advice. I’ll give a few things to think about today, which are good for anyone that might want to get into the data field. I think this is still one of the better technical careers. I’ve suggested this to my kids, though only one of them went into a technical area. One is a therapist for autistic children and one helps run the ranch while pursuing a graduate degree in literature.

    If I were to give someone advice on how to get started in a tech field, I’d likely start with these items: first, download the free SQL Server developer or Express editions. Most of us run Windows and this is a good place to start. Get SSMS, and learn to connect to your server. If you have struggles, ask a question in our forums.

    From there, I’d suggest working through a book on SQL. Or look at our Stairway series on T-SQL (basic, beyond basics, advanced). Learn to work with data and query it. Learn to download and get datasets into a database, as well as how to query, update, and analyze the data. Those are key skills. If you want to manage systems, try setting up an Availability Group, ensure you have backups and can restore systems, and maybe explore replication and CDC.

    If you want to develop applications, then start building something. Ask a GenAI for help, but produce a working system that lets you analyze some data. Pick sports data, or music data, or something else, and produce an application or report that conducts an analysis of the data. Work with something that’s interesting to you.

    While you’re doing this, blog. Write about what you learn. Build a growing resume that showcases your skills. Chat with others online, build a network of people, and always have an up-to-date resume that you can send out to find a job. Your resume/CV and your blog are invaluable.

    That’s my advice. Anything else you suggest?

    Steve Jones

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

    Note, podcasts are only available for a limited time online.