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. Consulting DBA ("and other duties as assigned") by day, and sometimes night, and caver by night (and sometimes day). 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.

Another Day in the ED

In about two hours I’ll be setting off for the Emergency Department. When I prepared for my first shift well over a month ago now (it seems like a lifetime) I was nervous, but I made it through it and ended up feeling fairly confident in short order. Today I face another first. It’ll be my first shift on the Pediatrics side of the Emergency Department. (if you want to be hip on the slang, we all just calls it Peds, but pronounced peeds). There’s a door between the two sides and over it, it says, “Two Departments, One Team” but the truth is, generally, at least for the Techs one pretty much spends their time on one side of that door or the other. For example, all the techs I’ve worked with so far on the adult side haven’t spent much time on the peds side (and probably not since their orientation) and the few techs from the peds side I’ve met have been in very brief encounters. But, as the sign says, in theory it’s really one team, so I need to be oriented on both sides of the door.

So today and Saturday are my two shifts in peds. I’m looking forward to it, but as I noted above, I’m definitely nervous. I’m not entirely sure why. Yes, there are differences, but at the end of the day, the work is going to be similar.

So, in 14 hours I’ll have my first shift done and be that much closer to having my orientation done. I can’t wait. Even if I am nervous.

The Circle of Life

“We’ve got a Level 1 Trauma coming into A1, can you run up to the blood bank and grab some units of whole blood?” I hadn’t done this before so another ED Tech came with me to show me the ropes. We went up stairs, handed over the paperwork and they handed us two coolers (one with packed red blood cells, the other with platelets and other factors). I carried them downstairs. It was a humbling feeling: in my hands, I literally was carrying the liquid of life. Without this fluid coursing through our arteries and veins, we die. (and ironically if the iron inside the hemoglobin gets out of its proteins and starts to float around in our blood freely, that can be seriously dangerous too). I didn’t yet know what the trauma was or if we’d even need the blood, that was a decision the doctors would make, but I knew this could make a difference.

I was reminded of the above yesterday as I sat on the bench at the blood drive watching the blood leave my arm and flow down a small tube into a bag just beyond my sight. I have O+ blood, the second most preferred kind (after O-). In addition, I have not been exposed to CMV (cyomegalovirus). This means my blood is a preferred type for pediatric patients since I don’t have antibodies to CMV (most adults have been exposed at some point and probably don’t know it and as such have antibodies).

I don’t know exactly where my blood will end up, but I do know it’ll help someone. In fact it will likely help multiple patients. To me there’s a certain joy, even thrill in that.

It doesn’t take much to give blood. It can take about an hour of your time (more if you do a double-red, but then you only donate half as often) and a small, fairly short, painless prick in your arm. Then they give you snacks!

As I recall, in the above trauma, that specific patient ended up not needing the blood. But I’ve seen other patients since then who have needed blood. I’m glad they’ve been able to get it. It makes a difference.

If you want to give someone something this holiday season, consider giving the gift of life. Give blood.

(and small footnote, before anyone criticizes the American Red Cross’s policies, some which I think are overly stringent and even discriminatory, please note it’s actually the FDA that sets the rules and the ARC has argued for changes. So make sure your frustration and anger is directed a the right group.)

Include the usual disclaimer that I do not speak for or represent my employer Albany Medical Health System.

100 Hours In

So far I’ve got 100 hours in as an ED Tech. Actually it’s a bit more since I’ve had to work past the official end of my shift a few times. Now if anyone has done the math and read a previous post, they’re probably curious how I got to the number 100 and why it’s not 96 or some other multiple of 12. The truth is, my normal shift is 12 hours. However, during my most recent 12 hour shift a text went out to all techs asking if anyone was available to work a “Crisis Shift.” I volunteered. Now the down side is, as an orient I’m not eligible for the bonus differential for a crisis shift (which I’ve been told is fairly nice). But I wasn’t doing it for the money. I was doing it for the experience. Normally my shifts are 11:00-23:30 (that includes in theory 30 minutes for a meal). Since this 4 hour shift started at 23:00, it meant I worked 11:00-03:00. Yes, you’re reading it right: I worked a 16 hour shift. This allowed me to experience the ED at a different time of the day than I’m used it. And I will say it was worth it. The overall “mood” is a bit different. It’s definitely a bit quieter.

And best of all, I survived the shift. Granted the next day I resorted to a dose of caffeine between class and lab in order to stay awake, but overall, it wasn’t too bad. On the other hand, if I were 30 years younger, I think it would have been a bit easier to recover from also.

I’ll probably pick up more Crisis shifts in the future, especially once I’m eligible for the Crisis Pay differential since it gives me the experience and pays decently.

Footwear

For my original shifts I pulled out some old shoes to wear. I figured if they got covered in fluids or something I could toss them. Sure enough, on my second or third shift I stepped in something very sticky. I looked down with dread and was relieved to see it was only some apple sauce the patient had spilled.

However, fairly quickly I realized how uncomfortable they were. The one weekend I should have gone shopping for new shoes I didn’t. It took me a few shifts and some thought to realize what the real problem was: lack of arch support. Hence the photo above where I added some impromptu arch support. It was an amazing difference.

That said, this past weekend I picked up a pair of Skechers to wear at work. One big advantage of them too is they’re machine washable. I suspect at some point I may have to take advantage of that ability, but so far I’ve been, apple sauce aside, lucky.

And now off to another shift (and two more this coming weekend.)

And of course the disclaimer that I in no way speak for my employer Albany Medical Health Systems in this post. That said, I do hope not to see anyone of you in the ED any time soon. Drive safe over this break and please do not drink and drive.

Production Code for your SQL database

I realized after writing my earlier post that today was T-SQL Tuesday. I wasn’t going to contribute, but after seeing some posts, I thought I’d give a very quick shot at it. This month, Tom Zika (t | b) asks us to talk about what makes code “production grade”. You can find his full invitation here.

There’s some great columns there, but I’ve noticed something that many developers assume (and honestly, it’s a good thing) and that’s that they work in a company with good source control and a decent release procedure. Sadly, with my clients, it’s rarely the case. Often I’m inheriting code that’s only available on the production server itself, or there’s 20 different contributors (ok I’m exaggerating, but not by much) and each has their own stash of code.

Ultimately this means the production server really the only single source of truth. So that leads me to my first item.

Select * and other shortcuts

It should be obvious, but while I may often use Select * while developing code, I’d never put it into production. Even if it works, it’s messy. But I’d go a step further. I prefer to fully qualify all my columns. For example

select Emp_Num, First_Name, Last_Name, City from Employee_Table

vs

select E.Emp_Num, E.First_Name, E.Last_Name, E.City from Employee_Table E

Now the above is an extremely artificial example. But now imagine I want to join it to say a table of phone numbers (because the original developer was smart enough to realize an employee could have multiple phone numbers and didn’t simply add columns to the Employee_Table.)

So now someone comes along and rewrites the first as:

select Emp_Num, First_Name, Last_Name, City, Phone_Num from Employee_Table E
inner join Employee_Phones EP on EP.Emp_Num = E.Emp_Num

Now, they’re of course deploying to production as they go and suddenly the above code breaks. Fortunately, they’re fairly smart and realize the fix and go in and edit it to

select E.Emp_Num, E.First_Name, E.Last_Name, E.City, EP.Phone_Num  
from Employee_Table E  
inner join Employee_Phones EP on EP.Emp_Num = E.Emp_Num 

So it’s a simple thing, but by making a habit of fully qualifying your column names, you can avoid future errors.

Failing Gracefully

When I’m writing quick and dirty code, while I try to avoid errors of course, I’m not overly worried about leaving the system in unstable state. By this I mean, if I’m debugging code with a cursor in it and it breaks and I have to manually drop the cursor that’s fine. Same thing with transactions. Yeah, I might block someone else’s work, but I’ll pretty quickly realize what I’ve done and be able to commit or rollback my transaction.

In production code, without going into details on TRY/FAIL blocks and all that, I would argue that any code that contains a cursor, a transaction or anything else that could potentially block processing absolutely needs to have robust error handling. I’ll ignore the debate about what the best way to handle it is, in part because sometimes rolling back is the right answer, trying again might be the right answer, or even finishing the transaction and then cleaning up data later. The point is, you can’t afford to fail in an ungraceful way and leave your system in an unknown state.

Alerting

I didn’t have this on my mind when I started out with this post, but the last bit reminded me of it. It’s not code per se, but more jobs and the like. Generally, I’m a huge fan of alerts. If something has failed, I want an alert! But, I realized a long time ago, that alerts have to be actionable. This means the person receiving it has to both be able to act on it and that it actually needs to be acted upon. If something fails and it needs no action (and the action can be as simple as simply noting it for future reference) then don’t bother alerting. Log it or at the very least, retry before you send an alert. Years ago at one client they had a job that would fail once about every 100 days. It ran once in the morning. It had an alert that met the above criteria, I or another DBA could react to it and in this case the reaction was simply “retry the job”. I finally analyzed it and realized that given the failure mode, simply waiting a minute and retrying was a far better solution than alerting us. I did some math on the failure mode and realized that this new setup should cause failure on the second attempt (and then send us an alert) once every 10,000 days. So the initial alert was sort of pointless when there was a better way of handling it.

Conclusion

So, to sum things up: avoid errors, if you do have errors, handle them gracefully, and if you have to alert, ma

“Help me put out the drunk cat”

Just a short post today. The title comes from the little bit of a dream that I recall from last night. It was something my father said in my dream. There’s really no meaning to it more than what it seems. In the dream he needed help catching and putting the very overweight and drunk cat outside. Don’t ask me why the cat was drunk or why it had to go outside (though I suspect that’s a better place for a drunk cat).

Why do I mention this seemingly random line? It’s because it’s an insight into how my dreams of my father have progressed. In my dream I heard my father’s voice. This is very bittersweet for me. Of all the tangible things I miss the most since he’s gone it is his voice I miss the most. For awhile I didn’t dream of him at all. After a while I’d start to have dreams with him in them. They were often variations on discovering that he was actually alive and we had to figure out how to undo selling his estate and all that paperwork. Then my dreams changed a bit and within a dream I’d remind myself that it was only a dream. Then they changed again. This time it was an inner voice telling me, that at least this time it wasn’t a dream. Those were hard to wake up from. But they also all had one other thing in common. He was always silent in them.

That was the hardest, I was forgetting his voice.

That too has changed over time. More often now when I dream of him, I hear his voice in my dreams. I couldn’t tell you what it sounds like and honestly, I’m not sure it’s really HIS voice, but in the dream it seems to be and that’s good enough.

I miss him every day, but some days, it’s his voice I miss the most.

I am in the Right Place

A couple of weeks ago I asked “Am I in the Right Place?” The question will always be in the back of my mind and I think that’s a bit healthy. I think any time anyone gets too sure of themselves, especially when lives are involved, it’s a bad idea. That said, I’ve now done 3 shifts in the Emergency Department (ED) and the answer to my question is “yes.”

In 36 hours I’ve learned a lot. I’ve done at least 2 dozen EKGs and only had to repeat one of them at doctor’s request. I’ve done more than my share of Covid Swabs. I’ve done a psych sit. And one of my fellow techs let me practice a straight stick blood draw on her. According to her I did well (she commented on her lack of bruise the next day). I’ve also done chest compressions. I’ve also sat around with nothing to do. That’s rare and one savors those moments.

I’ve had sore feet and one night as I got into my car my lower back froze and I couldn’t move for a few seconds. I’ve gotten dehydrated because I had forgotten my water bottle one day and it was too long between getting some water. I’ve snacked on the run (fortunately however, as an orient, I’m in theory guaranteed an actual food break which I’ve taken advantage of so far, but once I’m beyond orient status that may no longer be available).

I’ve worked to 2 12-hour shifts back to back and then gotten up on the 3rd day to make it to A&P Lab after only 6 hours of sleep.

But, though I’m only 3 shifts in (and about to run my 4th) after the first night I was confident I’m in the right place. I’m gaining confidence in my skills and abilities and I’m earning the trust of my colleagues. And at the end of the day, I’m enjoying what I’m doing. At least so far. We’ll see what I’m saying in 6 months or 12 months.

But at the end of the day, so far, yes, I think I’m in the right place.

And now the obligatory disclaimer that I do not speak for my employer Albany Medical Health Systems and my views are entirely my own.

Having Faith

Over a week ago, I had someone tell my wife that they were excited about my applying to PA school and they’d love to be my patient if I make it. While I appreciated their faith in me, I reminded my wife that if my career choice goes in the direction it does, my preference would be to work in an Emergency Department and as such, that person might not want to be my patient. This reminded me of a time when a friend was giving me a tour of the med-flight helicopter he worked on and showed me the logo that was on the ceiling above where a patient would be laying on a stretcher and joked few people saw it the way I did. In fact he added, many in a position to see it from a stretcher were often not in a good enough shape to really see anything.

Last week on social media I posted a bit about a specific concern I had in the process. It was more a comment than anything else. I generally don’t post such things looking for support or the like, it’s often more a stream of consciousness. Well the amount of “attaboys” and “you’ve got this” was uplifting and encouraging. Now the truth be told, most of the folks posting didn’t know the specific details of concerns and while I appreciated the sentiment, it didn’t change the actual reality. But that’s ok.

Here’s the thing. I might not succeed. I might hit a roadblock. I might find a class that simply stumps me. I might find my time in the ED to be such a negative experience that I decide to go back to being a fulltime DBA. Most of all, even with all the prep work, there’s no guarantee my primary (or even backup) schools of choice will accept me. Simply statistically, the odds are long. (Fortunately it’s not as simple as a roll of dice, there’s a lot more to the process than simply that.) But at the end of the day, knowing people have my back, for better or for worse, helps hugely. It’s not so much “how can I fail when I have so many people cheering me on” as much as “whether I succeed or fail, people will support me”. That makes the effort that much easier. And for that I’m grateful.

So, a year from now, I really hope to be able to tell folks, “yes, I was accepted” but even if I’m not, I’ll know they have faith in me. That’s helps more than I can express. Thank you.

Am I in the Right Place?

First this question came to mind when I arrived for the second day of orientation. Technically there was no sign for where ED Techs should report to, so I made the assumption that it would be the same classroom as Patient Care Associates. But when I went to the classroom it was dark and no one was there. I fretted a bit, but not too much, after all I was early.

Fortunately my assumption was right and I was soon seated among a number of other students. Turns out only one other was also a Tech, who happened to be assigned to the ED, but all the others were PCAs in various departments.

The second time the question came to mind was while waiting for the class to start and I’m reviewing the material and start reading the requirements and wondering, “umm, I’m not sure I really have the experience they expect. I’m sure I’ll be found out shortly.”

Fortunately, again the answer appears to have been yes, I was in the right place. This became more evident over lunch when 4 of us started talking about our backgrounds. Yes, some clearly have more experience in the medical field than I have. But some are starting at about the same level I am, or perhaps with even a bit less experience.

So yes, I’m in the right place. At least so far.

This is not to say it won’t be easy. There’s a lot to learn. Some of it I’ll learn tomorrow, some will come later. Like any job, I suspect the learning will never be over. So it’s two days into my new job and so far I’m still loving it.

And today I’m officially a step closer:

I make these look good?

And now for the first time I have to add that the above are my own words and do not reflect the opinions or views of my employer Albany Medical Health Systems.

It’s Just Another Brick in the Wall

Actually, unlike the song, I feel like I do need education and I’ve been getting it. Ironically in A&P II we’ve been covering the adaptive immune system just as I’ve been going through my intake steps for my new position. I mentioned last week that I had go get a number of shots. As of today in the last week I’ve had the current flu shot (last Monday), the new covalent Covid vaccination (Wednesday), a TDaP vaccination (yesterday) and the first of two Hep B vaccinations (also yesterday). So it’s been just “another shot in the arm” for me several times now. Oh and the second of two injections of tuberculin to test for tuberculous.

I’m not sure if my immune system is hating on me right now or loving me. Hating me because I’ve asked it to respond to a foreign substance 6 times in the last 7 days, or loving me, because right now, there’s a series of T cells forming (or having formed in my body) with the net result that I’ll have a bunch of additional T memory cells floating in my blood stream and lymphatic system just waiting in case the real thing (for pretty much any of these things) come around. I don’t know anyone who really enjoys getting a shot or even the reactions we often get (for the record my reactions to all of the shots so far have been very mild).

That said, I am happy that at least for now, it looks like my days of being a human pin-cushion are over. I have one more Hep B shoot in about a month and then after that I’m good for awhile.

Just one more step to get into the world of working in the Emergency Department.

I start orientation on Monday and can’t wait. In the meantime, my immune system can deal with it. I know I am.

“The Water is Turned Off…”

“,,, so you won’t be able to flush or wash your hands until I turn it back on,” the nurse said. I understood why, but honestly, the sound of some rushing water might have helped with the task at hand: filling a specimen bottle with at least 40 ml of urine.

I had forgotten until a few minutes earlier when she had mentioned it, that a urinalysis was required as part of the intake process. I’m generally against drug tests for most jobs as I think they’re irrelevant and don’t necessarily have a bearing on the candidates ability to do the job. It’s part of the reason I actually ended up in consulting right out of college. The software company I could have basically walked into a job with had been acquired and now required drug testing. Now, I was not at the time taking drugs and have actually never taken illegal drugs, not even any form of cannabis when it’s been offered. So it was never a fear of being caught. It was simply a resistance to what I feel is an unwarranted invasion of privacy for a tasking involving sitting in front of a computer and creating code.

But this job is different. This job involves both being directly involved in the health care of others and it involves being exposed to drugs. I feel it’s a reasonable compromise. So there I was being handed a sealed specimen bottle standing in a bathroom. Outside all my items, phone, keys, pen, etc. were locked in a cabinet, I’m assuming to ensure I couldn’t sneak in any clean samples. She walked out and I gave deep thoughts of places like Niagara Falls. Fortunately it worked. Less than a minute later I was handing this woman I had met only 20 minutes earlier a warm specimen bottle full of my pee.

Protocols

She had with her a kit that included another container of sorts. She opened it and the specimen bottle. I started to leave the bathroom and she told me I had to stay “since I have an open specimen bottle”. I realized in this case, unlike the lack of running water to keep me from cheating, this was most likely to make sure there was a witness to prevent her from tampering with the sample.

Once it was transferred and sealed in the new container we left together and she started filling out some forms on the computer screen while we waited for the urine to travel up the test strips and react with the reagents. Think about how the Covid test trips we’re all familiar with work, a Control line and before that a Test line (the Control being after to of course ensure the sample has travelled past the test). This container had 3 strips built in so I asked about them. The 3rd one actually had 4 tests on it, but she said she ignored one. I asked why. It turns out it was for THC, since it was no longer banned in New York. So, I suppose I could take up pot if I wanted to. But I have no interest. I also had fortunately not eaten any poppy seed bagels recently!

After all the strips all reacted she moved it to the edge of the counter and rang a bell. She explained she needed a second witness to sign off on the sample. In this case I assume it was to ensure I wasn’t bribing her to pass my sample. Not 2 seconds later we both hear a rather loud, “GOT IT!” from down the hall and up walked another nurse. She saw our somewhat surprised faces and admitted, “I love doing that.” I joked in return that I had apparently passed my audio test (which strangely enough is about the only thing they didn’t test yesterday!)

The Rest of the Afternoon

I’m not ready to call that the highlight of the day, but it was just one part of that day’s intake process. I also managed to get a flu shot, the first step of 2 TB skin tests, scheduled for a Tdap vaccination (in addition to hopefully at the community college getting my Covid Bivalent booster this week), the second of the 2 TB skin tests, get fingerprinted, get entered into the HR system, fitted for an N95 mask, and start the paperwork on parking.

I had arrived around 1:00 PM (a bit early for my 1:15 scheduled appointment with the health center) and was done with all of the above by about 3:15 PM. Not too bad. There was some waiting, but overall a rather expedient process.

N95 Mask Fiitting

This was one thing I wasn’t familiar with before yesterday. I knew the general principal: make sure the mask is tight and the nose bridge is well-formed to your face. However the fitting process is actually a bit more complex. I did find out after arriving that if I had wanted to keep my beard, they have a a PAPR and I could have been fitted for that. But honestly, I figured it was time to get rid of the Covid Beard for a bit so had shaved the day before.

The actual fitting is interesting because the mask they give you is hooked up to a machine with two tubes, I’m presuming to measure air inflow and out. You put on the mask, fit it to your face and then, as the machine instructs do a series of exercises, including bending over for 30 seconds and breathing, loudly reading some text, turning your head side to side and then up and down. Apparently my initial attempts at fitting weren’t quite right so the fitter came around to my side of the bench and moved the masked down and adjusted the nose piece a bit. She explained after why. So now when I’m wearing an N95 mask, I’ll have to remember to place it a bit lower than I thought was proper. I was also instructed to refuse an assignment if the type of mask I was fitted with was not available. So for those who are geeky enough to care, my mask type is a 3M 8210 Reg – White. I even have a sticker to put on the back of my ID badge once I receive it.

Beardless Again

Next Steps

So, Wednesday I go back to have the TB test checked and then next Monday go back again for the TDap booster, another TB Test, and I think the first of two shots for my Hep B regiment and then back next Wednesday for the final TB check. Then on the 17th I start actual orientation at 8:00 AM. (due to orientation it looks like I will be missing an A&P lab and two A&P lectures unfortunately). Finally, I think my actual start date on the ED floor will be October 25th. I can’t wait!