Dear-Sql-Dba

Category: dear-sql-dba

Dear SQL DBA: Training Resources for SQL Newbies

Dear SQL DBA: Training Resources for SQL Newbies

New to learning SQL Server? Get the scoop on free online resources to look up information, ask questions of community members, and learn SQL Server from the ground up.

Continue reading

Dear SQL DBA: Dealing With a Lack of Control

Dear SQL DBA: Dealing With a Lack of Control

This week I discuss a question that I’ve gotten in many forms over the years - a lot of the scenarios are so specific that it’s hard to keep them anonymous, but they can be generalized as a bigger problem: how do I deal with being responsible for things that I can’t fully control?

Continue reading

Dear SQL DBA: Do DBAs Need a College Degree?

Dear SQL DBA: Do DBAs Need a College Degree?

Our question this week comes from a database administrator who’s excited to be on a healthy career path, building their work experience, getting certified, and working with a more experienced mentor.

But they’re worried: will lacking a college degree block their career growth down the line?

Continue reading

Dear SQL DBA: How Do I Prepare for Certification Exams? (video)

Dear SQL DBA: How Do I Prepare for Certification Exams? (video)

In this episode, I talk about how to strategize for and prepare for Microsoft Certification exams, using the Database Fundamentals exam as an example.

Continue reading

Dear SQL DBA Q&A: A Poorly Indexed ISV Database

Dear SQL DBA Q&A: A Poorly Indexed ISV Database

At a recent conference, two speakers reminded me of something important: when you put effort into learning something or helping folks, don’t simply put your words in private emails or post-it notes on your desk.Β Whenever possible, blog it as well. It can help other people, and it can also helpΒ you remember it in the future!

Continue reading

Dear SQL DBA: I Want to Work for Myself (video with captions and transcript)

Dear SQL DBA: I Want to Work for Myself (video with captions and transcript)

Our question this week comes from an IT pro who would like to be self-employed. In this episode, I talk about three big things you need to think about to start working for yourself, and two possible paths to get there.

Continue reading