Founder and owner of Green Mountain Software, a consulting firm based in the Capital District of New York focusing on SQL Server.
Consulting DBA ("and other duties as assigned") by day, and sometimes night, and caver by night (and sometimes day).
When I'm not in front of a computer or with my family I'm often out hiking, biking, caving or teaching cave rescue skills.
One of the side effects, happy I tend to think, of taking my prereqs for PA school is that it’s forced me to better about my time management.
I’ve often said that one of the advantages of consulting is I can set my own hours. And there’s truth to that. But there’s a flip side. Sometimes it can be hard to get started on projects or to even get motivated. With projects sometimes I feel guilty if I’m setting aside time for them and not hustling for more work. Or, motivation is low because well, sometimes it’s tough to get motivated when the highlight of your day is “Can you add this user to the database?”
But now, I have approximately 12 hours of the week I absolutely have to block out. I can’t make excuses to myself of “oh, I can do that later” or “Oh, I should be trying to drum up more work” etc. I have to be in a room or lab, focusing on a particular topic.
But more so, on top of that, I have to block out time pretty much every night and so far one day of the weekend, to go over notes, study the past week, prepare for the next and work on study aids. So this has forced me to get better about time management. Fortunately I’m not in the stage where it’s highly stressful. If anything I’m feeling a bit better. I feel like I’m accomplishing more. So, a side effect of my school work is I actually feel a little more charged because I feel like I’m using my time more effectively.
And part of that, is making sure I get this blog out in time to take care of the rest of my day.
Because last Monday was Martin Luther King Jr Day, my classes didn’t start until Tuesday. So technically I finished my first week yesterday and I’m starting my second week today.
And wow, I have to say, so far, I’m loving it. But there’s more to it than just that.
I’ve had a few friends close in age say, “Wow, I could never do what you’re doing!” Or, “Wow, I’m done with school. How are you doing it?”
For all of them, I understand. For one, everyone is different. Some didn’t have a great experience in school. Some are too busy. Some just don’t have the interest. I get it. But for me, wow, it’s been a great and heady experience and parts of me wish I had done this years ago. Of course I have to temper that with “it’s your first week Greg, give it a few more weeks.”
It is definitely a strange experience being the oldest students in the class. The only reason I say oldest student and not oldest person is because the four professors I have area all close in age to me or older. I’m only taking three classes, but my Bio I lab professor is not the same as the Bio I lecturer, hence having 4 total.
Bio I – so far, all review for me. Basic chemistry and some basic definitions. The professor has made a good point that we all have to start someplace and I agree.
Bio I Lab – basic safety and use of the micropipette and spectrophotometer. Good stuff. But not the most exciting. I do hope it gets better.
Psychology 100 – Strangely the class I felt oldest in for a minute when he was talking about the theory of playing classical music in utero and if the idea it might have an impact on fetal and baby intelligence. It was just a brief comment, but I had to remind myself, I was alive when this was all the rage back in 1998, including the governor of Georgia wanting to send CDs with classical music to all pregnant mothers. Meanwhile, the other students in the class, if they had heard of it, it was either as history, or because they heard the music itself!
Anatomy & Physiology 1 – The professor was out due to Covid for our first two classes and lab unfortunately, so we did stuff via Zoom. I can already tell I think this is the class I’m going to have the most fun in. It’s also probably going to include some of the most amount of rote memorization. So flash card time! I’ve already warned Randi on longer road trips I may have her ask me questions while we’re driving.
Besides enjoying the classes, I think I’m prepared to be a better student than I was 30 plus years ago. There’s a number reasons. For one, I’ve simply just accumulated a lot of general knowledge over that time between a lot of reading and then the learning and teaching I’ve done for NCRC and other programs. So for example, I’m already ahead on some of the terminology in A&P.
But it’s more than that. I’m simply a bit more focused, though that will be something I’ll have to keep an eye in, including keeping the balance with consulting in place.
But also, the technology obviously is different, and this has honestly helped me. Being able to communicate with the instructors via email (and Zoom) works well for my style. And the other thing I’m taking advantage of is my Rocketbook and OneNote to better take notes and organize things.
I have yet to really meet any of my classmates or learn their names and this being a community college and all of us are on different tracks, I suspect I won’t get too close to any of them. If/when I get into PA School though I suspect that part will change, in part because we’ll all be focused on the same thing and because having study partners will be an absolute requirement.
So, it’s only been week one, but I’m really enjoying it and looking forward to the rest of the semester.
In the meantime, an update on the Lego Saturn V I received for Christmas:
The dream is always the same. … and I… find myself in a room full of kids taking their college boards. I’m over three hours late; I’ve got two minutes to take the whole test. I’ve… just made a terrible mistake. I’ll never get to college. My life is ruined. – Risky Business
Today is the day. For the first time in over 30 years I’ll be sitting down in a college classroom and taking a class. I distinctly recall taking my final exam for college. It was in Microbiology. I wasn’t overly concerned. I need to get something like a 40% on it to pass the class (and since it was counting as transfer credit, my actual letter grade didn’t matter as far as RPI was concerned.). It was multiple choice. Once I was confident I had gotten well over 40% I put down the pen and walked out. (For the record I ended up well over 80% on the exam.)
But I have to remind myself, that technically while that was the end of my undergrad career, I have taken classes since then. I took a class on SQL Server a few years later, I studied for and got my MCSE a few years after that, and starting in 2002, I started my career with the NCRC where I have since become an instructor.
But, this is different. For one, it’s 12 weeks of classes. There will be a lab. There will be homework. It’ll be harder in its own way than the other training.
Like many, for years after I graduated, I’d have a dream, usually around May, where it was exam time and I realized there was a class I had never attended and now had to take an exam in it. I’d always wake up a bit upset. One year though finally the dream changed. This time the setup was the same, but when I went to take the final exam, I aced it. Don’t ask me how. But I literally stopped having these exam dreams after that.
So I figure it’s appropriate that I had a dream about starting school last night. In my dream though, I was over in Schenectady (about 15 miles from the community college I’ll be taking classes at) trying to get folks to tell me what time it was, since I had to be at class at 2:00 PM. None would give me a straight answer at first until I got upset. Finally one person told me it was 1:45 PM. I was panicking because I knew there would be no way I’d make it to the Torrington CT Campus of UConn. It was then that I recalled that fortunately I didn’t have to drive that far.
All this is a setup to admit that yes, I am actually both excited and nervous. I’ve gone in a few short weeks from a feeling of ennui when it came to my career and life to one of stress and even a slight bit of panic. Of course it didn’t help that I had to get my vaccination status cleared, and then a bunch of other paperwork finished up late yesterday before it all became official.
I honestly have very little idea what my experiences over the next several years will be like. But I’m looking forward to them.
Andy Yun (t | b) is this month’s host. Our challenge this month is:
…to think about something you’ve learned, that subsequently changed your opinion/viewpoint/etc. on something.
I’m going to give a twofer for this one, since he’s also allowing non-technical answers.
“SQL Server writes everything in 8K blocks.” I recall learning this probably close to 2 decades ago. And, it makes sense, at a lot of levels. And it was “confirmed” when we reformatted the disks on one of our production servers into 64K blocks so SQL Server could read/write 8 blocks at a time. Performance definitely improved. But, then I learned from Argenis Fernandez that this isn’t necessarily true. SQL Server will write what it wants to write. And if you think about it, that makes sense. If you update one record and it’s a single value you’re updating, SQL Server isn’t going to simply sit there and not write your 1 byte change to disk. And it’s not going to make up random 8191 bytes just so it can satisfy this rule of 8K. Yes, SQL Server will try to consolidate disk I/O and be efficient about it, but even then, it may not matter. Gone are the days where we’re writing data to bare metal (some of us are old enough to recall an option in early versions of SQL Server where one could create a database on a “raw” partition to get a performance boost). No, today we’re probably writing through multiple layers, more than we realize. For one client for example, a disk write from SQL Server will pass through an encryption layer, then to the OS, which will pass it through a disk driver layer that will then pass it on to the VM which will have its own layers. At that point, even if SQL Server were trying to only write 8K blocks, it’s quite possible every other layer has its own rules.
Yes, changing our disk formatting from 8K blocks to 64K blocks helped. It helped us. But, your requirements and situation may be different and ultimately you may end up writing more or less than 8K blocks all the time. (and I hope I summed up Argenis’s position accurately.)
Toss the Rope Down
As many know, I’m a caver. I’ve been caving for decades. Early in my caving career I learned vertical caving and back then we still used what was known as a “3-knot” system or “prussiks”. That hardware has improved and changed. But one habit took longer. It was (and unfortunately still is) common to tie one end of the rope to a tree or other rigging point, and drop the rest down the pit. Sure, you ended up with a pile of rope at the bottom, but no one really cared, as long as you didn’t step on it (which is another myth for another time). This helped guarantee that your rope actually reached the bottom. The only thing that sucks more than rappelling down a pit and reaching the knot at the end of the rope 50′ from the bottom of the pit is rappelling down a pit and realizing 50′ from the bottom of the pit that you forgot to put a knot in your rope.
But somewhere along the line, folks started to realize, “hey, that rope at the bottom of the pit is useless. It’s FAR more useful if we can leave it at the top of the pit.” As the depth of most pits are known, it’s actually not that hard to measure out the rope you think you need (plus a bit extra) and then rig the rope so that you have extra at the top. Why is this important? Some call this “rigging for rescue” (or more accurately, one part of the bigger concept).
Imagine the scenario where you’re ascending the rope and have an equipment failure. You can’t go up and can’t go down. If all the extra rope is below you, it doesn’t do you any good. You can’t do anything with it. But, if that extra 10′ or 20′ (or more) is at the top and you’ve rigged correctly, someone at the top can, without too much effort, safely change the rigging (with you still on the rope) to a 3:1 or if nothing else, a 2:1 haul system. Suddenly that extra rope sitting at the top of the pit becomes useful.
Beginners will still often toss the extra rope to the bottom of the pit, but more experienced cavers will rig it to stay at the top and this may literally save lives.
Stop and think about practices that you do now that you may have learned that could be wrong or no longer applicable. And more importantly, do those bad practices interfere with doing something that’s better or safer? With SQL Server, over the past few decades, a lot has changed and improved, but are you still doing something you were taught 2 decades ago because “well that’s the way things are done.” A lot has changed in 2 decades. Make sure your knowledge is still valid!
As I posted in my 2022 Year in Preview on Saturday among other goals, I had decided to work towards a career change. On Facebook and elsewhere I asked folks to read it and by extension, for support.
Wow, I got it in spades. I’m humbled and thankful. Now if I could say I wasn’t nervous or even already feeling a bit overwhelmed.
I thought I’d provide a quick update.
One of the first steps I need to complete before I can even apply for PA school is to fulfill a bunch of prerequisites. This means taking a fairly full class load at the local community college. To do that, I needed to actually register for classes. I figured that would be the easy part, so I set off full of hope yesterday morning to do so. Their offices were closed last week, so yesterday was my first opportunity.
And I hit my first roadblock. I was told I needed to prove my vaccination status to the health office first. Well that’s a bit of a problem because for various reasons, I didn’t have access to my health records from when I was a kid, when I would have received the required vaccinations. After series of calls to various providers and the community college health office, I learned I could, if necessary get the shots from the health office. But, I needed to be registered for classes first. So effectively I couldn’t register until the health office said everything was OK, and the health office couldn’t say everything would be OK until I was registered for classes. Welcome to the classic Catch-22.
Eventually I was able to cut some red-tape and am registered and on the way to solving my vaccination status issues.
So, first hurdle cleared.
Then another one hit: I may have underestimated what prereqs I need and if that’s true, will have to 100% definitely push back one year for the whole process.
I’ll admit that gives me very mixed feelings. One one hand, it may mean a lot less pressure to get everything done this year. On the other, it definitely means another year before I can fully change careers.
So, yesterday was a roller coaster of emotions.
And it was just the first week. But I didn’t expect it all to be roses and flowers. But I’ve decided to t least share most of my ups and downs with my readers.
Oh and one upside: I finally got a Christmas present that I had wanted for two years: the Lego Saturn V. Thanks Ian. I’m going to take my time building it, spread out the enjoyment.
I started last year’s version of this post with the suggestion I should leave it as a blank page and I’m tempted again, but no, I actually have goals for next year.
By words, thoughts become actions, and by actions words become deeds.
I’m going to start with the usual list of items and then have a big reveal at the bottom (you can skip to that if you want).
Like last year, I’m going to continue to write for Red-Gate. Even if it’s just one article. I will also attempt to keep my “Friends of Red-Gate’ status. In fact, I vow to be even more involved if I can find time.
This year for the NCRC, I’m looking to premiere a new class we’re calling “Tip of the Spear” aka TOTS. The focus of the class will be to work with medical doctors, nurses, physicians assistants and other medically trained personal to get them (the tip of the spear) to the patient deep in the cave as quickly as possible to provide the best possible medical care. Unlike our normal classes where there’s a strong focus on things like setting up communications, rigging, searching, etc this will focus solely on getting them there to use their skills. I’m excited about this, even though there’s a fair amount of work required to fully develop the curriculum.
Yeah, I’ll continue blogging. ‘Nough said. (Hey no one says you have to read it!)
Travel: While I do plan to do more, the big trips may be out for reasons to be mentioned below. But we’ll see.
Biking: Yeah, I hope to hit at least 700 miles this year (that has sort of been my minimum goal for years and I’ve beat it every year. I’ll continue to do so).
Hike More: I hope to do at least one overnight this year. And of course day hikes. So if you’re interested in doing a hike, let me know.
Caving: There’s a few caves I want to get into this year. So I’m looking forward to that.
Changes are Coming!
And now “the big reveal”. I’m going to start by saying that while I enjoy consulting and I think I’m pretty good at it, I am not enjoying it as much as I used to. I’m also simply not finding it fulfilling in a way I’d like it to be.
Among the reasons is that at the end of the day I look at what I’ve done and wonder “what difference does it really make?” Yes, I’ve written some solid code. I’ve helped with projects that have saved my clients thousands of dollars or made them tens of thousands. Financially, they’ve obviously made a difference. But, on a personal level they haven’t.
One reason I’ve enjoyed teaching cave rescue so much (and participating in the few I have, including a body recovery) is because at the end of the day I know I’ve made a difference: I’ve taught someone valuable skills, helped someone get out safely, or even in the most extreme case, been able to help others find closure.
I’ve been contemplating a change for awhile. I had toyed with a few ideas, such as going back to being a full-time employee, ideally in a management position for awhile. And I may still end up doing that, but that’s not where I am planning on heading right now. Financially it would probably be the right move, and honestly, I think when I’ve had the right environment, I’ve been a good manager (on the flip side, in a bad environment I’ve found it hard to be an effective or good manager).
So, instead, I’m going to pivot a bit and attempt a career change. I’m going to to try to move into a field where I think I can make a direct impact on people’s lives. I’m going to start taking prerequisite classes so I can apply for a Physician’s Assistant program. This is an idea I’ve toyed with off and on for years. Or rather one of several. Besides enjoying working with computers, I’ve been fascinated with two other fields: medical and law. I’ve thought for quite a few years if perhaps I should explore them. This really came to a head during my dad’s fatal illness 6 years ago. I’ll brag a bit and say that more than once I had one of the attendings or nurses ask me (after discussing his condition or treatment) “Are you in the medical field?” Once even when students were rounding, the attending asked them a question and none answered it to his satisfaction, I was able to step in and correctly answer it. Yes, one or two students scowled at me.
Now, having said that, I’m quite realistic in understanding that while I do claim a greater than a laymen’s knowledge of things medical, I have a LONG way to go and I’m entering a difficult field later in life and have a bit of catchup to do. I have no illusions that this will be easy for me. But to perhaps channel a bit of John F. Kennedy “We choose to go to the Moon in this decade and do the other things, not because they are easy, but because they are hard…”
In the most optimistic timeframe, I’ll be completing my PA work in mid 2025. In a more realistic timeframe, probably 2026. This is a serious investment of time and effort. This is arguably going to be one of the hardest things I’ve done in years. There’s no guarantee of success (heck, there’s no guarantee that even after doing all the prereqs I’ll be accepted into a program). But, I’ve decided I have to try. Ah but a man’s reach should exceed his grasp, Or what’s a heaven for? I won’t know if I can do it unless I try and I don’t want to be a 4 years older wondering “what if?”
I’d been having thoughts about this for a long time. I finally put the thoughts into words, which made them that much more real. Now I’m starting to put the words into actions.
And one of those actions is to write the words down here for others to read. I do this for a multitude of reasons.
By writing this down and revealing it to the world (or at least to a small part of it) it holds me a bit more accountable for trying.
I’ll freely admit, I could use any and all support and help any of my friends, family, including #sqlfamily, and others are willing to give.
And honestly, perhaps it’ll inspire others in a similar position to stretch for their own goals.
For the coming year
I’ll keep working in SQL, you’ll see me at events and I’ll probably do some speaking, but I won’t be seeking out new work. I simply won’t have the time.
I’ll still keep running my local user group and looking for speakers
I’ll be blogging about my successes, and failures.
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.
It’s been awhile since I’ve focused exclusively on SQL Server or even T-SQL and perhaps this would make a great question for someone to ask on a T-SQL Tuesday, but for now I’ll ask.
An open question to any of my readers who work with T-SQL: “What command or construct do you find difficult?”
Let’s be honest, we all have something about T-SQL that trips us up. I’m hoping the basic SELECT statement doesn’t. Though, start to throw in stuff like an outer join and a correlated subquery, it can get complicated pretty quickly. But even those I can generally get written without too much effort.
The one construct I do encounter infrequently, but enough that I feel I should fully grok it by now is a DELETE with a join. It’s actually not all that complicated, but I often have to look up the syntax to remind myself.
But the one that gets me every single time: PIVOT. I’ve probably only written a half-dozen pivots in my life and that’s 6 too many in my opinion. I’m not sure what it is about them, but my mind still doesn’t just fully grasp the syntax in an easy way.
Thinking about it, I think one reason is because when I’ve had to use them, it has never been a trivial case.
Fortunately, since my primary focus is on the operations side of being a DBA, and most of the code I write is to support that, I don’t come across the need for a pivot very often. I suppose though if I were writing a lot more code, I’d use it more and understand it better.
I like when the day I blog lines up with a holiday, or some sort of astronomical event. it gives me a ready made topic.
And so in that theme, this post will be similar to the day: short.
Several years ago (it feels like a lifetime) my family and I flew into Manchester UK so I could speak at a SQL Saturday there. I hadn’t really given thought to how far north it was and the fact that it was close to the Summer Solstice, but I woke up at 4:00 AM local time and it was basically no darker than twilight I was a big groggily confused. Once I was finally awake later in the day I realized why it was so bright at that time.
This time of the year it’s the opposite. I wake up at my normal time (generally around 6:30 to 7:00, the time varies as I almost never use an alarm clock) and it’s still fairly dark and I have to check a clock to make sure if my body’s clock has really woken me up in time for the day.
Between shorter days and the fact that my largest client client is basically in a freeze period, my days are fairly empty, at least in terms of workload. The amount of darkness and lack of work does cause a lack of motivation for much, including writing this blog.
But, that’s belayed a bit by the fact that both kids are home from college, one until her next semester starts and the other until he discovers what life has to bring now that his college career is finished. Like me on the Winter Solstice, one thing is ending and the future seems limitless, perhaps a bit overwhelming. But it is ultimately something to look forward to.
Days are starting to get longer, and in 10 days, a New Year will begin, and I look forward to what that will bring.
In the meantime, I’ll enjoy my Christmas Music, have the lights I inherited from my grandparents lit (technically just the strand, I think I’ve replaced all the bulbs at least once, and they’re getting more rare and more expensive!)
So, here’s to longer days and a better New Year.
And see, I told you this would be a short one, much like the day.
Favorite Conference: The easy answer has been SQL Pass, but honestly, at this point, any where I get to see folks in person!
Best Venue: Ignoring Pass at Seattle, I have to say Manchester UK was nice, simply because it was my first overseas SQL Saturday, or perhaps Virginia Beach SQL Saturday, because Monica Rathbun and her group provided a nice charcuterie board!
Best Presenter: Oh, this is a tough one. I’m going to take a pass. But then cheat and answer below. Sort of.
Next event and why it’ll be Costa Rica: I’m suspecting sort of a bias in this question, but to be honest, I’d love to go. I think 2022 will be a bit too busy for me to visit, but perhaps 2023 or 2024. Maybe I can work in some caving then too!
That all said, I want to get back to my shout-outs above and tie that into this T-SQL Tuesday.
As the coordinator for the Capital Area SQL Server User Group, one of my primary roles, in fact perhaps the most important, is finding speakers to present. I’ve tried over the past few years to have a good variety and to bring some variety. We haven’t really missed a meeting since the pandemic has started, but we have been virtual for well over a year now. This has presented both drawbacks and opportunities. The biggest drawback of course is the lack of actual in-person interaction and the feeling of connectedness that has brought. On a personal note it also means not only have I not gotten out of cooking dinner the night of meetings, but often, I’m juggling getting something together for dinner and getting the session started (though last night my wonderful wife did take care of dinner for me.)
On the flip side, being virtual has allowed me to invite speakers who might not otherwise be willing or able to travel in person to Albany NY and for attendees from across the country to show up. It has also given me the opportunity to experiment a bit more with formats.
Last year, instead of our traditional in-person holiday party format, we did a version of “Bluff the Listener” where I asked various presenters to tell their worst IT/SQL horror stories, but one was lying. It was a success and a lot of fun.
Not wanting to repeat that, this year I decided to ask the above 4 presenters to present lightning rounds. That’s not so bad, except I added a twist. They didn’t get to choose their topics, they were given them: 10 minutes before they were scheduled to present. (And yes, some may I stole this idea from Buck Woody, I’d like to say I was inspired).
I’ll admit I was very nervous about this idea. It seemed a bit gimmicky and it could have been a complete disaster with lesser speakers. Fortunately, all four brought their A-Game.
Rob Farley, presenting from the future, in I believe a public work space, managed to give one of the best talks on column-store indices I’ve seen. Given he had only 10 minutes of prep, I was impressed. His presentation included the use of Powerpoint in sort of a “green screen” mode so he could draw on his screen and we could see what he was drawing.
Peter Shore followed up talking about Tips in Advancing a Career in Data. Again, off-the-cuff with limited prep time, he did very well with this topic. I think in some ways this was almost harder than the more technical topics because you can’t fall back on a demo or graphics.
Deborah Melkin followed, talking about the Best new SQL Server features (2019, 2022, Azure). I had announced previously that the best speaker would be awarded a prize. By I think unanimous declaration, even before Rob Sewell finished out the night with his presentation, the other speakers decided Deborah was the winner. She included some demos in her presentation, which, given the lead time, really impressed folks.
Closing out the evening, Rob Sewell entertained us with a demo of SQL Injection. Not surprisingly, he made use of PowerShell and Notebooks.
As I said, it was an entertaining and educational evening. I purposely set expectations low and made sure folks understood that the entertainment value was as much, if not more important than actual educational value. But I was very pleased with how educational it turned out to be. It was a nice way to end the year and honestly, I think a decent way to get a break from the bad news that seems to have surrounded us lately.
I do have a theory though about why the educational part turned out as well as it did though. In general I’ve always enjoyed lightning talks and I honestly, think they’re among the hardest type of talk to give. Sometimes people promote them as a good introduction to speaking for novice speakers, but I’m not so sure. To give a successful lightning talk, one really has to strip a presentation to the bare essentials and really focus on just one or two key concepts. This can be difficult. But done well I think it really makes those concepts stick.
Now, combine that with topics only being given out 10 minutes in advance, I think that really forces a presenter to focus on key concepts even more. I wouldn’t give an inexperienced presenter a random topic, and even with an experienced presenter, I’d give them a chance to decline a topic if they feel it’s completely outside their wheelhouse. But otherwise, give them a chance to see what they can do. It might surprise you. Heck, it might surprise them.
So, to go back and answer a question from above: Best Presenter… at least last night Deborah Melkin, who if nothing else proved her Google-foo was impressive.
And I think if I can find volunteers, I will definitely try to do an in-person version of this at a future SQL Saturday or Data Saturday or other conference.
Thanks to all who participated and joined us. It was a blast. But honestly, next year, I hope to see you all in person at our holiday party!