The Changing Size of the World

I was reflecting earlier how the size of my “world” has changed over time.

When I was an infant, I didn’t know of a world beyond my crib. But as I got older, the world got bigger. While I have memories of going between Storrs and Falls Village CT, I think my first realization of a bigger world was when I followed some older boys in the housing complex in Storrs and ended up lost (I suspect they probably ditched me since who wants the 4yo following them around and ruining your fun when you’re 8 years old.) That ended up with a happy ending as a stranger found me and quite literally drove around asking if I recognized my apartment building. Apparently I did. I can’t imagine that scenario playing out today. That said, well before I can remember, my parents did do a trial move to California, but I don’t count that in my awareness, though I have a vague memory of me brushing my teeth while sitting on the tailgate of the Scout which I suspect was from one of the early road trips my dad and mom did.

When I was a bit older, I recall going to New York City with my parents and being confused because somehow I had gotten the idea that a city was bigger than a state and couldn’t figure out how New York City could be IN New York State. But even then, my world consisted mostly of trips to New Haven, CT to see my paternal grandparents and Bennington VT to see my maternal ones. And then there was the occasional trip to Boston to see my aunt and uncle (technically half-aunt, but there was never anything half about Aunt Sue).

At one point, I want to say when I was seven or so, I know I did a trip with my parents to Cape Code and to Bar Harbor ME. My world was getting bigger.

A few years later, a very different trip to Bar Harbor and then the Cape. That ended well but didn’t start so well.

Then a few years after that my world jumped in size. My dad and his then girlfriend and her daughter (four years my junior) and I travelled first to the Grand Canyon and Havasu Canyon. Suddenly I was outside the comfort of the northeast. And I loved it.

There were a few trips to Florida in there too, including my first time flying alone.

A few years after that I went to St. Croix USVI with my dad. My first long flight over water.

Years later I accompanied my paternal grandmother (my grandfather having passed on years previously) to the UK for my cousin’s wedding. Again, my world had expanded.

The NCRC has also helped expand my world due to having training all over the country.

And over the years, including this one, I have been back to the Grand Canyon three times since and have with the family seen much of the west coast, the Rockies and more.

And pre-Covid, the family and I visited the UK, France, and Belgium. My world continued to grow.

Going forward, I’m sure I’ll see more of the world.

And yet, in some ways, my world has shrunk and for a sad reason.

Other than a couple of brief trips to or through, I haven’t been to New Haven since my grandmother’s memorial.

I still go to Bennington, because my mom is there, but even then there’s a bit I don’t go to, my grandparent’s house. It’s no longer in the family since they’ve passed.

I’ll go to Boston again, but not as frequently since my aunt has died.

And I have yet to go back to Falls Village, ever since my closing out my dad’s estate. That one is just too hard, even years later.

You’ll note there’s a theme to the places I’m less likely to visit. And it’s one that I expect to become more common as I age.

So the world is bigger than ever and I’m still exploring it (as my spring road trip shows) but ironically in some ways, it’s grown a bit smaller. And that saddens me.

And so it goes.

Day 15 – Reentry!

Spaceflight has shown that reentry is the most dangerous part of a flight. More people have died on re-entry than during launch. And even in uncrewed flights, there have been a lot of mishaps on reentry.

My reentry to normal life didn’t really have the risk of a fiery burn-up, though, had I not gotten enough sleep, a fire and crash was distinct personality.

After leaving my friend’s house I drove for another hour or two before getting some food and then eventually some sleep. I ended up pulling over at two separate rest stops to nap. The final time I woke up around 9:00 AM. I had hoped for an earlier start since I was still about 9 hours from home. But obviously my body needed the sleep.

There’s not much to report on the rest of the drive home other than I was struck by how green things were in the Northeast. Partly this was due to it being Spring and in the weeks I was gone a lot had bloomed. But also, I had been in the desert for so long which is a lot of reds and oranges and whites and grays, but very little green. The contrast was striking.

But the danger was a bit more subtle. It’s one thing to basically spend two weeks with no schedule and no responsibilities. It’s another to return those things. Here it is Saturday, and I’m still catching up. Laundry is done and half the car is unpacked. I’ve still got more to go. That said, it’s not like I haven’t been doing things. I spent most of yesterday dealing with paperwork related to starting school in a month.

And as strange as it sounds, Wednesday night/Thursday morning, I picked up a 4 hour “princess shift” in the Emergency Department from 3:00 AM to 7:00 AM. Based on the texts requesting help and looking at schedule, there were only 3 other techs scheduled so I knew they could use the help. I figured my sleep schedule was already messed up, so another late night/early morning wouldn’t be a problem. And honestly, it sort of helped me reenter my normal life.

At this point I have four regularly scheduled shifts left before I stop working as a .6 FTE tech. I will probably pick up one or two more during that time. But the time is quickly coming when I’ll be in that transition from working to schooling. I’ll have a couple of weeks to finish up projects around the house, sign a lease on a place in Delaware, and to move enough down there to setup housekeeping. So, my reentry is just a pause before the next journey. But I think I’m ready now.

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.

Another Regret and Another Milestone

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

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

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

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

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

And that’s it from here this week.

A Door Closing

So I’ve hinted a bit on some social media about a change. The change has come. I would have posted more details yesterday, but given that particular date, I didn’t want anyone thinking I was trying to do an April Fool’s Joke.

So the door closing is that as of March 31st, my contract with my largest client is over. This was actually a mutually agreed upon date. In fact, when my manager scheduled a meeting with me in December, I knew it was coming and expected he would want to end things in January or even perhaps December, so honestly, I was quite pleased to have the extra time.

That said, it was obvious to both parties that this was coming. I was spending less and less time on projects for them. This was due to actually a variety of factors. Strangely, a huge part of it was something that I hadn’t planned on: Grand Jury Duty. During the weeks I was on the Grand Jury, between that, the class I was taking and my ED Tech work, I had very little time left over to spend with this client, so they didn’t assign me any real projects at that time. But even besides that they had been using my skills less and less and I had been allocating less time to them. So, the end was inevitable.

And to be honest, I’m actually very excited about this. When I made the decision over two years ago to apply to PA School, it was driven in a huge part because I was tired of IT. I was also tired in part of having to learn new things in IT. Specifically, I didn’t want to learn who to do what I was doing in new ways. For example, the SQL Server world is moving more and more to Azure and other cloud providers. I’m actually in favor of this. But it’s really simply doing much of what I do in a new way. That’s not a challenge that excited me.

If I am to learn new things, I want to learn them in a new domain of knowledge. Becoming an ED Tech and eventually a PA is just that, learning new things in a completely new field. Some of my skills remain the same. One of them is my ability to solve problems. I’m just applying that skill in a new arena. This is exciting.

What’s also exciting is for the first time in over a decade, and ignoring two breaks, really since before the turn of the millennium, that I don’t need to be checking my email almost constantly. For a variety of reasons, most of my IT jobs over the past 3 decades have, if not required me to be available 24/7, at least highly encouraged me to be available 24/7. With my ED work, when I’m done with a shift, I’m truly done. No one is going to call me at home and ask me to log in and do an EKG on a patient. Right now my ED work is officially only part time, but I can pick up shifts, something I’ve been doing a lot. But on the flip side, I’m under zero obligation to pick up shifts if I don’t want to. The fact that I’m not on call and that I can pick up or not pick up when I want to is very liberating. I’ve been looking forward to this for awhile.

Another short-term change is that I don’t have to worry about trying to fit in client meetings with my currently highly variable sleep patterns. Last week for example, because of the shifts I picked up and one regular shift and my client needing meetings, I basically only got about 8 hours of sleep in a 56 hour period. I couldn’t get a solid “night’s” (since I generally sleep during the day because of the ED night shifts I work) sleep. I had to wake up and attend meetings. That’s over with.

And in some ways, there’s no going back. That’s not strictly true. My IT skills are still fresh and relevant and I have enough industry contacts that if I wanted to change course back, I could. But I don’t see happening.

Really the only downside is the change in income. Trust me, IT work pays a lot better than ED Tech work. However, fortunately we’re the point where total income isn’t as big as factor as it once was. Basically I can afford to “follow my dream” and we can still maintain our lifestyle. We’re fortunate that way.

So what’s next? Well later this month the application process for my second round of PA School applications begins. I’m much more hopeful this time around, though we’ll still have to wait and see. Assuming that’s successful, sometime in 2025, I’ll start a two plus year journey of again diving deep into learning with very little free time and I’m looking forward to that.

But in the meantime, I expect to travel a bit more, relax a bit more, work on some more projects around the house. Overall, I expect to simply enjoy life more.

And perhaps even blog a bit more than I have been.

Feeling Good but…

I think it would be fair to say that like everyone, I’m a bit sick of Covid (thankfully not sick from it.) I just got my booster on Friday and then I’m hearing about the Omicron variant.

I submitted talks for SQLBits in the UK for next year, hoping to present in person. And I’m hearing about numbers rising.

I’m planning a mini-vacation/cave rescue training trip to Hawai’i next year and making sure everything is refundable. Just in case.

So I’m feeling god but…

At the start of each year, I set some financial goals for myself. Some include what things I may pay off, save, or how I’ll spend it (now admittedly most of those are fixed, such as knowing I’ll tax property taxes, etc.) As a contractor I also set a couple of various goals for new work and how much I’ll hopefully earn in the coming year. I find these are important as they help keep me focused and moving forward.

The good news is, financially I’ve hit all my goals, and then some, this year. The downside, with that, and with Covid continually popping up its ugly head, I’ve lost some of my motivation for the rest of the year.

Fortunately, this has freed up some time for some projects around the house. Almost two years ago, with help from the kids, I started on a project to replace some leaking pipes and replace the resulting damaged drywall in the basement. I’m proud to say I’ve finally gotten around to taping and painting the drywall in the basement and patching around where I put in the new bathroom fan. Things get done, albeit slowly.

I’m also feeling good because a major project for one of my clients is mostly completed. But it also came very close to burning me out and I’ll admit I even considered walking away from the client over it. The strange part is that it wasn’t a particularly complicated project, though it did involve a combination of SQL, PowerShell, and using a product called Pentaho. Technically it was fairly straightforward. But, for awhile, the project management was absent and the then lead was actually another agency who, I think it’s safe to say didn’t clearly understand the full scope of the project. With the addition of the client adding their own PM and working with a different agency taking over a bunch of the work, things have gone much more smoothly. Now we’re simply dealing with small niggling details that got missed before.

What kept me from walking away (besides it being my largest client) was a sense of responsibility to the client. Without my efforts, I think the project would have easily been set back a month as they would have had to bring someone else up to speed on my efforts.

Now the upside is that because of the overtime required (and it’s still ongoing) I met my financial goals for the year (and hence now have time for the house projects). So that’s a good thing.

But it did highlight how frustrating being a single-person consulting agency can be at times. It’s made me re-evaluate my goals for 2022. I’ll be writing more about this in a future blog, but it has got me thinking more about getting back to working for an company as a full-time employee, ideally in a management position. Strangely one thing I’ve come to realize is I actually enjoy making decisions and I enjoy managing. I sort of miss it.

And perhaps after nearly 2 years of Covid (and nearly a decade of pure consulting), it’s time I get out of the house more and travel a bit and interact face to face with people.

We’ll see.

But that’s it for today. I’m feeling good but…

P.S. One thing I did finally accomplish is submitting my latest article to Redgate’s Simple-Talk.

A Different Perspective

I was going to write a follow-up to last week’s article on Simon Biles and talk about teamwork, but decided to go with something a bit more lighthearted: a Hudson River cruise.

As many of you may know, I live in upstate New York, specifically near Troy. A dominant physical feature here is the Hudson River. Within a 10 miles of my house there are eight road bridges and one river bridge. But even with that many crossings, it’s a definite barrier to travel at times.

The eastern side of the river, other than Troy tends to be fairly rural with only a couple of large open-air shopping malls. But to the west is Albany and Colonie and they have the two largest indoor malls in the area, plus a number of open air malls, the State Capitol, and the bulk of the office space. This means to do a lot of what most of us on the eastern side want to do, we have to cross the Hudson.

I suspect most folks who cross the river don’t give it much thought, beyond it being a barrier to get over using one of the aforementioned bridges. I know as a bicyclist I definitely have to do some route planning when I want to get to the other side.

This past weekend, my family and I decided to experience the Hudson from a different perspective, actually on the Hudson. We signed up for a 90 minute tour on the Dutch Apple leaving from downtown Albany. I want to start with the name. I’d say most of my readers are probably aware that the name of the river comes from Hendrick Hudson, an early explorer of the area, who first sailed up the river that now bears his name in 1609, over 400 years ago. They might even recognize he was Dutch. But, given the state I live in is known as New York, most folks think of New York as primarily an English settled area.

But, the early history is definitely Dutch and there’s still a very strong Dutch influence in the area that extends beyond the name of the river. I live in Rensselaer county, named for Kiliaen Van Rensselaer. He was once claimed ownership of the most land by any European in North America, with his claimed holdings extending for miles on both sides of the river.

In addition, the first settlement in the Albany area was known as Fort Orange. Also, instead of streams in the area, many of smaller waterways are known as Kills. But enough of the early history and language lessons.

The cruise let us see the river from only about 10′ above the water level, not 100′ like some of the bridges (little side note, until late in the last century, the US Coast Guard required bridges as far north as Troy to have at least 60′ clearance.) And instead of crossing over the river, this allowed us to cruise along it.

After undocking, at first the Dutch Apple headed north from its mooring. We sailed under the Dunn Memorial Bridge where a Peregrine nesting box was pointed out and some could see a one of the nesting falcons. I could not.

Dunn Memorial Bridge (Peregrine box underneath on top of the concrete pier)
Dunn Memorial Bridge (Peregrine box underneath on top of the concrete pier)

Unfortunately for us, just north of there is the Livingston Avenue Railroad bridge. This is a swing bridge that’s too low for the Dutch Apple to pass under. Taller boats can pass upstream of it but need to make arrangements in advance with CSX/Amtrak. So from there we turned downriver.

One thing many people are not aware of is that the Hudson River is actually an estuary as far north as north Troy where the Federal Dam is located. This means that there are tides on the Hudson all the way to north Troy. When one crosses over the river one can notice the tides if one is observant or the tide is particularly low and the smell pungent. Saturday, as we headed south, the tide was coming in. Between this and the wind, it actually meant the boat had to make more effort going downriver than upriver!

River in foreground, with the old D&H building in the midground and Corning Tower left of center in the background.
Albany from the Hudson

Another reminder of the importance of the Hudson and the nearby Mohawk, and later Erie Canal was that the Albany/Troy area was once the gateway to the west. Besides the waterways, trains were an important part of this, and one of the major local railroads was the Delaware and Hudson. From the river you have a nice view of the old D&H building which now houses SUNY Albany offices and other offices.

Heading further south, on the eastern bank Fort Crailo was pointed out to us. Again, a Dutch influence, but also home to where Yankee Doodle Dandy was later written down.

Given that the Hudson is a tidal river and Albany is still an important gateway to the west, the Port of Albany is a key part of the local economy. But again, I would suspect most folks who drive across the Hudson aren’t aware of the size and scope of the port. I think most equate it with the area where the Dutch Apple and the USS Slater are docked. Really though that’s not the active part of the Port of Albany. But the following photos show facilities on both sides of the river.

Foreground is the Hudson, with a seawall and then a wide open area for the port of Albany.
Port of Albany with huge mobile cranes

Apparently the Port contains the largest grain elevator east of the Mississippi!

Sloping roof dominates image with storage towers on both sides. Part
Grain Storage at the Port of Albany

As you can see, even ocean going ships come this far north.

Large orange tank, with two tugboats pushing it into position.
A large ocean going tanker
Bulk cargo ship with 3 of 4 cranes in operation, loading scrap
Loading Scrap on the eastern short
Dark and light orange barge with tug headed up stream.
Barge with tug

Not all commercial craft on the Hudson are ocean going. The Mississippi isn’t the only major US river with barge traffic. That said, Hudson river barges are much smaller and as far as I know, are only moved one at a time. It’s hard to tell in this photo, but the barge actually has a small notch in the stern that the tug fits into for pushing. This barge is most likely loaded as its sitting low in the water and being pushed. Once empty, often the tug will move to the front and tow the barge as it will be riding higher in the water and by being in front the tug has better visibility.

But the Hudson is not all business. Folks also have lots of fun.

Powerboat passing us on the Hudson.
Having Fun

Finally after about 50 minutes of sailing, we headed north. Our tour was scheduled for 90 minutes, but because of the incoming tide, we actually headed upstream a bit faster.

Image is of the Hudson, with the Corning tower a speck in the background. Boat ensign in the foreground.
Looking north before we turned around

I’ll brag a bit and say I probably know a bit more about the Hudson and its history and influence than many in the area, but it still really helps to see it close up and realize things like exactly how large and busy he Port really is and to hear more history of it and even see some of the history (like the shore protection put in over a century ago, or some of the older residences on the river, some that are close to 300 years old).

We have a deep history here and its worth getting down to see it. And sometimes one needs to look at something that they see every day from a different perspective.