Another Regret and Another Milestone

I blogged a few weeks ago about a few regrets I’ve had since leaving behind being a DBA but I was reminded of another just over a week ago. It’s an event that combined two of my favorite things: SQL (or more accurately #SQLFamily) and trains! And that’s… SQL Train!

No, it’s not a new Microsoft product or something. It’s an event when a bunch of SQL DBAs and others take the train from Portland Oregon’s SQL Saturday event up to Seattle in prep for the PASS event. So you already know it’s a great group of people. And of course I love riding Amtrak and that’s one segment I haven’t ridden yet, so I would have enjoyed it. It’s something I have been meaning to do for years but never got around to it. That said, I’m sure if I showed up in a future year, I’d be welcomed by my SQL Family, it’s how they role.

That said, this weekend I did something new: I acted in a movie. Technically it’s not my first, but it’s by far the most involved I’ve been. A bit of acting, my daughter is in her senior year of film school and needed a “dad like person in their mid 50s” for a role. After not being able to find someone local to fill the role, she asked me. This involved me leaving work at 3:30 AM Friday after my shift ended, driving a bit, napping for several hours, getting gas, a bit more of a drive, napping again, driving, getting some food, I finally showed up on set. Total, I spent about 6 hours on set on Friday, and 10+ hours on Saturday and 8+ on Sunday.

I’ll admit between short notice (less than a week) and little time (5 12 hour shifts in that week) I wasn’t as prepared as I’d like, but I managed to get most of my lines right.

I’ll say this, as much fun as it was, I do hope I’m a better PA than I am actor! I’m not about to give up my night job.

And that’s it from here this week.

2023 A Year in Review

Well, it’s that time to look back on the year and see how I made progress on my goals for 2023.

  • It was a mixed bag. For one thing, I was looking to up my patient contact hours to hit the minimum required to apply to my programs. I hit 1000+ hours by the end of April. I’m now at over 2500 hours and closing in on 3000 hours. (For those doing the math, yes, that’s over 2200 hours this year alone. That’s on top of my IT work and taking classes!) The nice thing about these numbers is they put me above the average for all the programs I’m applying for.
  • And yes, I said applying for. While a goal for 2023 was to get accepted into a PA program, it didn’t happen. I will admit it’s been discouraging. It became even more discouraging to learn, via email, that one of the programs I had the most hope for, despite not having an official minimum GPA, hasn’t accepted anyone below a 3.2 GPA in the last 5 years. I’m not irked so much about that number, but as much about how they market the fact that they don’t have a minimum when effectively they do. Oh well. Now the good news is, I did get wait-listed at one program. We’ll see how that progresses. I’m undecided on if I’ll actually attend if I move from wait-list to accepted. And there’s at least one long-shot of a program I have yet to hear from. So we’ll see.
  • But, I will be applying to a number of the programs again this year. I’ll have a stronger resume in a number of ways, so I’m more hopeful. But I’ll be honest, if I don’t get accepted this year, I may explore other options in my life. If I were 5 or 10 years younger I might consider a lot more rounds and work more on my GPA, but the truth is, I’m not as young as I might like to be.
  • That said, I did get a lot of classes in over the year, including the microbiology class I needed. This was sort of a freebie. My employer, Albany Medical Center, offers this free to its employees over the summer, so I took it then. It was actually a lot of fun and I have to admit, I was a bit surprised to learn how much had changed since I took it 30+ years ago. Science really has marched on.
  • In addition, this fall I took Genetics. Not many programs required it, but one or two did and I figured I’d add it to my transcript. I’m glad I did. While the mechanics of the class was a bit frustrating at times (all virtual, some lectures had no videos, only PowerPoints), it was really interesting and I learned a LOT.
  • For my NCRC work, we will be hosting the 2024 National Weeklong here in NYS and I’m the site coordinator, so I’ll be getting busier and busier as June approaches. Interest has been great. We filled all the available class slots in 25 hours and as of today have 13 waitlisted for Level 1 and several each for Level 2 and Level 3. And as for TOTS, our medical focused class, I think we have a curriculum and will be asking for approval to do a trial teaching of it this year. So that’s all coming together!
  • I mentioned continuing to blog, but the truth is, I didn’t blog as much as I used to. Between needing sleep (see above about working, school, and more) and not having much to say, I just didn’t blog much this year. Oh well.
  • Reading: Honestly, I dropped the ball on this. I expect to continue to do so. I did reread Echo Heron’s book, Intensive Care: The Story of a Nurse. I recommend picking up a copy.
  • My goal of speaking once this year didn’t come to fruition. I was hoping to be picked to speak at Pass Summit about how to do a career change, but wasn’t accepted. Oh well.
  • I can’t say I saw more of my friends, but I did see a number. I also worked on schedule changes, twice now, so that should free up more time. So time won’t be a huge issue, but money will as I’ll be being frugal to save up money for PA School. But hey, let’s get together!
  • Septic System: well we got the design approved (that only cost around $10K!) but didn’t get it in this year. We’re hoping to get the quotes and get it started as soon as Spring comes.
  • Hiking, Biking, Caving – I did far less than I’d have liked. That’s all I’ll say for now. I will add though that I’m feeling a bit older and my body reminds me of it.

One thing that was NOT on my list of things to do, but happened anyway, was serving on a Grand Jury. On top of serving, I was also the jury foreperson. This was quite an experience. I saw a lot about how the justice system works and as foreperson I got to swear folks in (which I’ll admit, is kind of cool) and also review the final paperwork before it was sent to the judge.

So, that’s my year in review. Stick around until tomorrow and I’ll see what my goals for 2024 are. Hint, a few of them are listed above already!

And thanks for everyone who was with my on this journey through this crazy thing we call life.

Missing SQL Summit

I’m not going to be at Summit this year. And I have mixed feelings about that. This would have been my first in-person Summit since 2019.

I had hoped to go. In fact moreover, I had hoped to present. I even had a topic submitted on exiting the industry. As many of you know, my plans are to get into Physician’s Assistant school and change careers and become a PA. You can read about my adventures in numerous posts here. So I figured, instead of the plethora of talks on “So you’re new to being a DBA” or similar, I’d offer the opposite, how to exit the industry in a positive and productive way. But as a hedge, I made sure to buy a ticket at the early bird pricing, figuring if I was accepted to speak I could get a refund then.

Sadly, my topic wasn’t chosen. That said, if you’re interested in hearing it presented, let me know. Just give me enough time to actually finish writing the presentation.

But at least I had a ticket. I was set.

But then I started to wonder. Was it worth the time and money? I don’t make a whole lot as a ED Tech, and I’d be using vacation time, so I wouldn’t actually lose any money, but I also wouldn’t be able to pick up extra shifts. And of course I’d need flights, and a rental car (I stay with friends so lodging was covered). And I realized that the main reason I wanted to go was to see my #SQLFamily. And I’ll say, that’s not a bad reason. But it’s also not inexpensive.

I finally started to put feelers out about selling my pass, but wasn’t really pushing it. And then, Grand Jury duty happened. There’s a decent chance I could have impressed upon the judge how important it was for me to attend Summit, but I didn’t think that was really right. Though, had I been selected to speak, I think I’d have made that argument. It wasn’t clear exactly when my Grand Jury commitment would end, but it was fairly clear it would overlap with Summit, and it has. Though, in a cruel twist of fate, it appears that we will in fact finish up this week!

But enough about why I’m not there. I’m here to say, I miss you all. I miss the lack of sleep, the plethora of food, hanging out on the couch at Minionware, getting massages at the VMWare booth, catching up with friends, oh and actually learning about SQL Server and the entire Microsoft data platform.

I’ve been giving my departure from the SQL arena a lot of thought and a phrase keeps popping into my head, “the long goodbye”. For now it’s not a binary process. It’s not “one day I’m a DBA, the next a PA”. For now it’s more of a DBA by day (and sometimes nights and weekends) a student taking pre-reqs (and in fact just took notes on a prerecorded genetics lecture this morning) and an ED Tech by night and weekends (and sometimes days). But I’m drawing back. I can’t recall the last presentation I gave. I haven’t signed up for SQL Saturdays. I barely attend my own local User Group. Even my consulting hours have been cut back.

But every day I’m more and more sure I’m making the right career move. I find myself missing my IT work less and less.

I’m saying good-bye, slowly. And sometimes it’s bittersweet.

This is not my final goodbye. I don’t know if there will ever be a final goodbye to any of you. But for now, however, you all… I miss you. Enjoy Summit for me!

Transitions and Regrets?

I was originally going to write a bit on the death of Queen Elizabeth II and reflections of mortality in general but thought I’d talk about a bit more about a more personal change.

It’s not news to my readers that I’m working to get into PA School. If all goes well, this means eventually I’ll move completely out of being a DBA and purely into the medical world. But this is not a quantum leap (which I have to say, I was pleased with the premiere of the new series last night). Things are not happening over night. I still have course work and patient contact hours to get in. The process is somewhat gradual. But, due to a biological need to sleep, it does mean I need to balance my obligations and in some cases turn my back on certain things.

I was reminded of one of those yesterday: PASS Summit. I’ve written about my previous experiences here and here and more. I’ve really loved my time visiting Seattle to attend it. I also enjoyed presenting, albeit it virtually. Besides being a great opportunity to meet with vendors and to attend a LOT of great sessions, it’s a great place to make friends and to catch up with friends. And yet, I’m not going this year. Under the old scheme, I had the advantage of being a User Group leader and as such getting a free pass. This helped me cost-wise, which as an independent consultant was a bonus. That wasn’t available this time around, so that figured into the decision a bit. But perhaps far more decisive was that I really don’t feel like I can take the time off from school.

What makes this doubly tough on me is that there are a lot of friends I really was hoping to catch up with in person and the fact that for the first time, I’d be an actual Friend of Redgate, an honor I’m proud of and with Redgate being the folks in charge, something I wanted to be more a part of than in the past.

I also did not put in to speak this year, because I knew I’d have classes during this time. I had been excited to be picked in 2020 to speak. The impact of Covid forced the conference to go virtual which dampened my excitement some.

So at the end of the day I had decided not to go and pushed the decision to the back of my mind. I figured I had no real regrets.

Then yesterday, a client asked me some questions about Summit and asked me to suggest some sessions that his people might get value out of and to give him some other notes about Summit.

So I had to pull the scab off the wound and to look at all the sessions. I of course saw a lot that applied to my client, but also some I knew I’d be interested in. And of course I saw easily a dozen names of people that I knew. This reminded me how much I’ll miss the social aspect of Summit. So it hit home. I’m going to miss Summit. The regrets are there.

I’ve given a lot of thought over the last 9 months about how my decision to apply for PA School would impact my life. Slowly pulling away from the #SQLFamily is one of them.

This doesn’t mean it’s going to be a complete break just yet. I actually have hopes of applying to speak at Summit next year since by then I should have all my pre-reqs done and have the time to attend. But in the meantime, I have to sometimes pull back from #SQLFamily events to focus on school and I’d be lying if that didn’t hurt a bit. What smooths this some though is exactly how much I’m enjoying my work to move towards PA School. So, on the balance, it’s worth it so far.

T-SQL Tuesday – The Conference That Changed Everything For Me

My faithful readers get a double dose today, only because when I wrote my earlier post I had not yet seen the invite for this month’s T-SQL Tuesday. Otherwise I would have started with this post (and perhaps written a better version of it. This will be a bit hurried).

Like many I’m picking PASS Summit. No, not very creative, but true and accurate. I should note my first conference was SQL Connections back in I believe 2006 or 2007 in Orlando and that had a fairly important impact on me too. But my first PASS Summit in 2015 had a bigger one. I managed to go in the place of our SQL Server User Group organizer provided I attended the User Group update the day before and also represent us officially in that capacity. I of course did both.

But I also had an ulterior motive for going. Two of my best friends from college lived in Seattle and I had not seen them in years, in fact in well over a decade. So it was a good chance to catch up with them. (Let me just say, flying from the east coast to the west coast and trying to go to bed at 1:00 AM West coast time, but waking up at 7:00 AM doesn’t work well!)

That said, the real reason this conference was so important was because I met Kathi Kellenberger @AuntKathi. She gave a presentation on how to get published. For years I had given thought to writing a book and with the recent death of my father, who had always wanted to write the Great American Novel this seemed like an interesting session to attend. She of course gave a great presentation. I spoke briefly with her afterwards and then went on to the next session. But her session stayed in my mind. Later that day I tracked her down and asked further questions and before I knew it I was introduced to her rep at Apress.com. Very quickly I was discussing my idea with him and before I knew it, he expressed and interest and suggested I submit a more formal idea via email. Within a few weeks of the conference I did so and my idea was accepted. That was the easy part. Translating my thoughts to paper was a bit harder. But a year later by the 2016 Pass Summit I was a published author. My dad wasn’t around to see it, but the book was dedicated to him. It wasn’t the Great American Novel and honestly, sales never lived up to even my more pessimistic expectations, but that doesn’t matter. Someone paid me for my writings! And you can still buy a copy of IT Disaster Response: Lessons Learned in the Field, my take on combining IT Disaster response with thoughts on plane crashes and cave rescues. It’s not the most technical book, nor was it intended to be, but it was meant to be sort of a different and more holistic way of looking at responding to disasters. Instead of talking about “do backups like this” it talks about using ICS (Incident Command System) and CRM (Crew Resource Management) techniques to help respond to your disaster.

I’m not here to sell you on my book but talk about how that one conference and that one chance encounter with the right person changed my life. But I won’t stop you from buying it. It’s a quick and I thikn fun read! And you might even learn something.

I’ve enjoyed all my PASS Summits, including 2020 when I finally had a chance to present (albeit remotely) and SQL Saturdays (where I’ve learned a LOT and owe too many people to name a great deal of thanks for all they’ve taught) but that first Summit was the one that probably had the most impact.

Thanks for reading.

T-SQL Tuesday #148 – Advice on Running a User Group

Today’s T-SQL Tuesday edition comes from Rie Merrit and she is asking about “Advice on Running a User Group.”

Fortunately she’s only asking for 1-2 ideas, not an entire book (though there’s at least one book out there on the topic, which I’ll admit I’ve skimmed but not read cover to cover).

It Starts at the Door

This is actually an area I’ve not done as well in as I’d like, but I’m going to continue to work on. For your in-person meetings (we remember what those were like, right?) find one of your more outgoing, sociable members, ideally someone who is good with names and details, and position them by the door to greet people. When someone new comes in, this person should make sure they get their name, ask them if they have any particular interests, and then introduce them to others, ideally with similar interests.

It can be very intimidating to walk into a new User Group meeting where you know no one, and every already there is already happily chatting away and you end up feeling like an outsider.

By assigning someone to the role of greeter, ideally any new person instantly can be made to feel welcome. Besides simply introducing them, the greeter can explain how things work in terms of schedule, where the bathrooms are, where food is at, etc. This keeps newcomers from feeling lost and left out.

On the flip side of this advice, the greeter has to make sure they’re not too enthusiastic either. If the newcomer indicates they’d rather just sit in the corner and listen and leave, that’s fine too. The goal isn’t to force everyone to socialize. The goal is to make it easier for those who wish to.

I can guarantee that if you make people feel welcome, they’re more likely to come back.

It Pays to have Sponsor

Or more accurately, its sponsors that make it possible to pay for food and other costs. Several years ago at a User Group Leader meeting at PASS Summit, I listened as a speaker talked about looking for sponsors you might not normally consider, i.e. going outside of getting sponsorship from technical companies. This has worked really well for me in the past. But before you even go that far, you need to get some data. And since we’re DBAs, we should be good with data. I recommend once a year, collecting data about your group with some questions such as:

  • How many people receive your weekly or monthly emails. You don’t need an exact number, but is it 100, 300, 500, 1000?
  • How many people typically attend your meetings? (and now ask in-person versus on-line if you’re doing hybrid)
  • Where are they coming from?
  • How many years have they been in the industry?
  • Do you have a breakdown by age range?

You’re trying to get a sense of demographics. This will come in handy when you look for sponsors that are non-technical (for technical sponsors you will want different demographics). But with the data from my group, I have approached a number of different sponsors such as banks, insurance agencies and the like. My sales pitch is generally along the lines of:

I can put your name in front of 400 people via email and 20-30 people in person that are in your demographic (generally 40-50 years of age, higher income) that are probably in the market for your services (such as life insurance, investment opportunities, etc).

I’ve had a lot of luck with this approach. Sometimes I’ve gotten a check right there, sometimes they’ve had to go up their chain of command, but now they have data to sell the idea to their boss. And sometimes, you find out a prospect is not a good match. This happened with me when I approached a contact at the local, then new casino. Turns out their target demographic was older, retired women. Apparently they spend a lot of time and money at the casino. In contrast, mid-life professional DBAs don’t gamble much!

The other key detail when approach a sponsor is being clear on what you’re selling them. You probably recognize this without really realizing it. At any conference you’ve been to you’ve seen Platinum Sponsors, Gold Sponsors, etc. The more someone is willing to pay, the more mention they get, the bigger their logo may be featured, etc. This works for user groups. My advice here is to not overdue the number of sponsorships and to deliver on what you promise. For my group, pre-Covid, I would typically try to have no more than 3-4 sponsors at a time, and total over a year, perhaps 6 or so. Some sponsors would sponsor for 3 meetings, some for the entire year. There were discounts for an annual sponsor as opposed to a quarterly sponsor. If you were a quarterly or greater sponsor, besides having your logo in emails and being mentioned from time to time, you were given the opportunity once a quarter or so to give a 5 minute pitch before the group. Some took advantage of that, some didn’t. But I have to say those who did, I think made a better impact when they could introduce themselves and point to the food and say they were glad to sponsor our group.

I’ll close with one final comment on sponsors: not all need to provide a direct financial contribution. We have a local hotel that has provided us 1-2 free room nights a year. We typically use one to put up a speaker who is coming in from out of town, and the second as part of our annual holiday raffle. We also had the local garbage collection company provide a free year’s service as a prize for our annual raffle. That was surprisingly one of our more popular prizes. In SQL Server you don’t have to worry about garbage collection and for a year neither did one of our DBAs!

In Conclusion

I can’t speak for other user groups, but I do know we’re probably very close to going back to in-person meetings in the near future so I’ll be dusting off the playbook and doing the above as well as other things in order to build up our successful in-person attendance again.

I look forward to seeing what other group leaders advise!

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.