F’ Cancer

This year I’ve lost two people close to me. Both died of cancer. Their deaths have hit me in different ways. Both were linked to each other and to me through caving.

I obliquely referred to the first in a post earlier this year. Don Paquette was a friend, colleague and mentor. His intensity could easily fill a room. As an instructor, he was quick to let you know where you stood. I know some thought he might be overly harsh or strict or that he might have unreasonable standards. But the truth is, he simply wanted everyone to try their best. He didn’t necessarily expect everyone to be perfect in the skills taught. But if he thought you could do better, he’d push you to do so. And deep down, he cared.

Don was known for judging how well students would lay out the gear cache during training. He felt strongly that a well laid out gear cache was a key part of a well-run and organized rescue. In the last few years of his life, when he couldn’t make it to training, I’d text him a photo of a cache and wait for his grade so I could report back to students.

Don might give this a B on a good day

He also was an advocate of what some might call a “Command Voice”. A command voice was more than simply being louder than the rest, it was a tone that caught your attention, made you listen, and moreover, want to to do what was asked.

And that’s where Cordelia Ross enters the picture, or Cordie as we all knew her. I first recall meeting Cordie at the NCRC weeklong in Indiana in 2009. I was helping to teach the Level 2 class, along with Don, while Cordie was taking it. During much of the week, Don kept encouraging Cordie to be a bit louder and more commanding. This wasn’t exactly Cordie’s style however.

Cordie is on the left

We were doing an exercise in Sullivan Cave. The students weren’t quite as organized as they could have been, but as one of the goals of Level 2 is to teach leadership, we as instructors were sitting back letting things unfold to see how the students would cope and if they’d organize themselves.

And then it happened. From the top of the breakdown pile we heard a loud and commanding voice: “Stop!” Everyone, and I mean everyone, including the instructors, stopped what they were doing and waited for instructions to come forth. I recall looking up at Cordie who then, in a much quieter but forceful tone started to direct her fellow students on what to do next. It took us instructors a second to realize that she wasn’t giving us commands. But her voice had been so commanding for an instant, had she given us instructions, we would have no doubt followed them. We liked to joke that Cordie had found her command voice. But she made it clear, she hadn’t found it, she simply had used the one she had had all along, but held in reserve until the right time. I tend to think she was right. After that Don never again gave her any flack about her lack of command voice.

That episode with Cordie really personified her to me. She was a petite woman, often surrounded by firefighters and cavers twice her size. But she was the mouse that could roar. Many might describe her as quiet, but that wasn’t true. When she did speak, it was with authenticity and power. Many might underestimate her, but never more than once.

In my final visit with Don, we talked about many things, including our times instructing fellow cavers. He reminded me of a time where we played a prank on a set of students on a haul team. He had a deep sense of humor. His death was tough and I grieved and still grieve for him, but also know that having lived into his 70s he had lived a good life. He had seen his kids grown and even watched his grandkids grow up. We often talked about his travels with his family on Amtrak. While I know he would have loved to live longer and had more to do, he expressed no regrets to me. He led a good life.

Cordie’s death though strikes a deeper chord. Her family was just starting. Just over a year ago she had given birth to her daughter, Viola. Her cancer diagnosis was a surprise and sadly didn’t give her enough time in this world. Her husband Wayne now has the unenviable task of being what some might call a “single father”. Technically that may be true, but I know there is a whole community out there that will help him. And much of that community will help Viola know the woman who was her mother. Whereas Don had much to look back on, Cordie had so much to look forward to. Cordie looked forward to being a mother and I suspect far down the road, a grandmother. She had so much she wished to teach Viola. And Viola, sadly will never grow up truly knowing her mother. The world is a smaller place because of Cordie’s untimely death.

Whereas Don and I talked Amtrak and travels, Cordie and I discussed New England (because she had gone to school at Dartmouth) and literature. Both were people to whom I had a connection far more than simply caving or cave rescue. Both are people that I dearly wish I could sit down with at least one more time and talk to.

Both I will miss but in different ways.

And for both, I say fuck cancer.

“What’s your favorite cave?”

Today I had the pleasure of co-leading some incoming freshman to RPI on a caving trip. I was asked a question I’ve been asked before and honestly, I don’t have a single answer for it.

“What’s your favorite cave?”

It sounds like a simple question, but honestly, I can’t easily answer it.

I can say that the cave I was in today, Clarksville Cave, is not my favorite cave. Though, if the question is qualified, “What is your favorite cave to take beginners into?” then Clarksville might be up there. It’s close to the road, easy parking and enough variation in terrain to make it interesting and challenging to almost any beginner.

A cave that ranks near the top of my favorites would be Eagle Cave at Chimney Mountain. Traditionally it wasn’t the easiest to get to, it was about a three-quarter mile hike up the mountain which could be strenuous. But parking was easy. That was then. Now, because some cavers or hikers could not respect the wishes of the folks who owned the parking lot, the landowners no longer allow parking on their land. This has turned the approach into a 5 mile hike. I have not been back since.

That said, the cave is a great one because unlike most in New York, it’s not solutional. It was formed basically by the side of the mountain falling away. It’s very different from most New York caves. But it’s also a 2.5 hour drive from home. So, is it my favorite? I don’t know. It’s got a lot going for it, but also has some drawbacks.

What about Knox? Great cave, I love it. And I’m thankful for the bypass to the Gun-Barrell, or else I’d probably stop going to it. It has a lot of variety and a lot to see. So it’s up there among favorites.

If I look beyond New York, I could add Flowing Stone as one of my favorite vertical caves.

Or I could add Tumbling Rock as it has some awesome features.

But what if I include commercial caves? (including National Parks) Then I might put Carlsbad up there. The large room is still one of the most impressive rooms I’ve seen in a cave.

Lava tubes? I can’t say I remember the names of too many, but there are some cool ones out there.

I guess I can’t say I have a favorite cave.

But I can say I have a least favorite one: Park’s Ranch Cave. No offense but…

And even then I have some fun stories to tell of it.

2024 A Year in Review

As I try to do every year, I look back at goals I set at the start of the year and see how well I did. As usual, this it’s a mixed bag.

How did I do?

  • Well, my primary goal was to get into PA School. Last year I had gotten waitlisted at one and declined at all the others. Close, but not close enough. This year started off rough. I was able to submit what I think was a much better application. I had a few more courses to add to my transcript. This helped bring up my GPA (though not above the magical 3.0 that most schools require for a cumulative GPA). But my last 41 credits were all 4.0 and if I include my last 60 (some schools have look back windows of 30-60 credits), it’s nearly a 3.7. Not too bad if I may say so myself. I submitted fairly early in the application cycle.
    In addition, I think I had a stronger essay for my application as well as better letters of recommendation.
    And then the first rejections rolled in. One was particularly disappointing since it was one of my top choices and they claimed to not have a minimum GPA. After exchanging some emails, I learned that while they claim not to, in fact in the last 5 years, they haven’t accepted anyone with a cumulative GPA under 3.2. That definitely felt like a bait and switch to me.
    However, the very next day I received the email that would change my life. In fact, I had to read it more than once since I was in shock. Even when I got the emails explaining how to put in my down-payment I have to admit I didn’t believe it! That said, for now I’m keeping the name somewhat under wraps as I’m still waiting to hear from two other great schools. But the key point is, regardless of what happens with them, I’m going to PA School in 2025!
  • Another goal I had was to keep working in the Emergency Department and keep my Red Badge status so I could be the lead tech in Traumas.
    • Not only did I succeed with this (as of last night over 2450 hours, including PTO) but I added to my resume the role of being the Tech who taught the Red Badge class to new techs. I’ll be handing that role over in a few months (and am already taking steps to make that happen) but it’s been a great job.
    • I also moved to night shifts for most of my shifts in the ED. Honestly, I love the crew and atmosphere, but it’s done shit for my circadian rhythm and for planning day events.
    • One benefit of another year in the ED is I got to become familiar with a lot more procedures and help out with a lot more than I did in the previous year. These are skills and experiences that will aid me well when I start taking classes.
    • More than once I got to listen in as an attending gave an in-depth “lecture” to a resident or med student. Also very valuable!
  • I definitely cut back on my IT consulting. My largest client and I mutually agreed to part ways as of April 1st. This was refreshing in many ways, even if the drop in income was noticeable. Ironically enough, they approached me just before Thanksgiving asking if I was available part-time starting in January. I’ve agreed to pick up some more time with them. This will most likely result in me cutting back some hours in the ED, but as I don’t need to built my resume there, I think it’s financially it’s a wise choice.
  • Work on me and be a better person – I was intentionally a big vague here, but I think I managed this a bit. I definitely tried to relax more and snap less. I’ll continue to work on that.
  • Hiking – I absolutely failed at this. I think I did one hike this year.
  • Biking – I also absolutely failed at this. Honestly, I’m not sure if it’s a result of age, perhaps some long Covid impact lung capacity (though I’ve never tested positive for Covid) or what, but I just found it harder to do the longer rides I preferred doing, especially at the speed I wanted. I also think the fact I was working nights and sleeping days didn’t help.
  • Caving – Ironically, despite having the NCRC weeklong in NY this year, I didn’t get into caves much this year. The best part was taking a local reporter into a local cave during our mock rescue.
  • See friends – Again, with my schedule, I didn’t do as much of this as I wished. And tonight, when normally we’d have a lot of folks over, I’m self-isolating because of a cold (not Covid thankfully).
  • Travel – this is one that Randi and I did manage to do! We flew out to Seattle and stayed with close friends for a night before boarding the Empire Builder for Whitefish Montana. There we disembarked and spent 3 solid days exploring Glacier National Park. Let’s just say 3 days is not nearly enough. When done we took the Empire Builder from Whitefish back to Chicago where we stayed a night at a hotel and then flew home. I’m already trying to figure out how to get back!
  • Septic system – Let’s not talk about this.
  • Several Projects around the House – well, just one, but it took finally biting the bullet and getting a table saw. But I think I’ll work on a few more before moving away for PA school.
  • Classes – I did take one more. If I had more time I might have taken more, or had I not gotten into a PA school I might have taken more to help with my transcript, but decided to focus the time on relaxing and working nights more.
  • Blogging – well I did blog, and as promised, not as much. So I guess I succeeded on that one.

So overall, us usual some hits, some misses, but the biggest hit is one I really was working for, so I’m content.

2023 A Year in Preview

Another quick post because another day where I have to be in the ED acting as a tech.

As I mentioned yesterday, I need a minimum of 1000 hours of patient contact time to apply to most of the PA schools I want to apply to. I’m literally hours short of 1/3rd of that. I’ll pass the 1/3rd mark today. This is just over 2 months. I’m confident I’ll make the deadline and add many hours to spare.

  • So that’s goal 1. Getting enough patient contact hours to apply to PA school. I’m well on my way!
  • Next, is finish my academic prereqs. I had to add a class to my list. I had taken Microbiology as an elective for my undergrad. In fact, it was my final exam of my undergrad career. However, to save money (since I was paying for this class out of pocket) I elected not to pay for the lab. Well, the professor made it clear he expected us to show up for lab anyway. So, I’ve done Microbiology, including the lab, but the transcript doesn’t show the lab portion and I need that. So I’ll retake micro. I’m OK with that. It was a fun class after all.
  • I’ll definitely keep working on my TOTS class I want to present at the NCRC. We’ll see how that goes.
  • Continue Blogging: I’ll continue my switchover from a focus on SQL and IT related posts to PA/ED Tech type posts.
  • Biking: We’ll see how my schedule works. Perhaps only 600 miles this year, not 700 as a goal. Ironically, one benefit I get at work is a secure bike storage area. Sadly, my shifts end at 11:30 PM so I don’t think I’ll be biking home much, so it means I won’t be biking to work much!
  • Hiking: Since my schedule is every other weekend on, it also means every other weekend off. I hope to squeeze in some hiking.
  • In fact: I expect to slowly wind down my IT work over the coming year so I can focus on applying to PA School and focus on other skills. Honestly, two big reasons I’m continuing my IT work is that it pays much better which helps since I’ll need the money for PA school and other expenses over the next few years (goal is to avoid as much debt as possible) and also because I do have some commitments to existing customers I want to fulfill.
  • Read more: I’ve found myself for a variety of reasons reading less in the past two years than I’d like. So I resolve to get books off my reading list. Right now I’m reading American Sirens, which is basically a history of how the paramedic service started in the US. I highly recommend it.
  • Speak at least once in the coming year. I’ve got a great talk in mind. But I won’t drop hints just yet.
  • Get Accepted into PA school. This of course is the big one. It’s what I’ve been working towards for the past 12 months. I’m confident that with my background and the experience I’m gaining I’ll get in someplace. It’s just a matter of where and what if any aid they’ll add.
  • See friends: Again, with that every other weekend off, I’m hoping to travel to see more friends. (That said, my schedule currently has me working every Friday, which I’m hoping to change so I can ensure a 3 day weekend.)
  • Get our new septic system in. Yeah, I didn’t mention it before, but the old one has basically failed (though not horribly so) so it’s time.

Finally, I realized I should have done this yesterday, but I want to thank EVERYONE who has given me encouragement and support in the past year. It’s meant a LOT. From blood family, to #SQLFamily, and NCRC family and others, I’ve had more than a fair share of folks say they believe in me and support me. It’s given me a lot of confidence. Thank you.

And with that, now time to shower, get into my scrubs and head back into the mix.

Barn Dancing

This past weekend was the annual NCC barn dance. This is an event my family and I, and often friends have been attending for the past 5 years or so. Or rather hoping to attend, since due to Covid it was not held the last 2 years. This event raises money for the Northeastern Cave Conservancy to help them acquire and maintain caves in this area. So if nothing else, it’s a good cause.

But it’s more than that, it’s a lot of fun. As a fund raiser, it is important to attract a good crowd of people. I also like to think longer term and realize that as many of us local cavers age, we need to draw in more younger folks to the community and this has been a great way to do so.

Getting ready for the next dance

I think it was 4 years ago that I first mentioned it at an RPI Outing Club meeting. I initially received the response I expected, “oh look at this old guy trying to get us to a square dance. Man he’s the one that’s square.” (ok, I realize no one uses the term “square” in that sense these days, but it works here, go with it.) But I figured even if just 2-3 students showed up that would be good. The night before the dance, I stopped by the ROC “Pit” (equipment room) and checked to see how many would be going. I was told the number was up to 14. I was very impressed, but honestly a bit skeptical they’d all show up.

Well the next night at the dance, sure enough 4 cars full of RPI students showed up. One was very excited too after she won a door prize (with your entry you get one raffle ticket. You can buy more if you want and your budget allows.)

A year rolled around and again in the fall I announced the barn dance at a meeting. Again I got a few eye rolls and the like. These stopped immediately as soon as one of the students who had danced the previous year said, “Oh, you have to go, it’s a lot of run, really!” I forget how many showed up that year, but it was was probably in the 20s.

RPI Outing Club students and many others dancing

Of course the last two years there was no square dance. But again I gamely announced it at a meeting this year and at the Orientation to Cave Rescue last weekend. Well this year exceeded all expectations. 35 students from RPI showed up. Plus, by my account at least 3-4 recent alumns, plus 4 alumns with families (including me and my family).

A sitting “dance”

Several of the students won raffle prizes and they all appeared to have fun, which of course made me and the organizers happy.

As I said above, the money the dance raises goes to a good cause, but the event is a good thing for another reason: it helps sustain a community.

Oh one last tidbit on “how things have changed.” After the dance was over, I caught a number of the students apparently exchanging links and the like using their phones.

Barn Dancing in the modern era

It was a Dark and Stormy Night…

Ok, wasn’t so much stormy as much as just raining, but I was headed towards Knox Cave again. People often ask me what my favorite cave is. Honestly, there is no answer. I have some caves I like less than others (cough, Parks Ranch Cave in New Mexico) and some I like more than others. Knox is in that latter category. It’s what I could call an “optionally vertical” cave. By that I mean it has a ladder at the bottom of the entrance sinkhole. Some adults prefer a belay (and under 16 it’s basically mandatory).

The brief amount of vertical is one of the reasons I like this particular cave. The other is that geologically, it’s fairly interesting. For one thing, it passes through three distinct layers of limestone, though I’ve only really seen two of them, the Coeymans and Manlius. Below the Manlius is the Cobleskill-Brayman. There’s a brief spot this can be seen from the main part of the cave, but otherwise, getting to it is quite difficult and I haven’t done it.

Besides seeing distinct types of limestone, the cave is basically a series of parallel fissures that give the cave a certain geometry that I like. As a result of these fissures, there’s a section I call the “Foundation of the Gods” since it’s almost like large foundation blocks were put in a 2-3 rows parallel to each other. Only I really call it that, but for those curious to the area I mean, I’m referring to the passage that leads back to the so called “Mudroom”.

This part of the cave I rarely get back to these days for a variety of reasons, but one in particular is interesting to note. Getting into the Mudroom is not necessarily easy. It requires a bit of contortion to navigate a tight crawl that ends in a passage where one has to rotate to a sitting position before standing. We’ve determined the limiting factor at getting in or out is femur length. It’s not easy, and I’ve found my cave suit often sticks to the cave mud in the crawl so I find myself crawling into the shoulders of my cave suit, but not really moving. It’s frustrating. One ends up breathing a bit heavily and feeling stressed.

Well over a decade ago a buddy of mine and my son and I decided to go into Knox and get at least as far as the Mudroom. My friend’s intent was to collect some gas level data for a project he’s been working on. One of the gasses measured is CO2 levels. His monitor immediately started to alarm as soon as he started to measure the level. This had never happened before. In other words, the CO2 levels here were higher than any other cave he had measured things in up to that point. Well, funny enough CO2 levels are correlated to hyperventilation and can induce feelings of stress. For once I could honestly say “it’s the cave, not me.” (ok, honestly, it’s partly me, I’m larger than I was as a freshman college student cave so that has made this a bit harder to get into.)

One last detail that makes this area interesting, is if you can get into a crawlway past the Mudroom, after about a dozen feet, with a bit of further contortion one can get into a decent sized room that has a unique feature in it: a well pipe from the surface that goes right through it. It’s been even longer since I’ve been into this room though.

Another area I haven’t been too in decades, but hope to get back to is an area called “The Alabaster Room”. To safely get back there a climb needs to be rigged and then a tight crawl followed. This room is the first place I gave very serious thought to what might be involved in a rescue. The crawl sort of comes into the top of the room and you have to lower yourself down into it. While doing that the one and only time I was there, my foot slipped and I slid about a body length down the wall onto the floor. I had to sit there for about 30 seconds while I tested moving my feet then legs then arms to make sure nothing was broken. Fortunately nothing was otherwise I realized that getting me out of there would have been a very serious issue. This is one part of the cave I do hope to get back to someday again soon.

In any event, it last night was a rather short, uneventful trip where I got wetter outside the cave than in due to the rain, but it was good to be back underground again.

Two last notes: Knox Cave is closed from October 1st through May 15th. Please do not enter the caving during this time.

In addition if you lack proper training or equipment, please do not go caving on your own. I’m always more than willing to take beginners and teach you how to safely cave. I can also provide equipment.

A third note: Knox requires a permit (which is fairly easy to obtain, but please make sure you do!)

A Hole in the Ground

A close friend of mine had asked me earlier this summer if I could take him, his daughter, and a work colleague caving. I immediately said yes. I also tried to schedule to take a couple of other folks caving, but alas, life got in the way. I had to postpone once, but was able to finally get underground this past Sunday.

For anyone who has been living in the area or watching the weather, you’ll realize exactly how hot and humid it’s been lately. Fortunately it’s cooler and in this case less humid underground. Because of the heat and humidity I was glad to have a chance to get underground. The only danger of course is overheating in your cave clothes before getting into the cave.

Often when I take beginners, I will take them to Clarksville Cave also known as Wards-Gregory. I’ll state up front it’s not my favorite cave in New York but it’s a decent beginner cave because it has a bit of everything and given the fact it has 3 entrances, one can plan several different types of trips from a pure walking with only a few spots of crawling to a trip with a good deal of tight crawling. You can stay almost completely bone dry to getting wet up to your neck. So it has variety. It is also not to far away and the hike to the entrance is an easy one.

The main entrance is a bit of a climb, but honestly, almost anyone can do it. This opens up into a large sized room with where I can start to orient folks to the cave and caving. One question that often comes up is “is this cave going to collapse on us?” The reality is no. The fact is, especially in caves as well travelled and large as this one, if it were to collapse completely, it would have collapsed long ago. That said, things do change at times. In this case, one thing I’ve noticed, is that after Superstorm Irene, the hydraulics of this cave did change a bit. The stream that travels the length of it and that used to commonly flow through this room has diverted a bit to one side and this room is often bone dry. I point this out to newer caves. I also tell of the time, decades ago that on a particular Friday night trip after a major rain storm, the water was so high in this room there was a rooster tail of water where the water was entering and then backing up. We cancelled that trip.

But that was not the case this Sunday. The water level was among the lowest I had seen it. On a typical beginner trip we headed up stream to what is known as the Lake Room. Often this requires some wading through toe deep water, but not this time. It was dry enough one could keep their feet wet the entire time. There’s some crawling required to do this, but not much. Often beginner trips will simply be a trip to the Lake Room and then back out. This is known as the Wards section (originally Wards Cave) But I had told this group we would head back past the entrance we came in (the main aka Ward Entrance) and go through the Gregory section (no relation to my name). This has what’s known as the Duck-Under. This isn’t really a bad section of the cave. I mean the ceiling is about 5′ above the floor. However the water is often 4.5′ deep here! Very rarely it will reach each the ceiling and sump this part of the cave. I was in the cave once (but not here) once when this happened. Folks went in the Gregory entrance sump dove the Duck-Under and apparently got disorientated and needed a quick rescue.

As I had mentioned, the water level this time was particularly low so there was closer to 1′ or more of headroom here. This still means getting pretty wet and trust me, going from being wet up to your knees to just past your waist is… not necessarily fun and often causes more than a few yelps from the cold water hitting sensitive spots.

But I was with troopers and we managed this without too much gasping at the cold water.

Now I’m going to share a little secret. I’ve lost track of how many times I’ve done the Wards side of the cave. As I mentioned, it’s an easy beginner trip and one I’ve done often. But the Gregory side I’ve explored far less and I suspect there’s parts I haven’t seen in decades if at all. Partly because by the time one gets in there, one’s got a goal of “get through the Duck-Under and now that we’re wet, get out.” (and to be fair, the more interesting stuff is before the Duck-Under, so once through it, there’s not much left to explore.).

In any event, we got through the Duck-Under and headed towards the Gregory exit. We hit the hot, humid air and I swear I was MORE soaked by that than the Duck-Under. With the Duck-Under I had managed to keep my upper chest and head dry. Not so much outside in the humidity.

But it was still a great end to a good trip and their were smiles all-around.

It was only later that I reflected, I think this is the first time in 3 years I’ve been in a cave purely for pleasure. I have been in caves (including Clarksville multiple times) over the past 3 years, but every time it was for cave rescue training. Those trips aren’t really caving per se. Yes, I’m in a cave, but not really showing it off or exploring it. I realized exactly how much fun I had had on this trip, especially with an enthusiastic bunch of new caves.

I’m hoping to plan at least one more trip with some beginners in the next few weeks as well as an Orientation to Cave Rescue class (which will use Clarksville on its second and final day). I don’t know if I’ll take this group to Clarksville or another local cave. We’ll see. Perhaps that time I’ll remember to take pictures!

And as always to my faithful readers, I extend the invitation if you ever want to try out caving, let me know. I can tailor trips to your level of interest and physical ability.

Learning the Lingo

“Now, in the ’60s, there were only two other cars made in America that had Positraction, and independent rear suspension, and enough power to make these marks.” – Mona Lisa Vito

In my first stint as a computer consultant, I was visiting a potential client and noticed a magazine called I believe The American Bee Journal. I was a little surprised at first that such a magazine even existed, but then it dawned on me that it made perfect sense and that probably every specialty had a trade magazine or the like of its own.

In the world of SQL Server we’ll talk about query plans and clustered indexes vs non-clustered indexes and use other words specific to our trade.

In caving we’ll talk about speleothems and karst and other words that the average person might not recognize.

And mechanics can talk about Positraction and skid marks.

Knowing the language of a particular specialty can be important when it comes to understanding it.

I’ve been reflecting upon this lately as I continue to study so I can apply to a Physician’s Assistant program. I’m about to finish up my first semester of classes and one of the classes I’ve been taking and really enjoying is Anatomy and Physiology I. I still have a second class to take, but I’ve been loving things so far. It is, to me, absolutely fascinating to learn how the body works. For example, learning the physiology of muscle contractions is in three words, absolutely fucking cool. And any caver who has vertical experience would realize it’s not much different from how we ascend a rope.

Part of what I’m learning to is the language. In fact one of the first lectures and labs was simply on the language to use describe where things are. To someone not familiar with the language, it may sound like gibberish to say that the tibia is lateral to the fibula and the lateral malleolus is at the distal end, but such a description can help someone who knows the language orient themselves as to its location. Similarly if someone says they have a sore sternocleidomastoid muscle, I’d know where it is, based simply on the name. (I’d also honestly wonder why they simply didn’t say they had a sore muscle in their neck). In that case, the name of the muscle basically describes its origin (the sternum and clavicle or cleido) and insertion (the mastoid process). (If you’re curious, if you turn your head to the left, you can see the right sternocleidomastoid sort of bulging from the right side of your neck).

Honestly, at times I feel like I’m at a Broadway play and the orchestra is playing the overture and the curtain is slowly being drawn back to reveal what’s behind it. I’m excited by what I’ve learned and seen so far and excited to see what more I’ll see as the curtain continues to be drawn back!

Change My Mind… T-SQL Tuesday #146

Andy Yun (t | b) is this month’s host. Our challenge this month is:

 …to think about something you’ve learned, that subsequently changed your opinion/viewpoint/etc. on something.

I’m going to give a twofer for this one, since he’s also allowing non-technical answers.

8K Blocks

“SQL Server writes everything in 8K blocks.” I recall learning this probably close to 2 decades ago. And, it makes sense, at a lot of levels. And it was “confirmed” when we reformatted the disks on one of our production servers into 64K blocks so SQL Server could read/write 8 blocks at a time. Performance definitely improved. But, then I learned from Argenis Fernandez that this isn’t necessarily true. SQL Server will write what it wants to write. And if you think about it, that makes sense. If you update one record and it’s a single value you’re updating, SQL Server isn’t going to simply sit there and not write your 1 byte change to disk. And it’s not going to make up random 8191 bytes just so it can satisfy this rule of 8K. Yes, SQL Server will try to consolidate disk I/O and be efficient about it, but even then, it may not matter. Gone are the days where we’re writing data to bare metal (some of us are old enough to recall an option in early versions of SQL Server where one could create a database on a “raw” partition to get a performance boost). No, today we’re probably writing through multiple layers, more than we realize. For one client for example, a disk write from SQL Server will pass through an encryption layer, then to the OS, which will pass it through a disk driver layer that will then pass it on to the VM which will have its own layers. At that point, even if SQL Server were trying to only write 8K blocks, it’s quite possible every other layer has its own rules.

Yes, changing our disk formatting from 8K blocks to 64K blocks helped. It helped us. But, your requirements and situation may be different and ultimately you may end up writing more or less than 8K blocks all the time. (and I hope I summed up Argenis’s position accurately.)

Toss the Rope Down

As many know, I’m a caver. I’ve been caving for decades. Early in my caving career I learned vertical caving and back then we still used what was known as a “3-knot” system or “prussiks”. That hardware has improved and changed. But one habit took longer. It was (and unfortunately still is) common to tie one end of the rope to a tree or other rigging point, and drop the rest down the pit. Sure, you ended up with a pile of rope at the bottom, but no one really cared, as long as you didn’t step on it (which is another myth for another time). This helped guarantee that your rope actually reached the bottom. The only thing that sucks more than rappelling down a pit and reaching the knot at the end of the rope 50′ from the bottom of the pit is rappelling down a pit and realizing 50′ from the bottom of the pit that you forgot to put a knot in your rope.

But somewhere along the line, folks started to realize, “hey, that rope at the bottom of the pit is useless. It’s FAR more useful if we can leave it at the top of the pit.” As the depth of most pits are known, it’s actually not that hard to measure out the rope you think you need (plus a bit extra) and then rig the rope so that you have extra at the top. Why is this important? Some call this “rigging for rescue” (or more accurately, one part of the bigger concept).

Imagine the scenario where you’re ascending the rope and have an equipment failure. You can’t go up and can’t go down. If all the extra rope is below you, it doesn’t do you any good. You can’t do anything with it. But, if that extra 10′ or 20′ (or more) is at the top and you’ve rigged correctly, someone at the top can, without too much effort, safely change the rigging (with you still on the rope) to a 3:1 or if nothing else, a 2:1 haul system. Suddenly that extra rope sitting at the top of the pit becomes useful.

Beginners will still often toss the extra rope to the bottom of the pit, but more experienced cavers will rig it to stay at the top and this may literally save lives.

Conclusion

Stop and think about practices that you do now that you may have learned that could be wrong or no longer applicable. And more importantly, do those bad practices interfere with doing something that’s better or safer? With SQL Server, over the past few decades, a lot has changed and improved, but are you still doing something you were taught 2 decades ago because “well that’s the way things are done.” A lot has changed in 2 decades. Make sure your knowledge is still valid!

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.