100 Things I Hate About Views: Undeclared Data Types in Columns
Views let you do dumb things by accident in SQL Server. Then they make you have to think way too hard to fix them.
Read Moreon • 9 min read
You’re a Junior or mid-level Database Administrator with no obvious career path. How do you grow the right skills to level up your DBA career?
Prefer a podcast instead? Find it at kendralittle.com/dear-sql-dba-podcast.
Today I’m answering two questions from listeners on one hot topic: advancing your DBA career when you don’t have a mentor at work, or a clear career progression.
Dear SQL DBA,
There’s so much to know within SQL and as a beginner DBA (1-2 years) that I’m not sure what’s a good starting point to becoming a great DBA. What would you say I should really take time to understand? What would take me to the next level.
and…
Dear SQL DBA,
I’m a junior DBA working in a very large company with very few DBA peers, and no one I can really look up to as a Senior. Luckily Production is pretty well-tuned so my workload isn’t overwhelming, and we have consultants who take care of a lot of monitoring and backup tasks.
Without a Senior DBA to mentor me and bounce ideas off of, I don’t have a good path to master my environment and move up (or on to another company). I regularly read community blogs and all the online video training I can get my hands on, but I’m still worried my skills fall short.
Do you have any suggestions for “leveling up” without a Senior DBA’s guidance?
There are two paths you can take at this point:
Path 1: Level up your career by building projects as work
This first path can get you a decent distance, but I’m not going to talk about it much today, because for many of you I think there is a more exciting and rewarding path to consider.
Path 2: Level up your career by building yourself as a speaker
It’s a choose your own adventure moment, right?
You can follow Path 1, where you build your career through doing projects at work! This can work well, particularly if you make a concerted effort to build your leadership and communication skills along with it.
I have a list of specific steps you can follow to identify the right projects to propose and work on in my post, “What’s the Difference Between a Junior and Senior DBA?”
OK, for the rest of you guys, who are considering it…
I built my career slowly and steadily doing projects at work for years
It can be rewarding, as long as you don’t fall into the trap of overworking yourself to burnout
One problem I realized was that a lot of the knowledge I gained was domain specific
I realized that I needed to start working a healthy number of hours. The hours my employer wanted me to work.
And I needed to start doing public speaking
Public speaking gave me:
I totally screwed this one up! I made a super common mistake: I thought I needed to blog about a “special” or “advanced” topic. Something that wasn’t “covered already”.
Huge mistake. This leads to spending a lot of time getting to know a piece of nice technology that isn’t very relevant to you, or to many other people.
Pick a common topic that is very useful for Junior DBAs.
Something that you know at least a bit about already, and that’s relevant to your job.
You’re going to learn a TON about this topic. Deep details. Pick something that’s worth the investment of your time, and also worth the investment of time of lots of other Junior DBAs out there.
Topics in this area are things like:
When you catch yourself thinking, “I can’t talk about that because ExpertSpeakerX already talks about it, and I won’t be as good,” then stop.
There’s room for you alongside ExpertSpeakerX!
In fact, the community is better with multiple speakers on core topics.
When you’re researching and testing, include materials from a wide variety of sources, and pull from your own experience. What confused you about the topic the most at first, or what were/are you surprised by? What’s your favorite way to solve a problem with that topic, and why?
You will naturally have your own voice and your own perspective.
Imagine you’re interviewing for a Senior DBA position, either at your company or another company
The interviewer asks you some technical questions about backups
You’re qualified to answer those questions, right?
Picture yourself being confronted with the questions now. (It’s normal to get a little sweaty.)
Now picture yourself being confronted with the questions after you’ve presented on backups a few times, and fielded questions from the audience.
So. Much. Easier.
The same thing goes for pitching a new project to your boss’ boss, having to fix failed backups at 3 am, and explaining what happened in an incident to a senior executive. Teaching others in the SQL Server community makes you better in all these sweaty situations.
Some people say that you should always start at a local user group
They tend to be small, and low pressure. A terrific choice for beginning! Find a list here: http://www.sqlpass.org/PASSChapters/LocalChapters.aspx
But maybe you’re not near one. Or maybe you’re like me: the closest user group when I started speaking was held at Microsoft in the building where developers coded SQL Server. Regular speakers at the group are Microsoft Program Managers, developers, and the people who literally “write the book” on SQL Server.
There was NO WAY I was going to test out public speaking at my local user group
So I submitted to a small SQL Saturday in Iowa. SQL Saturdays are awesome, and I got lucky– one accepted me!
I’d never been to Iowa. I didn’t know anyone in Iowa. But I got a cheap plane ticket to Iowa.
I figured if it was awful, well, all those kind strangers would just forget my name.
It wasn’t awful. I wasn’t a natural, and I was presenting on the wrong topics, but it didn’t kill me. It was a little exhilarating.
And I kinda wanted to do it again.
See a list of SQL Saturdays here: http://sqlsaturday.com/
If you’d rather start in front of a webcam, PASS has virtual chapters, too: http://www.sqlpass.org/PASSChapters/VirtualChapters.aspx (Seriously, really, DO USE A WEBCAM!)
Although speaking isn’t part of your job, it will benefit your job
Part of why I’m pushing backups so much as a topic is that speaking always teaches you a lot about your topic
You learn writing the demo scripts, doublechecking things on your slides, and answering audience questions (either live or later on – it’s always OK to say you don’t know and would like to check)
You’ll learn things that allow you to see improvements you can make at work
And once you start speaking, you’ll also learn things from your peers at the events you speak at, too
Regularly talk with your boss about what you learn from speaking, and from others at events
It’s good for your company for you to be a public speaker, and the more they know about it, the more they’ll support you and understand why you want to go to conferences
You’re at a fork in the road. You’re ready to level up your career. Starting to teach others is the best thing you can do – join the team of presenters and teachers! We’d love to have you.
Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.