Voice of the DBA

Tag: career

  • Goal Progress–Jan 2021

    I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2021.

    As I look at goal progress for 2021, I’m going to follow a similar pattern as last year. I’ll give myself a current grade and report on overall progress in of the areas where I set goals.

    Current Grade: C

    I think I’m making some progress, but perhaps not as much as I’d like. I started this post last week, but with Redgate buying the PASS assets, this week has been almost a loss for anything work or career related.

    Reading

    The goal was 4 books (3 non-fiction, 1 tech). Here’s the current progress:

    Technical Skills

    I’m solving the Advent of Code three times.  I’m also studying for certification.

    • Certification –  AZ-900 – 0%
    • Certification – DP-200 – 0%
    • Skills – T-SQL – 2020 Advent of Code – 4/25
    • Skills – Python – 2020 Advent of Code – 1/25
    • Skills – PowerShell – 2020 Advent of Code – 0/25
    • Skills – TBD

    Projects

    I had a few projects for myself. Most of January was supporting SQL Memorial as well as doing some SQL Saturday/Data Saturday stuff. So far things appear to be working fine.

    • Support events: submitted and approved some PRs.
    • Speak at the 3 local user groups, at least one live presentation
    • Help organize a Denver/Colorado event, live or virtual
    • Complete my Power BI Volleyball report – I know lots of kids will use this, so I need to get it done – 20%
    • SQL Memorial – 80% – This is mostly done, but working on some networking changes. I also need to move the repo out of my personal account, but this also entails pipeline changes, possibly security issues with hosting, etc.

  • Career Goals for 2021

    I’m a couple weeks late, but not nearly as late as 2020. In any case, I’m going to break these down as I did last year, but hopefully with a bit more focus. After a quick review last week, I am hoping I can do a better job in 2021.

    The areas I want to focus on for my career are slightly different from last year, but still in a few areas.

    • Reading
    • Technical skills
    • Projects

    I am going to go back to a monthly check-in, with a reminder in the calendar, to review the progress I’ve made, and hopefully help me keep slightly more focused. I used Outlook to set this as the last Friday of the month, ending on 31 Dec 2021.

    2021-01-04 13_54_25-Goal Progress Update - Appointment Series

    The details of each section are listed below. I’ve tried to be slightly detailed, but not so detailed that I don’t feel I have any flexibility.

    Reading

    I love to read. I’ve read over a 100 books some years, finishing 2020 with 82. I like the focus on longer reads in books, getting caught up in a topic, and I think this helps me to view the world differently.

    For my career, I need to read some semi-technical or business focused books. Last year I aimed for technical (meaning code related) and non-technical (but non-fiction) books. I am going to do something similar this year, but also the realization slightly.

    Goals:

    • 3 non-fiction, career related books
    • 1 technical book

    I’d like to do something technical, and work through some project in a book, so I’ll continue to do this. I realize that 1/quarter is probably plenty. For now, I’ll leave a template here for my updates:

    Technical Skills

    One thing that I’ve regretted slightly across the last year is that I didn’t focus on improving my career in a tangible way. Specifically, I need more Azure knowledge. I dabbled here and there, and could make things work, but not in a measured, focused way. I saw a few people work on certification, and I’ve regretted not going through some of the courses and work in the past.

    I do want to go through some of the Azure certification paths, which have changed. Microsoft has changed many of the options, but there are some data ones, and I certainly would like to round out some of my Azure knowledge in new ways.

    I also want to build more skills in these areas:

    • T-SQL
    • Python
    • PowerShell

    I find these to be the most relevant for my work, and I think these are areas that I use often. As a result, I have a couple of options here for the items that will grow my career. Here are my initial thoughts in a template:

    • Certification –  AZ-900 – 0%
    • Certification – DP-200 – 0%
    • Skills – T-SQL – 2020 Advent of Code – 4/25
    • Skills – Python – 2020 Advent of Code – 0/25
    • Skills – PowerShell – 2020 Advent of Code – 0/25
    • Skills – TBD

    The Advent of Code is a good, and fun, way to exercise my skills and mind. I usually find 5-6 are easy and the rest challenging, so I’m going to try and work through these across the year. Already I find that when I start in Dec, that weekends and time with family get in the way, so I’m expanding these through the year.

    I don’t know I’ve measuring improvement here well, but if I compete the skills test, that’s good.

    I’m sure I’ll add something else, but this is a good start.

    Projects

    Building something is good practice for a career project, and it’s good documentation. I think that a few of my ideas have been more fun in the past, so I’m going to focus on more tangible items.

    I want to do more community work, especially with PASS failing, so I’m going to aim here, especially in the local community. I also want to continue with a technical project of some sort, and certainly share some data.

    With that in mind, here are a few items.

    • Support DataSaturdays (or whatever the data platform one day event thing is)
      • Added 3 events manually in 2021
    • Speak at the 3 local user groups, at least one live presentation
    • Help organize a Denver/Colorado event, live or virtual
    • Complete my Power BI Volleyball report – I know lots of kids will use this, so I need to get it done – 20%
    • ?? – TBD

  • Goal Progress–Wrapping up 2020

    This is the final look at my goals for 2020 and how I did. I am writing this a few days after the end of the year, and examining what I accomplished for myself.

    Rating for the year: C

    Details below, but really, I let the pandemic get me down, I didn’t focus, and I took lots of opportunities to get away from work and technical topics when I could.

    That being said, I didn’t take advantage of the lack of travel to focus more on myself. I could have improved more skills in a focused way, especially around my goals. I also think that my goals were more of the “this would be fun” nature than carefully tailored around my career and the things that are helpful.

    In short, I don’t think I thought enough about myself and where I am in my life when I started planning 2020, thinking about the practical aspects of moving my career forward, but in an evolutionary, not revolutionary way.

    I’ll have to do better next year trying to set and work on goals.

    Reading Goals

    Here were my goals for the year.

    • 3 technical books
    • 2 non-technical books – done

    Books I’ve tackled:

    I didn’t finish one technical book. I had a few ones I was looking at, but never really dug into any of them. They were easy to put off, with my constantly citing current work and the pandemic. To be fair, I did also read 70+ fiction books, which helped me cope with the year.

    All in all, I am happy with my reading progress here, getting away from fun fiction or literature and doing some reading in areas that will help my career.

    Project Goals

    Here were my project goals, working with software

    • A Power BI report that updates from a database – 30%
    • A mobile app reading data from somewhere
    • A website that showcases changes and data from a database – 20%

    I did manage to get Power BI hooked to a database, and some minor visuals, but nothing like I wanted.

    I did build a few websites, using data from a database, but as static sites. It was simpler to just get things working like this, and I was worried about costs and value. The whole PASS failing thing also threw me at the end of the year when I anted to focus more on goals.

    Nothing done on the mobile app. I think this was an aspirational goal at the beginning of the year, a chance to just try something, and I never took the chance.

  • What Skills Will Help Me?

    Yesterday I wrote a little about skills from the corporate side of your career. What is important, valuable, and helpful to your organization. Today, as we close down 2020, I want to look a little at the skills that will help your career, whether at this organization or another one.

    When I speak with people about their career path, I often hear them speculating on which technologies will be hot, which ones will ensure a long and financially rewarding career. The answer isn’t the same for everyone, and I’m not sure there is any technology that’s can guarantee it will boost your career, but I do have a few thoughts.

    First, you will want to evaluate yourself and understand your skills. How skilled are you at T-SQL or SSIS or security or anything else. Write down skills, evaluate yourself, and also evaluate if you like doing that work. I know when I’ve done this, I sometimes realize I’m doing things I don’t enjoy far too often.

    Next, get some goals about the type of work or employer you are dreaming about. Ask friends about their workplaces, look at job postings, and network with others about the work they do. Be sure to check Glassdoor or other ratings services, as no one wants to go work for an employer everyone dislikes.

    To grow your own skills, I know most people want specifics, so here are some. For development skills, go through the Advent of Code or Exercism and show that you can solve problems. Don’t look at the answers, and don’t look at anyone else’s solution until you have one. Write down how and why you solved something, save it in Github, and blog about it. Whether you share this or not, it’s good practice for you.

    For development or admin skills, learn about DevOps, Continuous Integration, and Continuous Delivery. To do this, you’ll need to learn some scripting and various other organizational skills. Tackle a sample project, and learn to implement it, ensuring you can deploy code to one other machine using these principles. This promotes lots of good, core software development skills that anyone wants. You can use the cloud or not, but many things are not that different in the cloud, conceptually. The syntax varies, but a lot of what you learn can be reused.

    Lastly, work on your soft skills. I recommend blogging, but learn to make a presentation to a friend, at a user group, or even to your dog. Record yourself if you do the latter, and ensure you can concisely and clearly explain concepts. Learn to respect others, listen more than you speak, and critically evaluate ideas, code, and thoughts, without attacking or complaining to others.

    Ask lots of questions of others, in forums or live. Learn to learn, learn to share, and learn to improve your code or admin practices. Refactor things periodically and improve them. These are the ways in which you can grow your talents. You can do this at work, or at home. And if someone doesn’t want to use your refactored code at work, that’s fine. You know when you’ve written something better, and it gives you stories and content for interviews. It isn’t time wasted, as learning to do something better is always good for your growth.

    Steve Jones

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