A trip to New York City for #SQLSaturday #SQLSat912

(Photo source: britannica.com)

As I promised in my previous article, here is the article that details my trip to SQL Saturday #912!

Early last year, I wrote about my trip to SQL Saturday #714, Philadelphia. That was an enjoyable trip (well, they all are), and I enjoyed writing that article. With my trip to SQL Saturday #912 in New York City, I thought it’d be a fun exercise to write another one. I figured it’d be a fun piece for people who’ve never traveled to a SQL Saturday, not to mention people who’ve never been to New York City.

So, come along with me as we take another trip!

The planning

Being the trip planner that I am, I mapped out my plans for this trip a while back. Plans for this trip have actually been in the works for months.

Planning began back in May, when I submitted my presentations. For planning purposes, whenever I submit presentations to any event, I assume that I’ll be selected to speak, even before I find out whether or not my submissions are accepted. As soon as I submit, my plans for whatever event I apply are pretty well written into my calendar, unless either (1) I end up not getting chosen for the event, or (2) some conflict that I can’t get out of comes up for the same date.

Ordinarily, I don’t firm up my travel plans until I know for sure that I’m selected to speak, but this time around, there were a couple of twists. First of all, I saw Thomas Grohser, one of the event’s organizers, at SQL Saturday in Albany in July. He told me that I was going to be speaking in NYC. Granted, Thomas is a friend, but nevertheless, it was still not an official selection. I wanted to make sure that I had the official selection email before I started booking my train and my hotel room.

In early August — still before I received the official acceptance notification — I got an email from Amtrak (I’m a Guest Rewards member) that included fare specials. I discovered a round-trip fare from Albany to Penn Station that was too good to pass up. Unfortunately, the deal had an expiration date, so I had to act fast. I decided to pull the trigger on it. Okay. I had a train reservation. Now I was committed to the trip, regardless of whether I was chosen to speak or not. It wasn’t a big deal; I regularly attend SQL Saturday in New York, regardless of whether or not I’m speaking.

I selected an early afternoon train to New York. I wanted to leave myself time to make the speaker’s dinner, if they had one. As it turned out, that would not be the case, as I’ll explain later on.

Now that my train was reserved, I needed to find a place to stay. My two siblings both have places down in The City, and my sister has repeatedly told me that I can use her place in Brooklyn. While I’m appreciative of the offer, I also wanted to stay someplace closer to the Microsoft office in Manhattan, preferably within walking distance, where SQL Saturday takes place. Of course, as anyone who has traveled to New York City can attest, inexpensive places to stay in midtown Manhattan are nearly non-existent. It also didn’t help that the office was located near one of the world’s biggest tourist traps. (I usually try avoiding it, but that was impossible for this trip.) I checked a variety of places, including a few on AirBnB and a few places that were farther away but near subway lines. I found a few places that had potential, but kept looking.

I hit the jackpot when I tried Hotwire. They advertised a deal where I could stay at an (unnamed) midtown hotel for $109. It promised that I would be booked at one of three hotels, which they listed. The actual hotel would be revealed after I booked. I looked at their locations, decided I could live with them, and decided to take the chance. I ended up getting booked at the Sheraton New York Times Square. The final damage was $173 after taxes and fees — granted, more than the advertised $109, but still a steal for a Sheraton in midtown Manhattan near Times Square!

At some point — I’m not quite sure when — I looked at my own speaker’s profile, and noticed that three of my submissions were now listed as “Regular Session,” not “Submitted Regular Session.” This is usually a pretty good indication that I’ve been selected to speak, although it still isn’t official yet. I was surprised, however, that three of them were listed. I figured, either (1) it was a mistake, (2) they were still working on the schedule, or (3) I was going to be one very busy boy on October 5!

In August, I got an email from Thomas Grohser. It was no mistake. Indeed, I had been selected to give three presentations! Thomas asked me, “let me know if this is too much or not.”

I sent him back a two word reply: “challenge accepted!”

So things were in place. Travel plans were set, and I was definitely speaking. I went about my business, awaiting the first weekend in October to arrive.

A funny thing happened along the way. I’m a big Yankee fan. The Yankees ended up winning the American League Eastern Division. At some point, I looked at the dates for the Yankees’ first two playoff games: October 4 and 5 in New York.

Hey, I was going to be in New York on October 4 and 5!

I looked into getting tickets for ALDS Game 1. They definitely weren’t cheap, but they weren’t so expensive that they would break the bank, either. The only thing that made me hesitate was that no game time was announced. If it was an early afternoon game, there was no way that I’d be able to make it. When they announced that it was a 7 pm game time, I pulled the trigger and bought myself a ticket! I’ve been going to ballgames for years, but I’ve never been to a playoff game before, and attending a postseason game has been on my bucket list for a long time. A weekend that was already going to be fun had just become more exciting!

At this point, all the plans were set. I only had to wait for October 4 to arrive.

The trip

Friday, October 4 arrived. My wife dropped me off at Albany-Rensselaer train station around 12:30. Other than the fact that my train, which was supposed to depart at 1:05, was about twenty minutes late, the train ride to Penn Station was uneventful. I arrived in New York around 4:00.

I took the E subway to my hotel. Upon exiting the subway, I had my first (pleasant) surprise of the trip. While I was at the street level, looking for my hotel, someone said hi to me. I was surprised to see that it was Michelle Gutzait, one of the SQL Saturday speakers, and her boyfriend! We spoke briefly. She was speaking at our user group in November, and said she was looking forward to speaking. They were looking for a theater for a show they were seeing that night, while I was looking for my hotel.

Randomly bumping into Michelle on the street turned out to be the first of numerous surprises on this trip.

I found my hotel, dropped off my bags, and proceeded up to the Bronx.

Image may contain: Raymond J Kim, stadium
Here I am, attending my first-ever postseason playoff game!

Now, I’ve been a baseball fan since I was around 12 or 13. I grew up rooting for the Yankees. I’ve attended numerous regular season games, more than I can remember. However, despite all those years going to regular season ballgames, I have never been to a postseason playoff game. It’s something that’s been on my bucket list for quite some time. When I saw that the Yankees’ first two playoff games were at home at the same time I was in the City for this trip, I jumped on the opportunity and bought myself a ticket for Friday night.

No photo description available.
My scorecard from the game

Friends told me that it was a different atmosphere from a regular season game, and it did not disappoint. The atmosphere was electric, and the crowd was loud — much more than a regular season game. Fans hung on to nearly every pitch during the first seven innings. By the time the seventh inning rolled around, the Yankees had scored ten runs and held nearly an insurmountable lead. I stuck it out until the end of the game and hopped the subway back to my hotel. I did stop to get a couple of slices of pizza on my way back (I can’t pass up genuine New York-style pizza!). It was well after midnight by the time I got back to my room, and around 1 am by the time I went to bed.

SQL Saturday

My alarm went off at 6. After hitting my snooze button a couple of times, I got up around 6:20. I rolled out of bed, showered, dressed, checked out of the hotel, and proceeded to Ellen’s Stardust Diner for breakfast.

Image may contain: 4 people
At Ellen’s Stardust Diner, it’s about the singing wait staff!

This was the second time that I had gone to breakfast at Stardust; the first was when I spoke at NYC SQL Saturday last year. Now, I’ll say that the food at Stardust is good, but not great. If I picked a place to eat based on the food alone, Stardust would not be my first choice. However, I love Ellen’s Stardust Diner. It isn’t about the food; it’s about the experience. Stardust is known for their singing wait staff, and they put on a good show!

Amusing note: my waiter was named Kansas. Kansas is my favorite band! I told him as much, and he told me he was so named because they were also his parents’ favorite band! I hoped that he (or someone else) could sing a Kansas song before I finished my breakfast, but it wasn’t to be.

I could’ve sat there all morning and listened to the wait staff sing (and I told Kansas this), but alas, my first presentation was at 9:00. I wanted to get to Microsoft as soon as I could so I could prepare. Upon finishing my breakfast, I proceeded to the Microsoft building and SQL Saturday.

I arrived at the Microsoft Times Square office, directly across the street from the Port Authority Bus Terminal, around 8:15, and came across several #SQLFamily friends, including, among others, John Miner, Matt Cushing, Taiob Ali, Michelle Gutzait, George Walters, James Phillips, Thomas Grohser, Steve Simon, Kathi Kellenberger, Kevin Feasel, Alex Grinberg, James Serra, and Chris Seferlis. (I hope I didn’t leave anyone out!)

Image may contain: people sitting, screen and indoor
Me doing one of my three presentations

I wrote earlier about my presentations, so I won’t rehash them here. I will say that the combination of doing three presentations, combined with waking up at 6 am after having gone to bed at 1 am made for a long and tiring day! After lunch, for the sake of my own sanity, I decided not to attend any more sessions until I presented my own. There were some couches outside the speaker’s room, so I attempted to take a power nap — a plan that was thwarted by a security guard who kicked me awake (literally — he kicked the couch I was on) and told me, “you can’t do that here.” Sheesh.

At one point during the day, Matt hilariously sent this tweet. I got a good laugh out of this!

My trip of fun surprises continued at the end of the day during the conference closing session and raffle drawings. I was sitting in the front row. James Phillips, one of the co-organizers, was running the raffle. Since I was in the front row, he had me pick one of the winners. I stuck my hand in the bowl with the tickets, mixed them up, pulled one out, and gave it to James.

Mind you, I did not look at the ticket. Upon seeing the ticket, James shook his head and said, “I don’t believe it.”

He showed me the ticket. It had my name on it. I had pulled my own ticket! I’d won a Bluetooth speaker!

After SQL Saturday was over, I proceeded to 32nd Street, where Koreatown is located. It’s one of my favorite neighborhoods in Manhattan. As a Korean-American, I feel somewhat obligated to visit this place now and then, but as one who was born in New York State, I also feel at home when I come to this place to visit. I picked out a Korean BBQ place — one where I’d never been before — and had myself an excellent meal.

While I was waiting to be seated, a gentleman who had seen my shirt came up to me and introduced himself as a fellow Syracuse University alum. Yet another example where my clothing became a conversation piece! We spent about ten minutes talking about our alma mater before we were finally seated.

I had purposely scheduled a late train back home so that I could enjoy dinner while I was in Manhattan. After dinner, I walked the block west to Penn Station so I could catch my train.

Image may contain: 2 people, including Randi Stracher Moore, people smiling, people sitting and screen
Yet another surprise on this trip; I ran into Greg Moore and his daughter on the train heading home!

Upon boarding the train and finding myself a seat, I heard a familiar voice say, “boy, they’ll let anybody on this train!” I turned around and saw Greg Moore sitting a couple of seats back. Yet another surprise on this trip!

Although Greg is very active in the SQL Server community, he did not attend SQL Saturday. Instead, he attended ComicCon with his daughter. (Greg wrote a nice ‘blog article about their ComicCon experience; you can read it here.) I moved back to sit across from them, but we didn’t converse much (if at all) during the ride; we were all pretty tired, and we planned to sleep on the train ride home. No matter; I see Greg often enough, anyway. (I’ll see him next week at our next user group meeting.)

I didn’t sleep well on the train; no matter how much I tried, I couldn’t get comfortable. My wife picked me up at the station, and I arrived home sometime after midnight.

Epilogue

Despite getting very little sleep, I had an absolute blast on this trip!

Mind you, I always have fun every time I go to a SQL Saturday, but I especially have a blast whenever I travel to New York City. It was an opportunity to get together with #SQLFamily, it was an opportunity to network, I got to practice my presentation skills (again), and as an added bonus, I got to attend a postseason baseball game! I absolutely love taking this trip, and I hope to do this again for NYC SQL Saturday again next year!

This is my last scheduled SQL Saturday for 2019. I don’t have any more SQL Saturdays lined up — I applied to speak at Boston BI SQL Saturday, but I will likely withdraw because of a conflict. There are “save-the-dates” listed for Rochester, Philadelphia, and Boston (non-BI) set for next year, and I intend to apply for them once they go live. (I might also apply to Virginia Beach as well; we’ll see.) And, of course, our Albany group usually has our SQL Saturday at the end of July.

My next scheduled presentation is in Seattle for PASS Summit, which is in four weeks (!!!). I’ll ‘blog about my PASS Summit experience as I go along. Hope to see you in Seattle!

Thanks for taking this trip with me — we’ll see you later from the road!

Jumping on the opportunity

(Photo source: NYCgo.com)

As I mentioned before, I’ll be in New York City for SQL Saturday #912 this Saturday (come check out my three presentations! </plug>). I’m taking the day off from work and am traveling down to The City on Friday.

I also noticed something else that was going on in The City while I was there — and I decided to jump on the opportunity!

Did I mention that I’m a big Yankee fan? As it turns out, Friday and Saturday also happens to be Games 1 and 2 of the American League Division Series! It’ll be the Minnesota Twins vs. the New York Yankees those days. And lo and behold, I’ll actually be in The City on those days! Can we say, opportunity knocks?

The only issue was the game time. My train arrives at Penn Station at 3:45. If it was an early afternoon game, there was no way I’d be able to go. When I found out the game was at 7 pm, I went online and splurged on a ticket for Game 1.

I’ve never attended a postseason baseball game before. It’s been on my bucket list for a long time. Granted, I’d prefer that it was a World Series game. But it was a situation where opportunity was knocking. The first two playoff games are in New York, and I’ll be in town when they happen!

So I will be in attendance at Yankee Stadium on Friday evening!

As I’ve written before, every now and then, you need to say, what the heck! Your professional life is important, but so is taking the time to stop and smell the roses (or, for me, to catch a ballgame). Opportunities don’t come around very often. And if one comes around, and you have the wherewithal to make it happen, then jump on it. Make it happen, and enjoy yourself!

(P.S. Let’s go Yankees!!!)

Wanna play fantasy football with a bunch of data geeks?

The fantasy football league I play in is down a player, and we’re looking for someone to join us!

If you’re interested in playing against a group of database geeks, go to the SSC Fantasy Football forum here!

You do NOT have to be a database geek to join us!

Major League Baseball in Troy, NY

A friend of mine pointed out that a Wikipedia article about the Troy Trojans baseball team cited me as a reference!

The article was actually a project for a Writing for Publication class that I took in grad school. It was later republished as a feature article in a baseball preview issue published by The Spotlight News.

However, when I looked at the Wikipedia reference link, I realized that the link was an old one that I’d forgotten about, and didn’t know was still there! I figured I should give the article a new home. So I took my article and created a new page for it. You can find the new article page here!

The article is a neat history piece that dates back to a period around the Industrial Revolution. If you’re a baseball enthusiast (like I am), I hope you enjoy it!

Memorial Day Murph — crossing the finish line

Yesterday, I did the annual Memorial Day Murph workout. I’ve written about it before. For those of you unfamiliar with CrossFit, the Murph workout consists of a one mile run, 100 pull-ups, 200 push-ups, 300 air squats, and another mile run. Needless to say, it is a LOT of work!

For those of us who aren’t professional athletes, many of us scale it down. Some people reduce the length of the runs. Many others reduce the number of reps. I set a goal of running (well, okay, “running”) the entire one mile lengths for each run. I broke down the reps into ten rounds of 5 ring-rows (since I can’t do pull-ups), 10 push-ups, and 15 air squats. I had every intention of doing the full twenty rounds, but when I reached round 6 and realized how much time had elapsed, I came to the realization that “twenty rounds isn’t happening!”

As you can see in the photo above, I had a nice cheering crew waiting for me as I crossed the finish line! I finished the workout in 1:04:31.

I started doing CrossFit to get into shape. I still continue doing CrossFit because of the great friends I’ve made and all their support. Find something that works for you, and you’ll keep wanting to go back for more!

My first road race — the debrief

Well, I survived my first road race! Wondering how I did? Here’s my official results! Hey, I didn’t get lost, and I didn’t finish last!

And as I write this, my hamstrings are still saying some nasty things to me!

I was hoping to maintain at least a slow jog throughout the race, but that went out the window as soon as I hit the first big hill. The course ended up being more difficult than I expected. (I’ve driven through that area dozens of times. It doesn’t seem too bad in a car! It’s a lot different when you’re on foot!) I tried to jog where I could, but mostly, I walked. I did try at least to maintain a brisk walk, although that didn’t always happen, either. One piece of advice that my CrossFit coach gave me beforehand was, “just keep moving. Don’t stop.”

I did have to stop a couple of times to retie my shoes, but aside from that, I pretty much heeded that advice. I didn’t stop!

One of my favorite moments happened in the middle of the park. A kid had a hand-drawn sign with a Super Mario Mushroom Power-Up and a caption that said “Hit sign to power up!” I don’t know how many people used that to push themselves, but for me, it worked! I touched the sign and broke into a jog — albeit briefly.

A little past the halfway point, one of my friends from the office came up alongside me, and we pretty much did a steady walk together for the remainder of the course, all the way to the finish line.

There were a couple of down moments yesterday. After the race, I parked in a pay lot, didn’t pay, and got towed. (I did manage to get my car back.) Also, they ran out of T-shirts in my size. I was disappointed about not getting a shirt! But nevertheless, it was a good time! It was a beautiful day out — temps were cool and comfortable, and it was sunny. And in addition to my co-workers, I saw several friends at the event. I met my co-workers at a bar after the race (it was while I was here when my car was towed). We ate and drank, and I spoke to a number of people from my office whom I usually don’t talk to!

All in all, it was a good time. I have to admit that I had fun yesterday! Has it changed how I feel about running? Well… not yet. Will I do this event again? Well… more than likely!

Talk to me again next year!

The evolution of statistics

During my lunch break, I was perusing the ESPN website and stumbled across this article. It contemplates whether or not a .300 hitter (in baseball, for those of you who are sports-challenged) is meaningful anymore. As a baseball fan, the article caught my attention. I didn’t read through the entire article (it ended up being a much longer read than I expected — too long for me to read while on a lunch break at work), but from what little I did glean from it, a couple of things struck me.

First, they talk about Mickey Mantle‘s batting average and how important hitting .300 was to him. That struck me a little funny, because (as far as I know — as I said, I didn’t get through the entire article) there was no mention of the fact that he actually finished with a batting average under .300. His career batting average was .298.

The second thing that struck me was (Yankees’ first baseman) Luke Voit saying how he felt that “feel like batting average isn’t a thing now.” Indeed, baseball is a much different game than it was, say ten, twenty, or thirty years ago. Analytics are a big part of statistics these days. A lot of stats that are prevalent now — WAR (wins above replacement), exit velocity, OPS (on-base plus slugging), etc. — didn’t even exist when I was a kid growing up, closely following my Yankees. Back when I was eating and sleeping baseball, hitting was about the triple-crown statistics — batting average, home runs, and runs batted in (RBIs). But now, we have “slash lines,” on-base percentage, slugging percentage, and so on. Even as big of a baseball fan as I am, I haven’t a clue about many of these “new age” stats. I still have no idea what WAR represents, I’m not completely sure as to what the numbers in a slash-line are, and I don’t know what constitutes a respectable OPS.

That got me thinking about how statistics have changed over the years, and whether or not that applies to statistics outside of baseball (or sports, for that matter). Maybe people who study data analytics for a living might know this better than I do, but what business statistics have a different meaning now than they did ten, twenty years ago? Are there any numbers from way back when that I should now take with a grain of salt?

I’m sure there are many examples of this outside of sports, but I struggled to come up with any. Off the top of my head, I remember how a company where I once worked made a big deal out of perfect attendance — to the point that they gave out perfect attendance awards at the end of the year. However, that had to contend with situations such as coming to work when you were sick, and so on. Do you really want someone who’s sick coming into work? These days, workplaces do not want sick people in the office, and with the advent of work-at-home provisions, perfect attendance isn’t so meaningful, anymore. (By the way, my understanding is that company no longer recognizes or rewards “perfect” attendance.)

So I suppose the takeaway is, how well do statistics age? Can they be compared with the same statistics now? What needs to be considered when analyzing statistics from years ago? It’s true that numbers often tell a story, but in order to get the full picture, you also need to understand the full context.