• Skip to main content
  • Skip to primary sidebar

DallasDBAs.com

SQL Server Database Consulting

  • Services
  • Pocket DBA®
  • Blog
  • Testimonials
  • Contact
  • About

Personal

The Ironic DBA—Don’t Be Afraid of the Climb

October 14, 2019 by SQLandMTB Leave a Comment

Welcome back to The Ironic DBA Files, a series where the newbie DBA on staff at Dallas DBAs chronicles the ups and downs of fast-tracking a new career as a DBA.

Yes, my blogging pace has slowed somewhat, but I’m back with something to share. Last time I wrote about getting back to basics and reinforcing my knowledge of introductory SQL Server concepts. This week I want to go in the opposite direction and share why I think you should regularly push yourself out of your comfort zone.

The view from the top is worth the climb.

Climbing Sucks

I’ve mentioned before that I love mountain biking—I’m not great at it, but I love getting out on the trails. Unfortunately, I also have very low heat tolerance, and so I was almost completely off my bike for the majority of the Texas summer—about 2.5 months. I did sneak one ride in before the worst heat abated about 3.5 weeks ago, but it didn’t end well.

I’ve been able to get back out and do three or four trail rides a week for the last three weeks. The trail I’ve frequented is one of the closest to my house, though it’s not a favorite. There’s not a lot of elevation at this trail, but after so long off the bike even gentle slopes were tough to climb at first. To make matters worse, I’m overweight, have some significant balance issues, and absolutely suck at climbing.

Fast forward to just last night where I went out and rode a different trail—the same one that hadn’t gone well 3.5 weeks ago. This trail is not the longest or hardest in the area, nor does it have the most climbing, but it’s been my nemesis since the first time I put down tires on its dirt. I have a less than 50% completion record at this particular trail, so I’m determined to conquer it.

Last night’s ride was pretty good. I completed the entire trail for the first time in months, and set some personal records on a few segments along the way. But here’s the coolest thing about the ride. At one point I made it to the top of climb that’s typically pretty tough for me and took a quick water break. I immediately noticed that the climb had felt easier than expected, but I figured that was due to intentionally choosing easier gears than usual. I was pleasantly surprised to look down at my gears and realize that I was 9th gear when I thought I was probably in 6th or 7th. (For those who don’t ride bikes, the lower the gear number the “easier” the gear.)

The time I’ve been spending getting back to trail riding regularly is already beginning to pay off. I’m back to feeling comfortable on the bike, my fitness level is increasing again, and my ability to ride harder, longer, steeper trails is gradually improving.

Climbing is Awesome

Tim Chapman presenting “Troubleshoot SQL Server Like a Microsoft Engineer”

“That’s great,” you say. “Good for you. But what does this have to do with SQL Server stuff?” I’m glad you asked!

I recently attended a fantastic one-day workshop that was made possible by my local PASS group, the North Texas SQL Server User Group. After the huge success of this year’s SQL Saturday Dallas, and in particular the response attendees had from Brent Ozar’s (b|t) performance tuning pre-con, the group decided to bring in Tim Chapman (t) in for a one-day workshop entitled “Troubleshoot SQL Server Like a Microsoft Engineer.”

I was looking forward to attending even though I knew the vast majority of the class was probably going to be over my head. I’ve advanced fairly rapidly in my SQL Server knowledge since beginning this journey a little over four months ago, but the reality is I’ve only got four months of experience. That’s actually far too little time and experience to make the most of a class at this level. So why bother attending?

Learning is a climb, sometimes a very arduous climb. Just like some of my trail rides, there are moments when I can’t reach my learning goals and have to take a step back and start over. Some days the learning is smooth and the climbing is easy, boosting my confidence and my progress. Some days, the climb is hard, but not as hard as expected due to the work I’ve put in previously.

It’s for this very reason that I wanted to attend this workshop, and the same reason I’m currently working my way through Brent Ozar’s Senior DBA Class. Both are way over my head and deal with issues I won’t have to worry about being directly responsible for any time soon. But the classes make me climb and reach for a goal. Such classes make me dig deep and recall everything I’ve learned so far and apply it as best I can. Such classes expose holes in my current knowledge set and help flesh out a trail map for what I need to learn moving forward to become the best DBA I can be.

Sometimes the climb sucks, but getting to the top is awesome. Onward to the next peak!

Troubleshoot SQL Server Like a Microsoft Engineer—A Review

As for Tim Chapman’s class itself, let me give you a quick review and share my thoughts and takeaways from the day.

First up, I didn’t know what to expect walking into the class. Still being somewhat new to all this, I sort of expected the class to rapidly accelerate to light speed and beyond to leave me grasping for whatever small tidbits I could glean. That never happened.

Tim is an excellent presenter, but beyond that he’s an excellent teacher. So many technical people who are very smart, know their stuff, and have years of experience often don’t realize just how far beyond the average newbie they really are. But not once did I feel like the class was moving too fast for me to keep up, and a great deal of this is due to how Tim broke everything down logically, built concepts upon one another, and didn’t make assumptions that everyone in the room knew more than they really did.

Having said that, there definitely was a certain level of foundational knowledge required in order to make the most of the class, and thankfully my studies thus far proved to be enough. There were a few concepts and pieces in SQL Server that I’d never heard of before (namely triggers and forced query plans), but by and large I was familiar enough with SQL Server, relational databases, nomenclature, and SSMS to never get completely lost.

In a nutshell, here’s what Tim covered in roughly seven-hours-worth of sessions:

  • An Overview of Troubleshooting
  • Queries and Waits
  • Extended Events
  • Query Store
  • Most Common Problems

One of the most encouraging things Tim shared as a new DBA was this concept: “Often, there are 5 or fewer things to look at for a server to solve problems. Like the Pareto Principal: 20% causes 80% of the issues. Today’s Goal: Identify and master the 20%.”

This is why so much of the class was understandable and relate-able. The truth is, to know how you fix the other 80% of problems possible in SQL Server means you’ve either gained years and years of experience, know how to ask Google and StackOverflow the right questions, or both. Stay in the DBA field long enough and you’re sure to run into something rare, an edge-case that very few people have seen. But beyond those edge cases, the vast majority of the problems we see are repeated regularly. Getting a grasp on these underlying issues that regularly rear their head will help me be a solid DBA while giving me the foundation to troubleshoot those rare issues.

Big thanks to Tim for helping me put together a more direct path to follow on my self-guided learning. If any of you reading this ever have the chance to take this class from Tim in the future, I highly recommend it. I’d like to sit through it again myself sometime in the future when I’ve got more knowledge and experience in my tool kit.

Also thanks to NTSSUG for investing in your members and bringing Tim in to teach us. I’m looking forward to more opportunities in the future.

That’s all for this post. Join me next time for the next episode in The Ironic DBA Files.

Follow me on Twitter at @SQLandMTB, and if you’re into mountain bikes come over and check out my site NTX Trails.

The Ironic DBA Files

    • Prequel: The Ironic DBA—Starting a New and Unexpected Career
    • Episode 1: You Back That Up?
    • Episode 2: Attack of the Corruption
    • Episode 3: Revenge of the Index
    • Episode 4: A New Primary Key
    • Episode 5: The Maintenance Plan Strikes Back
    • Episode 6: Return of the TSQL
    • Episode 7: The Backup Awakens
    • Episode 8: The Last Rebuild
    • Episode 9: Rise of the Clients
    • Review One: A SQL Story
    • It’s Hip to Be Square
    • Rock Around the Clock
    • Failure is Always an Option
    • Back to Basics

Follow @Dallas_DBAs

Filed Under: Accidental DBA, Apprentice, Career, Cycling, EntryLevel, Personal, Troubleshooting

T-SQL Tuesday #99 : Dealer’s Choice

February 13, 2018 by Kevin3NF Leave a Comment

Welcome to my contribution to the 99th installment of T-SQL Tuesday, where Aaron Bertrand (b|t) gives us a choice to spread our wings and talk about our personal passions OR…play it safe and talk about our favorite T-SQL bad habit.  This whole T-SQL thing is all Adam’s fault, btw 🙂

If you follow me on Twitter, you probably know me more as SQL Cyclist than Kevin3NF.  I grabbed that name because it was cool, and well…I’ve been riding bikes since I was 3 years old.  I’m waaaay older than that now, and still riding.  My racing days are pretty much over, but the passion is still there!

I started out just riding in the neighborhood as most kids do, jumping ramps, skidding, wheelies, etc.  All the normal kid stuff.  Did a little BMX in the 80’s.  I moved into road bikes, track racing and eventually added mountain biking into the mix, which has become my favorite.

In the last 15 years I’ve gotten more and more involved:

  • Started road racing in 2004 (5)
  • Raced on the local velodrome for 5 years
  • Started coaching juniors racers as a certified USA Cycling coach
  • Became a local level USAC official
  • Started the North Texas chapter of an International Club
  • Started racing endurance mountain bike races (6+ hours)
  • Raced Cyclocross for a couple of years
  • Set a course record with a friend on the back of his tandem

I’ve had to dial it back lately for work, family and physical reasons…but the passion is still there.  Come to my house in July…and if you can’t tell me who is leading each category in “The Tour” you will be relegated to snack fetching duty as punishment 😉

And now, on to a small portion of the tons of favorite pictures:

Warming up a kid I coached…he’s a marine now

Hollering last second instructions to one of the very few young ladies I coached…she’s in college now…

I left Lee’s watermark in just to aggravate him 😉

Best looking track bike I ever rode…

2 State Champions and the team Rookie of the year

Do what I say LANDON!!!!

Dude in the middle should and could have gone pro mountain bike…

The most air I ever got without crashing…

Met this cool old guy that actually had some skillz…the dog’s name is Casey.
He’s a good doggo

My view for 54 miles from the tandem…

Rallying the troops at the start of the DFW area MS150 fundraiser ride.

 

That’s a small part of who I am when not being a DBA.  The MUCH bigger part is being a husband, father and grandfather…hands down.

Thanks for reading!

Kevin3NF

 

 

 

 

Filed Under: Cycling, Personal, TSQL2sday

Rant: Dead DBAs

November 27, 2017 by Kevin3NF 1 Comment

Where I go on a rant about the “death of the DBA”…which by comparison to others barely even qualifies as a rant 🙂

This is the post I reference in the video:

My prediction of the DBA role

And these are the names I mentioned:

  • Grant Fritchey
  • Brent Ozar
  • Pinal Dave
  • Paul Randal

I’ll let you YaBingGoogleHoo them yourself…

One thing I forgot to mention:  If you are not improving your skills and learning all the time…you are not a dead DBA, but you are becoming a “Zombie DBA” (baaaackuuuupssss….)

Thanks for watching!

Kevin3NF

 

 

 

Filed Under: Accidental DBA, Apprentice, Beginner, Career, Performance, Personal, PowerShell

TSQL Tuesday: Folks Who Have Made a Difference

November 14, 2017 by Kevin3NF 3 Comments

TSQL Tuesday Brent Ozar PASS Summit Ewald Cress

 

T-SQL Tuesday is a monthly blog party for the SQL Server community. It is the brainchild of Adam Machanic (b|t) and this month’s edition is hosted by Ewald Cress (b|t), asking us to post about those who have made a difference our life in the world of data.

I’d like to call out 3 (of the many) people who have been instrumental in my SQL Server career (and two of them will only see this if I send it to them):

The early years:   Max Lutz

Max was my manager at Jobs.com back in 2000.  He taught me quite a bit about T-SQL development that I had no clue on.  Max had been with Microsoft for some time before jobs.com and came in with a wealth of experience.  He also covered me when I took down the company by pointing out that I had implemented a “disaster recovery” plan for situations just like that.  I have not seen or heard from him since 2001.

The middle – current:  Rand Boyd

Rand is one of my best friends on the planet.  I met him in 2004 when I was on the first of two contracts I did at Microsoft in the SQL Support center in TX.  He was my go-to for calls where I had no clue what to do.   After my second contract was up I recruited him into the job I was moving to and we worked side by side every day either in person or WFH for the next 8 1/2 years.   He’s still there, I’ve moved on but we stay in touch as well as 2 introverted DBAs can.   His friendship is more valuable to me than all the SQL I know.

The current:  Brent Ozar

Cliché?  Probably.  I met Brent at PASS Summit 2008, when I was wandering around the Daily Grill at the Sheraton the first morning.   Brent was waving people over to his table to join him for breakfast.  Funny guy, super approachable and great stories.   I recall bacon.  Tim Ford was there as well and someone else I’ve forgotten the name of.   Since then I’ve been reading his blogs, buying his training and went to a pre-con of his at SQL Saturday Houston this year.  A lot of people know the same things as Brent, but his style of teaching them works as well for me as it probably doesn’t work for others.  I’ve started speaking/presenting this year and in addition to my own personality I’ve brought in some Brent and some Pinal Dave to my style.

Special shout-out to Andy Yun (b|t) for giving me the kick in the pants I needed to start the public speaking journey I began this year. 3 SQL Saturdays, one pre-con and two DFW area independent classes…all in 6 months.   I had the chance to thank him in person last week at Summit.

There are a great number of people that could have been mentioned here due to their amazing work in and for the community, but these are the ones that have impacted me directly and in person.

Thanks for reading!

Kevin3NF (<<stalk me!)

Filed Under: Career, Personal, Speaking, TSQL2sday

Crossfit for DBAs

September 29, 2017 by Kevin3NF 3 Comments

I’m a Database Administrator (DBA)…which should be obvious since you are reading this on a site for Dallas DBAs 🙂

Being in IT very frequently means sitting at a desk for many hours at a time, managing things, fixing broken stuff, learning about Microsoft’s new shiny feature in the next SQL version that your boss wants to implement on release day…

I am also an avid cyclist.  I have been riding in one form or another all of my life…from BMX to road to mountain bike and even raced a few years at the local velodrome (think NASCAR on bikes).

In 2015, after a series of training crashes while prepping for a 24 hour road/mountain bike race I had such pain in my left hip that I finally went to the doctor.  I thought I was just pushing too hard, but the pain went from hip all the way down to the knee.   In March I was riding 100 mile solo road rides.  In April I crashed in a 60 mile MTB race.   In late April, I was 5 miles into a road training ride when the pain level literally brought me to tears.  That April crash was the final straw.

After X-rays, the doc told me that I have bone spurs and trashed cartilage in the left hip, and osteo-arthritis in both.  Most of my other joints were hurting as well, but to a lesser degree.   For reference, I was 47 at the time.

I stalk follow a lot of world class Data professionals on Twitter, including Pinal Dave (b|t) from India.  Pinal is known around the world for his teaching, presenting, his daily blog postings and his skill.   At some point in April 2017 (maybe March), he posted about becoming a Level 1 Crossfit trainer.   I was inspired.  I’ve met Pinal in person…he’s a good sized guy.   I figured if he can make the progress he has, I can at least try.   After all…if my hip gets worse, I’m looking at a replacement.  I’d really like to keep that at bay as long as possible.

On April 11, I showed up at my local gym and showed off how badly I suck at anything but endurance cycling.  I took it easy, and still couldn’t walk properly for 4 days.  I thought I was in good shape for my age.   I was wrong.  I could barely do an air squat without falling over.  Almost no range of movement in any joint.

5 months later, and this is a summary of the changes that I recently sent the gym owner:

Before: I couldn’t run 200m.
Now: I can run 2 miles non-stop at 10 min/mile pace

Before: 12″ box step-ups at best (not jumps)
Now: I can jump onto a 24″ box multiple times, 30″ at least once

Before: Air squats, barely. Back squats – no.
Now: Air squats are easy. Can do Front, Back and Overhead at various weights

Before: What is a deadlift?
Now: I can deadlift 205. Once. 185lbs in sets of 3-5

Before: ALL of my joints hurt
Now: None of my joints hurt, except the hip with the bone spurs, and that one hurts less. Much less

There is more.   Too much to list.  The thing that has worked for me is that if I get in the door on any given day, I am going to improve.  In a regular gym I would just be lazy and flounder around.  In a CF gym there are coaches leading a class through the same level of suffering.  Yes, I pay people to hurt me.   They respect my mobility issues and when I’m done, I’m done.  My goal is to finish every workout.  Most days I do, some days the clock beats me.  Or my legs.

This sounds like a “How I got healthy” post…but its really much more of a THANKS PINAL! than anything else.  If you are sitting at a desk all day, whether in IT or some other office job…please get up and walk around.   The office, the block, whatever.  Get a bike.  Or Roller Blades.  Make room in your schedule to take care of yourself!

Pinal is now a level 2 trainer: read it here

Thanks for reading!

Kevin3NF

Filed Under: Personal

Love Good, condemn evil

August 13, 2017 by Kevin3NF Leave a Comment

This post very much reflects the opinions of DallasDBAs.com and its ownership.

All people deserve to be treated with respect and dignity. Period.

You and I may be on opposite sides of some spectrum or another – political, religious, racial, or any of the other classifications we have decided to break ourselves up into these days.  But, I will treat you with the same respect as a fellow human as I would my family and friends.

These divisions are all subsets of “human.”  Whether you are a White-Christian-Straight-Male or a Transgender-Liberal-Atheist-African American makes zero difference to me.

We can:

  • disagree on many things, yet still find a common ground.
  • discuss without arguing
  • debate without name-calling
  • co-exist without violence.

There are so many pressing needs in this world to direct our energies to that we simply cannot afford to waste time throwing sticks and stones at each other.  You will never change anyone’s opinion through violence and hate speech, in person or online.

We condemn all violence against others…not just in Charlottesville, but everywhere.

Kevin

Human

DallasDBAs.com

Filed Under: Personal

Primary Sidebar

Search

Sign up for blogs, DBA availability and more!

Home Blog About Privacy Policy
  • Home-draft
  • Blog
  • About Us

Copyright © 2025 · WordPress · Log in

 

Loading Comments...