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.

If you don’t try, you can’t fail

As of today, I’ve hit submit on the applications to 5 different PA schools. There are at least a half-dozen more on my list I’d like to hit submit to, but probably won’t. I’ll explain why in a few.

But let me say, the first was the hardest. There are two reasons. The first is that it’s my first choice. I wanted to make sure everything was in order. I proofread everything multiple times and had at least two others review my submissions for content and for grammar errors. Once I felt those had been handled, I was ready.

Except, for the hardest part: I couldn’t be denied if I didn’t apply. I mean that is sort of obvious. But it’s true. Up until that point there was no way that school (or any) could say no. Sure, they also couldn’t say yes either. But the yes doesn’t really scare me and if I hear a yes, I can shout to the world “I’m accepted”. But the nos… those are hard to hear.

Years ago, when I was in college, before I really started dating I was afraid to ask a woman out on a date. I didn’t want to hear no. No would be soul-crushing. But then I realized that it also meant I’d never hear yes.

So, one day I screwed up my courage and asked a woman I was attracted to if perhaps I could make her dinner. And she said yes! I can’t recall the dinner, but I recall afterwards we ended up on the couch cuddling and falling asleep. Afterwards I walked her back to campus. I recall that in part because my contacts had dried out so much from napping in them that the streetlights appeared as sort of halos until the moisture returned.

That particular relationship didn’t last, but it did reinforce the lesson that to hear yes, you have to risk hearing no.

And so, I can’t hear yes from any PA school if I don’t risk hearing no, even from my primary choice.

After hitting submission on that first one, the next one that night was far easier. Then last night, I hit submit on three more.

Now, why do I hesitate on the rest? Well because in most cases they have a firm undergrad GPA requirement which I fail to meet by a wide margin. At least two I’ve emailed directly to confirm and have received a very clear response that the GPA requirement is a hard limit.

I’ve received a lot of support here and on Facebook in my quest and many have said, “Oh, don’t worry about your GPA, trust me, your life experiences will counter that.” And for the five I’ve applied to, I hope and expect that’s true. But for the others, I’m less sure, especially the ones that have replied to my email inquiries.

That said, this is actually another reason I didn’t want to hear no. I’ve got such a huge crowd of cheerleaders that I don’t want to disappoint them or even honestly face them if every school says no. While I appreciate the support, and at times I need it, I also fear at the end of the day it may all be for naught and I’ll feel guilty for raising their hopes.

But that’s a problem that may not arise, and if it does, is for another day.

So for now, I keep looking and considering what the next schools I will apply to.

In the meantime, I will risk the nos, while hoping for the yes.

Still Running

Last week I wrote about my PA School application process and the CASPA site used to apply. Since I wrote that, I’ve made more progress. I am technically at the point where I could hit “send” on 8 applications. But I haven’t. Yet.

And it’s a good thing! Since this is so important, I wanted to make sure I had others proof-read some of my submissions and comment on them. So first a call out to my wife Randi who gave me some good feedback on the general tone. One of my concerns was my general essay. The general essay answers the question: Please explain why you are interested in being a Physician Assistant.

I had written two versions and felt my second one was much stronger, she agreed. The best way I can describe my first one was that it was very pedestrian. The second one I think far better reflects why at this point in my life I want to be a PA. I think I’ve said it before, but in case I haven’t, I will here: To make a difference. Yes, I suspect everyone wants that, but after 30+ years of basically pushing data, I want to have a direct impact on people’s lives. The more I think about it, the more I realize how much it motivates me. It’s one reason I work with the NCRC and teach cave rescue (and perform cave rescues). It’s a direct impact. It’s a reason why I like teaching. Even now, before I’m a PA, every shift in the ED I know I’m making a difference. It might be getting a cold patient a blanket or assisting in a trauma, but I know at the end of every shift, I’ve made a difference.

The second call out is to my friend Alma. I’ve relied on her for years (I won’t say how long as that might give insight into how old we both are) for her editing prowess. I’m thankful I did so since she caught a number of minor typos, but also a major one that at best would have elicited some laugh, at worst, doomed me. I had meant to say underserved communities, but had written undeserving communities. Quite the difference!

So, does that mean I’ll hit submit today to those 8 schools?

Not quite. I have to reload my edits and then still review the submissions and decide if I really want to apply to those 8 or just a subset. In any case though, come this weekend I think I’ll be hitting submit and I’ll admit I’m excited.

Running to Stand Still

To apply to PA School, one uses a common application called CASPA. Pretty much every PA school uses this platform for their applications. They also, for the most part follow a similar timeline, of allowing the application process to start on May 1st. My goal had been to have as much completed as I could by May 2nd, or barring that, May 31st. Well here it is June 20th and I’m still working on it.

It’s not for the lack of effort. Even though I finished up the prior semester, I was busy with a lot of other stuff and found myself travelling or working every weekend in May and the first two weekends in June. Between consulting and working in the ED work, I often find myself working 60 or more hours a week. So it’s not like I’ve been lazy.

Now, that said, many of the hours in the ED are actually hours I’m picking up to gain the experience and to expand the numbers on my applications. As noted previously, some schools only require 500 hours but a few require 1000 hours. A number I surpassed a while back. But that’s a minimum, and often below the average. So I definitely want to boost it.

I was actually planning on going in last night for an extra 8 hour shift, but finally convinced myself to slow down and take the night off from work. Or at least from paying work. I did end up, as I had promised myself, working on my application and knocking out some essays. As a result, if I submit the essays as written, I am fully complete with applications to two schools. That said I will be waiting a few more days so I can review the essays and possibly improve them.

And I also now have to consider, in order to apply to a few schools that might be on my list, if I want to take Genetics come fall. And possibly a Medical Terminology course. Most that require that will allow a certificate program, but at least one school wants a 2 credit minimum class. And I’ll be honest, that particular school is not high on my list of schools I’m considering.

But meanwhile, I feel like the Red Queen in Through the Looking Glass, “Now, here, you see, it takes all the running you can do, to keep in the same place. If you want to get somewhere else, you must run at least twice as fast as that!”

I’m running as fast as I can.

Why I March and Engage

I’ve been “online” since the fall of 1985 when I first encountered one of the earliest “chat” programs at my alma mater. It was known as CB (like the radios popular in the day) and only was accessible by fellow students. It was a few more years before I gained access to the Internet. Back then it was still basically just academics. But even then it was easy to find the trolls, bigots, racists, and more. And it was as easy to both engage with them and ignore them.

I learned pretty early on that often engaging them did not change their minds. Such is still true today.

And yet, I still do at times. People have asked me “Why are you wasting your time?”

There are two reasons, one relevant to this post, the other less so. The one less so is at times it can be amusing in its own way. The relevant one is because I’m not necessarily trying to change their minds (though there is still that hope and sometimes it works.)

The reason I engage is because I can. Because it’s a case where sometimes I can use my privilege in a good way. Because I can ideally show those who are being attacked, shamed, or hurt that “hey someone is on your side.”

Hence, this is why in a huge part I choose to march with my employer Albany Medical Health System in the recent Pride Parade in Albany. I want people to know they “hey, you’re not alone.” This was driven home when I overheard two of my coworkers discussing some recent Supreme Court decisions and how they feared those and possible future ones might impact their lives.

Yes, it’s true that marching in a pride parade is much like preaching to the choir, pretty much everyone there is already supportive of equal rights for the LGBTQ+ community, but it’s always possible there’s those who aren’t, or those who are on the fence.

Now, I honestly don’t know the sexualities of my coworkers that I marched with. Nor is it important. What is important is standing up and saying, “I’m with you, you’re not alone.”

Disclaimer: As always, I speak for myself, not my employer, Albany Medical Health Systems and these opinions are my own. That said, since they organized our participation and provided shirts, you can read into that what you will.

The End of the Semester and the Start of the Next

Looking at my notes, apparently I didn’t blog at all during May. I suppose I was busier than I thought. But I figured it was time for another quick update on “Greg’s journey to apply to PA School.”

First, the spring semester of 2023 is in the books. Biochem, Writing, and Stats all complete. Biochem was definitely the most interesting and best of the classes. Stats was delivered at a 100 level and was basic enough I could skip the study seasons and still take the exams without much studying. With the homework bonus (which actually was quite helpful) she gave, technically my grade was 100+. What’s the odds of that? 100% I can tell you since it’s a past event that happened. This was the only class that had an in-person component and it was at 9:00 AM four days a week. It was just useful enough to tie the notes to the concepts that I made a point of attending. As noted, I did tend to skip the review classes, except for the last two exams, where I actually took the exam during the review session as it fit my schedule better.

Writing was hit or miss. It was all online and honestly, little feedback from the instructor, so I’m not entirely sure if I got much out of it. But as most programs want some sort of writing intensive class, it was necessary to take.

The Biochem class was all online and one of the few times in my academic career I actually went to office hours for help. After asking me exactly how long ago I had taken the chemistry pre-req and commenting that they really expected it to be within the past few years, not 35+ years ago, I was even more incentivized to do well.

The professor honestly, had put together one of the best online setups I’d seen, taking good advantage of the tools Blackboard offered. A few of my previous online classes were basically “here’s a lecture, listen and that’s about it.” One was even simply “here’s the Powerpoints, good luck figuring out what’s relevant and what’s not when it comes time to take the test.” In this case however, she had study guides, required participation in an online discussion and made use of online study quizzes to help reinforce the material. In fact you couldn’t move onto the next module until you had taken the quizzes, tests and exams for the previous material. This last detail did munge me up a bit at the very end when I was prepared to take the final but couldn’t see my grade for the previous exam yet (the grades wouldn’t show until after midnight on a specific day so that everyone had a chance of taking the exam without cheating off someone else taking it earlier).

I also had a study partner that I had met during Organic Chemistry last summer that works at AMC with me, so we were able to take advantage of the study rooms in the AMC school library and help each other with homework and studying.

Besides being well designed and run, it was also the most interesting class, as we got to delve fairly deep into some of the biological-chemistry pathways that occur in us. It was pretty interesting to see stuff to that detail rather than simply stuff like “and then Acetyl-CoA enters the Krebs cycle”. Now we got to learn exactly how and why that happens. Trust me, it’s pretty damn cool!

After classes were over, I was prepared to take a little over a week to teach the annual Weeklong Cave Rescue class I teach. Unfortunately my largest client had a major upgrade the weekend before that went sideways, exactly for a reason I had predicted. So rather than leaving town Wednesday night after work with a buddy of mine, I ended up working on the issue for much of the week and finally leaving Friday morning and having to drive all by myself to Alabama. This led to a definite lack of sleep. And even then I had to deal with some work issues. And finally a drive home by myself and then another shift in the ED.

Finally Memorial Day weekend I spent with some friends at an annual retreat of sorts.

And now, I’ve started my last planned prereq, MicroBiology. Ironically this was the last class (and last final) I took for my original undergrad degree, but at the time I didn’t pay for lab, despite ending up taking it at the professor’s insistence anyway. So ironically it appears it’ll be the last exam before PA school, unless I decide on my own to take more this fall.

So that’s the update from here. Now back to work (after the second night in a row of working until 3:30 AM).

1000

Work and school have conspired to use up my time, so I’ve been blogging less often. But I wanted to make a point of blogging this week because I’ve reached an unofficial milestone.

Over the weekend I reached my unofficial 1000 hour mark as an ED Tech.

I say unofficially because I’m using a fairly conservative method of counting it and officially, I reached it close to two weeks ago. So why am I counting my number, that came later, rather than the earlier number? Because this one is more meaningful to me and gives me more of a margin for counting.

Officially, by the timeclock, I reached 1000 hours over two weeks ago. However, this time included by 24 hours of initial classroom orientation and the time to get my CPR recertified and some other training where I wasn’t even in the Emergency Department.

The other factor, was that officially, many of my shifts have been 8.5 hours, with .5 reserved for lunch. However, due to staffing shortages, often many of us techs will work through our meals (and swipe the timeclock for that, guaranteeing we get paid for that time). But it was simply easier for me to ignore those “worked through meals” and only count an 8 or 12 hour shift as 8 or 12 hours, not 8.5 or 12.5 hours.

So, I simply tracked time I was actually in the Emergency Department.

Now I’d like to say that when I hit my unofficial 1000 hour mark I was doing something exciting like working a trauma or even something routine like taking an EKG. However, the truth is, I was sitting at a desk going over some study materials. I was working what’s known as the “BB-Short Stay”. Generally when working here, there’s very little to do (I think I did 18 sets of vitals in 8 hours, and one bed change. But, that’s the nature of the job sometimes.) Fortunately, my next 4 hours of that shift was back in the main area of the Emergency Department and I was able to be more active.

That’s not to say I didn’t celebrate a bit:

Me celebrating 1000 hours with overpriced sushi

So, a final note, the reason for the 1000 hour celebration, is that a number of the schools I’m applying to require a minimum of 1000 “patient contact hours” (one only requires 500 hours and another 750 hours) and now I’ve met that! That’s why I don’t count the classroom orientation or the like because that’s technically didn’t involve any patient contact.

At this point, I can start applying, despite a few classes this semester pending final grades and for most schools, needing to take Microbiology, which I’m doing over the summer.

But this was the single biggest hurdle that I had the least control over. For classes, I could simply sign up. However for the patient contact hours, I had to first get a job, ideally in a place that gave me more contact than simply “taking a set of vitals now and then” and then gain enough hours. Officially my job is only 24 hours a week and I started in late October. Fortunately I’ve been able to pick up a lot of extra hours, hence hitting my 1000 hour mark in only 6 months. My hope of course is that my 1000+ hours of patient contact in an Emergency Department stands out compared to say someone who has only had 1000+ hours in say a medical office where they’re simply taking vitals.

So this bridge crossed!

Slowly but surely getting there.

Standard Disclaimer: nothing here represents any official policy or action of my employee Albany Medical Health Systems and I do not speak for them in any capacity or in any way.

The Value of DR Testing

Just a short blog post today since I’m actually in the middle of a call with a client as we test our failover scenario.

Right now I’m calling it a success even though the SQL Server hasn’t come up yet.

Why am I calling it a success? Because we learned that our current plan has a serious gaping hole concerning how the iSCSI drives failover. Yes, technically we failed to failover as quickly as we expected.

But, we’ve learned that before this system went into production. So that’s a success. This raises our confidence level for next time.

In all honesty, we often learn more from our failures from our successes. For example, before NASA would allow SpaceX to fly a crew on Crew Dragon, they required several abort tests, one of which involved launching a Falcon 9 and then in mid-flight firing the Crew Dragon abort engines. This resulted in the destruction of the Falcon 9 (which was expected) but proved the abort plans worked. Note however that for Orion on Artemis, NASA has decided such a test is not necessary. The decision making process behind this particular decision is worthy of a blog of its own.

In any case, with the current DR test, we expect to have things finally failed over in the next hour or two. Then we’ll update our playbook and have a lot more confidence.

Moral of your story: test your DR. Assume things will go wrong the first time because they will, but far better to have that before you go to production. This is not the first time I’ve had a failover not go as planned, but prior to production.

Update to my Race

For the first time in I’m not sure how long (I suppose I could check, but I won’t) I skipped blogging for two weeks and am late this week (I almost skipped it actually). But I decided I’d take time out to blog and when I realized what my last post was about, I figured it would be a good segue for this post.

Yes, I’m still running the race. I’ve hit some marks along the way, but still a ways to go.

For one, I’m now at over 800 hours of work in the Emergency Department proper. I’m closing in on my goal of 1000 and expect to hit that by May 1st. I’m excited. That said, during my study time with one of my classmates who is also applying for PA School, I realized that the number I had remembered for the number of average hours for most applicants to my top schools of choice was a lot higher than I had remembered. So instead of beating the average, I’ll come in below it. Alas, that can’t be helped. But I’m going into this later in life and so who knows how that will impact things. Also, I’m hoping that my hours in the ED will count more heavily than some candidates who may have had jobs with less involved contact.

Another goal post I’ve hit along the way is finally getting my “Red Badge”. Simply put, in the ED I work in there’s two colors of badges, blue and red. Blue is the basic, call it “entry level” badge. You get it when you’re hired. Red means you can work traumas without supervision from another tech. I had actually qualified, except for a written test, over a month ago, it’s just a matter of scheduling to take the written test and finally things lined up last night. As a result of passing this, it means I can be assigned to what’s known as the A-Zone without needing another red-badged tech with me. And sure enough, right after passing the test, I got my first assignment as a lone tech in the A-zone.

Now I’d love to regal you of stories about how in my short 4 hour shift I had some amazing trauma come in that I played a key role in. The reality is more mundane. It was a pretty quiet shift as shifts go. Ironically, so far my hardest shift so far was probably last Tuesday, where I ended up doing compressions on two different patients, assisting putting in a Blakemore tubing and more. It was one of my busiest shifts and I had already extended it from 4 hours to 8+ (staying until after 3:00 AM Wednesday morning) and almost stayed until 7:00 AM. From reports afterwards, things didn’t get any better. Not entirely sure what was going on that day that made so many people need the ED, but it was a busy time.

I’m starting to see the end of this part of the trip. I have about 5-6 more weeks of school and I will be quite glad when this semester is done. That said, now I have to pop-off and take an open-book online quiz for BioChem.

Running a Race

I’l probably expand upon this when I have more time, but I’ve given some thought to an analogy that describes my current life this semester:

It’s like the show from the late 2000s (and apparently back called Wipeout. The goal is to run the course as quickly as possible while avoiding obstacles, many you can see and plan for, but some might pop-out unexpectedly.

The race I’m running is to get in at least 1000 hours of patient contact time so I can apply to most of my choices for PA School (one I am considering actually only requires 500 and a few more). In theory I can apply BEFORE I finish the hours (most allow programs you to apply as long as you’ll have enough before the end of the year). That said, I’m not content to say “Oh ok, I barely squeaked in 1000 hours”. Nope, I want them NOW! I’m getting there.

The obstacles are my classes. I pretty much know when tests and quizzes will be, but I have to plan my schedule around them. And then I have my IT work which mostly I can shift around the workload, but occasionally something pops up that needs fairly immediate attention. These are the obstacles I can expect, but not when.

Fortunately, come May, I’ll be down from 3 classes to just 1 over the summer and things should get easier.

But in the meantime I’m running as fast as I can, trying to avoid wiping out! And that’s one reason my weekly blog posts have been shorter and later than in the past.

What Inconvenience?

On the way into the ED at where I work, there’s a player piano in the lobby. It’s nice, adds a bit of ambiance.

That said, the other week it apparently stopped working. These things happen. What struck me as interesting was the sign that was put up.

Piano will remain silent, until necessary repairs are made.
Sorry for the inconvenience.

It was that last bit that struck me: Sorry for the inconvenience. I can see “sorry for the disappointment” or something similar. But now I’m genuinely curious about who is inconvenienced by this small mishap.

Again, my views reflect my own, not my employer, Albany Medical Center, and anything I say here should not be interpreted as speaking for them.