Changing Technologies – T-SQL Tuesday

Select <columns> from Some_Table where Condition=’Some Value’

T-SQL Tuesday Topic

The above statement is pretty much the basis of what started my current career. Of course it actually goes back further than that. I have a Computer Science Degree from RPI. So I’ve done programming, learned hardware and more. I even took an Intro to Databases course while at RPI. I still recall the professor talking about IBM and something called Structured Query Language. The book had a line that went something like “while not the most popular database technology, its use may grow in the future.” Boy did it.

When I first started working with SQL Server, it was 4.21 and for a startup. I had a lot to learn. Back then, a lot was by experience. Sometimes I made mistakes. But I learned.

When I started at that startup, if one could write basic queries and backup and restore a database, one was a half-way decent DBA. Knowing how to tune indices was a definite bonus, as was knowing things like how to set up log-shipping and replication.

Back then, besides experience, I learned new stuff two ways: SQL Server Magazine and the SQL Connections conference. Work paid for both. It was worth it. But honestly, there wasn’t too much to learn. But there also weren’t as nearly as many resources as there were today.

Fast forward 30+ years and here I’ve written a book, worked for several startups, regularly write about databases and database related topics, and often presented at User Groups, SQL Saturdays and at the now defunct PASS Summit. Today as a consultant I regularly touch the SQL Server Query Engine, SSAS, SSRS, SSIS, use PowerShell, write the occasional C# and VB.Net, sometimes do work on a Linux machine or VM and more. A lot has changed.

Obviously the technology has changed. So how have I responded? By doing what I said above. This may sound like a tautology or even circular reasoning but it’s true. When I would go to a SQL Saturday, I’d often attend 3-5 different topics. I’d learn something. But then I started presenting. And that forced me to learn. As much as I may like to think I know about a topic, when I go to present about it, I like to ensure I know even more. This forces me to read white papers, other articles and perhaps attend other sessions.

When I’ve written an article, I’ve often had to do a lot of research for it.

So strangely, I would say a bit part of keeping my skills up to date is not just learning from others, but from teaching. Teaching forces me to keep my skills up.

In summation, I’ve responded by learning from others, but also forcing myself to teach myself before I taught others. It’s a feedback loop. The more technology changes, the more I reach out and learn and the more learn, the more I do outreach.

The impetus for this week’s blog was Andy Leonard’s call for a T-SQL Tuesday topic.

This Post is Free!

Yes, seriously, other than a bit of your time, it will cost you nothing to read this post. And you might gain something from it. That can be a good value.

As I’ve mentioned in the past, one of things I do when I’m not doing SQL Server is perform training for those interested in Cave Rescue. I also sometimes blog about it. I have also mentioned that this year I’m organizing the National Cave Rescue Commission‘s national weeklong training class. In addition, since apparently I’m not enough of a masochist I’m also organizing a regional Level 1 only weeklong training class.

Due to generous contributions the NCRC is able to offer scholarships. For the regional weeklong, we are able to offer 4 scholarships of a value of up to $375 each. This covers 1/2 the cost of training. Applications were due Saturday. Now, we’re hoping for 12-20 students, so this means if everyone applied, they’d have between a 1/3-1/5 chance of getting scholarship. Can you guess how many had applied as of Saturday?

Before I answer that, I’ll note my wife used to work as a financial aid director at a local nursing school. They too sometimes offered scholarships. There was one worth I believe $500 that often went unclaimed. Yes, it required a one page essay to be judged to apply. That one page apparently was too high of a barrier for many folks and as a result sometimes it was never awarded. Quite literally a person could have written. “I would like to apply for the scholarship” as their essay and gotten it.

The same thing happened with our regional scholarships. Out of 11 students so far, none applied. This was literally free money sitting on the table. We have decided to extend the scholarship application process until April 23rd and reminded folks they could apply.

Now, some of the students probably can NOT apply, because they are employees of government agencies that sometimes have rules on what outside funds or gifts can be accepted. This actually increases the odds for the other students. And some may feel that their economic status is good enough that they don’t need to and fear they’d take a scholarship away from someone who has more of a need for it. And that’s a position I can definitely appreciate. But my advice to them, “let the scholarship committee make that decision.” If they determine someone is more needing the money, or your need is not enough, they will let you know. And if they do give you a scholarship and you feel guilty, pay it forward. Donate to the fund later on, or give the money you saved to other causes.

Besides essentially free money at the NCRC, I got thinking about the amount of free training I’ve received in the SQL Server community. Yes, I’ve paid for PASS Summit a few times, but even if I had never gone to that, the amount of knowledge I’ve gained for free over the past several years has been amazing. Between SQL Saturdays and User Group meetings, the body of knowledge I’ve been exposed to has been absolutely amazing.

And yet, I know folks who shun such activities. I’m not talking about folks who say, “I can’t make it this month because it’s my kid’s birthday”. I’m talking about folks who claim they never learn anything. I don’t understand how that’s possible given the HUGE range of topics I’ve seen at SQL Saturdays and oh so many other free events. Some folks seem to think only the paid events are worth it. And while PASS Summit had certain unique advantages, the truth is, you can listen to almost all the presenters at various free events too.

Yes, time is not free, and I recognize that. But overall, it still amazes me at the number of folks who overlook the value of free events, or easy to gain scholarships to events. Don’t turn your nose up at free. It can be valuable.

P.S. – for the parents of college bound kids out there, one thing I did in college which netted me a bit of free money. A few days after the semester began, I’d stop by the financial aid office and ask if there was any unclaimed scholarship money I was eligible for. I never netted much, but I did net a few hundred dollars over the years. For 15 minutes of my time, that’s a pretty decent ROI.

2020 in Review

Yes, I’m joining the chorus of so many others who are publishing a lookback on the previous year. This has become a tradition for me. And I of course followed last year’s review with a preview for 2020. I made the obligatory dad joke then and I’ll make one now, that I can’t wait until 20/20 is truly hindsight!

2020 I think upset everyone’s goals, and mine were no different. But I figured I’d start with my goals from last year and then try to end on an actual up-note.

  • I had a goal of blogging at least once a week. I think I missed 1 this year, but a few weeks I blogged more than once, so, including this post, I will have 56 posts this year. Not to shabby. And my overall page count is up. So that’s good.
  • I vowed to write more for Red-Gate and I did. But not as much as I’d like. I do blame this partly on Covid. I lost some of my enthusiasm. But I am working on another article. I was hoping to have it done this week, but lost motivation. I did learn one of my articles there is one of their top read articles. I’m quite proud of that!
  • I did read more this past year, that’s for sure.
  • One goal I had was to keep speaking at more SQL Saturdays. Well, that didn’t quite go as planned. I did speak at the Albany event, but that was about it. This one I 100% blame on Covid. On the other hand, I finally attended the Portland Oregon SQL Saturday, albeit virtually.
  • Speak at SQL Summit: well I did achieve this one, sort of. It was virtual, but I was selected and that was a HUGE highlight. And in fact I ended up being part of two presentations, the 2nd a live one that I ended up doing from my car while waiting for something else. And my presentation on PowerShell for Beginners apparently was very popular. So, I can at least say I went out on a high note.
  • On one hand, we postponed our NCRC Weeklong Cave Rescue Seminar here in NY to 2021. On the other hand, I was able to work out a Modular Level 1 Seminar here in September, the first of its kind in my region ever. And we did it safely and effectively.
  • Started to use git on a far more regular basis, including from the command line (previously I had limited myself to the GUI in Visual Studio).
  • I did read more! – including:
    • The Power Broker, I biography of Robert Moses
    • Station Eleven, though in retrospect, reading a book about the world after a global pandemic was NOT a great way to start the year!

So, overall, I did accomplish a number of my goal. I had some generic ones that included caving more, biking more, and hiking more. More on those in a moment.

Overall, the year was a bummer in many ways. I really missed travelling. I really missed seeing friends and family (I think we saw my mom in person twice during the entire year). I missed my seeing my #SQLFamily in person. I missed my NCRC Family. I missed having our normal annual pool party.

I missed, normalcy.

But…

You know what, for me personally, 2020 was actually a year of some ups. I’ve been very fortunate and I was able to do things I had not done as much as in the past.

  • For one I accomplished my first overnight hike in perhaps over a decade, a nice 18 miles on the Appalachian Trail. Due to scheduling I couldn’t quite get in a 2nd hike that would have completed a gap in Massachusetts, but perhaps next year. I did find I needed some new equipment, which I purchased in anticipation for next year.
  • As for biking, I definitely did a LOT more this year. I biked over 1300 miles this year (I can’t recall the last time, if ever, I did as much) including my first century ride (100 miles in one day) since my senior year of high school. I’m really proud of that one. Who knows, maybe I’ll do another in 2021.
  • Despite a contentious election season, America voted the Orange One out.
  • Spent more time with my family! We did several walks around the area including some paths we had not explored in the 20+ years my wife and I have lived in the house.
  • I fixed the dryer that had been making a horrible rumbling sound for years.
  • I made a bunch of sourdough bread, pancakes, waffles and even a pizza crust or two. And I’m back to making sourdough again.
  • I finished binge-watching Haven, a quirky fun show based on a Stephen King story.
  • I rewatched (and for my family, they watched for the first time) the entire Prisoner series. Yes, everyone still wonders what the hell the final episode is still about.
  • We’re binge-watching Schitt$ Creek and wondering why we didn’t watch it sooner.

All in all, it was a very mixed year. It wasn’t a normal year in many ways and some of the normalcy, I really missed. But, on the flip side, I think it encouraged and in some cases forced me out of my comfort zone and to do things I might not have had time to do otherwise.

I can’t say it was a great year. While I’ve been fortunate and have not had anyone close to me succumb to Covid, I know too many people who have had friends and family die of it. So in that aspect, it’s been a terrible year. As of the latest count, over 342,000 have died in the US and yesterday set a new record in the US for daily deaths. At this rate, by the start of next week we’ll have over 350,000 deaths and predictions are of over another 80,000 in the next three weeks. PASS has been a side casualty of this too.

Too many lives have been impacted and effected and I don’t want to minimalize those.

But, I do want to highlight that even in a dark year, at least personally, I’ve been able to find some positive things to focus on. I hope others have too. Hopefully everyone reading this has at least one thing they can look back on and say, “Yeah, that was good” or “That’s a special memory, I won’t forget.”

And to quote Colonel Potter from MASH: “Here’s to the New Year. May she be a damn sight better than the old one, and may we all be home before she’s over.”

SQL Community

First, I want to thank Rie Irish for giving me cause to blog a second time this week. Normally this time would be sent writing up another article for Redgate (yes Kathi I’ve got one more in the works).

Second, I want to add, that up until now I had decided to refrain from writing about the fall of PASS. I knew eventually I probably would, but some good news last night has accelerated that process.

Last night Rie posted to Twitter an announcement about a new initiative by Microsoft to provide a space and tools for the former PASS User Groups. I was thrilled when I saw this and I’ll explain why.

In the past few days there has been a LOT of efforts put forth by various members of the #SQLFamily to create new spaces for the former members of PASS, both individually, and as groups. I’ll admit, I was both heartened by this, but also a little concerned. I was obviously heartened, because as I knew would happen, the members of #SQLFamily have stepped up and tried to fill various needs. This is a great volunteer community! I want to emphasis that. Even weeks ago when I had suggestions forwarded to me that PASS was about to close shop, I felt that the community would go on.

However, my concern was that it would fracture, that various little domains and fiefdoms would develop. Now, this may not necessarily be the worst thing that could happen. A decentralized community might actually be a good idea. For example if we separate the concept of Saturday events from User groups, that might spur innovation and might encourage new ideas to come forth. But, it might also inhibit things for folks who have organized both if they end up having to maintain two mailing lists, two sites, etc. So it’s a mixed bag. That said, if nothing else had happened, I’d take that over having the community completely falling apart.

And even if nothing else had happened, I know my User Group has speakers scheduled out through May of 2021 (and the only reason I haven’t scheduled beyond that is because I’m hoping by June to know if we can do in-person again and if so when). I know that Monica Rathbun has the Hampton Roads SQL Server User Group scheduled out through all of 2021. This is the case with a number of other User Groups. So, no matter what, User Groups would continue.

And there are still SQL Saturdays in the works, by that name or others. So, the community will continue.

But, as I said, my concern was the community might fracture into fiefdoms.

I think the announcement from Microsoft goes a LONG ways to allaying my fears. Yes, it’s just a press announcement with details to be worked out, but it has several things going for it. The biggest is the name behind it: Microsoft. Let’s be honest, the one thing the #SQLFamily has in common is we all work on the Microsoft Data Platform. So, to me, it makes sense that Microsoft be a central focus. Another is it appears this platform will end up providing a lot of the tools community leaders will need, and all in one place. These two facts should help keep the community from fracturing.

Now, I already know there is going to be one huge objection from some: “But it’s Microsoft, they can dictate what we do! We want something independent like PASS was!”

Well, first let me point out, for all its independence, PASS is no more. So independence is no guarantee of perpetual success.

Secondly, please read the release with an open mind. It’s NOT an attempt to recreate PASS. There’s no talk of a Board of Directors, there’s no talk of a main event. It’s very clear, at this stage what it is: a set of centralized resources to sustain the community. Additionally I’ve spoken further with Rie that has given me further confidence in the plan. We will see more over time how the winds blow, but I am comfortable recommending moving forward with this path. And you know what, if it turns out the Microsoft suddenly wants to take things in another direction, #SQLFamily will again do what it needs to for its members.

So, this is NOT “PASS Version II”. It doesn’t attempt to be. Perhaps PASS Version II will come to pass someday. I sort of hope it does. I look forward to another Summit. But for now, I think this is an excellent step forward. I will end by pulling a quote from the release:

Although Microsoft built SQL Server, it’s clear that the passion and dedication from each of you is what makes it thrive.

And I think this is as true today as it was 2 weeks ago.

Has PASS Passed? Does it Really Matter?

The last week or two of the Twittersphere and blogosphere has left me unsettled. Three members of the PASS Board have resigned in protest: Hamish Watson, Melody Zacharias, Mindy Curnutt. These are three people I’ve had the honor of working with and in Hamish’s case, even sharing the stage (albeit virtual) with. They’re great, hard-working, dedicted people. Rumors are that the Board is consulting with lawyers, presumably to see what is required for an orderly and legal dissolution of PASS as we know it.

Yesterday, a friend posted on my Facebook timeline that she hoped to see me again in a year when I came back out to Seattle for Summit. I had to say, it wasn’t clear there would be a Summit next year.

These things sadden me. Winter, at least here in the Northern Hemisphere is a time of literal darkness, but the situation with PASS, on top of our time of Covid and our bitter partisan divide brings darkness to other parts of my life.

But, I’m reminded of the good things too. Sitting on my kitchen butcherblock are 6 bags of cookies, plus a pile more for ourselves. Tonight is the 6th night of Hanukkah, where again my family and I will gather to light candles to remind ourselves of hope and joy among a dark time millennia ago when evil was vanquished. In a few days, Jupiter and Saturn will be in conjunction and create a single bright “star”. This will happen on the darkest, longest night of the year and then light will start to return and a new year will begin. A vaccine is out and being distributed and hope for 2021 builds.

And last night, I was reminded that PASS itself may be an organization, and I don’t know its future but an organization is made up of the people in it. It’s more than just the founding papers and bylaws and NDAs. To quote Shakespeare, “O brave new world, that has such people in it!”

What exactly do I mean? Well in more normal years, last night would have been our holiday party for the Capital Area SQL Server User Group. This means we would have gathered at a local restaurant, in person and shared stories and memories over food and drink. Months ago it became apparent that this could not happen this year. I struggled with several ideas to do instead. For one, we could have cancelled, but that just seemed too depressing. I could have found yet another remote speaker, but that just seemed boring. I can’t recall exactly where the idea came from, but I decided to do a version of “3 Truths and a Lie”. It turned out to be 4 Truths and a Lie. For those who aren’t familiar with the idea, or who do not listen to NPRs “Wait Wait, Don’t Tell Me” which has a version they call “Bluff the Listener”, the idea is some number of people (in my case 4) tell a true story, perhaps a bit outlandish. One additional person tells a lie. The others in the group then cast their votes for whose story is made-up. It can be quite fun.

I struggled a bit with who to ask to be guest speakers. I wanted folks that I knew could tell a good tale and that had probably some quite unusual stories. So I reached out and very quickly got back positive responses from everyone I asked. THIS is the #SQLFamily I’ve grown to know and love, always willing to help out and if it involves a good story, all the better. One of them, David Klee was positively giddy with excitement. And then it happened: several of the others had to drop out for personal reasons. They all reached out to me and apologized for having to drop out. I understood. Life happens and I know none of them did so without some anguish. But fear not, I had others to ask and other contacts of mine helped suggest names. Originally I was going to go with 4 total story tellers, but because time was now short, I reached out to at least one extra person to ensure if someone said no, I’d still have enough folks. Amazingly, all the folks I asked said yes. Now I had a total of 5 and that was fine, I decided to run with it. So, besides David, I ended up with Kellyn Pot’Vin-Gorman, Ed Leighton-Dick, Rick Lowe, and Amy Herold all weaving tales; of upgrades that included a Cheshire cat, the coworker who thought you had to sit and watch SQL jobs run to completion before going home, a trigger that would routinely update 63,000 rows, JBwelding USB ports in the name of security, and upgrading a server to something 31% slower for the low low cost of only $4M.

Unfortunately, the actual turnout for my group, despite the sign-ups on Meetup, was about 1/2 of what I had expected, but everyone had a great time. Surprisingly, no one guessed which of the above stories was made up (and I’m not giving it away). But we had plenty of prizes so everyone will be going away with something.

The one thing I went away with, was the confirmation that while I have no idea what the future of PASS is (ok, I have some thoughts, perhaps for another time), I do know that it’s far more than just the organization, it’s really the people, the demonyms of PASS that are the #SQLFamily I’ve come to know and love. In this season of darkness, knowing that there are such people out there fills me with hope.

So thanks to the folks named above and to all my other #SQLFamily members, and fellow CASSUG folks, including Ed Pollack and Ray Kim for your help over the past year.

One a finale note: for my birthday this year, I’ve added a link on my Facebook page to the local foodbank. I already exceeded two early goals and have added a third, stretch goal. Watching a segment on hunger and food drives on The Today Show this morning I am again reminded of how much I have and how lucky my family is. I would ask, if you can, donate, either to your local food bank, to the link on my Facebook page or to a charity of your choice.

Thank you and to all, a Merry Christmas, a Happy Hanukkah, and happy holidays for other holidays that you may celebrate.

The Song is Over

So the past few weeks I’ve been writing about PASS in general and about Summit. And now like several of my fellow #SQLFamily members who have already blogged, such as Deb Melkin and Andy Levy, I’ve decided to post a post-Summit post.

First Impressions

Virtual Summit was better than I expected it to be. Let me actually correct that a bit, it was much better than I expected. Now, it was not as great as in person, but my fear was virtually it would completely lack any semblance of the social interaction that makes Summit such a great experience. And while the social interaction was greatly diminished, it was still there and that made it a great experience. I will add that Twitter really helped here, both with the #SQLFamily and #PASSSummit hashtags.

My Sessions

I was honored to have the opportunity to speak at two sessions this year. This is a grand total of two more than I’ve ever had given before. Initially I had been selected to give a session on PowerShell for DBA Beginners. I was a bit disappointed to learn it would be a prerecorded session, but took that in stride. I was very curious how it would work. More on that in a bit. A few weeks before Summit I was asked to take part in another session, this time a live panel session All About PowerShell Panel Discussion. I immediately said yes. And then was later reminded by my wife I’d be out of the house taking her to an appointment and back. This was going to complicate things. But I didn’t want to say no, in part because I felt honored to be among such great luminaries: Hamish WatsonBrandon LeachRob SewellBen Miller. So, I decided I’d do it from my car in the parking lot. And since this would be live I was really excited for that, since I had been looking forward to the real-time interactions. The only other drawback was the timing. It was an 8:00 AM EST session on Wednesday, which meant it was one of the first sessions of Summit, and it would be live, so if there were opportunities for things to go wrong, this would be it. Other than Hamish being up at I think about 1:00 AM his time and a wee bit sleep deprived (or as he put it, the entire world now was on Hamish Standard Time) it went really well. He did a great job of moderating and we had a very good turnout and a number of good questions from the audience. I’ve written about PowerShell quite a bit in my blog and for Redgate and feel very strongly that every DBA needs to have some experience with it, so this was a great opportunity for all of us to evangelize a bit. I was really happy with the this session and can’t wait for the recording to be available. It left me in a very energized state for my session at 2:00 PM the same day.

I had realized several days before my 2:00 PM session that there was a benefit of having it prerecorded. I didn’t have the normal butterflies I have before presenting. It was done. I couldn’t change it. I went into it very relaxed. That said, I did make one change to my normal desktop setup. I added a monitor.

Multitasking at Summit for the win!

The upper monitor is generally my TV but has a HDMI input so I added that to my usual setup. This allowed me to have the ARS window up there so I could see questions and comments and answer them or moderate as needed. The lower left is the video chat window. Though in theory this was only needed during the live Q&A session at the end of my session, I opened it right at the beginning and was able to chat and share with others. You can see my accidental selfie in it. The rightmost monitor showed my presentation as attendees would see it.

After chatting with some other presenters I realized most did not go full-bore like I did and just did one window, generally the ARS window, or maybe the ARS window and their presentation muted in another. For me, the setup above worked well and I’d use it again. I’m used to multi-tasking like this and it worked really well. While I couldn’t modify the presentation itself on the fly in response to audience input, I could interact with the audience in a way I hadn’t previously.

One drawback of the system was while my presentation was on, I had no idea how many were actually “attending” it. Before it started the window with the link to it showed 143 people as “attendees” but I have no idea how many actually ended up viewing, but I’ve got to say even a 1/3rd of that number would have been a win for me. I was VERY happy with those numbers. Also the questions I got during the session and during the video chat Q&A after and then via email really pleased me. It seems like I met my goal of generating interest among people was a success.

Another drawback I realized half-way through (due to a mistake on my part of trying something) was that if you came into the session late, you started at the beginning, not at the same point in time as everyone who had started at the start of the session. While later on I think this is ok, I think during the session presentation times, folks should come into “where the session is at that time”. For me, it meant I had to figure out where most of my attendees were at that point in the session.

After I was done I realized, “that was it. My work is done, the rest is just fun now.”

Other Sessions and Events

I found myself, despite work interfering attending probably as many sessions as I might have at an in person Summit. These included Rob Sewell‘s session on Notebooks, PowerShell, and Excel Automation and LGBTQ+ and Pass Local Groups Birds of Feather sessions on Wednesday.

On Thursday I started with Bob Ward‘s Inside Waits, Latches, and Spinlocks Returns (which is so information rich, but at 8:00 AM EST? Really? And what’s worse, is he makes it seem just so natural), part of Erin Stellato‘s Query Store Best Practices and part of the Diversity in Data Panel Discussion: For the Professional Woman, Itzik Ben-Gan’s Workarounds for T-SQL Restrictions and Limitations which again blew me away with how powerful SQL can be in the right hands.

On Friday I moved on to Brand Leach’s SQL Server Configuration And Deployment With Powershell DSC which gave me some great ideas I hope to implement someday. After lunch I caught Ben Miller’s Getting Started with PowerShell as a DBA (I always like to see how others present on similar topics, gives me ideas to compare and contrast and while we had similar topics, very different approaches and I’d recommend people view both). I finished the day and basically the Summit with Panel Discussion: Consulting 101 – Help Us to Help You. Despite being a consultant for many years, I’m always looking for new tips (and new clients, hint hint)

I also attended several of the keynotes and was especially blown away by the Diversity, Equity & Inclusion Keynote by Bärí A. Williams. I would HIGHLY recommend watching that when you get a chance if you didn’t watch it before.

So That Was Summit

So technically that was Summit. I learned a lot and had a great time. But, I have to talk about some of the drawbacks and disappointments.

For the vendors, I think Summit was a bust. This is unfortunate. I think it’s just harder to do it this way. One thing I noticed is that some vendors advertised “one on one” video chats. I avoided them because I didn’t want to tie up precious resources just being sociable (I don’t have much vendor needs these days). But it turns out in at least one case it was really a 1:Many relationship and the vendor would have welcomed more folks just stopping by. I think that’s on the vendors for not being clear enough in their own descriptions. But that said, even with that change, I think an issue with “stopping by a booth” is there’s more pressure to make it solely productive and not about being social. I don’t know how to change that. I’ll also admit I quickly gave up on trying to collect my points or whatever it was like I would stamps at the in person event. I was told this was more straightforward on the mobile app, but I had no desire to download that, especially since I was attending from my desktop. That said, I think in general vendors struggle with making virtual events worth their time and money. That last one is important because it’s what makes PASS possible. So, perhaps it’s still worth showing a vendor some love and mention you saw their name at Summit.

Overall, I’d say I think the prerecorded sessions and the ARS/Video chat stuff went better than I had hoped for. I’d probably do it again if I had to. I really only had two issues. For the prerecorded sessions there was no way to “pop” it out or expand the presentation screen. You were forced to have he Chat/Comment sidebar at all times. This took up precious screen space. For some reason on the live sessions you had this ability. This should have been made available on the prerecorded sessions. Also, it appeared the session window did not scale. i.e. if you had a monitor with higher resolution, it simply kept a certain mount of space around the presentation itself. Overall, the session window did NOT take good use of screen real-estate. This was compounded by the fact that some presenters (me included) did not make their fonts large enough. On my screen when I was recording, the size was great, but once in the presentation window, for many nearly unreadable. I know at least one person left my session because of that. I’ll own up to the fact I should have better headed the recommendations and probably gone overboard on font size, but the fact that screen real estate was so poorly used only exacerbated the situation.

I was disappointed in the turn-out for the two Birds of a Feather sessions I attended. I think the timing was rough, especially for folks on the East coast and perhaps Central timezones. Honestly, I think the Birds of a Feather and some of the other social times should have had FAR wider windows of time, perhaps from lunch until dinner or past. Take advantage of the fact that folks are in different timezones to get more moderators. I know I’d have attended more Birds of a Feather sessions had they been available at times other than when I was making dinner (or eating my salad).

That aside, the one issue that quite honestly angered me and I felt there was no excuse for was the horrible closed-captioning. When I first heard about it I was excited because I’m a firm believer in accessibility. All speakers were told we had to have our sessions recorded early enough so that closed-captioning could be applied. Given the time frame I had wrongly assumed this included time for a Mark I human brain review. It was VERY apparent that the closed captioning was purely automated and had not been reviewed. Some of the errors were comical, apparently at one point I was talking about T-CPU and not T-SQL, and another presenter was creepily talking about skin. Other errors made the presentation at times seem senseless. I had more than one person comment that the real-time capabilities of PowerPoint did a better job in their experience. Pretty much every speaker I spoke with had similar complaints. So, in conclusion I’ll say, I’m not sure the point of having stuff in so early when current realtime tools from other vendors can already do a better job. If you have two weeks to review the closed-captioning, I highly recommend outsourcing it to a human to review. Or somehow give speakers the ability to touch it up (if that was a possibility neither I nor any other speaker I spoke to was aware of it, and it was not on our speaker checklist on the dashboard). Honestly, not only do I think there was no excuse for the poor quality, I think it did an actual disservice to any hearing impaired people trying to attend.

Finally

By the time you read this, it’s probably too late, but if you haven’t VOTE OR YOUR PASS BOARD if you’re eligible. I’ll be blunt, we’re at a crossroads with PASS and we may not have it a year from now. But no matter what happens, if you’re eligible to vote and failed to do so, I really don’t want to hear you kvetching about the future of PASS.

And while it’s too late to register for Summit, if you have already, remember, you get access to ALL the sessions for the next 12 months. Take advantage of that!

Almost There

The important election season is here. No, I’m not a week off or 4 years ahead of my time. I’m not talking about the recent US election, I’m talking about one that is upon us in PASS.

In the past few weeks I’ve blogged about my speaker preparation timelines here and here. Tomorrow morning, the pedal hits the metal and I’m doing a live panel discussion on PowerShell with some great panelists. And then in the afternoon my pre-recorded session on PowerShell for DBA Beginners will be broadcast with me doing a live Q&A afterwards. I hope you can join me for both.

Over the past few months I’ve been promoting the SQL PASS Virtual Summit. I’ve tried to get as many folks to sign up as I can, but honestly, I’m not sure I made much of a difference. Most of the folks I know had already made up their minds. But I didn’t stop. I even was promoting it at my User Group last night. And I’ll say now, it’s still not too late to sign up if you want.

I truly do think that PASS Summit is one of the great things our community does.

But…

Yes, there had to be a but here. I’m not happy, and from the blogs, tweets, and private comments about I’ve heard, neither are a lot of a other people. We have to be honest. COVID and going virtual has hurt PASS in several ways, but very much financially. There may not BE a PASS in the future if things don’t change. Some folks want to put the blame at the feet of C&C, the organization PASS pays to manage its daily affairs. Others put their blame elsewhere. There are many recriminations and attempts at casting blame. I don’t want to dwell on that, other than to say often I think it’s misplaced and can be hurtful.

Let me start by saying that I don’t think anyone, on the board, at C&C, or otherwise is acting in bad faith or ill will. I know many of the people involved and I truly think they’re good people who mean well.

But, that said, I think things have to change. Initially I thought about running for the board, but honestly, didn’t have the time to do the research and background gathering I wanted to before I could submit my application to the nomination committee. I reached out to several of my peers and colleagues for their thoughts and received a lot of useful feedback. But the long and short is, I’m not running. Perhaps next year. However, that doesn’t mean I can’t help effect change. Nor does it mean you can’t either.

We can effect change by voting for who we want on the PASS Board for next year. The list is here at the bottom. Steve Jones also has a quick blog listing them and other links. Rather than reproduce what he wrote, use the link above.

Just like in the US elections, I think it behooves oneself to participate as fully as possible and that means doing your research on candidates and actually voting. I’m not going to make recommendations here. In part because I still have to do the first part and do more research. But I can say this much, though I’m not running this year, I am certainly voting this year. PASS is very valuable to me and I want to see it be the best organization it can be and to do that, I think it needs to change and I hope to see it change for the better.

So, I’ve promoted Summit, I’ve prepared my presentations, I’ve kept my User Group informed. And shortly I will do the last bit for this year, and vote. I hope you do to next year.

And in closing, I’m going to steal a line generally said at Passover: Next year in Seattle! In the original it’s a call for hope to meet again in Jerusalem and in that spirit I truly hope to be among my friends and family next year in person, be it Seattle, Houston, or another city.

Speaker’s Timeline Part II

This is a follow-up to my first part. But before I dig into it, I want to thank all the readers who check in on my post last week. I had the best week ever in blogging. And I’ll admit, while my ego was pleased with the numbers, I think what really warmed me heart was the number of my fellow #SQLFamily members who retweeted, shared, or gave positive comments about it. Thanks.

So, back to my speaking timeline. On November 11th I’m giving my presentation on PowerShell for DBA Beginners at 2:00 PM EST. I’d be thrilled if you joined me.

So, last time I wrote about this, I had ended with what my next steps would be.

October 20th around 10:00 PM EDT

Upload final version of slide deck. Yes, I could probably improve upon it (and looking back now, there’s 1-2 slides I’d probably like to fix, but oh well).

October 20th – 10:44 PM EDT

Confirmation email: slides were received. Excellent!

October 21st – Midday

One more run through. Basically nail it at right around 0:58. But now really worried, what happens if I finish early before the live Q&A? Will there be 2 minutes of dead air?

October 22nd-24th

Do nothing. I deserve a break. Right? Right?

October 25th – Late Afternoon

Record my presentation with Zoom. It’s acceptable, but I made a mistake or two. Worst case, if I run out of time, I can use this, but honestly, I want a redo. But, like a good dba, I basically have a contingency plan in place in case I don’t get time to do a redo.

October 26th – Morning

Decide to use OBS to record, in part so I can include a window of me talking. I think it’ll be a bit more personal and interactive than simply having slides and a demo with a faceless voice talking.

October 26th – Morning 30 minutes later

What was I thinking? Why go through all this trouble. This is more work than I want to deal with today.

October 26th – Morning 45 minutes later

Ok, this just might work! I’ve figured out how to get the overlay the way I want, but gave up on green-screening me against a background, but that’s ok because the thumbnail video is small enough my background is not distracting.

October 26th – Morning 1:00:08 later

This recording is nearly perfect. I think it ran over by about 8 seconds, but if they cut that, it won’t hurt anything. Honestly, I’d ilke one more try, but I can’t stand the thought of listening to my own voice one more time.

October 26th – Late afternoon

Wait until the kids are done with school Zooms and my wife has no more meetings to start the upload.

October 26th – an hour later

Hmm, seems stuck. Do I wait or start over?

October 27th – an hour and 5 minutes later

PASS Virtual Summit 2020 – ‘Upload Video’ Upload Confirmation email arrives.

Excellent!

October 27th – an hour and 6 minutes later

Tweet about it!

Since Then

Several of my #SQLFamily members admit, some publicly, some in private that they missed the deadlines or at least feel better that they’re running as late as me. I feel for them and I’m glad that my timeline and tweets made them feel better about their own timelines.

Up until I had finally submitted my video, I had put off watching any other presenters talk about PowerShell. But now that I’ve submitted my video, I’ve decided to relax that rule and watch at least one other presentation on an introduction to PowerShell and start to think, “why didn’t I bring that up? Hmm, he’s got a good point there. Hmm, I should have covered that.” I start to have doubts about whether my presentation will hit the mark. But fortunately, upon further reflection I realize the other presenter took a different tack than I did and mine has a focus he doesn’t. Someone watching both will actually get useful information from each of these. Now I’m feeling better. In fact, feeling great because I think this is the way it should be, multiple paths to the same end point that can broaden your horizons. And given the time limitations there’s only so much any presenter can cover in a limited amount of time.

That said, I realize that Rob Sewell is doing a full-day pre-con called Introduction to PowerShell. I’m curious what he’ll cover and both am jealous he has a full-day to do this and thankful I didn’t have to come up with a full-day’s worth of slides and scripts! That said, I know this will be a great one, so highly recommend you attend. I’ve seen Rob present at lest once before and it was great.

October 28th – 6:40 PM EDT

Get an email from Audrey at Pass Summit asking if I want to be part of a part of a live Q&A panel with Rob Sewell, Hamish Watson, Brandon Leach, and Ben Miller at 8:00 AM on the 11th. I have to think about this? There’s some big names on that panel and they want lil’ ol’ me?

October 28th – 6:41 PM EDT

Reply, “Hell yeah!”

October 29th – Over the course of the day

Folks at PASS realize the world is round and that we all live in different timezones and 8:00 AM may not be the best time for folks living Down-Under. Of course their first suggestion for a new time is even worse. Finally Hamish steps in, declares the entire world is in the Hamish Time Zone and that the original time is fine and he’ll let FutureHamish deal with the lack of sleep. Fair enough!

October 31st – Morning

My wife reminds me I’ll be out of the house at 8:00 AM on the 11th. I start to panic, but decide, “I can do it from the car with my cell phone.” So this is going to happen!

November 2nd – 2:00 PM

Tech check with Zoom and all to make sure things will work for next week. Learn a little more about how the recorded session will work. Still nervous for the “live from the car” presentation, but do the tech with the cell phone as my uplink and it works.

It’s getting real.

Today – November 3rd

It’s election day and just over a week from my presentations. I’m excited. I’ve made it clear to work I won’t be available at all on the 11th and not much on the other days. This is going to be a summit unlike any other. I’ going to have to remind myself to actually “attend” it.

And now, finish up a few things and go vote.

I’m voting today for my kids and my friends and my family, blood or chosen. I’ll be voting for the future and for hope.

Voting and Apple Pie – Two American Traditions!

A Speaker’s Timeline

This post will be short, for reasons that are hopefully obvious by the end.

Sometime in February

Hmm, I should put together some ideas to submit to present to SQL Summit in Houston (not Dallas as Mistress SQL pointed out to me) this year.

March 16th

An update, the call for speakers has been postponed. Darn.

March 23rd

Call for speakers is finally open!

March 30th

Submit 3 possible topics.

April 1st

Approach a fellow speaker about a possible joint session, but after discussion, decide not to go ahead with the idea.

June 3rd

Get an update, Summit will be virtual this year. Thankfully I didn’t book any tickets or hotel rooms in Dallas.

July 20th 6:49 PM EDT

Woohoo! I got the email! One of my submissions got selected to present!

July 20th 6:50 PM EDT

Crap, now I actually have to write the entire thing!

July 20th 6:51 PM EDT

Wait, and it’s going to be virtual too. That’s going to make it a bit more of a challenge to present. But I’m up to it!

Sometime in August

I really should get started. Hmm, here’s one of the scripts I want to present.

But honestly, I’m preparing to teach a bunch of cavers and medical students cave rescue, I need to concentrate on that first.

September 5th

I just biked over 100 miles. I’m certainly not working on my presentation THIS weekend.

Later in September

Ok, now I’m going to sit down and really work through this. Here’s a basic outline.

October 1st

Oh wait, it’s going to be virtual AND I have to prerecord it? How is that supposed to work? I had better read up at the speaker portal!

October 2nd

Huh, ok, that sorta makes sense, upload the slides, do a recording, but I still don’t get how it’ll work with a presentation like mine with lots of demos. Well I’ll figure it out.

October 6th around 11 PM EDT

Well the PowerPoint template deck they provided looks pretty slick. I should start prepping my slides.

October 6th, approximately 5 minutes later

There, got the first slide done. Of course it’s only my name and pronouns, etc. But it’s a start.

Oh and the 2nd slide is done, but that’s simply the default PASS slide talking about chapters, SQL Saturday etc, so technically I didn’t do anything there.

I’ll start working on the closing slides.

October 7th, sometime after midnight

Ok, about 5 slides done. I’ll like to myself and say I’ve made great progress!

October 9th, approximately 10:00 PM EDT

Ok, I’ll at least start writing out the scripts I need.

October 9th, 20 minutes later

What the bloody hell? Why is this script failing? I’ve got to present this. If I can’t get this script working how is anyone going to believe that I know PowerShell, let alone actually use it.

October 9th, 5 minutes later

Well, damn, that was an embarrassing mistake, just had the , in the wrong place

October 10th around 9:00 PM EDT

Hmm, to properly demo this, I really need to run against 3-4 SQL Servers and I really don’t want to spin up a bunch of VMS and I can’t use my development one, too much proprietary data there.

I know, NOW is a perfect time to start to learn to use Docker! Why not? And besides Cathrine Wilhemsen has a great post on it. I’ll simply follow that.

2 hours and 1 reboot later

Hey, would you look at that? I’ve actually got a docker container running SQL. This is awesome!

Another minute later

But why can’t I actually connect? What network is it on? Why did I decide docker was easier? Why did I even submit this proposal? What the heck am I doing here? What is the meaning of life?

5 more minutes

That’s it, I’m going to bed.

October 11th, late night

Oh, I get it it now, I didn’t setup a full separate network, it’s bridged and that’s why it’s showing 0.0.0.0. I just need to change the port and I’m good to go!

A minute later

This is pretty awesome. Not what I’d do for a production setup, but definitely works for my demos. Now if I were really smart, I’d also setup persistent storage and the like, but this is good enough. And honestly now, setup a loop, increment a variable and bam, I’ve got 4 instances of SQL running in docker, 2 are 2017 and 2 are 2019. This is really incredible. I’m proud of myself.

Oh and even better, I’m doing all this in a PowerShell script, so I can actually make it PART of my presentation!

October 12th 2:26 PM EDT

Send off an email to the Program folks at PASS asking about how the recording stuff works with demos. Eagerly awaiting a reply.

October 15th, another late night

Yes, there’s a theme here, much of my work is being done late at night. It seems to work for me. But dang that deadline is getting closer!

October 16th, late night, again

Watched some Schitt$ Creek with the family. “Why didn’t we start watching this sooner? It’s hilarious! But I need to work on my presentation some more.”

Get all the PowerShell scripts basically done. I’m happy with it, need to work on my speaking script some.

October 19th 3:00 PM EDT

Get off the phone with a fellow Cave Rescue expert. Just before I get off, I mention my upcoming virtual, prerecorded session I have to finish. He says, “Oh, you know I just did 2-3 of those for a rescue conference, exact same format. It worked out really well. I can send you some details and feedback.”

I find that reassuring.

Also recheck email, still no answer from the folks at PASS on my questions about demos, etc.

October 19th, guess what time

I’ve finished everything, even updated the slides and scripts a bit more. I’m a bit worried I’m going to run too long, but decide to do my first of several practice run throughs.

Do my first full run through. Stop and correct a few mistakes or rough edges here and there. I’m not too worried if I run over now since I know I’ve artificially added some time.

October 19th, 42 minutes later

I get done, look at the PowerPoint timer: 42 minutes. “CRAP! I need this to be 60 minutes!” I’m not too worried, I can add more, but I’m not sure where and I don’t want to simply add fluff for the sake of fluff. I need to give this some thought.

Later on October 19th

Talking to a friend of mine who among other things has a background in adult education. She doesn’t know SQL or PowerShell, but she’s a good sounding board and she’s going to sit through my next run-through, not so much for the technical details but to give feedback on the flow and perhaps suggestions on where I may be making too many assumptions on what my listeners will know.

October 20th Early Morning

It’s a Tuesday, time to blog. As always I face that question, what should I blog about?

“I know, I’ll blog about how I’m getting my presentation together and the deadline is fast approaching. I can’t be the only speaker that often finds themselves up against the deadline and panicking.”

Next 36 hours

Add a bit more content and run through it 2-3 more time and then… RECORD! (technically it looks like I have until the 26th to upload my recording, but I want to get done early).

Conclusion

The above may or may not be a wholly accurate timeline or description of the process I’ve gone through trying to get my presentation ready for Pass Virtual Summit. I may have elided a few details and over-hyped a few others, but in general it’s close to true and accurate. Despite my always best intentions, I find myself often working up close to the deadline for submissions. Since for Summit they want NEW presentations, I can’t simply dust-off one of my previous presentations and use that, so there’s definitely more work involved here.

And honestly up until I learned it was going to be prerecorded, I thought I’d have most of October to work on it. The deadline to get the slides and recordings submitted sort of threw my original timeline for working on it in the dumpster so I’m actually a bit further behind than I expected to be.

On the other hand, I really did learn to use Docker and I think that’s valuable and I am making that part of my presentation. And, when all is said and done, I think I’ll be happy with it. I think though like any good speaker, I’ll look back and think “well next time, I’ll have to improve this or that.” There’s always room for improvement. I’m not keen on giving it prerecorded. I value the instantaneous feedback I get from the audience. So that will be different. But I at least can elicit questions during the presentation and there’s a life Q&A afterwards. But, I’ll still be nervous.

I’m in awe of speakers who get their presentations all prepped and prepared months in advance, but I suspect there’s a number out there like me, that don’t operate that way. And I suspect there’s a few who are even more nervous than I thinking, “OMG, am I the only one in this spot?” Nope, you’re not. Or rather, “Please let me know I’m not the only one!”

See you all at Summit, at least virtually!

And in the meantime there’s another possible deadline coming up I need to think about…

#SQLFamily

I’ve mentioned this in the past and thought I’d write something quick about it today. The quick is because I’m lacking time, not because the topic isn’t important or worthy of exposition.

Anyone who has spent much time at any PASS events such as SQL Saturday or Pass Summit has an inkling of what #SQLFamily is.

At its base, it’s a group of professionals who all have SQL Server in common. That might be a start, but it’s hardly a good definition. It’s also:

  • Professional contacts
  • LOTS of people willing to give SQL help when you need to solve a problem
  • Folks that will fact check your blog or post
  • It’s the folks willing to step up for a User Group Meeting talk

And that might be enough, but that’s not all it’s also:

  • Someone who loves bicycling as much or more than me.
  • At least one amateur radio operator (and quite the ham in other ways at times)
  • Several with 3D printers making mask band holders and the like
  • Several that sing karaoke
  • Someone who makes more homemade pizza than I do
  • At least one with cute puppies she’s been known to have on her webinars

But, honestly, it doesn’t end there. In this time of Covid it’s been more.

  • It’s been the folks who I get together with on Friday’s for a long-distance social hour
  • It’s the ones I’ve been able to talk about fears of COVID and schooling and kids
  • It’s been the ones I’ve reached out to to make sure they’re ok
  • It’s been the ones that have checked in on me
  • It’s the folks that write blog posts, sometimes daily, about how to support others

In short it really is a family. We’re not together by blood but we still share our thoughts and feelings and support each other. And you know what, right now I’m extremely grateful for that family.

So to my #SQLFamily, if I haven’t said it enough, thank you for who you are and for being there, especially during this time of Covid. I know I’ve needed it. And I really appreciate it.

And I can’t wait to see you all in person again at some point.

P.S. – if you’re shy or don’t think you’re welcome in the family, don’t worry, you are welcome. Pop in, say hi, or even just reach out to one person and say hi or ask for an introduction.