What a TV ballgame can teach us about design

This afternoon, the 2021 slate of spring training games started for Major League Baseball. And of course, being the big baseball fan that I am, I took to it like a lion to a steak.

I wasn’t thinking too much about design or layout until I heard Michael Kay of YES mention, “I think our fans will like the new clean design of our scorecard.”

At least that’s what I think he said. It threw me for a loop, because I am enough of a baseball fan that whenever I go to the ballpark, I’ll buy a scorecard and keep score during the game. So when he said “scorecard,” I thought about a pencil and paper in my hand (and, usually, a hot dog or a beer in the other). At that point, I realized that he was referring to the score display in the upper left-hand corner of my TV, as pictured below.

It then occurred to me: “wow! That’s a TON of information contained in that one graphic!” At that point, I felt compelled to write this article.

So, let’s break down just how much information is contained here. (A warning to those of you who don’t know anything about baseball: for most of this article, I am going to “speak baseball.” If you’re not a baseball fan, you’re just going to have to bear with me.)

First, I’ll start with a paragraph as to what information is contained in this graphic. Be forewarned: I am about to inundate you with information.

In the top of the third inning, Toronto leads New York, 3-0. There are runners on first and second, with nobody out. Jansen, the Blue Jays’ number 7 batter in the lineup, is facing Wojciechowski, the Yankee pitcher. Wojciecowski has thrown ten pitches, and has a full (three ball, two strike) count to Jansen.

That’s a lot of information to glean from a single graphic, isn’t it? Let’s break it down.

  • We’ll start with the score. Toronto 3, New York 0. (I’m sure that will please many Yankee haters out there.) The score dominates most of this graphic. I don’t want to say that’s obvious, but it does take up most of the image, and is the largest takeaway.
  • Underneath the score are two names, located under the teams for which they play: Jansen for Toronto, and Wojciechowski for New York. The 7 in front of Jansen represents his spot in the lineup (which would be a number from 1 to 9). “10 P” indicates that Wojciechowski has thrown ten pitches. (Note: since Wojciechowski is an unusually long name, the pitcher’s name and the number of pitches would not ordinarily run into each other like that.)

On the right side of the graphic, we see a couple of smaller graphics.

  • Let’s start with the box containing the shapes. We see three boxes, two of which are blue (and the third is gray), denoting baserunners on first and second base. The boxes represent the bases (going right to left, first, second, and third base). The boxes that are blue indicate that they are occupied by baserunners. If the bases were loaded, all three boxes would be blue; if no one was on base, all three would be gray.
  • Under the boxes representing the bases, there’s a “3” indicating the inning. The arrow (represented by the triangle next to the 3) denotes whether it’s the top or bottom of the inning. Therefore, the arrow pointing up and the “3” indicates that it’s the top of the third inning.
  • Now, let’s look at the “3-2” with the two gray circles underneath. The 3-2 refers to the batter’s count. For those of you who are baseball-challenged, a “count” represents the number of balls and strikes on a hitter. A batter who gets four balls is allowed to go to first base (called a “base on balls” or a “walk”). A batter who gets three strikes it out. So the “count” represents the batter’s status, and is always represented as numbers denoting balls-strikes (2-1, 1-2, 3-2, etc.). Therefore, 3-2 indicates that the batter has three balls and two strikes on him.
  • Finally, the two circles under the count represents the number of outs. Each blue circle represents an out (there are three outs in an inning). That these circles are gray indicates that there are no outs in the inning. (And no outs, with a 3-2 count, and two baserunners are a pretty good indication that the pitcher — Wojciechowski — is in trouble.)

The point is that within a relatively small space, a great deal of information can be gleaned. This concept carries over into many concepts of design, including data visualization and interface design. A person who understands how to read that information can obtain a large amount of information from a well-designed graphic.

Whomever it was that designed this score display definitely knew what (s)he was doing. Kudos to the person who designed it. I think this is a great example of how good design can effectively convey information.

Remember the past, embrace what’s next

“Don’t hang on; nothing lasts forever but the earth and sky; it slips away, and all your money won’t another minute buy…”

Kansas, Dust In The Wind

“Movin’ me down the highway, rollin’ me down the highway; movin’ ahead so life won’t pass me by…”

Jim Croce, I Got A Name

When I was in grad school, I wrote a quote for a paper I wrote. My professor loved it, and I’ve used it plenty of times since then. “Ben Franklin had it wrong,” I wrote (or something like that). “There are not two sure things, but three: death, taxes, and change.”

What made me think of this is a Facebook meme that made its rounds over the weekend. Valentine’s Day was this weekend, and a meme with the hashtag #ValentinesDayChallenge was going around. I figured it was fun and harmless (as far as I know, I didn’t include any security info that could be hacked), so I participated.

I still look my answers over, even a couple of days later, and it makes me smile. My wife and I have had some fun times during our years together, and I certainly hope they continue. We’ve done a lot of things that I would love to relive. But, of course, that’s impossible. That time has passed, and we need to confront whatever is ahead.

The fact is, we cannot move backwards in time, and we can only deal with what’s in front of us. What’s done is done. If it was something good, you reflect on it. If it was bad, you learn from it and move on. Unfortunately, too many people (and I’ll admit falling into this trap myself on occasion) don’t understand this. They don’t just want to remember the past; they want to live there. But the fact is, time marches on, and change happens. Those who continue to try living in the past are doomed to fail.

Memories are a wonderful thing — as a song lyric once lamented, they’re “sweetened through the ages just like wine.” It’s okay to remember and reflect on them. But it’s not okay to dwell on them. Memories belong to the past. You can only control the future. Don’t try to go back to what’s already happened. Instead, create new memories that you’ll enjoy reflecting upon once they’re done.

Dating yourself on your #resume — #JobHunt

I’ve spoken to a number of friends about my frustration regarding the job hunt (going nine [!!!] months — and counting). I’ve wondered, at times, whether one of the reasons why I’ve been constantly rejected is my age.

Ageism — a.k.a. age discrimination — is, of course, illegal. But when it comes to the job hunt, it’s nearly impossible to prove. I’ve spoken with a number of my friends and colleagues who believe that it not only exists, but is prevalent. (Before anyone decries me for this statement, no, I don’t have any facts to back this up; this is merely what has come up in conversation. Maybe someone who knows more about human resources can explain this better than I can.)

In any case, one piece of advice I’ve received is to only include the last ten years of experience on my resume. That’s well and good, except that I have a lot of relevant experience that goes back a lot more than ten years. As a technical writer, I want to keep all my listings consistent. How do I go about keeping these experience listing on my resume without listing dates?

The solution: I divided the work experience on my resume into two sections. Under my Work Experience heading, I listed my experience going back to 2009 (slightly more than ten years, but for my own purposes, it works). The second section uses a heading labeled “Previous Work Experience (before 2009),” under which I list my positions — without dates — that I held before then.

It seems like a good solution for obfuscating older experience dates that might reveal your age. However, also be wary of other parts of your resume that might also indicate how old you might be. For me, personally, that section was my education. Before I revamped my resume, my bachelors and masters degree listings included my years of graduation. Those years were also removed as well. Prospective employers just need to know that I have those degrees; they don’t have to know when I got them.

So, if you’re a job hunter who’s older than, say, 35, hopefully this tip will help you with your job search and combat any ageism that might exist.

February CASSUG Monthly Meeting

Our February meeting will again be online. NOTE: you MUST RSVP to this Meetup at https://www.meetup.com/Capital-Area-SQL-Server-User-Group/events/275968506/ to view the Zoom URL!

Our February guest speaker is Elizabeth Noble!

Topic: Streamline Database Deployments

Our online meeting schedule is as follows:
6:00: General chat, discussion, and announcements
6:30: Presentation
We usually wrap up between 7:30 PM and 8:00 PM.

Please RSVP to this Meetup, then use the online event URL to join (note: you MUST RSVP for the URL to be visible). We will send out a meeting password as we get closer to the event.

Thanks to our sponsor, Datto, for making this event possible!

Setting up my #Sessionize profile, and speaking opportunities — #DataSaturday

The other day, I wrote about how Data Saturday — the successor to SQL Saturday — was making use of Sessionize for event applications and scheduling. In order to take advantage of the technology, not to mention future opportunities to speak, I took the time to work on my Sessionize profile.

It turned out to be a lot of work — much more than I expected. I already had my bio and my presentation descriptions within the application, but I discovered a number of other features that, I believe, will present me with additional opportunities to speak.

First, while Sessionize keeps track of events to which you apply through its application, I discovered that it also has the ability to enter external events not scheduled through Sessionize. Even the header on the external events page says, “Organizers love to see your talk history” (and I agree). So, I went through my presentations page to enter all my previous speaking engagements that I did not schedule through Sessionize.

Did I mention that it was a lot of work? I started speaking regularly in 2015. In that time (until now), I’ve spoken at 26 SQL Saturdays, two PASS Summits, seven in-person user group meetings, three professional development virtual meetings, and a podcast. Granted, I know people who’ve spoken at more events than I have, but still, that’s a lot of speaking engagements. I added them to my external events, including descriptions and web links (where applicable — since PASS.org is no longer active, I linked the SQL Saturday pages to the schedule PDFs that I downloaded several weeks ago, and a few other links to any YouTube presentation links I had available).

I also discovered that Sessionize has an option called “discover events” — a feature that allows you to discover potential speaking opportunities. I had gone through the Data Saturdays site to apply to speak at (virtual) events in Redmond and LA, but when I saw the “discover events” option, I got curious.

As it turned out, in order to use this option, I had to fill out sections for areas of expertise and topics, so I filled them out as best I could. Once I did so, I was able to view (and apply to) potential events. In addition to the two Data Saturday events, I also applied to the VTTA Tech Conference and Techorama 2021. (And Sessionize says that I still have an active application to speak at Albany Code Camp, where I’d applied last year, but the event was wiped out by the pandemic.) I think I have a decent shot at the Vermont tech conference, and I have my doubts about being accepted to Techorama, but I figure, you never know until you try.

So far, I do like the Sessionize application. It does a good job of keeping track of my profile and my speaking engagements, and it could potentially open up more speaking opportunities. I’ll admit that I felt some trepidation after PASS (and SQL Saturday) ceased to exist. I wanted to continue speaking at events, and I wasn’t sure how to approach it once the SQL Saturday window closed. We’ll see what speaking opportunities open up with this application.

#DataSaturday

After the demise of PASS, a common question among data enthusiasts and PASS members was, “what happens with SQL Saturday?” SQL Saturday was backed by PASS, and as such, when PASS disappeared, so did SQL Saturday.

Enter Data Saturdays, the successor to SQL Saturday. As I write this, the first Data Saturday is in progress, in Guatemala (virtually, of course).

I’ve applied to speak at the first Data Saturday in the US (so far), event #5 in Redmond, WA on April 17. I submitted three sessions: my presentations on ‘blogging, job hunting, and networking.

When I submitted my sessions, I was a little surprised to see my information come up in the speaker’s profile. My initial thought was that they had exported and imported my profile and presentation info from the PASS.org site, but I don’t think this is the case. Data Saturday uses Sessionize to coordinate events, and as it turned out, I already had a Sessionize profile; I had created it last year for Albany Code Camp, where I had applied to speak last year; of course, the event was wiped out due to COVID. I did notice, on my Sessionize profile, that my submissions are in evaluation for Albany Code Camp on September 25, so I’m assuming that that event is rescheduled for that date.

We’ll see if I’m picked to speak for the Redmond event. There are a number of additional Data Saturday events listed as well; I haven’t yet decided what other events I’ll apply to speak. Even though the events are virtual (for now), they still require some work, and I’m wary of spreading myself too thin, despite my desire to speak at more events.

In any case, I’m looking forward to participating in this next endeavor. I’m looking forward to contributing toward these conferences, and, as always, I’m also looking forward to reconnecting with my #SQLFamily friends.

Archiving my talks, part 3: PASS Summit — #PASS

With the imminent demise of PASS, I figured I should take Steve Jones‘ advice and archive my presentation links.

I spoke at PASS Summit in 2019 (in Seattle) and 2020 (virtually). Naturally, I wanted to get as much as I could from my sessions from those two events.

Unfortunately, it appears that the pages from 2019 are no more. Even the pass.org/summit/2019 URL goes to the 2020 Virtual Summit page, not 2019. So, unfortunately, it appears that many (not all — see below) references to PASS Summit 2019 are lost forever.

However, it appears that the 2020 PASS Virtual Summit page appears to still be active (until next week), so I figured I should grab whatever I could from my presentation.

Alas, getting material from the PASS Summit page is not as straightforward as from the SQL Saturday pages. Unlike the SQL Saturday pages, I did not see a “create PDF” option for the schedule. I did grab screen captures for both my speaker’s description page and my presentation session page (as seen below).

My 2020 PASS Summit speaker’s page
My 2020 PASS Summit session page

I mentioned that just about all references to 2019 PASS Summit appear to be gone. One thing I did manage to download from 2019 was my session recording. Like my virtual group recordings, I took my recording and uploaded it to my personal YouTube. You can view my 2019 PASS Summit presentation here.

I did not do the same with my 2020 presentation. As I mentioned, I ended up having technical issues with my presentation, so I elected not to download it. (Steve Jones suggested that I re-record it and upload it to the PASS Summit site, but that was before PASS announced they were shutting down. I don’t see the point of doing it now.)

At the moment, I believe that takes care of most of my speaking archive. (There’s also the links to my in-person user group talks, but those are archived on Meetup, and are controlled by individual user groups, not PASS, so they’re not as urgent.) I’ll keep poking around to make sure I haven’t missed anything,.

Goals for 2021

So, for my first post of 2021, I figured I should list my goals (I refuse to call them “resolutions”) for the new year.

  • First and foremost, above everything else, find new employment. I have been unemployed since May 1. For those of you keeping score, that’s eight months. 67% of my 2020 was spent in unemployment. Getting a new job, for me, is priority number one above everything else.

    I do have a couple of relatively promising leads, but I’m not out of the woods yet. Hopefully, things will be turning around very soon.
  • Do more with my business. In 2020, as a direct result of my losing my job, I started an LLC. I managed to pick up two clients. It’s good experience, but not enough to pay my bills (hence why I’m still looking for employment). I haven’t done a lot with it in the last few months of 2020. I want to devote more time and energy into it in 2021.

    I readily admit that I slacked off on this as the year went on, and I don’t want to let it slip in 2021. I intend to keep this endeavor going, even if I do land new gainful employment.
  • Get back to the gym. COVID-19 kept me from getting into my CrossFit gym more than I would’ve liked, but the pandemic wasn’t my only issue. I developed back and arm issues that kept me from being more active than I wanted to be. Simply getting out of bed without pain is a chore for me right now. Hopefully, I can get back to being as active as I was before the pandemic.

    Speaking of the pandemic…
  • Travel. The pandemic is my biggest (but not the only) roadblock for this goal; my other major roadblock is making sure I have the money to do so (see “find new employment” above). I enjoy traveling, and I wish I could do more of it. Since the pandemic began, I can count on one hand the number of trips I took away from home (trips to the grocery store don’t count).

    Trips for SQL Saturday have satisfied my desire to travel for the past several years, but now that PASS will be no more, I might need to find another outlet for my out-of-town speaking engagements (more on that in a minute). I also told my wife that I want to take a relatively significant vacation somewhere once the pandemic is over. She and I have both encountered a lot of stress this past year, and I think we both need to find a way to relieve it.
  • Find speaking engagements. One thing I’ve discovered about speaking for SQL Saturday is that I enjoy presenting. I’d like to do more. My last in-person speaking engagement was SQL Saturday in Rochester last February. I was also scheduled to speak at SQL Saturday in Chicago (which would’ve been my first SQL Saturday where driving was not feasible), and I had applied to speak at a local code camp. Both of those were wiped out by the pandemic.

    My friend Matt Cushing encouraged me to sign up for the Idera Ace Program, which would provide funding for me to take part in more presentation opportunities (not to mention that it would look good on my resume). Since I first started presenting regularly, all of my in-person speaking engagements (with the exception of 2019 PASS Summit) have been within driving distance of my home in the Albany, NY area. There is a reason for this: traveling costs money. The Idera Ace Program would provide more opportunities for me to speak at nonlocal events (pandemic notwithstanding, of course).
  • Do more house projects. These past several months at home made me realize how much I want to do with my house, and how little I’ve done to attain that goal. (I’m talking about “fun” projects, as opposed to chores.) Money has been a major detriment (again, see “find new employment” above) as well as energy (see “get back to the gym”), but time has not; since I don’t have anywhere to really go, I have no shortage of time on my hands. There’s a long list of projects I’d like to do, such as finish my basement, build a backyard patio and entertainment area, build a porch, and so on. While I don’t necessarily expect to finish these in 2021, I’d like to at least take steps toward those goals.

There are a lot of other things that I’d like to do, but I think this is a good list for now. (I reserve the right to amend it.) In general, I’m hoping for a better year, and 2021 supersedes the dumpster fire that was 2020.

January CASSUG Monthly Meeting

Our January meeting will again be online. NOTE: you MUST RSVP to this Meetup (https://www.meetup.com/Capital-Area-SQL…/events/275432320/) to view the Zoom URL!

Our January guest speaker is Bob Ward!

Topic: SQL Server Edge to Cloud

SQL Server is everywhere you need it from the IOT Edge to your cloud to public clouds. With all of these options it can be difficult to know which to choose and why each options may be right for your data needs. In this presentation, I’ll review with you all the current released and preview versions of SQL Server from the edge to the cloud. I’ll compare each of them and discuss why you want to get ahead of the curve by understand what is possible with the modern SQL Server. I’ll discuss technical details of some of these options so you can understand what SQL Server flavor fits your company needs. This session will include some demos to highlight key innovations with SQL Server.

About Bob:

Bob Ward is a Principal Architect for the Microsoft Azure Data SQL Server team, which owns the development for all SQL Server versions. Bob has worked for Microsoft for 26+ years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2019 including Azure SQL. Bob is a well-known speaker on SQL Server, often presenting talks on new releases, internals, and performance at events such as PASS Summit, Red Hat Summit, Microsoft Ready, SQLBits, SQLIntersection, Microsoft Inspire, and Microsoft Ignite. You can follow him at @bobwardms or linkedin.com/in/bobwardms. Bob is the author of the books Pro SQL Server on Linux and SQL Server 2019 Revealed available from Apress Media.

Our online meeting schedule is as follows:
6:00: General chat, discussion, and announcements
6:30: Presentation
We usually wrap up between 7:30 PM and 8:00 PM.

Please RSVP to this Meetup (use the link above), then use the online event URL to join (note: you MUST RSVP for the URL to be visible). We will send out a meeting password as we get closer to the event.

Thanks to our sponsor, Datto, for making this event possible!

Archiving my talks, part 2: Presentation videos — #PASS

With the imminent demise of PASS, I figured I should take Steve Jones‘ advice and archive my presentation links.

I’ve done a few presentations for the PASS Professional Development Virtual Group. Of those presentations, two of them were recorded to the group’s YouTube channel.

Because the channel lives on YouTube and not PASS, I have no idea whether or not it will disappear when PASS does. Nevertheless, I decided I didn’t want to find out. Better to be safe.

I downloaded the two recordings that I did for the PASS virtual group and reuploaded them to my own personal YouTube channel. Even if PASS decides to drop the channel, the videos will continue to live on my own channel.

So, at the moment, I currently have three PASS-related presentations on my personal YouTube channel.

Links to these videos are also available on my presentations page. Note that my Professional Development Virtual Group presentations still point to the PASS YouTube channel videos, but if PASS decides to drop the channel, I’ll change the links to point to the videos on my own channel, where they’ll live indefinitely.