Mentoring

Over the years when I changed careers and then advanced in IT, many people helped me learn or provided opportunities. Some of these people gave specific in-person help, like my brothers who taught me programming logic and database normalization before I ever thought about working in technology. Others assisted from a distance when I read their books and articles or watched their presentations. I’m not sure if these people can be called my mentors, but I am sure I wouldn’t be where I am today without them.

I count Steve Jones as a long-time mentor because he was the person who helped develop me as a writer 15 years ago. He was also kind enough to sit with me to discuss my career options one year at PASS Summit, and I’m sure he was quite busy that week, so I’m grateful that he took the time. We’ve never had any kind of formal mentorship set up, but I know I can always count on him for advice. (We work together now at Redgate!)

A consulting company I worked for a few years ago set up mentoring sessions between senior and junior consultants. I ended up with three or four juniors who wanted me to mentor them. If I remember correctly, many of the sessions would be cancelled due to customer work, so I’m not sure how effective they were.

Today, I get many informal requests asking for help with just about anything related to the data platform. Many are requests for good books on a particular data platform topic. It's frequently on an area I know nothing about, and only or or two books might exist on the topic as well.

I also often get asked for help with queries. This usually ends up with me writing a query instead of actually teaching anything. It's also possibly not correct because most people don’t take the time to provide enough sample data nor all the business rules. Most problems are not straightforward. My advice is to be sure to provide a script with the create table and insert statements as well as making sure that the data is representative, not just one edge case. In fact, it is probably better to post your one-off questions like this on a forum or #sqlhelp. That way, more people who have some time to spare will see your questions.

Right now, I have what I’ll call official mentoring relationships set up with three people. I’ve given each individual some recommendations, and there are specific goals in mind. So far, my mentees are enthusiastic and following up with me on their own. It is up to them to do the work. The outcome is not my problem; however, I will assist the best I can and am rooting for them.

Being a mentor is a great way to pay it forward. For those of you who have found mentors, remember that they are giving you a precious give – their time.

Kathi Kellenberger

Join the debate, and respond to the editorial on the forums

Phil Factor explains how SQL Monitor helps focus performance tuning efforts on the tables and queries where 'rogue indexes' might be a significant problem, and then how to identify both 'missing' indexes that might be beneficial to the overall workload, and those that are unused or duplicated, and so are doing more harm than good.

A REST API can hide the complexity behind large scale solutions using simple verbs like POST, PUT, or PATCH. In this article, Camilo Reyes explains how to create a REST API in .NET Core.

Services to include spotting racial bias, developi...

By Steve Bolton …………Like many of my other series of amateur mistutorials, the section of my blog devoted to the broad topic of Information Measurement is ultimately meant to... The...

Click to learn more about author Haoyuan Li. The present global crisis has bolstered cries for cost-cutting across organizations. Data lakes spanning from on-premises environments to a public cloud...

The master database contains records of the structure/configuration for both the current instance and all other databases...

Once you have worked on enough SQL Server performance issues, you start to develop an approach and lean on the same tools...

I got a message from a friend on Twitter last night asking ‘Is there an easy way to get dbachecks backup info into an Excel spreadsheet?’...

Sometimes as a DBA, I am lazy and want the ability to execute all of my tasks in one place...

Robert Sheldon wraps up his series on storage by discussing the latest storage innovation and ideas.

Total: 1 Average: 5 INTRODUCTION The master database contains records of the structure/configuration for both the current instance and all other databases. When you run sp_configure, you are writing...

SQL Server Agent Jobs are one of the core features of SQL Server. Agent Jobs perform many actions, from maintenance tasks (server and database), data movement flows, replication, log... The...

Click to learn more about author Errin O’Connor. If you have heard about Moore’s law, then you know that in the span of two years, the computer’s capacity increases...

Managing Azure Resource Manager (ARM) templates can be challenging. The Microsoft Azure team is aware of the challenges and has released a very early-alpha-v0.1 version of a new effort named...

I’m thrilled to have been part of the second Eig...

Through automated database monitoring, organizations are not only catching deployment issues faster, they are also resolving them quicker by empowering seamless integration between development and database management teams.

Discover the future of DevOps! Join Microsoft MVP Kendra Little to see Redgate's recent innovations in action and give you a picture of where Database DevOps is going, and why.

dbatools commands used: Get-DbaDatabase Get-DbaDbF...

Two years ago I wrote a post that got a lot of traction in the comments at the time. Last month there was renewed interest because one of the...

How can you use GitHub to do team-based database development? This article proposes a process that splits development work into task-based GitHub branches, incorporates daily database builds and integration...

Updated August 2020 If you were asked what the benefits of DevOps are, you could probably name two or three straight away. Maybe four or five. But – and...

In this series on DevOps for Data Science, I’ve explained the concept of a DevOps “Maturity Model” – a list of things you can do, in order, that will...

Azure Data Factory has grown in both popularity an...

Total: 1 Average: 5INTRODUCTION This document describes the steps and additional information necessary to configure AlwaysOn Availability Groups for HA and DR on MS SQL Server. AlwaysOn Availability Groups...

SQL Server 2017 (compatibility 140) brought us many Intelligent Query Processing (IQP), formally known as Adaptive Query Processing, features that improve performance on workloads straight out of the box... The...

Hidey-Hole When you’re looking at the execution plan for a query that someone is griping about, one thing to keep in mind is that it’s just part of the picture....

No, Lock Locks are necessary, I’m told. There’s this whole “ACID” thing that makes databases work. It’s generally a good idea for people who into correct answers. But blocking is one...

I’m really pleased to announce that new Power BI Migration documentation that I authored is published on the

Thanks for watching this week's Power BI news roun...

Two years ago I quit my job and started working for myself. After two years, I think most people would look at it as a big success, I’m now...

You've possibly just found out you're in a data breach. The organisation involved may have contacted you and advised your password...

Ed Pollack walks us through some query patterns wh...

There is a very common anti-pattern you should avoid, involving updating a row if it exists and inserting it if it doesn't. See how to avoid race conditions and...

When I am not working on or writing about SQL, I am posting theme park pictures on Twitter of DisneyWorld (@DisneyPicADay) and Dollywood (@DollywoodP). The fun part of it...

Quick post today. Recently I was helping a co-worker write a trigger. Basically there is a table of servers that’s ... Continue reading The post All triggers have to be...

Who Dropped My Table? - I was recently asked this ...

Triggers. Still blech. In June I asked you to play with DML triggers. Well, one more time. First of all ... Continue reading The post SQL Homework – September 2020...

So far this series has covered: installing Docker for Windows...

Everyone is using containers and talking about containers. Except those for whom it hasn't "clicked." Obvious to some and unendingly frustrating to others, containers are changing how we build...