It’s Not Their Responsibility

Imagine if you will, a friend tells you they found an unwelcome guest had been in their house. Not necessarily a burglar or anything like that, but simply someone who saw the door was unlocked, and decided to walk in, grab a cold one, pop it open and then put their feet up and start watching TV. Finally they finished watching TV and left. The only thing left behind was a note that said, “Hey, I noticed you had a really nice house, and a nice taste in beverages and your TV is really kick-ass. Hope you don’t mind me checking it out. I’d love to get to know you better and perhaps replace the cold one I drank. Thanks”

Your friend is understandably upset. They feel violated and they post their anger about it.

Now I want you to ask yourself, how would you react?

Would you tell them, “well you should lock your door?” That may seem like good advice, but I suspect your friend has already thought about it. And perhaps they had good reason to leave the door unlocked (perhaps they were just out for a bit and expecting an actual welcome guest to pop in?) In any case, probably not the most useful advice and in a sense is putting the burden on your friend.

Would you commensurate with? Give them a hug and tell them how you sympathize and how you share their concerns? I’d hope so. Your friend has just shared something traumatic with you. They are most likely looking for some comfort.

Would you suggest to your friend that perhaps they should figure out who this person is and take the time to tell them that going into people’s houses uninvited is not a good idea? Let’s ignore the difficulty of figuring out who the person is (perhaps they left their address in hopes your friend would contact them). I would certainly hope you would not do this. First of all, it’s not your friend’s responsibility to tell a complete stranger how to behave. Secondly, you’re now putting the pressure on the victim here and potentially adding to their trauma. There really is no upside to this approach. Just DO NOT DO THIS!

Now, imagine it’s the complete stranger is actually your friend who did this. You hear their story of how they basically played Goldilocks for a day in someone else’s house. This time, ask yourself the question, would you expect the home owner to tell them what they did was wrong or would you think perhaps you as a friend should point out how egregious their behavior was. This is where your focus should be. Making sure the people around you don’t do this. Not telling the homeowners to give this lesson.

To whose who are saying “well the above is a made up scenario” you’re right. It is.

But replace the house and the cold one and the TV with an unsolicited email via a professional site like LinkedIn. It’s the same effect.

Let’s play a little game here. You may recall it from Sesame Street. It’s called “One of these things is not like the other.”

  • Grindr
  • Tinder
  • LinkedIn
  • Adult Friend Finder

Or another

  • SQL Saturday
  • Local User Group Meeting
  • Your local Singles Group

In the first case, one of those sites is definitely not a place to try to hit on people. It’s a professional site to maintain professional contacts. The other sites are designed to find dates

In the second case, one of those places is definitely a place appropriate place to try to hit on someone. The other two, not so much.

If you can’t tell the difference, my advice, stay away from all of the above until you can.

The take-away: Don’t put the burden for teaching proper behavior on the subject. Take it on yourself and make sure you don’t know anyone who would presume to use a professional site in such an unprofessional manner.

This post may or may not have been inspired by true events. Does it matter?

2021 in Review

Ayup, it’s that time of year where I look back on what I wrote just short of one year ago and heap praise or shame on myself. It’s not original, but gives me some perspective. You can make of it what you will.

So, how did I do for my goals?

  • I did better writing for Red-Gate than I thought. It appears they published 4 of my articles (and in the back of my mind I thought it was only 1 or 2). So check that one off.
  • Expanding my client base: Sort of. Talked to 2 potential clients, one fell through, the other is still in the works. And had another client come back to me with another project which is still in progress. So call that half-way.
  • NCRC Weeklong – Well, a hit and a miss. The National Seminar which was scheduled for June we postponed to August figuring things would be better with vaccines. BUT, there was enough interest in a Level 1 Regional, we used the original June dates for that. And then ended up cancelling the August one, not because of fears here in New York, but more so elsewhere in the country, including the fact that a number of our instructors were being told by their employers they were essential during the end of August and as such could not leave work for a week. So we had A seminar, but not THE seminar. Next year is scheduled for Virginia and isn’t my baby this time around.
  • Continue blogging: This turns out to be my 2nd best year yet in term of page views (unless I get over 300 on this particular post which I suspect I won’t). Last year I was boosted because Brent Ozar happened to retweet one of my blogs. So I think without that I did well anyway. A friend jokes he tells his jokes not to amuse others, but because they amuse him. Well, my blogging is a bit like that. While I always hope others take away something from my blog and writing, I do it as much for myself, both as an exercise in discipline and to keep my writing skills honed (though some may snark I could be failing a the latter).
  • Travel: Nope. Didn’t really do much of that this year. I did get down to Washington DC twice to see old friends (and hopefully make new ones). Those two trips were the first time in close to two years I’ve stayed under a roof outside of New York State. One was via train, so I did get to see the new Moynihan Train Hall in NYC.
  • Continue Biking: Definitely did. But I didn’t get a new bike. This was due to two reasons. One, I stopped by a bike store I had visited years ago, but this time the indifference of the staff was partly a turn off, as was the fact that they didn’t have the bike I really wanted to try in stock. The second was, even if they had the model, getting the one I wanted, apparently had an 18 month backlog. So, we’ll see what 2022 brings. I did NOT do a century ride this year. And instead of 1300 miles, only did 843. Still not too shabby.
  • Hike More: The goal was at least one or two overnight hikes. That was a big fat zero. Mostly due to scheduling and other events just didn’t happen. But, on the flip side, did do several hikes with Randi towards the end of the summer, including one that was a bit more rugged than I remembered (and we almost ended up having to assist in a carryout rescue, which would have really sucked, but the rangers decided to airlift her out).
  • A Book: This was not on my official list since I added it later in the year. I had given some thought and even wrote an outline and 1 or 2 chapters for an idea for a new book, but that didn’t come to fruition. Call is partly due to the Covid Doldrums.
  • Continue to enjoy life: This I definitely did. It was definitely a different year. In some ways 2020 was both harder and easier. 2020 at some point I think I simply accepted the fate of Covid and that we wouldn’t get back to normal until a vaccine was widely available. So I stopped getting my hopes up. 2021 was in some ways harder because with a vaccine, it was easy to get ones hopes up, but due to various surges and now Delta and Omicron, have them dashed again and again. I’ll say right here I’m frustrated and angry with those who continue to ignore the science and tout conspiracy theories about the vaccines and refuse to take them for “freedom” and the like. But I’ll save further thoughts for another day.

Tomorrow I’ll post my goals and hopes for 2022 (and one will surprise most of my readers!) (yeah, a bit click-baiting there!)

But in the meantime, for the close of 2021 (and for some the bell has tolled) let me wish you a happy and safe end to the New Year. If you do insist on going out, be safe, and for the love of all that is holy, and for the sake of my friends who will be working in EMS and elsewhere tonight, do NOT drink and drive!

P.S.: I will link two fellow bloggers who are also ending their blogging year:

  • Steve Jones – The End of 2021 The amount this man writes is simply amazing. Follow him if only for his Daily Coping tips.
  • Deborah Melkin – My 2021 In Review Deborah doesn’t blog as much as Steve (but who does) but when she does, it’s top notch.
  • If others have year and blogs, I’ll add those here if they want.

Speaking Again

Last week I spoke remotely for the Sioux Falls SQL User Group. Adam Hafner had approached me several years ago about speaking at their SQL Saturday event. As much as I was interested, I just couldn’t fit it into my schedule at the time.

More recently he approached me again about speaking, this time at their user group meeting. I hesitated at first, but finally agreed. My hesitation had nothing to do with the group itself, but because I had not spoken in awhile and am still suffering from a bit of what I consider burn-out from Covid and had two less than stellar experiences speaking remotely.

As a User Group Leader, I’m often in the in the position of trying to find speakers and I know how much work that can be at times. And as I’ve noted in the past, I like to give back to the #SQLFamily community that has given me so much. So I said ultimately yes.

I have a variety of topics I can speak on (my favorite though is still my talk about Plane Crashes and IT) and when I’m in a regular rhythm of talking, I can probably give almost any of them on short notice and with little practice. That said, ideally I will run through any of my talks at least once in full again before I present it in front of people. This helps me with pacing, remembering what slides come when, ensuring I don’t forget points I want to cover, and equally important, not straying too far off topic. If the talk requires demos, I DEFINITELY want to run through it at least once or twice before I present.

In this case, since I think I had only presented a SQL talk twice since PASS Summit last year and it was even longer since I gave this talk (A Dive into System Databases), and this one is particularly demo heavy, so I definitely wanted to practice. And it was frankly a damn good thing I did. One demo didn’t work at all. I realized after 30 minutes of struggling with it, that it had never worked and I had simply forgotten that. (Though the comment at the top of the code Do Not Demo might have been a clue to me I should have heeded. I just couldn’t remember why I had written that). Another demo quite honestly, didn’t work nearly as well as I would have liked, in part I believe because I had written the demo for SQL Server 2014 or 2016 and was now running that machine on 2017. I didn’t have time to rewrite the demo, but I did have time to revise my comments and put the issues into context.

The other demos ran according to plan, but being able to run through them again helped me group my thoughts and comments so I could present them more effectively.

Ideally I would have had one more chance to run through my entire talk before I presented it, but I just didn’t have the time. I’ll admit it was not my best effort, sorry Sioux Falls folks, but it wasn’t one I am ashamed of either. And it was far better than if I had not run through it at all.

One of the issues with giving a remote talk is you don’t get nearly as much feedback from the audience. That can also be discouraging. And I won’t shame any particular user group, but there was a group I presented to remotely in the last year where it went quite honestly from my ending it with “Any Questions?” and getting none to having the organizer within seconds basically saying, “Thanks Greg. Ok folks, meeting is over” and closing the session. The lack of any feedback, positive or negative was really discouraging (hint to organizers of remote sessions, don’t do that.)

In this case I had several questions and we chatted briefly afterwards before the session ended. I also ended up with at least 2 additional followers on Twitter. I’ll take that as a good sign.

I think as the time of Covid is hopefully ending I’ll be looking at speaking more and more. I still prefer in person (and have one scheduled next year for the Hampton Roads SQL User Group) but will probably still do a few more remote ones.

Writing this, I realized I had ignore an interview I recently did with an old college friend and a partner of hers. It’s not a presentation, so didn’t come to mind when I was writing the words above. The interview was about an hour, but they managed to break it up into 2 different videos, with some overlap.

Subject2Change – Caves

Subject2Change – Leadership, Risks and Cave Rescues

Inbound and Outbound to NYC

I still recall the first computer program I wrote. Or rather co-wrote. It was a rather simple program, in Fortran I believe, though that’s really an educated guess. I don’t have a copy of it. It was either in 7th or 8th grade when several of us were given an opportunity to go down to the local high-school and learn a bit about the computer that they had there. I honestly have NO idea what kind of computer it was, perhaps a PDP-9 or PDP-11. We were asked for ideas on what to program and the instructor quickly ruled out our suggestion of printing all numbers from 1 to 1 Million. He made us estimate how much paper that would take.

So instead we wrote a program to convert temperature Fahrenheit to Celsius. The program was as I recall a few feet long. “A few feet long? What are you talking about Greg?” No, this was not the printout. This wasn’t how much it scrolled on the screen. Instead it was the length of the yellow (as I recall) paper tape that contained it. The paper tape had holes punched into it that could be read by a reader. You’d write your program on one machine, and then take it over to the computer and feed it into the reader and it would run it. I honestly don’t recall how we entered the values to be converted, if it was already on the tape or through some other interface. In any case, I loved it and fell in love with computers then. Unfortunately, somewhere over the years, that paper tape has since disappeared. That saddens me. It’s a memento I wish I still had it.

In four or five short years, the world was changing and quickly. The IBM PC had been released while I was in high school and I went from playing a text adventure game called CIA on a TRS-80 Model II to programming in UCSD Pascal on an original IBM PC. (I should note that this was my first encounter with the concept of a virtual machine and p-code machine.) This was great, but I still wanted more. Somewhere along the line I encountered a copy of Microsoft’s Flight Simulator. I loved it. In January of 1985 my dad took me on a vacation to St. Croix USVI. Our first step on that trip was a night in NYC before we caught our flight the next morning. To kill some time I stepped into 47th Street Photo and bought myself a copy of Flight Simulator. It was the first software I ever bought with my own money. (My best friend Peter Goodrich and I had previously acquired a legal copy of DOS 2.0, but “shared” it. Ok, not entirely legal, but hey, we were young.)

I still have the receipt.

For a High School Student in the 80s, this wasn’t cheap. But it was worth it!

I was reminded of this the other day when talking with some old buddies that I had met when the Usenet sci.space.policy was still the place to go for the latest and greatest discussions on space programs. We were discussing our early intro to computers and the like.

I haven’t played this version in years, and honestly, am not entirely sure I have the hardware any more that could. For one thing, this version as I recall was designed around the 4.77Mhz speed of the original IBM PC. This is one reason that some of my readers may recall when the PC AT clones came out running the 80286 chip running at up to 8Mhz (and faster for some clones) there was often a switch to run the CPU at a slower speed because many games otherwise simply ran twice as fast and as a result the users couldn’t react fast enough. So even if I could find a 5 1/4″ floppy and get my current machine to read the drives in a VM, I’m not sure I could clock down a VM slow enough to play this. But, I may have to do this one of these days. Just for the fun of it.

I still have the original disks and documentation that came with it.

Flying outbound from NYC

A part of me does wonder if this is worth anything more than the memories. But for now, it remains in my collection; along with an original copy of MapInfo that was gifted to me by one of the founders. But that’s a stroll down memory lane for another day.

And then I encountered SQL Server only a short 6 or so years later. And that ultimately has been a big part of where I am today.

ICE ICE Baby

I rarely like to make predictions or bold claims, but dawned on me that it’s pretty much all over for the Internal Combustion Engine cars and trucks. Forget government mandates or the latest Tesla press release.

Why do I say this? a few months ago I recall reading the press release for the new F-150 electric truck. The stats made for some impressive reading. And more interestingly, if anything, it appeared Ford downplayed some numbers like range (i.e. giving a conservative estimate based on actual usage as opposed an optimal number based on unrealistic driving conditions). They announced an initial set of production numbers and a few weeks later doubled their 2024 production estimates. The Ford F-150 has been the best selling vehicle in the US since 1981. Announcing an electric version was no small thing. And people took to it like a duck to water.

But that wasn’t the thing that convinced me. It was the ad I saw tonight. I can’t find a link to the latest but it features the F-150 Lightning, the E-Transit, an electric version of their best selling van and the Mustang Mach-E. This is a wide range of vehicles and it’s clear that they’re not targeting niche vehicles or make a pro forma attempt. They mean business.

They know where the market is heading and it’s electric. The market has spoken and the future is electric. Mandates and the like won’t matter.

Touring a Tin Can

As some of you know, my grandfather served on PT 127 in WWII. 80′ of fighting fury. PT boats were fast, with speeds of 40 knots or more. I had the honor and privilege of riding one with him close to 15 years ago when one of the few remaining operating ones in the world was on the Hudson River. After that, my family and I had the privilege of boarding PT 617, an 80′ Elco at Battleship Cove. As a “splinter” we were able go on board and below decks and get essentially a private tour. One of the items I hoped to see was the map table, where my grandfather claimed he slept, rather than his bunk. He had the privilege because he was the oldest on board and this allowed him to get a nice cross-breeze in the tropical heat of the Philippines.

Cabin of PT 617

I was thinking of him this past weekend as my wife and I visited another WWII ship, the Destroyer Escort Slater (DE-766). Everyone loves the battleships, from the USS Massachusetts at Battleship Cove to the famous Iowa class battleships that were brought back into service in the 1980s. And yes, I have to say, there is something to be said for the “big guns”. The ability to hurl a shell the mass of a Volkswagen Beetle over 15 miles and to hit ones target is impressive.

But very often the workhorses of the fleet are overlooked, the Destroyers and their little brothers, Destroyer Escorts. They guarded the conveys bringing much needed supplies to Europe to fight Hitler. They guarded the fleets in the Pacific. Literally 100s were built. The first Destroyer Escort rolled off ways in 1943. This means in the space of approximately 24 months, more than 20 a month were built. Destroyer escorts were built quickly and without the luxuries their large siblings might have, such as air conditioning or even a simple thing like an ice-cream maker. And fast, they were knot. Top speed was closer to 20knots, with them often operating slower than that. For their primary role however, anti-submarine warfare while escorting conveys, this was sufficient. Their size also allowed them to turn more tightly and gave them more maneuverability than their bigger brothers.

But this did not mean they weren’t critical to the war effort. However, at the end of the war, like much of the US arsenal many were tossed on the scrap heap. There was little need for so many of the ships often called tin cans because of their lack of armor compared to the fleet carriers and battleships. Some were transferred to other navies. This was the fate of the USS Slater. It was transferred to the Hellenic Navy and was decommissioned in 1991 when it was brought back to the US.

It eventually made its way to Albany NY where it’s a floating, living museum. I say living because you’re actually allowed to touch and operate some items and they encourage sleepovers and the like.

Looking Forward

The tour is impressive and well worth it. If you’re ever in the Albany area, I do recommend stopping by the USS Slater and then perhaps a flight of beers at the Albany Pump Station.

3″ Gun on the Bow

While waiting for our tour guide, we walked around the tour shop a bit. Two things jumped out at me. The sodas and snacks were only 93 cents a piece (with tax that comes to an even $1.) That’s a bargain as far as tour shop snacks go. But the real find was a copy of “The Last Stand of the Tin Can Sailors”. This had been on my reading list for a few years and I decided I’d pick up a copy on the way out. (The additional bonus of this, was any profit from the sale of the book would go to the museum and not to a large nameless company shipping it to me.)

For those not familiar with it, it details the exploits of “Taffy 3” at the Battle off Samar, where 3 destroyers and 4 destroyer escorts, combined with the aircraft off of the withdrawing “jeep” carriers (CVE) took on a major Japanese fleet, including the battleship Yamato, ultimately causing the Japanese fleet to withdraw.

To give you an idea of the mismatch here, the combined weight of the destroyers and destroyer escorts was about 1/5th of the weight of the Yamato alone. Even if you add in the weight of the CVEs and their planes, it wouldn’t have added up to the weight of the Yamato. And the Yamato, the largest warship afloat, was just a part of the Japanese fleet heading their way.

The largest guns Taffy 3 had were 5″ guns. These were no where nearly powerful enough to penetrate the armor of the Yamato or other Japanese cruisers. On the other hand, the 18.1″ guns on the Yamato were designed to penetrate the armor of American battleships. The armor on a tin can wouldn’t even slow down such a shell.

And yet, the American sailors, knowing how important it was to stop the Japanese fleet turned towards the Japanese and engaged them head on. And ultimately, the Japanese withdrew, thinking they were facing the fleet carriers and that the larger cruisers and battleships were probably on the way.

The battle of Midway is often considered the turning point of the war in the Pacific, and in many ways it is, with the Japanese losing a majority of their fleet carriers. But I think the Battle off Samar has a special place with David defeating Goliath.

Sometimes the smallest can do the mightiest things.

40 mm Bofors

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.

Free Cell #1703491

This is a completely random post and for a very select crowd.

I often play Freecell (far to much, but that’s another story). Years ago, when it first came out with Windows XP, I wondered if every game was winnable. Apparently, not. That said, I haven’t come across any of the “impossible games”. But I’ve come across a few hard ones.

But none nearly as hard as game #1703491. Usually I can solve most games in 2-5 minutes, sometimes it takes 15-30. I was into this one for over 2 hours before I did something I’ve rarely done. I looked for help. Mostly I wanted to know I wasn’t playing an impossible game. A brief search suggested I wasn’t. A longer search proved I wasn’t. But there was only one cryptic suggestion. I had pretty much settled on this being the most likely path, clearing the 6th column.

Now, small sidebar. To add a bit of a challenge, I have a self-imposed rule that I don’t put cards up on the home cells manually, I let the game move them automatically. In other words, if there’s a free card I can put up there manually, but that won’t go automatically, I won’t put it up. This happens for example if the the home cells AH, blank, 2D, AS, I won’t put up the 3 of diamonds. The game won’t automatically put up the 3D until the 2H, 2C and 2S are up there also. Like I say, no real reason other than the extra challenge. I had to break that rule in this game.

Anyway, even with that advice, I kept getting stuck.

A common spot I would get to was:

Making Progress

Still not much wiggle room

This was the first time I had freed up the 8th column. So that was progress and I had considered that key. I’m not sure what took me this long to figure out this combination of moves.

And now the break-thru. I’m feeling good here. I know once I get the 2 of Hearts up there, I’ll be making real progress!

This move is obvious

Now I’m gaining momentum. I may seem tempting to free up that 2 of Spades. Resist that temptation!

Don’t play the obvious move!

Rather you want to move that stack on the 5 of Hearts. With that move and a few others you end up at:

Now we’re making real progress!

The next few moves are pretty clear. Now we can move up that 2 of Spaces and after that the game is clearly winnable.

Getting Close

That said, I have to break my own rule one more time, but I don’t care. I’m ready to win.

Almost There!

And that’s it! I can relax now!

Whatcha Reading?

I thought I’d start off March with something a bit lighthearted and as sort of a follow-up to last week’s post about what I’ve been eating in the last year.

For as long as I can recall, I’ve loved reading. I could not wait until my kids could learn to read. Without reading, we are in many ways limited to what we can see with our own eyes right in front of us. But by reading, we open up whole new worlds.

I’ve stood on the peak of Amon Hen with a Halfling as he stood there, wearing a magic ring, debating what he should do as he looked across the world and could feel himself being spied upon.

I’ve flown in a spacecraft controlled by an intelligent computer that was given opposing directives that it decided it could only resolve by killing its crew as it flew through space on its way to a flat rectangle whose dimensions were known to us to be in a ratio of 1:4:9 and in higher dimensions could be said to extend to to 16, 25 and possibly higher.

I’ve travelled the ante-bellum Mississippi with a young man named Huck and his best friend Jim. I’ve wondered why the hounds of Baskerville didn’t bark. I’ve flown over Italy, dropping bombs on people wondering why I was doing that as they had never done anything to me. And people thought I was the crazy one.

I escaped my boarding school and wandered the streets of New York City for day. (I should note my dad insisted I read this one and told me I’d really relate. I didn’t. I found Holden to be boring, self-centered and honestly, just plain annoying). On the other hand, I loved riding in an automobile escaping New York City to Long Island while past a valley of ashes during the roaring 20s. Those same ashes appear later in the biography of the man who would literally reshape the outline of Manhattan and the traffic patterns of that great city and other parts of New York for generations to come.

I’ve read of a dystopian future that at times seems all to close where certain women are forced to wear red cloaks and to bear children for other couples. But I’ve also sailed across the seas of a foreign world where there are no continents, just archipelagos of islands, on one of which one a young woman, raised to be a priestess/goddess to her people learns from the gentleness of a young man she’s forced to impression that there’s so much more to learn of the world and gains her freedom.

I’ve sailed into deepest Africa to find a man who has gone crazed with power. And later voyaged to the bottom of the planet on a sailing ship, only to find myself stuck with my fellow crewmates in ice for over a year. Our captain undertook a daring and amazing voyage to a whaling station, only to have to cross over the mountains between where they landed and the village in order to find our rescuers. I’ve also sailed to the Moon and back, numerous times, the first, hitchhiking along on Christmas Eve as the story of creation was read to the nations of Earth. I joined him again later only to discover once again we weren’t going to land, in fact we weren’t even going to orbit. But that’s ok, I also travelled to the Moon and back again not just once, but multiple times, including with the first man to walk on the Moon and the last.

I’ve also hiked to the top of Mount Everest and surveyed the detritus of bodies of those who attempted the trip and failed and felt relieved to know that at least one who had been left for dead later found the will-power to pick himself up and crawl to the nearest camp. In a similar vein, I’ve read both sides of the story, of two climbers in the Andes, one who had to cut the rope of his partner, letting him plummet to his death, the other being the one whose rope was cut, falling not to his death but to a miracle. But I was also heartbroken to read of the young man who went into the wilderness of Alaska to live, and ultimately die in an abandoned bus.

And then yet another morning I woke up to find myself in the body of an insect, wondering what it all meant. And another day I came home from school to find a tollbooth in my bedroom through which I could ride a toy car and be joined by a humbug and later jump to conclusions.

Ok, enough reflections on that, let me talk a bit more about what I’ve read or will read in the coming months. I’m a luddite in some ways. I still prefer the feel of dead paper in my hands. At the top of this article is a photo of some of the magazines I tend to read on an a monthly basis (I just realized at least one is missing).

Discover and Scientific American: I read monthly, cover to cover and learn all sorts of new things. I highly recommend everyone read at least one of these. Yes, some might argue they “dumb down” science, but in reality I think they make it more accessible.

NSS News: This is an interesting one. The articles can range from extremely technical (the chemistry and hydrology of a cave for example) to very lighthearted or celebratory. It’s one of the few printed items I read where on a nearly monthly basis I can expect to read the name of someone I know personally, or see their credits for photos. It also collects excerpts from grotto newsletters, giving me a more intimate feeling of what other cavers are doing.

Trains: Ok, this is a bit of a niche market, but I’ve always been fascinated by trains and railroading and in fact bought stock in BNSF long before Warren Buffet did. He just had a bit more money than I did when it came to buying the whole thing.

Outside: I’ll admit I actually read this the least. I get it for free, so it’s nice to browse when I have time. But honestly, I’d rather BE outside than read about it!

Air & Space: Again, following my theme of science and space, I love reading this one.

The Times Union: Ayup, I still read the daily newspaper. I find an online version doesn’t cut it. When I was working in the Washington DC area I also subscribed to the Washington Post (and then on the weekends would come home and catch up on the Times Union)

But what else? You may notice so far I haven’t mentioned anything about SQL Server. But, just this past month I finished reviewing a book a publisher has asked for my feedback on possibly editing and updating. So there’s that. But I find most of my SQL reading is done via blog posts. These include but are not limited to:

Monica Rathbun: some great articles, generally with a focus on performance. Well worth the read!

Deborah Melkin: I’ve known Deborah since she first came to SQL Saturday Albany to speak and have always enjoyed her style and ability to make complicated things simple enough to understand.

Steve Jones: I think he probably blogs the most of anyone I follow. I’m not sure how he does it, but it’s consistently great.

Ray Kim: a fellow member of the Capital Area SQL Server Group, he, like me blogs about a lot more than just SQL Server. He will often focus on baseball, like his most recent blog entry.

Derek Lyons: I’ll admit, anime has never really been my thing, but it’s always nice to see what a friend is writing about. But if anime IS your thing, check out his blog.

And of course I’d be remiss if I didn’t admit that I’ll google stuff a dozen times a week if I need to, so there are plenty of other blogs and pages I’ll hit on a regular basis.

And being the luddite I am, I still read Usenet and actually moderate the sci.space.tech and sci.space.science discussion gorups.

And I really do read SQL books from time to time, they’re just not overly gripping reading!

Finally, living outside of Illium, err Troy, I once met a young old man who went by the name of Billy who told me of his adventures in WWII and travelling to another planet. All the above is just a small part of what I’ve read and a small part of what I will read. And so it goes.

Backups Are Useless

I’m going to take a controversial stand and argue that backups are useless.

Over the last few months I’ve worked with a client of mine to test their Disaster Recovery procedure for one of their major in-house applications. This involved multiple several-hour meetings with anywhere from 5 to 10 people at each meeting, sometimes more. Each hour probably cost the client $1000s of dollars. The cost of running these meetings and tests probably cost the client well over $100K.

This is ignoring the costs of the associated hardware, the power for the backup datacenter, the cost of heating and cooling, and of course the licensing. I wouldn’t be surprised if they easily spend more than $1 Million a year in backups and the like.

And for what? A fairly low probability event?

I mean sure, if their system failed and they had no Disaster Recovery plan it could cost them 10s of millions of dollars in business and perhaps even end up putting 100s of people out of work. But they’d find other jobs. In the meantime, all that money spent on backups could have been spent on other things like lunches for for the employees (and maybe a pizza or two for select consultants). Think of the boost to the pizza economy that would have been!

So, don’t do backups.

Oh and don’t wear a mask. They’re hot, sweaty, and really not even .1% of the US population has died. And sure, you might get COVID-19, but you’ll probably survive. Sure, you might have some cognitive long-term issues, but hey, that’s sort of like the employees at my client above who, if the company went under, could simply find another job. I mean it’s not a big deal. Amirite?

Now let’s be serious. If a DBA came in to your business and said not to bother doing backups, you’d probably laugh at them. Do backups. And of course wear a mask. There is so much evidence it makes a difference. And, socially distance for now. And reconsider large family gatherings for the next month or two, if only to help increase the odds that you can have such a gathering a year from now.

Part of this post was prompted by a question on Quora from a user asking how to recover their database if they didn’t have a backup. I hated to tell them that it might be too late and there was quite likely little they could do. And I’ve read too many heart-wrenching stories from nurses who have had to hold the hand of a dying patient because they thought Covid was no big deal or a hoax. So, please, take precautions. Even if nothing happens to you, it may happen to those close to you.

That said, I will repeat an adage about backups I heard a few SQL Saturdays ago: “Backups don’t matter, restores do!” So do backups, but restore them every once in awhile to make sure that they actually work!

For the record, with my client, not only did the official DR test run go smoothly, we beat our RTO and RPO by huge margins. If disaster strikes, it’s highly likely this customer will weather it without threatening the future of the company.