Unknown's avatar

About Greg Moore

Founder and owner of Green Mountain Software, a consulting firm based in the Capital District of New York focusing on SQL Server. Formerly, a consulting DBA ("and other duties as assigned") by day, and sometimes night, and caver by night (and sometimes day). Now, a PA student working to add PA-C after my name so I can work as a Physician Assistant. When I'm not in front of a computer or with my family I'm often out hiking, biking, caving or teaching cave rescue skills.

Two Years in the ED

It’s been two years since I first walked into the ED as a tech. It’s been quite the ride.

For those who haven’t heard or read the story of how I got into the ED, Next Steps tells the tale. Even after getting the job, I was trepidatious. It wasn’t long before I decided I was definitely in the right place. And now I’m even more convinced that I am.

My original hope was that I’d be in PA school by now, but honestly, the extra year has been worth it. There are several reasons. For one thing, I’ve gotten a lot better at being a tech.

It also has given me the opportunity take over and teach the “Tech in Trauma” class required by all techs before they can become red-badged (meaning they can be the lead tech on traumas). I’ve also spent a lot more time assisting in procedures, including providing traction while the orthopedic doctor set a femur, suturing, even being part of a thoracotomy. While I wasn’t the ones doing the main work, simply observing such stuff has helped me to learn and will be invaluable once I start my clinical portion of my education.

I also, once I was accepted, decided to take an additional step at ensuring my success. Like the days of old when a monarch might assemble a Council of War to advice them for upcoming battles, I’ve assembled a Council of Moore. I asked three people in the ED that I have a lot of respect for, one of the attending, a PA, and one of the assistant nurse managers to be part of my Council of Moore. We’ve had one meeting already where I was able to get some good advice and as I go through the next two years I’ll be relying on them for advice, feedback, criticism when necessary and even a wee bit of cheerleading. Had I started PA school a year ago, I doubt I would have taken this step, much to my detriment.

When I started working in the ED my goal was at least 1000 hours of patient care experience, because that’s the minimum of what most schools I was applying to required. At this point I calculate I have approximately 4,500 and will have well over 5,000 by the time I start school. It’s been long and tiring, and some weeks I’ve worked 60 or more hours in the ED, but it’s been oh so worth it.

So here it is two years later and I’m still going strong and raring to start PA school come next May!

One last comment: my statements above are not endorsed by my employer, Albany Medical Health System nor do they reflect the views of my employer.

All’s Quiet on the PA Front

I can’t believe it’s been since July that I’ve made a blog post. That’s two whole months of not posting. There have been multiple reasons, including laziness on one hand and being too busy on the other. Looking over my work calendar I’ve worked a number of Monday night overnight shifts, which means I’ve simply been asleep during the time I’d normally be posting on Tuesdays.

At the start of the year I picked up a lot of extra shifts, in part to ensure I had more patient contact hours when applying to PA schools. That obviously paid off. Since then I’ve picked up shifts for the extra money and experience and honestly because some nights we’ve been short-staffed and I’ve felt like helping out. One of the benefits of picking up shifts on short-staffed nights is that I’m often in the A-Zone which is not only where the traumas come to, but also where the tech desk is next to the provider desk. This, for me, is the real benefit. I learn a lot this way.

For example last week, both the attending and the lead PA that night had students following them. And in good Socratic fashion, they took time out to further their students education. Since these were slow nights, this meant I was able to listen in and even participate. As a result, I got basically graduate level lectures on hyperkalemia and pain management. That’s pretty cool.

I also in the last month was able to take advantage of some time schedule and visit the campus of the PA school I’m currently planning on attending. It was both exciting and a bit of a letdown. The letdown is because (and this is typical of a number of programs) it’s not on the main campus of the associated university and is basically in an office building. So much for that ivy covered wall experience. That said, I’ve had that, so that’s ok. But it was definitely exciting because I was able to stand in the classrooms and lecture halls I’ll be in in about 8 months!

I still wake up and have to pinch myself and say, “did I really get in?” I’m in a number of Facebook groups for prospective PA students and it’s heartbreaking to see some of the posts as they list their rejections and the like. I give advice where wanted and condolences where appropriate. There are also the successes which are nice to see and to give congratulations on.

But at this point, PA school itself is 8 months away. I’m thrilled and nervous!

Second Down Payment

I mentioned a few weeks that I had been accepted at a PA school. I won’t lie when I say that sometimes I lay in bed and think, “did I imagine that? Perhaps I read the email wrong!” I even went back and reread the email at least once, if not twice.

But since then three events have reinforced that I’m in. Last week the first down payment had to be submitted by midnight Tuesday night. I got out the credit card, went to the webpage and submitted my information. First deposit accepted. I figured they wouldn’t take my money unless they had accepted.

Later in the week there was a scheduled Zoom meeting for accepted students. At that point it was really sinking in. I mean they wouldn’t invite me to such a meeting unless I really was accepted, right?

The Zoom meeting was interesting, and being a good student, I did take notes. I don’t think there’s a quiz later, but I figured it’s better to be safe than sorry.

And just this morning I whipped out the credit card again and made the second down payment, also accepted.

I mentioned in my earlier post a concern about the school’s accreditation status. But two things have allayed my fears. The first is a practical manner. The way the review process works, if the worst case scenario happens, it would be only a month into the program and I’d work to get my money back and still have plenty of time to resubmit to other programs if I really wanted to try for a third round. Though I’d probably want to retake some undergrad courses to help my GPA.

The second is a more nebulous reason. I managed to find some forums for students in my cohort and some had contacted current students and their thoughts on the current probationary status was that the school in fact was making good progress in fixing the cited deficiencies and they all had great things to say about the program.

So, that makes me feel far more comfortable and prepared to stay the course and attend this school. For now, so that I don’t influence any potential recruiters at other schools (yeah, right, like they’ll read this!) I’m keeping the name out of my posts.

But, I’m getting more and more used to saying, “Yes, I’ve been accepted and will be a PA student next year.”

So yes, I’m no longer Schrödinger’s PA. I’m accepted and will be a PA student next year.

Coming up… more self doubts…

PAs Under Pressure

Now that the reality of being accepted to Physician Assistant school is settling in, I’m more and more convinced I made the right decision. This was reinforced the other night when I was working.

The attending mentioned it and one of the more senior PAs turned around gave a hearty “Congrats” and offered me a high five. This definitely helped my ego. But that wasn’t what really drove home my decision. It was later that evening.

A trauma patient came in. During a trauma there are a number of people in the room, one or two techs, one or more nurses and generally at least three providers. One of these will be a doctor, but the others are sometimes PAs. This patient came in somewhat stable but her condition quickly got worse. The decision was made to intubate her.

It was at this point I realized in addition to the attending doctor for the zone the other providers in the room were all PAs. The attending was supervising and monitoring, but otherwise the PAs were calling the shots, including performing the intubation and putting in what are known as a central line and an arterial line.

They rocked it.

My goal is still to be a PA in an emergency department (ideally to come back to where I currently work as a tech.) Above is part of the reason, because the PAs here are very important members of the team and once proven themselves, can do a lot.

But, it’s not just traumas. One might call that the most “sexy” aspect of working in the ED, but the honest trust, they end up spending far more time with the patient with a dislocated shoulder, or counselling a patient on why they should take their meds, or a million other smaller medical interventions. They fill in a lot of gaps and have a lot of close patient contact. I’m looking forward to that.

But hopefully the day will come when I can feel as confident as the PAs I currently work with so that when the trauma comes in, I can rock it like they did.

As always, the above views are mine only and do not necessarily represent those of my employer.

“Regrets, I’ve had a few…”

With apologies to Frank Sinatra.

Last week I was reminded of one of the few things I missed out on my IT career. A number of friends and colleagues posted about how they had achieved or been renewed for their Microsoft MVP status. It’s one achievement I never obtained.

Let me be clear, I’m not bitter or upset. The honest truth is, I never really worked hard at achieving it. So to me it’s most like seeing friends making the Olympic team and wishing I was there but also recognizing that they worked at it and earned it while I really didn’t. So this is on me. And I’m VERY excited and proud for them. They’re amazing people and they deserved it!

But, with my career change, I’m even less likely now to make it. And… I’m ok with that.

One thing that I’m finding remarkable to me about this career change is how few regrets I’m having. I’m reminded all the time it’s the right move. I was tired of IT and tired of data.

But, the one thing I never tired of was the community, aka #sqlfamily. Honestly, this is what probably what kept me going the past few years: being part of such a community. Let it be said, the #sqlfamily is an amazing group of people: they mentor, they teach, they push the state of the art forward, they make everyone better. I’m a better DBA and IT person because of them.

In fact, in a way, I’d say #sqlfamily probably gave me the inspiration and courage to move forward and change careers.

So regrets, I’ve had a few, one being perhaps not working hard enough to earn an MVP, but meeting, getting to know, and loving my #sqlfamily, I will never regret.

Schrodinger’s PA

Those familiar with quantum physics know the idea of Schrodinger’s Cat. It’s a thought experiment that posits a cat in a box is in superposition of being both alive and dead until it’s observed (and to be clear, it’s BOTH alive AND dead, not simply alive OR dead until observed.)

Until recently, my PA status has been sort of in a similar state. Until I received notification from a program, I was both “accepted” and “not-accepted”. And this week, the quantum value collapsed and, I’m still both, but in different programs.

Not-Accepted

First, the program I wasn’t accepted into. I won’t give out its name for my own personal reasons, but let’s just say it was my top choice. As many of you know, one of the problems I’ve been trying to overcome in my applications is my poor undergraduate GPA from 34 years. This was a program that on their website said they didn’t have a minimum GPA so I was hopeful. Last year when I was turned down I wasn’t entirely surprised because most PA candidates get turned down their first time around and I barely met the threshold for patient contact hours and honestly, while my letters of recommendation were from folks that I knew would say good stuff, they had limits in how well they knew me.

So I was more hopeful this year, a slightly improved GPA (with more post-bacc classes taken) and far better references and a lot more patient contact hours.

I have to say, I was a bit surprised when I was denied again. Not so much that I was denied as much as how quickly it happened, less than 24 hours between my application being complete and being rejected. Last year it took a week.

This time I decided to reach out to the program director. Unfortunately that didn’t really make a difference. It turns out that despite their website claiming they don’t have a minimum GPA, in practice, they basically admit to having one.

But that happens.

Accepted

However, just over a day after exchanging emails with the director of the above program I received an acceptance letter from another program. I have to say I was quite excited.

So now I was non-accepted officially at one school and accepted officially at another.

That said, there’s on small issue which is a concern. Any PA program in the US, like any respectable college needs to be accredited. A program can have:

  • Developing – Not accredited – just like it sounds. They can’t matriculate students. This means one can’t take the program and then take the PANCE (Physician Assistant National Certifying Examination). So this is an absolute no go for me.
  • Provisional – Generally new programs that don’t have much of a history. This could be a program that has developed everything, but is still being observed. One can attend and graduate and take the PANCE. However, it’s not clear how good of a program would be because of its lack of histroy.
  • Continued – This is the gold standard. This is what you want to see in a program. This means it is meeting the standards required. Odds are very good that you’ll matriculate and pass the PANCE on your first try.
  • Probation – This can be problematic. The accreditation body has found problems. Programs have two years to fix this. If they succeed, great. If they’re making progress, they can get a two year extension. If they fail to make progress, accreditation can be withdrawn. If this happens in the middle of you attending, this can be “bad”.

There’s other categories, but those are the important ones.

So why do I mention them? Because the program I was accepted into is in probationary status. I have to admit, this makes me nervous. On one hand, I’m in a program. On the other, there’s a chance it could disappear before I can qualify to sit for the PANCE. That’s a HUGE concern.

That said, right now, I’m most likely going to make the down payment and secure a spot in the program.

“But Greg, you’re crazy! That’s risky!”

Yeah, potentially it is, but I’m not overly worried. For one thing, the program is nearly 3 decades old. So it’s not like it’s some new program struggling. It’s hit a rough spot that they appear to be taking steps to overcome. The faculty and staff seem very confident, which is a good sign. The program itself has some very strong points (and admittedly a few weaker points). And from reading comments of students currently in the program, they are feeling very well prepared to take the PANCE. Their most recent PANCE pass rate was 98% for a first time taker. This compares to the national rate of 92%. I can live with that.

And while I have to put in a non-refundable deposit soon, it doesn’t mean I can’t later change my mind. For example if another program accepts me, and I like the program better (there are many factors that can go into such a decision, accreditation status is just one, cost of attendance, cost of living, facilities, etc. are others) I can forfeit the deposit. I’d hate to do that, but it’s an option in the back of my mind.

So, I’m now semi-officially a PA Student… at one place, waiting to hear from others!

A Certain Kind of Bravery

One part of my job as a tech is to help with psychiatric patients. They may be checking in for a variety of reasons, but one that stands out are those who are checking in because of what is termed “suicidal ideations”. These are the folks who for whatever reason are having suicidal thoughts and afraid they may act upon them.

For such patients, we get them changed into hospital scrubs and then put them in a room where they can be observed. We’ll keep an eye on them until they are cleared by a psychiatry doctor. Basically we take away anything that they might use to harm themselves (hence no belts, sharp objects in the room, etc) and make sure if they do suddenly try, we can stop them.

The honest truth is, pretty much every patient I’ve had to do a “one to one” sit for has been fairly sedate. Generally by this point they’re calm and simply trying to purge the thoughts and waiting for psychiatry to take a look at them.

So why brave? Because society has a stigma against people committing suicide (a good thing in general I think) and it has a stigma against folks who express suicidal thoughts. This stigma can often reinforce the already negative thoughts in their head.

People with suicidal ideations have them for many different reasons, but often they feel a sense of worthlessness, “the world would be a better place without me” or “No one cares about me”.

And yet, they’re taking a leap of faith. They’ve come to us because they believe that “some cares enough to make sure I’m safe” and “the world is better with me still in it.” That’s brave.

Some sadly can’t find that bravery for a variety of reasons, or they’ve been brave multiple times, but the last time they couldn’t be.

But for those to do end up checking themselves in, I am awed that they are brave enough to make that leap of faith.

I’ll close by saying: if you or a loved one are having suicidal thoughts, please take a leap of faith and trust someone cares.

Call 988 – the national suicide hotline.

Or go to your local hospital and tell them you need help. They’ll help.

The world is a better place because you’re in it. Let’s keep it that way.

Back in the Saddle Again

With apologies to Gene Autry, I’m back in the saddle again. CASPA, which is the Centralized Application Service for PA programs, opened up for applications for the 2024-25 round of PA school applications. I actually logged in last night, but there were no changes, at least as of 1:45 AM ET. So sometime between then and 10:00 AM today they finally opened things up.

So I’ve officially started the process for the second round of PA school applications. As loyal readers know, last year, my total was all “thanks for applying, but no” except for one school that waitlisted me. For various reasons I didn’t pursue that one very hard. While I had had hopes for being accepted last year (which would have meant I’d be taking classes now, or starting within a few months), the chances honestly where low. It’s actually pretty common for folks to take 2-3 attempts before getting in. There are a variety of reasons. So to play a bit on Arlo Guthrie’s words from Alice’s Restaurant Massacree, “Kid, have you rehabilitated yourself?” In other words, what’s different this time?

Well, my overall GPA is still an issue, there’s little I can do to completely fix that short of taking probably another 30-40 credits worth of classes. But my science GPA has improved and I’ve added a few more useful classes to my transcript that will help with a few of the schools I’m applying to.

Of course, as I mentioned some schools tend to want to see repeat applications, so I’ll be checking that box.

My patient contact hours are much higher. For the schools I am most interested in, the minimum number of patient contact hours was 1000 hours, I had barely met that last time I applied. Now I’m at over three times that number, with over 3000 hours under my belt. This also exceeds the mean average for most of the schools I’m applying to. I’m hoping this shows my dedication and interest. And as I’ve said before, the fact that it’s in the ED helps a lot because it shows I have a wide variety of medical experiences (things I’ve assisted in or observed first hand include several spinal taps, a thoracotomy, bone reductions, and more.)

And finally, better references. This isn’t to disparage my previous references; the people I had selected I have a great deal of respect for and I believe they share the same in regards to me (and at least one shared the letter of reference he sent on behalf and I was overwhelmed by his positive words). But this time around, with at least two schools, I will have far more targeted references, for example from graduates of their schools, so that tends to help. In addition, at least one professional reference is one that knows me even better than the reference I used last time. So, I’m hoping these references make an even bigger impact than last time.

I haven’t fully decided which schools I’m applying to this time, nor exactly how many, but the process is moving forward. There’s a few schools that are obvious choices for me, and a few that are on my no list this time around that were on my list last time.

But that said, this weekend (only because I’m starting a 12 hour shift in 2 hours and need to sleep tomorrow) I’ll be moving ahead quickly with the application process.

I’m excited and nervous!

Close Encounters of the Eclipse Kind

One of the clips of a movie I like is from Close Encounters of the Third Kind, just before the alien mothership arrives at Bear’s Lodge (aka Devil’s Tower). “Is everything ready here at the Dark Side of the Moon?

Well, yesterday everything was ready. In 2017 I had taken a bit of a leap of faith and driven all the way to my uncle’s place in South Carolina in order to observe totality. Despite thirteen hours driving southbound and I think close to twenty driving northbound (due to traffic and a nap) I decided it was totally worth it. Totality was unlike anything I had ever experienced before in my life. If you didn’t get to see it then or in 2024 (or any other time) let me tell you that there is a 100% difference between 99.9% coverage and totality.

So, with some last minute planning, Randi, Ian, and I were aboard Amtrak’s Adirondack yesterday, bound for Port Henry, NY. It appears we were far from the only ones who had decided to forgo driving and to risk potential tardiness (though we had a buffer of over an hour) and cloud cover (mitigated by fully refundable tickets). According to the conductor, 130 people were scheduled to get off Port Henry that day. In contrast, it appears on average, Port Henry has 3-4 people get off or on the train day. Amtrak apparently called the town supervisor a few days previous to let them know 150 people were bound there. Suddenly they were planning to do some stuff right near the train station, something they hadn’t planned on before.

Image of Amfleet Cafe car at concrete platform for Port Henry, NY train station.
The Adirondack, preparing to depart Port Henry, NY after dropping us off.

Like last time, the build-up was interesting, but also a bit boring. It’s not until you’re at over 50% coverage or so do you start to notice a dullness start to cover the land. It’s sort of like a cloudy day, but different in a way I can’t necessarily describe other than muted. This grows as coverage increase. We spent our time walking around, buying and consuming a pizza made in portable trailer based pizza oven (not bad, but I normally wouldn’t have paid as much for it as I did, but hey, I was hungry and it was supporting local business).

As 99% approached, we could definitely feel the temperature drop and now everything was really simply in dull colors. At that point, my eclipse glasses were basically glued to my eyes (with an occasional peak at the landscape around me).

White plate with a colander held above it, showing the Moon's shadow.

Then 100%: Totality. Glasses came off. People cheered and shouted. There was a hole in the sky where the Sun should have been. If you’ve never seen it, it’s bizarre. Literally where the Sun should be, is a dark black dot. It’s the darkest thing in the sky. It’s a bit unsettling.

I can’t recall if I saw it last time, but this time I definitely saw the Sun’s corona. When one considers who big the Sun really is, the eclipse drove home how far from it the corona can extend. I also saw, and confirmed with others, that I saw what apparently was a solar prominence. It had a very distinctive red color and for me appeared at about the 7 o’clock position on the Sun.

Then, just minutes after beginning I saw a flash of the “diamond ring” and put my glasses back on. It was over. We waited for our train, boarded, and once my ticket was scanned, I fell asleep. It wasn’t so much because it was anti-climatic as much as because I had just worked my standard 12 hour shift, plus 3 more the night before. (I literally went from work, straight to the train station).

I still can’t really put to words the experience, but I do know Randi and Ian also came away with the belief that the trip was well worth it.

I will just say this, if you ever get the chance to be in totality, do it. This is especially true for the folks I’ve heard about and say things like “well I was at 99.9%, that’s good enough”. No, it’s not. So, if you make plans to see an eclipse, get into totality. Yes, I get it, you might live or work at say 90% and decide “that’s good enough” and logistically it may be, but honestly, the closer you are to totality, the more worth the effort it is to get all the way. It’s not worth travelling from 40% to 60% but it is for 99% to 100%.

And here’s looking forward to the next North American eclipse in 2044, and perhaps ones elsewhere sooner!

Randi overlooking Lake Champlain
Randi overlooking Lake Champlain

My Inbox Today

I posted Tuesday about the end of my contract with my largest client. One of the last set of steps I took was to take my email address off many jobs and alerts. The difference has been stunning and well worth it.

My inbox for my main business account is now down to fewer than a dozen emails a day. I apparently missed 4-5 alerts from my client that I’m getting cleared up, but other than that, now it’s emails related to other items.

Not only has this made my email box reading a lot easier and faster, it honestly has given me a lot of relief. For example, for the last few months of 2023 and the first two of 2024, there was an important job that started to randomly fail around 4:00 AM. If I was at work in the ED, I’d be stressed about getting home in time to rerun it (and to try to debug it). Fortunately I finally resolved that about a month ago, but still kept my eye on it.

In addition, there was another major server issue that would randomly occur with one of the VPNs. We hadn’t seen the issue in months, but I had been paranoid about it failing. Sure enough, I found out from a former coworker that it failed Sunday night for the first time since December. And my first thought was “well thank god it’s no longer my problem.” I mean I felt for them that they had to deal with it again, but it wasn’t anything I had to worry about. That was refreshing.

This morning, after a 12 hour shift in the ER, a bunch of us went out to breakfast. It’s the first time I could do that and not worry about having to get home in time for a meeting or needing to check email. Again, it was refreshing and relaxing.

I think I’m enjoying this so far.