Improvement through rewriting

If you’re an application developer (or at least you used to be one, like me), how many times have you come across an old piece of code that you wrote and said to yourself, “what the f*%k was I thinking?!?” You say to yourself, I can write that much better now than I did back then, and your instinct is go back and change everything that you’d previously written.

The same holds true for documentation. I recently had an experience that reminded me of that.

I was updating my slide deck for my upcoming SQL Saturday talk this Saturday. I thought my slides were in pretty good shape, but I wanted to go through them to ensure that everything was still fresh and up-to-date. Besides, the organizers at SQL/Data Saturday LA sent me a link to their PowerPoint template, and I figured that I should use it for my slide deck for Saturday.

Indeed, when I went through my slide deck, I was hit with a case of “what the hell was I thinking?” Many of my statements and references were outdated. I found that I could rewrite much of what I’d originally written, making them more efficient and readable. Some items were unnecessary, and I eliminated them altogether.

I spent a couple of days rewriting my slides. When I was finished, I discovered that I liked the new slides much better than my old ones. I took the new slides and made some minor modifications (mainly removing the SQL Saturday LA branding so that it was more generic). If you’d like to see them, you can download them from my Presentations page.

So the moral of the story is, no matter how good you think something is, it can always be better. Don’t be afraid to review and edit something you’ve created. You might find that you like your new version even better.

(P.S. check out my presentation this Saturday!)

Reminder: I’m speaking this Saturday! #SQLSaturday #DataSaturday #SQLSatLA #Networking

This is a reminder that I will be speaking this upcoming Saturday, June 12!

I am speaking at SQL Saturday Los Angeles. I will do my presentation titled: Networking 101: Building professional relationships.

I am scheduled to present at 4 pm EDT (1 pm PDT). This is a virtual conference, so I will be speaking to you from the comfort of my home office in upstate New York. As much as I’d love to travel to LA, I’m sorry to say that I won’t physically be on the West coast on Saturday! (Perhaps I’ll make it out there at some point — especially now that my new employer is located out there — but it won’t be this weekend!)

Anyone can attend the conference (you don’t have to be a data geek!), but you must register to do so. The event is free! Use their Eventbrite link to register!

Hope to see you (virtually) this Saturday!

June CASSUG Monthly Meeting #Networking @CASSUG_Albany

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

Our June guest speaker is Vasiya Krishnan!

Topic: SQL Database at the Edge

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 using the above link, then use the online Zoom 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!

Upcoming speaking engagements (as of 5/27/2021) #SQLSaturday #DataSaturday #PASSSummit

It seems like it’s been quite some time since I posted about my upcoming speaking engagements, but I do have one coming up!

Confirmed

  • On Saturday, June 12, I will be speaking at SQL Saturday Los Angeles. I am scheduled to speak at 4:00 pm Eastern (1:00 pm LA local/Pacific). This is a virtual event, so I will be presenting from my home office in upstate New York; I will not be flying out to California for this conference!

    I will do my presentation titled: “Networking 101: Building professional relationships.” I will talk about business/professional networking: what it is, how to do it, ways to break the ice, and where to find networking opportunities. This is an interactive session (although I’ll admit that the “interactive” part works better when I do this session in-person rather than virtually), so you might even get a chance to practice networking during this presentation!

    Anyone is welcome to attend; however, you do need to register. Follow the instructions on the SQL Saturday LA site to register for the event!

Applied, but not confirmed

I’ve applied to speak at a couple of other events, but I don’t know whether or not I’ll be speaking at either of them. Stay tuned.

  • November 8-12: PASS Data Community Summit. This online event is the successor to PASS Summit! I also submitted three presentations (so far) to this event. We’ll see whether or not I’m chosen!

    And if you’re interested in speaking at this event, the call for speakers is now open! If you’re interested in speaking at this event, you are encouraged to apply!

As always, I’ll mention any speaking engagements that I have coming up. Hopefully, as we emerge from the pandemic, I’ll be speaking at some in-person events, rather than doing so over Zoom. Hope to see you at an event sometime soon!

I’ve landed!

After 388 days, 557 submitted resumes, and countless rejections, I’m happy to report that I have landed!

I have accepted a position for Insight Global. I will be working remotely as a technical writer for their client, PlutoTV! I start my new gig in a few weeks, depending on how long it will take for them to configure and send me my new work laptop!

I have made no secret about how stressful this job search has been, and I even talk about it in my job hunt presentation. Indeed, an entire calendar year is a long time to be without gainful employment, and it is the longest that I have ever gone without regular work. But I persevered and survived it, and I’m very much looking forward to this new opportunity!

Thanks to all of you who have followed my exploits and supported me!

#PASS is dead. Long live PASS!

Many data professionals, myself included, were saddened back in January when PASS ceased operations. As I’ve mentioned before, PASS provided me with many professional opportunities that I didn’t think were possible. It enhanced my career and provided me with countless networking opportunities. I made many friends during my association with PASS that otherwise wouldn’t have been possible. Believe me, #SQLFamily is a real thing!

Redgate picked up the ball that had been carried by PASS. They have been hard at work resurrecting the community that PASS had built.

I was happy to see that the PASS brand has been rebooted in a couple of ways: PASS Data Community Summit and the resurrection of SQL Saturday.

I wrote earlier that I’d been chosen to speak at Data Saturday LA. However, I did not see the link on the DataSaturdays site. It turns out that the link is listed under SQL Saturday.

The new SQL Saturday site includes links to all the previous SQL Saturday events that were hosted by PASS. I was happy to see that all the previous events appear to be listed. With that, I plan to update my old presentation links to point to the newly-listed (old-listed?) events. (I see a lot of work ahead of me!)

One question I have is what will happen between SQL Saturday and Data Saturday? Will they remain two different entities, or will they merge? I am not privy to that level of administration, so I have no idea.

The new SQL Saturday and PASS Data Community Summit links still need work, but I’m happy that Redgate has been putting in the work to restructure the brand and the community. Great work, Redgate! Bravo! I am very much looking forward to seeing how Redgate proceeds with the updated community.

Edit/correction: as it turns out, there is actually a board, of which Steve Jones is a part, that actually does the work on the new SQL Saturday initiative. While Redgate sponsors it (their branding is all over it), it’s the board that actually does the work. Nice job, board!

The right frame of mind is important for your overall health

I’ve been holding off on writing about this, but what happened to me is an important story to tell, and a cautionary tale for others who might be going through the same thing.

The photo you see above is me lying in a hospital bed about a month ago. And I want to tell you how I got there.

I have made no secret about how much the experiences of the past year have stressed me out. When I keep a regular schedule (and when I’m working), I have a routine that I maintain. And as long as I stick to the routine, I tend to do pretty well. If my routine gets upset, that’s when I get into trouble.

Well, the stress that I’ve endured upset my routine. My sleep schedule had been irregular. And I’ve been doing a terrible job of taking care of myself. The pandemic closure, in the early months, shut down gyms, which meant that I stopped going to CrossFit (which had been part of my routine). To make up for it, I started doing a Couch to 5K program. I had been doing pretty well with that program, until about halfway through, I was beset with injuries which also upset my (now new) routine. (The injuries were bad enough that I ended up going to PT to address them.) My extracurricular schedule, also part of my routine, had been disrupted because of the pandemic. I was stressed and overwhelmed. Things that I used to enjoy now suddenly seemed like a chore. To sum it all up, I had stopped taking care of myself.

About a month ago, I started having problems eating. Twice within two weeks, I got sick after eating. After the second time, my wife insisted that I go to the ER. Upon being examined, I was told, “we’re admitting you.”

For the sake of my personal privacy, I won’t say what it was that I had, except that it was not COVID. I will say that I remained in the hospital for a week. I barely ate anything during that week. My only diet was bags of IV solution that they sent through my system.

That was not a pleasant experience. I would not recommend that to anyone.

I have been home from the hospital for almost three weeks. I am slowly (emphasis on slowly) getting back to normal. Even as of this article, although I feel much better than I did, I still have not recovered 100%. My energy level is not what it was, and I get tired easily. And it all came about because I had become overwhelmed and had stopped taking care of myself.

The moral of this story is that your emotional and psychological well-being is just as important as your physical one; in fact, it can directly affect it. Your morale is important; in fact, it’s one of the things that I address in my job hunt presentation.

So take it from me. Take care of your mental well-being, and make sure you’re in the right frame of mind. Do what you need to do to roll with the punches. If you need to occasionally let off steam, do so. Get help if you need to. Get yourself to where you need to be, mentally and psychologically. Once you do that, you’ll be able to take care of yourself. Don’t end up like I did last month, and spend a week in a hospital bed.

#DataSaturday LA — I’m speaking! 6/12/21

I am speaking once again! It’s been a while!

I learned today that I will be speaking at Data Saturday (the successor to SQL Saturday) LA on June 12! This event is online, so I won’t be flying out to the West Coast that weekend.

I will be doing my networking presentation. If you’ve wondered about what professional networking is about, or if you’re not comfortable with networking, check out my session!

I am scheduled to speak at 1:00 pm PDT (that’s 4:00 pm EST for those of us, including me, who are out on the East Coast) on June 12.

To RSVP for this event, use the EventBrite link by the Los Angeles Data Platform group at https://sqlsatla2021.eventbrite.com/.

Hope to see you there!

May CASSUG Monthly Meeting #Networking @CASSUG_Albany

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

Our May guest speaker is Anthony E. Nocentino!

Topic: Kubernetes!

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!

Our user group logo gets a makeover @CASSUG_Albany #Logos #Branding

As some of you might be aware, I’m the person who handles communications and branding for the Albany local SQL user group. As such, I’m responsible for sending out group announcements, updating the calendar of events, and maintaining whatever social media resources we might have.

Our old user group “logo”

Last week, I was preparing the announcements material for our April meeting, and in doing so, I took a long look at our “logo” (seen here on the right). There were many things that I found amiss. First, the logo, which we had had for several years — I’ve lost track of how long — was unwieldy and no longer representative of our group. Second, it used the PASS branding (and the REALLY OLD branding at that), which needed to be removed since PASS ceased operations in January. Finally, it was not dynamic — we were using it universally as a logo and an icon, and it really did not function well as such. I spoke to Greg and Ed, our user group’s co-admins, and got their blessing to come up with a new logo for our group. (Besides, I needed the design practice!)

One idea that I tried…
…and another

I sat down and tinkered with some ideas. I tried out some fonts and visual schemes. Ideally, I wanted to incorporate some specific design elements: New York State, something representative of the Albany Capital Region where we’re located, a technical-looking font, and the universally-recognized (at least to data professionals) database icon. I wasn’t sure what kind of color scheme I wanted to use, but as it turned out, I started out using blue and gold for the fonts (which, unofficially, are considered to be New York State’s colors), decided that I liked them, and stuck with them.

My initial idea was to superimpose the user group acronym (CASSUG) over the outline of New York State; those are the designs you see here to the right. I tried a couple of different fonts, including one (which you see in the second image) that included NASA in the font name. (I decided that I liked the other font better.) I positioned the database icon over where Albany is located, which would satisfy my requirement of representing the Capital Region.

While I was generally happy with the results, I also wanted to take another approach. I downloaded a line drawing image of the Albany skyline and placed the CASSUG text logo underneath it. I liked the idea and decided to run with it; however, I needed to find another image, as the skyline image I used could potentially have violated copyright restrictions (I did not post it here for exactly that reason). I had to find another image, but I was unable to find one that I liked. I decided that the only way I could come up with a suitable skyline outline image was for me to create my own.

I opened MS Paint and hand-drew a simple representation of the skyline. I decided to represent four local landmark structures in the drawing (and anyone local to the Capital District knows that one of those structures had to be The Egg — it is the one landmark building that instantly identifies the Albany skyline, just as much as The Pyramid identifies Memphis, the Carrier Dome identifies Syracuse, or the Space Needle identifies Seattle).

I thought the outline came out fairly well, but I had to make sure that I did it justice, so I posted it to my Facebook and asked local friends if they could identify the buildings. (If you’re looking at the logo at the top of the page, the buildings represent, from left to right, the Corning Tower, the Egg, the State Capitol, and the Smith building.) The outline was not to scale and it wasn’t perfect, but it didn’t have to be; it just needed to be recognizable. Everyone correctly identified The Egg, and most people were able to correctly identify at least two of the four structures. That people recognized the skyline told me that I had done my job.

I placed the CASSUG acronym and accompanying text underneath the skyline outline. I wanted to make sure the acronym was spelled out for the benefit of those who wanted to know the acronym’s meaning. As a final design idea, I took the New York State outline, placed it to the right of the acronym, and superimposed the database icon on top of it.

The end result is the image that you see at the very top of this article.

I ran my ideas past the user group members, and people overwhelmingly said they liked the Albany skyline image.

I like how the image came out. I intentionally created a relatively large image (2830 x 1250px); you can create smaller images from a big one, but you can’t create big images from a small one. The image is versatile; for example, if we need a banner, we can use the acronym and text without the skyline; if we need a thumbnail, we can use the icon over NYS, and so on. I started updating our Meetup page with the new design, and I’ll incorporate it into other materials as well.

What do you think about my rebranding effort? Like it? Hate it? Let me know in the comments below.