PA School: Learning and Teaching

There’s a time when you’re whitewater boating where you’re just above the rapids, trying to figure out the line you want to take. The water around you is calm, but you know eventually you’ll be in rapids and at that point you’ll have hopefully picked out that line because it can be very hard, downright dangerous to change your line through the rapids once among them.

I’ve left that area just above the rapids and now I’m in them. So far the line I’ve picked to navigate the rapids appears to be working. I’ve got some Class III maybe some Class IV rapids ahead, but I’ve navigated one class III already and just passed some Class II rapids and the boat is still upright with me in it.

I am of course talking about my first semester of PA school so far. I mentioned in a previous post about trying to figure out where the return on benefits for studying is for each class. At some point doing more studying one topic won’t make that much of a change to my grade so I spend that time on a different topic. So far, based on my last few test, I think I’ve hit that mark. Yeah, I could get a marginally better grade on a few of the tests, but I’d have to steal the time from elsewhere.

At the start of the semester they mentioned there were some Grad Assistant (GA) positions available that included a stipend. One of the positions is to lead what they call Study Sessions. I applied for that position and I’m one of 3 in my cohort at this campus (we have 3 counterparts in Glenside) get the position. While they’re called Study Sessions, they’re more accurately (and I’m working to get the name changed) Student Led Review sessions. The idea is that for a particular upcoming exam one of us will work with our counterpart at the other campus and develop a slide deck of practice questions covering objectives that we feel are critical for us and our peers to understand for the next exam. We submit our deck to the course professors for review. After they’ve signed off on it, then we use a tool called “Pear Deck” to make it into an interactive slide show that students can run on their computer to submit answers to the questions while we can then show the results. It’s pretty cool.

The first three Study Sessions were run by professors. I was the first GA at my campus to run a student led one. From the feedback I received, it went really well. This was good to hear. There are several reasons I signed up for the GA position. The stipend, while minor was among them, but a small reason. Another was because, as many of my readers are probably aware, I love to teach. So being in front of a classroom, especially of my peers, is something I enjoy. But there was also a final, somewhat selfish reason for signing up: I can’t teach what I don’t know.

Now, to be fair, the topic for the first lecture was Genetics. I had taken an entire course in this as one of my pre-reqs and as a result found the objectives covered to be pretty much review. That certainly helped me in preparing the slide deck, but even then I found myself referring to my notes and the lecture notes to confirm I really understood a specific point. Nothing would be more embarrassing than asking a question and then confidently telling the students the wrong answer!

The next topic I will be covering is Cardio-physiology and pathophysiology. I have not taken a class in this specifically in the past, but some I learned previously in my undergrad A&P and some from working in the ED. But there’s definitely some I need to review before I present.

I have one or two more opportunities to present more during this semester. I’ll decide in the next 48 hours what I will end up doing.

But that’s it for now. So far it appears I’m putting in about the right amount of effort for the grades I want to get and I’m helping my fellow students review for particular exams so we can all do the best we possibly can.

And I’m still loving it!

Social !Distancing

As some of my #SQFamily knows, Mike Walsh has been hosting a Friday afternoon Zoom “social hour”. It’s a chance for all of us who are social distancing to hang out, chat and basically socialize.

This past Friday, and then Monday night was a real reminder of how much I love my #sqlfamily.  Earlier in the day, my client asked me to come up with a script to back up some SSAS databases. A bit surprising to me, there isn’t the robust built-in support for this like there are for the normal databases. No problem some googling quickly brought me to an article on how to do it using PowerShell by Jana Sattainathan. Now as any of my readers know, I’m a huge fan of PowerShell, so this was a great solution. I had to tweak it a bit for my needs, but not much.  So I was already happy that someone else had done the work for me. For one thing it meant I could finish my day a bit earlier and get on the Zoom call with #SQLFamily.

Well, what do you know, but during the call as we’re talking Kevin Hill happens to mention he’s having trouble with a script to backup SSAS databases. I immediately chimed in, “hey, I’ve got a working script, let me email it to you!”  Ten minutes later he was up and running and contacted me back. Turns out he had found the same article by Jana but got hung up on the fact Get-ChildItem there needs DEFAULT for the $instancename when dealing with the default instance. As most of my readers would understand, usually if you’re referring to the default instance, you don’t need to explicitly reference it. I had encountered this issue writing one of my first articles for RedGate.

So I’d like to say I solved Kevin’s problem, but truth is it really goes back to Jana.

Meanwhile on the call, there was a discussion of the work being done by #SQLFamily for the @FoldingatHome project, being led by Glen Berry I believe. Others, led by Tim Radney are printing clips to help hold N95 masks on. (If I’m leaving out folks or getting names or credit wrong, please let me know).

Monday night we hosted our local SQL Server User Group meeting, but virtually. We had between 9-12 people on line at any time, which is not bad considering that’s about 1/2 of what we usually have in person. We had no specific topic, other than simply catching up on each other and how folks were dealing with the current crisis. Meanwhile I learned of at least one other virtual User Group meeting going on. Our #SQLFamily is still finding a way to share knowledge at this time.

So for all these reasons, I love my #SQLFamily (but still insist they stay at least 6′ away for now!)

‘Tis Better to Give than Receive

My family complains that I’m hard to buy gifts for, and I have to admit, I suppose they’re right. Things I want, I’m likely to buy for myself. And honestly, I’d rather give than receive.  But sometimes, it’s two way street:

CASSUG

This is the local Capital Area SQL Server User Group I head up. I haven’t added up the number hours a year I spend on this, but I wouldn’t be surprised if it’s in the triple digits. And I don’t get paid. It’s all volunteer.  Now that’s not to say I don’t get something tangible out of it, I do get to attend PASS Summit every year at no cost. But that’s not the only reason I do it. I do it for #sqlfamily.  I’ve mentioned them before, but let’s just say, that the help and advice I’ve received from them is amazing. It’s made me a far better DBA.  So I give a lot, but get a lot more in return. Thanks #sqlfamily.

NCRC

If I give a lot of time to CASSUG, I give even more time to the National Cave Rescue Commission. In a normal year, I will teach at least one 2-day OCR and a Weeklong. To be clear, a “week-long” for instructors typically means arriving sometime on a Thursday and working 14-15 hours days until the following Saturday. I’m planning the 2020 Weeklong, which means I will spend far more hours than usual doing work for the NCRC. I also am a Regional Coordinator, which means meetings with my fellow coordinators as well as working with local resources.  Now I’ll admit, there’s an additional reason I do this. I figure if I ever get stuck, I want some trained folks out there.

RPI Outing Club

I still work with the RPI Outing Club, mostly on caving, because it gave me so much I want to give back. That and being around young people does make me feel younger.

Blood (and more)

This and the holiday tomorrow is what prompted this post. I give blood pretty much as often as I can.  It literally is the gift of life. I figure I’ve got plenty and I can make more. I’m partly inspired by a childhood friend who had a rare platelet diseases and needed multiple transfusions. I was too young to give then, but I figure I’ve more than made up for it since then.

I’m also a registered bone-marrow recipient and a certain friend knows, if the time comes and I’m a match, she’s got dibs on one of my kidneys.

My Family

I’ll admit, I thought twice about putting this down. Not because I don’t love giving them things, but because I figure it’s sort of my job. But I’ll admit, I take enormous satisfaction at times at sitting back and seeing the smiles on their faces and knowing that I had a role in that. And ultimately, they’re the most important to me. And for everything I’ve given them, they’ve given back to me 10x.

What do I want?

Now, I know I’m not on the gift list of most of my readers. So I don’t expect anything, but I’ll say what I want. Be kind. Give time. Give your skills to another. To quote Whitman:

Oh me! Oh life! of the questions of these recurring,
Of the endless trains of the faithless, of cities fill’d with the foolish,
Of myself forever reproaching myself, (for who more foolish than I, and who more faithless?)
Of eyes that vainly crave the light, of the objects mean, of the struggle ever renew’d,
Of the poor results of all, of the plodding and sordid crowds I see around me,
Of the empty and useless years of the rest, with the rest me intertwined,
The question, O me! so sad, recurring—What good amid these, O me, O life?

Answer.
That you are here—that life exists and identity,
That the powerful play goes on, and you may contribute a verse.

What will your verse be in this holiday season?