SQLBits – My Thoughts

Many weeks I struggle with what I plan on writing about, but this post came to me last Thursday or Friday. It was clear to me that I should write about 2022 SQLBits.

Now, the more astute of you are probably thinking, “But Greg, you weren’t there. How can you write about it?”

Well you’re right. I’m not going to write about my experience attending it. Rather I’m going to write about my experience not attending it.

I had applied to speak at SQLBits, but didn’t make the cut this year. That happens. But this time there was more than mixed feelings. Had I been selected, I almost certainly would have tried to find a way to do so in person. However, as many of my readers know, I’m back in school taking classes as prereqs to get into PA school. And frankly, I’m loving it. But it is taking time and focus. This week, March 14-18 is Spring break for my fellow students. But last week I did have classes and I’m not sure I could have taken the time off to fly to the UK. And I’m not sure I would have wanted to; if only because of missing my A&P I lab this week (learning about the bones of the head and spine, including the axis and atlas (C1, C2 vertebrae).

So in a sense, I’m almost grateful that I wasn’t chosen to speak. It solved me the pain of trying to solve the dilemma of do I attend in person or not?

But dang, did I miss people. I saw posts from so many of my #SQLFamily that I was sad I couldn’t see them in person. And then, looking at the calendar, it dawned on me, I’m not entirely sure I can make the PASS Summit this year, again due to classes.

It just drove home how much so many of you have become family and how much I miss so many of you. And in some ways its just the start. As my plans continue, I’ll find myself making the slow transition from the #SQLFamily to hopefully a #PAFamily or whatever community I find there. And while I have often found myself in many communities, for example besides #SQLFamily I’m also heavily involved with the NCRC and plan on continuing my efforts there, I know over time my active involvement in #SQLFamily will slowly diminish. That said, I’m not walking away just yet and will continue to be involved as much as I can, both in presenting when I can and in running my local user group.

But that said, I miss you all. And do look forward to seeing any of you when I can.

Fair and Equal Medical Treatment

Today is International Women’s Day. I was reminded of this from a semi-unrelated post by a fellow #SQLFamily member, but this post is an intersection of a variety of Facebook posts and discussions I’ve had over the past week that touched upon women’s health. In the interests of privacy and protection I am going to anonymize a bit what happened. I’ve mentioned in past posts how we as DBAs have to take into consideration topics such as gender and more. We’re here to describe the world, not to prescribe it. But, if my hoped for career change to become a Physician’s Assistant passes, topics of women’s health will become even more important for me to take into account.

Let me start with the first discussion I had: menopause and Nuvaring. A friend mentioned she’s going through menopause and her physician had suggested the Nuvarin as a form of hormone replacement to help reduce the effects such as hot-flashes. She looked into what her insurance covered and found out that it would cost I believe $360 for 3 months of coverage. But, Viagra was free. That’s health insurance in America. Want to get an erection, if you have good health insurance, it’s free. Want to avoid feeling like you need to rip off your clothes in public because you’ve gone from cold to sweating hot in seconds, sorry that’ll cost you $120/month! Perhaps it’s time to rethink how we allocate some of our funds.

The other discussion that came up was someone that I know more vaguely, but who is a trans-woman. She mentioned how doctors have turned her away. Pharmacies have refused to fulfill prescriptions for her that they routinely fill for cis-women. In general, because in their minds her physical presentation doesn’t match their expectations, they treat her as an outcast. Let me be simple and blunt: I’m offended and angry. She deserves access to the same treatment as any of the cis-women around her (and as the above discussion suggests, women in general deserve better treatment).

Writing this, I realized, I lied a bit, unintentionally. The above paragraph was prompted by a particular post, but I know several women to whom it could apply. So no need to try to guess who she is among my friends. She could be and is in fact a compilation of several.

Before I close, I want to recommend a Youtube channel I spend some time on: Dr. Momma Jones. While I don’t think my specialty will involve Ob/Gyn (I’m more interested in emergency medicine), I love watching her posts because I learn a lot, both medically and about gender bias and topics that I’m generally less familiar with.

That said, in closing, if I become a PA, I will work at treating all my patients equally and equitably and to the best of my abilities, regardless of their identity. Even if I don’t become a PA, I will continue to work to fight for the rights of all and to treat all equally and equitably .

So on International Women’s Day, let’s celebrate and remember all women.

P.S. and in the meantime, let’s fight against the rules put in place in Texas regarding medical treatment and discussion around trans-children and against the “Don’t Say Gay” law being voted on in Florida. I will say right now: children will die because of these rules. They will commit suicide.

2022 in Preview

I started last year’s version of this post with the suggestion I should leave it as a blank page and I’m tempted again, but no, I actually have goals for next year.

By words, thoughts become actions, and by actions words become deeds.

I’m going to start with the usual list of items and then have a big reveal at the bottom (you can skip to that if you want).

  • Like last year, I’m going to continue to write for Red-Gate. Even if it’s just one article. I will also attempt to keep my “Friends of Red-Gate’ status. In fact, I vow to be even more involved if I can find time.
  • This year for the NCRC, I’m looking to premiere a new class we’re calling “Tip of the Spear” aka TOTS. The focus of the class will be to work with medical doctors, nurses, physicians assistants and other medically trained personal to get them (the tip of the spear) to the patient deep in the cave as quickly as possible to provide the best possible medical care. Unlike our normal classes where there’s a strong focus on things like setting up communications, rigging, searching, etc this will focus solely on getting them there to use their skills. I’m excited about this, even though there’s a fair amount of work required to fully develop the curriculum.
  • Yeah, I’ll continue blogging. ‘Nough said. (Hey no one says you have to read it!)
  • Travel: While I do plan to do more, the big trips may be out for reasons to be mentioned below. But we’ll see.
  • Biking: Yeah, I hope to hit at least 700 miles this year (that has sort of been my minimum goal for years and I’ve beat it every year. I’ll continue to do so).
  • Hike More: I hope to do at least one overnight this year. And of course day hikes. So if you’re interested in doing a hike, let me know.
  • Caving: There’s a few caves I want to get into this year. So I’m looking forward to that.

Changes are Coming!

And now “the big reveal”. I’m going to start by saying that while I enjoy consulting and I think I’m pretty good at it, I am not enjoying it as much as I used to. I’m also simply not finding it fulfilling in a way I’d like it to be.

Among the reasons is that at the end of the day I look at what I’ve done and wonder “what difference does it really make?” Yes, I’ve written some solid code. I’ve helped with projects that have saved my clients thousands of dollars or made them tens of thousands. Financially, they’ve obviously made a difference. But, on a personal level they haven’t.

One reason I’ve enjoyed teaching cave rescue so much (and participating in the few I have, including a body recovery) is because at the end of the day I know I’ve made a difference: I’ve taught someone valuable skills, helped someone get out safely, or even in the most extreme case, been able to help others find closure.

I’ve been contemplating a change for awhile. I had toyed with a few ideas, such as going back to being a full-time employee, ideally in a management position for awhile. And I may still end up doing that, but that’s not where I am planning on heading right now. Financially it would probably be the right move, and honestly, I think when I’ve had the right environment, I’ve been a good manager (on the flip side, in a bad environment I’ve found it hard to be an effective or good manager).

So, instead, I’m going to pivot a bit and attempt a career change. I’m going to to try to move into a field where I think I can make a direct impact on people’s lives. I’m going to start taking prerequisite classes so I can apply for a Physician’s Assistant program. This is an idea I’ve toyed with off and on for years. Or rather one of several. Besides enjoying working with computers, I’ve been fascinated with two other fields: medical and law. I’ve thought for quite a few years if perhaps I should explore them. This really came to a head during my dad’s fatal illness 6 years ago. I’ll brag a bit and say that more than once I had one of the attendings or nurses ask me (after discussing his condition or treatment) “Are you in the medical field?” Once even when students were rounding, the attending asked them a question and none answered it to his satisfaction, I was able to step in and correctly answer it. Yes, one or two students scowled at me.

Now, having said that, I’m quite realistic in understanding that while I do claim a greater than a laymen’s knowledge of things medical, I have a LONG way to go and I’m entering a difficult field later in life and have a bit of catchup to do. I have no illusions that this will be easy for me. But to perhaps channel a bit of John F. Kennedy “We choose to go to the Moon in this decade and do the other things, not because they are easy, but because they are hard…”

In the most optimistic timeframe, I’ll be completing my PA work in mid 2025. In a more realistic timeframe, probably 2026. This is a serious investment of time and effort. This is arguably going to be one of the hardest things I’ve done in years. There’s no guarantee of success (heck, there’s no guarantee that even after doing all the prereqs I’ll be accepted into a program). But, I’ve decided I have to try. Ah but a man’s reach should exceed his grasp, Or what’s a heaven for? I won’t know if I can do it unless I try and I don’t want to be a 4 years older wondering “what if?”

I’d been having thoughts about this for a long time. I finally put the thoughts into words, which made them that much more real. Now I’m starting to put the words into actions.

And one of those actions is to write the words down here for others to read. I do this for a multitude of reasons.

  • By writing this down and revealing it to the world (or at least to a small part of it) it holds me a bit more accountable for trying.
  • I’ll freely admit, I could use any and all support and help any of my friends, family, including #sqlfamily, and others are willing to give.
  • And honestly, perhaps it’ll inspire others in a similar position to stretch for their own goals.

For the coming year

I’ll keep working in SQL, you’ll see me at events and I’ll probably do some speaking, but I won’t be seeking out new work. I simply won’t have the time.

I’ll still keep running my local user group and looking for speakers

I’ll be blogging about my successes, and failures.

And I’ll be busy.

Wish me luck.

What T-SQL Do You Find Difficult?

It’s been awhile since I’ve focused exclusively on SQL Server or even T-SQL and perhaps this would make a great question for someone to ask on a T-SQL Tuesday, but for now I’ll ask.

An open question to any of my readers who work with T-SQL: “What command or construct do you find difficult?”

Let’s be honest, we all have something about T-SQL that trips us up. I’m hoping the basic SELECT statement doesn’t. Though, start to throw in stuff like an outer join and a correlated subquery, it can get complicated pretty quickly. But even those I can generally get written without too much effort.

The one construct I do encounter infrequently, but enough that I feel I should fully grok it by now is a DELETE with a join. It’s actually not all that complicated, but I often have to look up the syntax to remind myself.

But the one that gets me every single time: PIVOT. I’ve probably only written a half-dozen pivots in my life and that’s 6 too many in my opinion. I’m not sure what it is about them, but my mind still doesn’t just fully grasp the syntax in an easy way.

Thinking about it, I think one reason is because when I’ve had to use them, it has never been a trivial case.

Fortunately, since my primary focus is on the operations side of being a DBA, and most of the code I write is to support that, I don’t come across the need for a pivot very often. I suppose though if I were writing a lot more code, I’d use it more and understand it better.

So, what’s your T-SQL nemesis?

And Fun Was Had By All

I want to give shout-outs to Rob Farley, Peter Shore, Deborah Melkin, and Rob Sewell for making the final Capital Area SQL Server User Group meeting of the year a rousing success. And this being T-SQL Tuesday, I’m going to try to very loosely tie this into the topic this month How much do you love meeting in person, where would you like for your next event to take place, and why Costa Rica? as invited by Xavier Morera.

tsqltuesday
T-SQL Tuesday

First, let me get his questions out of the way:

  1. Favorite Conference: The easy answer has been SQL Pass, but honestly, at this point, any where I get to see folks in person!
  2. Best Venue: Ignoring Pass at Seattle, I have to say Manchester UK was nice, simply because it was my first overseas SQL Saturday, or perhaps Virginia Beach SQL Saturday, because Monica Rathbun and her group provided a nice charcuterie board!
  3. Best Presenter: Oh, this is a tough one. I’m going to take a pass. But then cheat and answer below. Sort of.
  4. Next event and why it’ll be Costa Rica: I’m suspecting sort of a bias in this question, but to be honest, I’d love to go. I think 2022 will be a bit too busy for me to visit, but perhaps 2023 or 2024. Maybe I can work in some caving then too!

That all said, I want to get back to my shout-outs above and tie that into this T-SQL Tuesday.

As the coordinator for the Capital Area SQL Server User Group, one of my primary roles, in fact perhaps the most important, is finding speakers to present. I’ve tried over the past few years to have a good variety and to bring some variety. We haven’t really missed a meeting since the pandemic has started, but we have been virtual for well over a year now. This has presented both drawbacks and opportunities. The biggest drawback of course is the lack of actual in-person interaction and the feeling of connectedness that has brought. On a personal note it also means not only have I not gotten out of cooking dinner the night of meetings, but often, I’m juggling getting something together for dinner and getting the session started (though last night my wonderful wife did take care of dinner for me.)

On the flip side, being virtual has allowed me to invite speakers who might not otherwise be willing or able to travel in person to Albany NY and for attendees from across the country to show up. It has also given me the opportunity to experiment a bit more with formats.

Last year, instead of our traditional in-person holiday party format, we did a version of “Bluff the Listener” where I asked various presenters to tell their worst IT/SQL horror stories, but one was lying. It was a success and a lot of fun.

Not wanting to repeat that, this year I decided to ask the above 4 presenters to present lightning rounds. That’s not so bad, except I added a twist. They didn’t get to choose their topics, they were given them: 10 minutes before they were scheduled to present. (And yes, some may I stole this idea from Buck Woody, I’d like to say I was inspired).

I’ll admit I was very nervous about this idea. It seemed a bit gimmicky and it could have been a complete disaster with lesser speakers. Fortunately, all four brought their A-Game.

Rob Farley, presenting from the future, in I believe a public work space, managed to give one of the best talks on column-store indices I’ve seen. Given he had only 10 minutes of prep, I was impressed. His presentation included the use of Powerpoint in sort of a “green screen” mode so he could draw on his screen and we could see what he was drawing.

Peter Shore followed up talking about Tips in Advancing a Career in Data. Again, off-the-cuff with limited prep time, he did very well with this topic. I think in some ways this was almost harder than the more technical topics because you can’t fall back on a demo or graphics.

Deborah Melkin followed, talking about the Best new SQL Server features (2019, 2022, Azure). I had announced previously that the best speaker would be awarded a prize. By I think unanimous declaration, even before Rob Sewell finished out the night with his presentation, the other speakers decided Deborah was the winner. She included some demos in her presentation, which, given the lead time, really impressed folks.

Closing out the evening, Rob Sewell entertained us with a demo of SQL Injection. Not surprisingly, he made use of PowerShell and Notebooks.

As I said, it was an entertaining and educational evening. I purposely set expectations low and made sure folks understood that the entertainment value was as much, if not more important than actual educational value. But I was very pleased with how educational it turned out to be. It was a nice way to end the year and honestly, I think a decent way to get a break from the bad news that seems to have surrounded us lately.

I do have a theory though about why the educational part turned out as well as it did though. In general I’ve always enjoyed lightning talks and I honestly, think they’re among the hardest type of talk to give. Sometimes people promote them as a good introduction to speaking for novice speakers, but I’m not so sure. To give a successful lightning talk, one really has to strip a presentation to the bare essentials and really focus on just one or two key concepts. This can be difficult. But done well I think it really makes those concepts stick.

Now, combine that with topics only being given out 10 minutes in advance, I think that really forces a presenter to focus on key concepts even more. I wouldn’t give an inexperienced presenter a random topic, and even with an experienced presenter, I’d give them a chance to decline a topic if they feel it’s completely outside their wheelhouse. But otherwise, give them a chance to see what they can do. It might surprise you. Heck, it might surprise them.

So, to go back and answer a question from above: Best Presenter… at least last night Deborah Melkin, who if nothing else proved her Google-foo was impressive.

And I think if I can find volunteers, I will definitely try to do an in-person version of this at a future SQL Saturday or Data Saturday or other conference.

Thanks to all who participated and joined us. It was a blast. But honestly, next year, I hope to see you all in person at our holiday party!

Summit Recap

As many of my readers know, last week was the 2021 PASS Data Community Summit hosted by Redgate. In the past I would have travelled to Seattle to attend in person. Last year, due to Covid the Summit became a virtual event. I was a bit disappointed since I had finally been selected to present and was looking forward to doing so in person. I ended up presenting virtually. That alone would have been disappointing enough, but there were other issues and basically the underlying structure that supported PASS and its structure went belly-up and declared bankruptcy.

More Thoughts on Last Year’s Summit

My recap last year was positive but I have to be honest now. I was certainly trying to put a good spin on things. The truth is, I was more frustrated than I originally let on. I’m still not only grossly disappointed by the poor closed-captioning, I’m still a bit offended. I’m as guilty as anyone for probably not being inclusive enough when it comes to things like color-blindness, difficulty of hearing, etc, but to know that the organization had weeks to get good closed-captioning done, and didn’t still offends me.

I was also extremely insulted when weeks before the Summit, User Group leaders were asked to pony up money to attend. A benefit of doing the work of leading a User Group has traditionally been a free ticket to Summit. To have that change weeks or just a few months before Summit, especially one that was going virtual definitely felt like a bait and switch.

This and some behind the scenes factors in regards to PASS had left a bitter taste in my mouth. Then of course we finally got word that PASS as an organization was no more.

There were wails of anguish, and rending of garments, and wearing of sackcloth. (ok, I may be overdramatizing a bit). But I was hopeful. As I stated then, PASS really is the community. It’s the people. And they’re some of the best people I’ve known professionally: #sqlfamily.

This Year’s Summit

So, on to Summit this year. Within months of the demise of the former structure, Redgate announced it was buying the intellectual property associated with PASS. Microsoft in the meantime was rolling out tools to help the user groups. Steve Jones was working on SQL Saturday. Things were looking good. I was hopeful.

Redgate announced the Pass Data Community Summit would happen, albeit virtually. I was excited and looking forward to it. That said, I’ll admit I did not put in to speak this year. I just didn’t have the motivation. This was a mark on me, not on Redgate’s efforts. Redgate also announced that while the precons would cost money, the Summit itself would be free. Last year there was a lot of discussion about charging for a virtual summit and while I defended the concept a bit, because there are still enormous costs associated, I also was not a fan of it, because I knew it would be a hard sell to managers. I think I was proven right there. The very preliminary numbers I heard for attendance this year appear to have FAR outpaced the numbers for last year. I think that’s a good sign.

So, enough rambling, what about Summit this year?

First two criticisms

I common complaint, and one I knew I was guilty of, was it was unclear that for many sessions one was supposed to watch the recorded session first and then attend what was essentially a live Q&A. I know for the first presentation I attended on Wednesday, even the presenter, who was in the Q&A was confused by this. I’ll admit, I never did figure out how to watch the recorded sessions beforehand.

The second was, I didn’t discover the Spatial.Chat system until the 2nd day, and that was only because I am a Friend of Redgate had received a specific email inviting me to a private chat.

Now, partly, I will put the blame for the above two criticisms squarely on myself for probably not reading the emails in enough detail. But, it does seem others had the same issue and perhaps more succinct, clear links or emails might have helped. I honestly don’t know.

The Positives

That said, despite the above criticisms, I really enjoyed Summit and in a huge part because once I learned about the Spatial.chat system and how to use it, I for the first time, felt like I was in a virtual space that closely mimicked real life. The idea of being able to move closer to people to hear them better, or to move away if I wanted to focus on some work but still be “part of the crowd” worked REALLY well. Trying to translate a physical presence into a virtual one is often tough, but I think the Spatial.Chat stuff worked really well. I found myself hanging out there more than anything else.

Since I never did figure out how to watch recorded stuff before the live Q&A, I focused on the actually live sessions and they did NOT disappoint. As usual, while folks talk about how great the social atmosphere is at Summit, the truth is we tell our bosses we go for the technical content and it was topnotch as expected. Once again great content!

I also really enjoyed the Keynotes this year. I’ll admit, because of jetlag and because I’m often up late talking with the college friends whose house I crash at while in Seattle, I am often late to the keynotes (if I make it at all) and sometimes doze off in the large, warm dark room. This year, none of that happened. I was entertained and really enjoyed them. I especially enjoyed Brent Ozar‘s Keynote on Friday and the impact of the Cloud on ones career.

I think this year’s Summit overall felt more positive for a number of reasons. For one, I think many of us are finally hoping to see a light at the end of the Covid Tunnel. For another, I think most of us are far more hopeful about the overall #SQLFamily community and future PASS Summits than we were a year ago. Finally, I think we just all felt the need to socialize again, albeit it virtually.

Redgate has already announced next year’s summit will be in Seattle again next year, but will be a hybrid event. I will be very curious to see how that works, but I can tell you right now I’m already budgeting to attend in person.

  • End note: I am a Friend of Redgate and write for their Simple-Talk blog. That said, in this case Redgate isn’t paying for my thoughts and my thoughts are my own.

Impact and Legacy

One of my favorite movies for many reasons is Dead Poet’s Society. Robin Williams is excellent in this role. Shortly after his death, Apple repurposed a short segment that I’ve always loved where he quotes my favorite poet, Walt Whitman: What will your verse be?

“That the powerful play goes on, and you may contribute a verse.” – Walt Whitman.

I’ve been thinking more about my legacy and the legacy of others and this week seemed a good time to muse on that. This is the week that in the past many of us would travel to Seattle (or in years before my time, other cities) and gather at PASS SQL Summit. This year things area bit different, but Pass Data Community Summit is happening, albeit remotely. Though at times like this, I can’t but help think of and riff on a line from the Passover Seder, “Perhaps next year in Seattle.” So in any case #SQLFamily is on my mind. And here’s my thoughts on the impact of some individuals.

Let me start with saying this is FAR from a comprehensive list of the people who have had an impact on me. If I didn’t name you, that’s more an oversight on my part and please don’t take it as a slight. And there’s really very little order to this.

Grant Fritchey – I’m sure I remember my meeting with Grant better than he remembers meeting me (is oft the case when a presenter or instructor teaches so many) but it was at a SQL Saturday in Boston where I first heard him speak, in this case on HIPAA. From there I learned not only more about SQL but about #SQLFamily itself and how important this community truly was.

Rie Irish – I want to say it was a SQL Saturday in Philadelphia, but I could be wrong. I was one of two men in her talk  Let Her Finish: Supporting Women’s Voices in Technology. Turns out the other was a friend she had asked to attend. I still wish more men had attended, it’s still a great topic. Rie has helped me be more aware of diversity issues in this community and called me out at least once or twice when I needed it. She’ll be speaking at my user group in a few months and can’t wait.

Andy Mallon – There’s just something infectious about being around Andy that no matter what my mood makes me want to smile.

Bob Ward – Despite him being a Dallas Cowboys fan, he’s an all-around good guy. More seriously, despite how hard he works for Microsoft, he always takes time out to speak to the community and I’ve been honored to have him speak at my local User Group more than once. And despite the general advice to “not type during a demo” he’s brave enough (or crazy enough) to pull out the debugger and debug SQL Server live!

Kathi Kellenberger aka Aunt Kathi – At my first Summit I attended a talk by her on writing a book. What a long strange trip it’s been since then. I wrote my first book and numerous articles for Redgate since then. And yes, I did say first book. I have ideas for others.

Jen and Sean McGowan – Not only have I spent plenty of time on their coach in their booth at Summit, I still find Sean’s class on regexp usage in SSMS, especially for find and replace to be one of the more useful technical skills I’ve learned that arguably isn’t really T-SQL specific.

Tracy Boggiano – For being their during Covid and for making me more aware of mental health issues. And I’m proud to say I’ve got her first ever signature on a book she co-authored with Grant Fritchey!

David Klee – My go to man on certain subjects who knows more about VMWare tuning than I’ll ever hope, let alone want to know. His current Twitter profile picture is a bit misleading, as it suggests a rather sedate, mild-mannered person, but the reality is there’s a mischievous streak there.

Deborah Melkin – I first saw her speak at our Albany SQL Saturday and was immediately impressed, especially as it was her first SQL Saturday. I immediately cornered her and didn’t so much ask as told her to prepare a topic to present to our user group. She happily obliged. One of the aspects I really like about her presentations is she can take a topic that may appear to be a 100 level topic, but still have something new to teach to experienced DBAs.

Andy Yun – I of course now can’t mention Deborah without bringing up Andy’s name. We first met at a SQL Saturday Chicago where I had a blast. At the time it was my most western SQL Saturday gig (since surpassed by two in Colorado Springs). Always helpful and just fun to be around.

Steve Jones – If nothing else, his Daily Coping Blog posts have been a light in my day (even I only skim them). That said, I honestly, don’t know how he gets time to write so much AND do actual work!

Hamish Watson – Despite being literally half a world away, great fun to be around and has shared his great chocolate me, and for that alone he gets a mention.

There are so many more folks that have had an impact: Monica Rathbun, Chris Bell and Gigi Bell, Andy Levy, John Morehouse, Matt Gordon, Kimberly Tripp, and so many more. If I’ve left a name off, I apologize. Honestly, there are dozens of members of the #SQLFamily that have had an impact on me. The only folks I’m not intentionally naming are folks local to me, simply because I want to focus on the larger, worldwide community as a whole. The folks local to me hopefully already know how important they are.

In years past, I’d be looking forward to seeing many of them in person at Summit, but this year the best I can do is perhaps see them virtually and remember them this way.

You may notice a theme too: the impact hasn’t always been directly database related. While it’s true I’ve learned some great database tips from everyone above, their impact has been larger than that. And all of the above folks are more than simply folks who “work on the Microsoft Data Platform”. They’re folks who have lives outside of that. Some rock-climb, some run up buildings, some love to cook, others love to bake, others love to work on their houses, or love to talk about their dogs or cats. And I care about all of them

They’ve each introduced a verse (or more) into the powerful play of both #SQLFamily and to my life. And I’m eternally grateful. Thank you.

Feeling Older

This is probably far from the last time I’m going to write on the subject, and certainly not as in depth as I plan to someday, but this past week made me feel past my prime.

While in many ways I believe age is just a number, the truth is, it does change us. While I am still very active, such as biking a century ride last year, still caving and teaching cave rescue, the reality is, the body and mind are slowing.

I’ve been working with SQL Server in one form or another since 4.21. I’ve spoken at PASS Summit, I’ve presented at more SQL Saturdays and User Groups than I can remember. I’ve published a book and numerous Red Gate articles and I’ve mentored more than a few people over the decades. I’ve worked at two start-ups (not counting mergers and acquisitions) and been a consultant before, between and after those gigs.

So I think I can safely say I’m comfortable with my credentials.

That said, the past week really made me consider if it was time to hang up my cap, or at least change caps again. I won’t go into details, other than to say a particularly stressful project for one of my clients reached a major milestone. I’m actually just one small cog in a much bigger piece of the project, but it’s a fairly important cog. And, it had issues. Now, I’ll put on my shoulders that a bit was due to issues with my code and some assumptions I had made. Most of the issues actually stemmed at a far higher level and with another consultant agency working on the project. Let’s just say that GIGO still thrives. But some of it I realized was, I was slightly off my game, and I think a bit of brain fog was involved. I don’t know if that was age related, simply a result of being cooped up for well over the last year due to Covid or what.

Regardless, the culmination of all that and other issues, some personal, started to come to a head. By Friday I was seriously wondering how much more I had left in the tank, physically and mentally.

Today I will admit I’m in a better place. The last major piece of code I needed to get working finally succeeded in production last night and the GIGO problems seem to be disappearing.

But that was after a long weekend of introspection about where I’m headed. I am at that age where retirement is no longer some far off nebulous goal, but an actual reality I have to consider. I’ve always known I’ll probably never truly retire; I do enjoy being busy and working too much. However, I have for several years now done the delicate balance between making sure I hit certain target goals for income and actually enjoying my work. Last week that balance was way off. I need to get it back.

This is my long-winded way of saying that for the first time in years, I’m honestly not sure what I’ll be doing a year from now. Perhaps I’ll still be consulting in my current form and enjoying it. Perhaps I’ll go back to a full-time 9-5 gig; I have come to realize, I deeply miss the management side of work. For my two stints as a full-time employee I was a manager and honestly, I loved that. I miss it. Perhaps I’ll be consulting in a very different way going forward. Maybe I’ll invest in real-estate. Perhaps become a vagabond teaching cave rescue across the country (this last one is not as far fetched as it sounds, I am planning on teaching at least 2 if not 3 different classes next year.)

But I think change is coming again. It’s the season.

Updating My Avatar

A want to thank in part, fellow DBA, Cathrine Wilhelmsen for the topic today. She posted a tweet this morning asking we all look like our Twitter profile pictures when we meet again at in-person events. I replied that I wasn’t sure I was ready to shave my beard. So, instead, in the meantime, I updated my avatar on Twitter photo to my latest headshot, which does include a beard. I figure I can always shave it and update my photo later.

I was at a loss for a topic today until that tweet came in and then a request from Adam Hafner came in reminding me to send him an updated bio for my upcoming talk at his User Group in Sioux Falls later this month.

Between these two events, it was another reminder of how much as changed in the last 18 or so months and how much will change again in the next 18 months. For example, I signed up to do an in-person User Group presentation next May for the Hampton Roads SQL Server User Group.

The beard is perhaps my most obvious change. But I’ve also come to realize how much I miss my #SQLFamily. I’ve been fortunate in the past 18 months to teach two in-person cave rescue classes and still avoid Covid. And yet, I missed travelling. I miss getting out. Last month my wife and I drove our out to Buffalo to help my son move into his apartment for his final semester of college. That’s the furthest I’ve been from home in 18 months. Other than teaching the cave rescue courses about 30 miles away, I don’t think I’ve slept under another roof in all that time. This is unusual for me.

I had even stopped doing remote SQL presentations. My writing for Redgate dropped off (though I just had a new article published, check it out here!)

But, that’s all starting to slowly change. I can feel the winds shifting and I think next year will be a great year for travel and I’m excited about it.

And, I may or may not have a beard. Hopefully you’ll recognize me. And I hope I recognize you.

Take 5 Minutes

This weekend I had the pleasure of moderating Brandon Leach‘s session at Data Saturday Southwest. The topic was “A DBA’s Guide to the Proper Handling of Corruption”. There were some great takeaways and if you get a chance, I recommend you catch it the next time he presents it.

But there was one thing that stood out that he mentioned that I wanted to write about: taking 5 minutes in an emergency. The idea is that sometimes the best thing you can do in an emergency is take 5 minutes. Doing this can save a lot of time and effort down the road.

Now, obviously, there are times when you can’t take 5 minutes. If you’re in an airplane and you lose both engines on takeoff while departing La Guardia, you don’t have 5 minutes. If your office is on fire, I would not suggest taking 5 minutes before deciding to leave the building. But other than the immediate life-threatening emergencies, I’m a huge fan of taking 5 minutes. Or as I’ve put it, “make yourself a cup of tea.” (note I don’t drink tea!) Or have a cookie!

Years ago, when the web was young (and I was younger) I wrote sort of a first-aid quiz web-page. Nothing fancy or formal, just a bunch of questions with hyperlinks to the bottom. It was self-graded. I don’t recall the exact wording of one of the questions but it was something along the lines of “You’re hiking and someone stumbles and breaks their leg, how long should you wait before you run off to get help.” The answer was basically “after you make some tea.”

This came about after hearing a talk from Dr. Frank Hubbell, the founder of SOLO talk about an incident in the White Mountains of New Hampshire where the leader of a Boy Scout troop passed out during breakfast. Immediately two scouts started to run down the trail to get help. While doing so, one slipped and fell off a bridge and broke his leg. Turns out the leader simply had passed out from low blood sugar and once he woke up and had some breakfast was fine. The pour scout with the broken leg though wasn’t quite so fine. If they had waited 5 minutes, the outcome would have been different.

The above is an example of what some call “Go Fever”. Our adrenaline starts pumping and we feel like we have to do something. Sitting still can feel very unnatural. This can happen even when we know rationally it’s NOT an emergency. Years ago during a mock cave rescue training exercise, a student was so pumped up that he started to back up and ran his car into another student’s motorcycle. There was zero reason to rush, and yet he had let go fever hit him.

Taking the extra 5 minutes has a number of benefits. It gives you the opportunity to catch your breath and organize the thoughts in your head. It gives you time to collect more data. It also sometimes gives the situation itself time to resolve.

But, and Brandon touched upon this a bit, and I’ve talked about it in my own talk “Who’s Flying the Plane”, often for this, you need strong support from management. Management obviously wants problems fixed, as quickly as possible. This often means management puts pressure on us IT folks to jump into action. This can lead to bad outcomes. I once had a manager who told my team (without me realizing it at the time) to reboot a SQL Server because it was acting very slowly. This was while I was in the middle of remotely trying to diagnosis it. Not only did this not solve the problem, it made things worse because a rebooting server is exactly 100% not responsive, but even when it comes up, it has to load a lot of pages into cache and will have a slow response after reboot. And in this case, as I was pretty sure would happen, the reboot didn’t solve the problem (we were hitting a flaw in our code that was resulting in huge table scans). While non-fatal, taking an extra 5 minutes would have eliminated that outage and gotten us that much closer to solving the problem.

Brandon also gave a great example of a corrupted index and how easy it can be to solve. If your boss is pressuring you for a solution NOW and you don’t have the opportunity to take those 5 minutes, you might make a poor decision that leads to a larger issue.

My take away for today is three fold:

  1. Be prepared to take 5 minutes in an emergency
  2. Take 5 minutes today, to talk to your manager about taking 5 minutes in an emergency. Let them know NOW that you plan on taking those 5 minutes to calm down, regroup, maybe discuss with others what’s going on and THEN you will respond. This isn’t you being a slacker or ignoring the impact on the business, but you being proactive to ensure you don’t make a hasty decision that has a larger impact. It’s far easier to have this conversation today, than in the middle of a crisis.
  3. If you’re a manager, tell your reports, that you expect them to take 5 minutes in an emergency.