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.

2021 in Review

Ayup, it’s that time of year where I look back on what I wrote just short of one year ago and heap praise or shame on myself. It’s not original, but gives me some perspective. You can make of it what you will.

So, how did I do for my goals?

  • I did better writing for Red-Gate than I thought. It appears they published 4 of my articles (and in the back of my mind I thought it was only 1 or 2). So check that one off.
  • Expanding my client base: Sort of. Talked to 2 potential clients, one fell through, the other is still in the works. And had another client come back to me with another project which is still in progress. So call that half-way.
  • NCRC Weeklong – Well, a hit and a miss. The National Seminar which was scheduled for June we postponed to August figuring things would be better with vaccines. BUT, there was enough interest in a Level 1 Regional, we used the original June dates for that. And then ended up cancelling the August one, not because of fears here in New York, but more so elsewhere in the country, including the fact that a number of our instructors were being told by their employers they were essential during the end of August and as such could not leave work for a week. So we had A seminar, but not THE seminar. Next year is scheduled for Virginia and isn’t my baby this time around.
  • Continue blogging: This turns out to be my 2nd best year yet in term of page views (unless I get over 300 on this particular post which I suspect I won’t). Last year I was boosted because Brent Ozar happened to retweet one of my blogs. So I think without that I did well anyway. A friend jokes he tells his jokes not to amuse others, but because they amuse him. Well, my blogging is a bit like that. While I always hope others take away something from my blog and writing, I do it as much for myself, both as an exercise in discipline and to keep my writing skills honed (though some may snark I could be failing a the latter).
  • Travel: Nope. Didn’t really do much of that this year. I did get down to Washington DC twice to see old friends (and hopefully make new ones). Those two trips were the first time in close to two years I’ve stayed under a roof outside of New York State. One was via train, so I did get to see the new Moynihan Train Hall in NYC.
  • Continue Biking: Definitely did. But I didn’t get a new bike. This was due to two reasons. One, I stopped by a bike store I had visited years ago, but this time the indifference of the staff was partly a turn off, as was the fact that they didn’t have the bike I really wanted to try in stock. The second was, even if they had the model, getting the one I wanted, apparently had an 18 month backlog. So, we’ll see what 2022 brings. I did NOT do a century ride this year. And instead of 1300 miles, only did 843. Still not too shabby.
  • Hike More: The goal was at least one or two overnight hikes. That was a big fat zero. Mostly due to scheduling and other events just didn’t happen. But, on the flip side, did do several hikes with Randi towards the end of the summer, including one that was a bit more rugged than I remembered (and we almost ended up having to assist in a carryout rescue, which would have really sucked, but the rangers decided to airlift her out).
  • A Book: This was not on my official list since I added it later in the year. I had given some thought and even wrote an outline and 1 or 2 chapters for an idea for a new book, but that didn’t come to fruition. Call is partly due to the Covid Doldrums.
  • Continue to enjoy life: This I definitely did. It was definitely a different year. In some ways 2020 was both harder and easier. 2020 at some point I think I simply accepted the fate of Covid and that we wouldn’t get back to normal until a vaccine was widely available. So I stopped getting my hopes up. 2021 was in some ways harder because with a vaccine, it was easy to get ones hopes up, but due to various surges and now Delta and Omicron, have them dashed again and again. I’ll say right here I’m frustrated and angry with those who continue to ignore the science and tout conspiracy theories about the vaccines and refuse to take them for “freedom” and the like. But I’ll save further thoughts for another day.

Tomorrow I’ll post my goals and hopes for 2022 (and one will surprise most of my readers!) (yeah, a bit click-baiting there!)

But in the meantime, for the close of 2021 (and for some the bell has tolled) let me wish you a happy and safe end to the New Year. If you do insist on going out, be safe, and for the love of all that is holy, and for the sake of my friends who will be working in EMS and elsewhere tonight, do NOT drink and drive!

P.S.: I will link two fellow bloggers who are also ending their blogging year:

  • Steve Jones – The End of 2021 The amount this man writes is simply amazing. Follow him if only for his Daily Coping tips.
  • Deborah Melkin – My 2021 In Review Deborah doesn’t blog as much as Steve (but who does) but when she does, it’s top notch.
  • If others have year and blogs, I’ll add those here if they want.

Happy Solstice 2021!

I like when the day I blog lines up with a holiday, or some sort of astronomical event. it gives me a ready made topic.

And so in that theme, this post will be similar to the day: short.

Several years ago (it feels like a lifetime) my family and I flew into Manchester UK so I could speak at a SQL Saturday there. I hadn’t really given thought to how far north it was and the fact that it was close to the Summer Solstice, but I woke up at 4:00 AM local time and it was basically no darker than twilight I was a big groggily confused. Once I was finally awake later in the day I realized why it was so bright at that time.

Manchester UK Daylight Map

This time of the year it’s the opposite. I wake up at my normal time (generally around 6:30 to 7:00, the time varies as I almost never use an alarm clock) and it’s still fairly dark and I have to check a clock to make sure if my body’s clock has really woken me up in time for the day.

Troy NY, US Daylight Map

Between shorter days and the fact that my largest client client is basically in a freeze period, my days are fairly empty, at least in terms of workload. The amount of darkness and lack of work does cause a lack of motivation for much, including writing this blog.

But, that’s belayed a bit by the fact that both kids are home from college, one until her next semester starts and the other until he discovers what life has to bring now that his college career is finished. Like me on the Winter Solstice, one thing is ending and the future seems limitless, perhaps a bit overwhelming. But it is ultimately something to look forward to.

Days are starting to get longer, and in 10 days, a New Year will begin, and I look forward to what that will bring.

In the meantime, I’ll enjoy my Christmas Music, have the lights I inherited from my grandparents lit (technically just the strand, I think I’ve replaced all the bulbs at least once, and they’re getting more rare and more expensive!)

So, here’s to longer days and a better New Year.

And see, I told you this would be a short one, much like the day.

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!

More Thoughts on Scott Alarik and Others

I’m sitting here listening to The Hudson River Sampler on WAMC a local Public Radio station, hosted by Wanda Fischer and reflecting more on Bill Staines and Scott Alarik. There’s a lot to reflect upon, but I’m going to comment on just a bit.

First is a quote from Scott Alarik talking about folk music and how memory is how a person remembers, but tradition is how a society remembers. He then talked about how we can tell what was important to a society by what is preserved and what we hear years later and how we can be drawn back in history by tradition.

But the other thought is a basic tautology: every performer has their own style of performing. This reminded me first of the two “worst” folk performers I’ve heard over the years. Now, worst is relative. Neither technically were bad performers. Technically they were competent and their performance enjoyable, but…

In the first case, it was a performer who performed at Mother’s Wine Emporium at RPI. I honestly don’t remember who it was, but they did their two sets, and at the end of the evening asked for their check, which I promptly handed to them. Now, let me point out here, that as much as many performers loved performing, performing was the way they put bread on the table. Performers who appeared at Mother’s were professionals and we paid them as such. But… In all my years of interacting with performers this was the first, and only, that treated it simply as a job. There was nothing more there. I think they would have put in the same effort with no crowd, or with the largest crowd ever. I’d say their heart simply wasn’t in it or something. That’s fine, but not what we wanted.

The second performer was one my wife and I caught at a lodge on the Skyline Drive in Virginia. We were staying there for the night and during dinner, there was live music. The performer setup, and segued from a warm-up into the performance. He was quite good, and he had some good monologue to go with it, but unfortunately he failed to make any attempt to connect with the audience. It was a shame because there was another family there with young kids and I suspect they walked away without any sense of the specialness of the music. From his demeanor and comments, I suspect this was a regular gig he did every week and was simply a bit jaded. Which is a shame.

This is not to disparage either performer, but more to offer a contrast to other performers such as Scott and Bill.

Bill loved to perform, as the mileage on his car, and the name of 2 of his albums suggested. I don’t think he’d pass up a chance to perform. And despite how many performances he did, I always felt like he was there for the audience. He’d give his all and the audience always enjoyed it. I think the bigger the crowd, the more energy he’d give and make the room feel all that much larger. He could make a small room feel like a concert hall.

But listening tonight, I realized Scott had a very different style, one that worked for him. I’m not sure Scott ever was performing for the audience per se. He was performing for himself, but inviting the audience to come along for the ride. As he’d sing, you could tell he was enjoying the songs and if you joined him and enjoyed the show, great, but if not, he was going to enjoy it anyway. It was almost like being invited into the inner sanctum of his mind. In his case, no matter how large the room, he could make it feel like an intimate, small space where it was just you and him.

Both had their styles and I enjoyed both and will miss them.

Life Shortened

As I start to write this, the TV reminds me, that this is the 80th anniversary of the attack on Pearl Harbor; and that there are still a few veterans alive from that day.

This is both a somber note, and a somewhat celebratory one to start the day. Horrible things can happen, and yet life can still go on. I was reminded of this over the weekend.

I woke up on Saturday morning to read on Facebook that Scott Alarik had passed away. Some of my readers will recognize the name immediately, but for those who don’t, a little background. Scott was a singer-songwriter who was also a columnist for the Boston Globe and write a book on folk music and wrote for a number of other columns. I first met Scott at Mother’s Wine Emporium so many years ago. He had performed his opus Fresh-Water Whaling, telling the little known history of the glory days of whaling on the Great Lakes. I must add that the history is so little known as to be non-existent. But, for those who do recall it, remember those little harpoons you sometimes find in drinks memorialize it. Or so it was said by Scott. As much as Scott liked to sing, I think he preferred more to talk and write. He was a living, walking history of the world of folk music. I still recall one night, after he had performed at a Mother’s Wine Emporium show at RPI where we discussed “what exactly is folk music?” We agreed it was “music of the folk” but beyond that we decided it had no easy definition. As I write this, I’m listening to the first video I found on YouTube and it is Scott at his best. Yes, there’s a song or two in there, but mostly it’s him telling stories. It’s as I remember Scott.

Scott Alarik at Mother’s in 2019

That news was hard enough, but to myself I said, “at least Bill is still with us.” I had read late last month that another singer-songwriter I knew, Bill Staines was fighting cancer and the battle was not going well. Alas though, on Sunday I woke up to more tragic news. Bill had journeyed to the next folk stage. Bill was another performer I had met through Mother’s Wine Emporium many years ago. I have several of his albums, at least one I believe signed. He was known for the prodigious miles he would put on his car, I believe at one point he said he averaged 100,000 miles a year, as he drove from performance to performance. Three of his albums reflect this: The First Million Miles, The First Million Miles, Vol 2, and The Second Million Miles. His best known song was perhaps River,(Take Me Along). I think his final journey though is longer than all his rest.

Finally, later on Sunday I also read of the death of fellow caver Mark Hodges. I can’t say I knew Mark very well. I want to say I caved with him at least once, but I honestly can’t remember. But I knew the impact he had on the cavers around him. He apparently suffered a heart attack while exiting a cave over the weekend. The tributes left to him from his friends and fellow cavers are touching and serve as a reminder, that one doesn’t need to write books, or travel 100,000 miles a year to have an impact on those around him.

I’m going to close with a memory of another friend and also former “Mother” at Mother’s Wine Emporium: Tom Duscheneau. Tom was a fixture at Mother’s for more years than I can remember, and many an attendee will recall him taking a seat at the front of the room, settling in as the music would wash over him, and closing his eyes. Yes, occasionally he’d need a nudge if had started snoring, but otherwise he would simply sit there, soaking in the music until the set ended. He passed in 2006, but I still recall him from time to time. I suspect if there’s a great beyond, he’s just pulled up a chair and sat down, preparing to take in a great concert as Scott and Bill decide to tell a few tall tales and perform a duet or two.

Mother’s Wine Emporium aka Mother’s Coffehouse – For those who don’t know what Mother’s was, it was a magical place at RPI, a place where one could retreat from the hustle-bustle of the busy world and sit back and listen to singers, raconteurs and more. It had moved at least once over the years (the above photo is the latest incarnation). For the longest time, it was the oldest, continuously student run coffeehouse in the nation. Scott liked to talk about how if you made it here, you knew you had probably gotten your ticket to the college coffehouse circuit. Those of us who had the honor of working here were known as “Mothers” and it is were my wife and I met. Due to a variety of circumstances, including the death of Tom Duscheneau, it had its last show sometime in 2007. In 2019, I worked with the RPI to bring back Scott Alarik for a performance, with a hope for future shows. Covid has unfortunately put a hold on that plan, but I do hope in the coming years to again sit back and soak in the music of some great performers.

Feeling Good but…

I think it would be fair to say that like everyone, I’m a bit sick of Covid (thankfully not sick from it.) I just got my booster on Friday and then I’m hearing about the Omicron variant.

I submitted talks for SQLBits in the UK for next year, hoping to present in person. And I’m hearing about numbers rising.

I’m planning a mini-vacation/cave rescue training trip to Hawai’i next year and making sure everything is refundable. Just in case.

So I’m feeling god but…

At the start of each year, I set some financial goals for myself. Some include what things I may pay off, save, or how I’ll spend it (now admittedly most of those are fixed, such as knowing I’ll tax property taxes, etc.) As a contractor I also set a couple of various goals for new work and how much I’ll hopefully earn in the coming year. I find these are important as they help keep me focused and moving forward.

The good news is, financially I’ve hit all my goals, and then some, this year. The downside, with that, and with Covid continually popping up its ugly head, I’ve lost some of my motivation for the rest of the year.

Fortunately, this has freed up some time for some projects around the house. Almost two years ago, with help from the kids, I started on a project to replace some leaking pipes and replace the resulting damaged drywall in the basement. I’m proud to say I’ve finally gotten around to taping and painting the drywall in the basement and patching around where I put in the new bathroom fan. Things get done, albeit slowly.

I’m also feeling good because a major project for one of my clients is mostly completed. But it also came very close to burning me out and I’ll admit I even considered walking away from the client over it. The strange part is that it wasn’t a particularly complicated project, though it did involve a combination of SQL, PowerShell, and using a product called Pentaho. Technically it was fairly straightforward. But, for awhile, the project management was absent and the then lead was actually another agency who, I think it’s safe to say didn’t clearly understand the full scope of the project. With the addition of the client adding their own PM and working with a different agency taking over a bunch of the work, things have gone much more smoothly. Now we’re simply dealing with small niggling details that got missed before.

What kept me from walking away (besides it being my largest client) was a sense of responsibility to the client. Without my efforts, I think the project would have easily been set back a month as they would have had to bring someone else up to speed on my efforts.

Now the upside is that because of the overtime required (and it’s still ongoing) I met my financial goals for the year (and hence now have time for the house projects). So that’s a good thing.

But it did highlight how frustrating being a single-person consulting agency can be at times. It’s made me re-evaluate my goals for 2022. I’ll be writing more about this in a future blog, but it has got me thinking more about getting back to working for an company as a full-time employee, ideally in a management position. Strangely one thing I’ve come to realize is I actually enjoy making decisions and I enjoy managing. I sort of miss it.

And perhaps after nearly 2 years of Covid (and nearly a decade of pure consulting), it’s time I get out of the house more and travel a bit and interact face to face with people.

We’ll see.

But that’s it for today. I’m feeling good but…

P.S. One thing I did finally accomplish is submitting my latest article to Redgate’s Simple-Talk.

Thanksgiving 2021

One of the holidays I’ve really come to enjoy over the years has been Thanksgiving. It’s also perhaps the one that has varied the most in my life. One of my earliest memories of it was when my parents were still married (I believe) and spending part of the afternoon playing some tag football with some friends the next street over in Falls Village. (Part of the reason that day was so memorable was the inadvertent discovery of some dog crap after sliding through it!)

After my parents divorced, typically my father and I would go to my paternal grandmother’s house in New Haven and then go out to dinner. She never cooked, for a variety of reasons, including the fact that her kitchen was rather cramped. I recall one year having to shovel out her driveway so we could get back out. Her house was a converted carriage barn at the bottom of a hill in the Westville part of New Haven.

We did this tradition for as long as she lived. But once she passed I decided to take up the tradition by doing it, first at our apartment in Troy, and then later our house. Over the years various friends and members of the family have joined us.

Thanksgiving 2014

While in college, I also did a few early-bird Thanksgivings with a couple of the groups I was involved with. One literally was an “early-bird” where it turns out the students responsible for cooking one of the two turkeys didn’t thaw it first and brought it to the event in a half-raw state. Fortunately my mom caught it in time, mentioned it to Dean Dave and we sidelined that turkey! Thankfully the second turkey was properly cooked and we could enjoy that and the other sides and desserts, including the apple pie I brought.

At some point my dad, who was never much of a cook himself, but enjoyed spending time with his family, suggested we start rotating it from year to year. He went so far as to buy a gas stove (haven gotten rid of the wood-fired kitchen stove well over a decade previously) just to have a place to cook the turkey. I suspect it’s the only time of the year the stove got use. Part of the tradition while driving there, at least for me, included tuning the radio until I could find at least one station that was playing Alice’s Restaurant (that’s the name of the song, not the restaurant of course). One year, we even took a very slight detour and took some photos of the family standing outside of a particular former church in West Stockbridge. (I should note, somewhere in the dirt bike race scene my father has me nestled in his CPO jacket while he’s standing next to my mom. Both were extras, as I suppose was I.)

We also would then on the third year, go to his half-sister’s house outside of Boston where she would host. One one hand I missed hosting every year, on the other hand it gave me a chance to enjoy someone else’s efforts. Unfortunately, this tri-yearly rotation did not last overly long. I think we got in two dinners at my father’s before 2015 when he passed away.

Since then, while we’ve enjoyed a few thanksgivings at my Aunt’s, both last year and this year have conspired to prevent us from gathering with here. Last year it was strictly due to Covid and this year, to other health issues. It’s frustrating as we’d love to see her again.

My Dad and my Aunt Thanksgiving 2013 in Boston

So, on Thanksgiving, I will miss my father and my aunt. But both kids are home from college, my mother will be joining us (since her mother passed several years ago, she’s started doing Thanksgiving at our house when it’s held here) and perhaps a few others.

I’ll watch the Macy’s parade while preparing the turkey and fixings and catch part of the Great American Dog Show.

We’ll go around the table before digging in and each give thanks for something in the last year. I think it’ll be easier this year than last year when the days were darker, not only because of the angle of the Sun, but also the general temper of the year.

And then, at some point, later that evening, probably around 8:00 PM, I’ll go to the fridge, carve off some leftover turkey, grab some mayonnaise, a dash of salt and bread and make myself a turkey sandwich.

Thanksgiving 2011

No matter where you are, or who you are with, I wish you all a Happy Thanksgiving. And here’s looking forward to 2022.

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.