Category: Blog

  • One Thousand SQL Saturdays (*ish)

    This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule, with lots of neat sessions. I’ll be speaking in the am, and am happy to be a part of this event.

    When this appeared on the schedule early this year, I started making plans and leaving space in my schedule for this event. When the pandemic hit, I had hopes that we might be back to events by now, but sadly, that’s not the case.

    Still, it’s the 1000th SQL Saturday scheduled, and I’m thrilled that we’ve gotten here. From 2007 and SQL Saturday #1 in Orlando to #1000 in Oregon, it’s been an amazing ride.

    You can register and watch this weekend if you aren’t tired of online video.

  • Daily Coping 22 Oct 2020

    I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here.

    Today’s tip is to write down 3 specific things that have gone well recently.

    First, I got to see my Mom. It’s been too long, but earlier this week I flew to the East Coast, drove to her town, and got to visit with her.

    Second, I’m coaching and we managed to compete in a few tournaments lately, winning more than losing. The important thing that went well was that we managed to get a tournament completed without health issues during this pandemic.

    Third, I’m back to weekly massages and they’re going well. Masks on, but it’s good to be adding in things that I enjoy and that support others locally.

  • My Recording Experience for the #PASSSummit

    I wrote a post about the online recording, which wouldn’t work for me. This post looks at the live recording for me, giving you my process and time.

    This doesn’t cover the building the deck, setting up demos, or practice time. That’s the same for every presentation for me.

    First Take

    The first take was a mess, since I didn’t have some things set up or my hair combed, and I mangled the opening slide, so after 2 minutes, I just abandoned it.

    Second Take

    This was really a live practice for me, mostly to tech check and get timing down. It’s always different when you do it live. I didn’t bother getting my shirt, so this was at the end of a normal workday.

    I had some Internet issues, so I couldn’t keep this anyway, but it was annoying to get some missing pages, and delays in refreshing. I had to refresh in Azure DevOps a few times to get the site to come up. I use microwave Internet, so if the air is bad things can be slow or drop. With a fire near Denver, that was happening, but you should be glad here that if you have Internet issues, which could happen in the convention center, you couldn’t rerecord.

    My timing was long as well, about 5 minutes over, so I took a few notes to help me get better for the next time.

    I did load this into Camtasia and check the sound and view. I also wanted to play with splitting the camera track and having it visible sometimes and not others. Easy to do, and I need to remember that I’ll watch this whole thing, plus render it, so I need to account for probably a 3 hour process.

    Third Take

    A day later, I had some time, so I set thing up, reset my demo, and started to record. Overall this was one take, but two pauses, so my recommendation is that you know where the pause button is on your recorder.

    1. I forgot to pre-stage one item in the demo, and realized it, so at the end of a slide, I paused, staged an item, and restarted. Pausing at the end lets me move to the next slide and start more naturally.

    2. I had to sneeze, so I stopped talking and quickly hit pause.

    Editing

    Camtasia does a picture in picture when you record with the camera, which is what I wanted. However, I didn’t want to have that up the whole time. I wanted a larger insert, and then at times, to hide it.

    This is easy, so as I watched for issues, I would pause, split the camera feed, and either resize it or move it out of the way. Took maybe 5 minutes on top of the 53:00 to watch my recording.

    Uploading

    Once things were done, I looked again and then uploaded it. My file was 688MB, more than a CD! I started the upload, and I initially got about 2.5M/sec, and the upload noted that this would take 5 minutes or so. That didn’t see right to me.

    The upload somewhat froze in the pop up window with 3:57 left, and stayed that way for a few minutes, with 11% done. However, at about 4:45 total, the window closed itself and I got a confirmation email that the session had been uploaded.

    Watch the Details

    My task was noted as completed on the main page when I first went here.

    2020-10-19 08_36_25-Conference Harvester - PASS Virtual Summit 2020

    Even if I click the Upload Video link, I see this:

    2020-10-19 08_37_09-Conference Harvester 2.0 - PASS Virtual Summit 2020

    I had only uploaded one video at this point, so this interface doesn’t properly handle multiple sessions. If I wasn’t careful, I’d think I’d already uploaded everything. Since I’ve only recorded 2, this isn’t right.

    If I return to the  main page and click “Preview Uploads”, I see this.

    2020-10-19 08_35_53-Conference Harvester - PASS Virtual Summit 2020

    Two are uploaded, and the task isn’t really completed. I wish there were some yellow indicator for partial completion here.

    I did go into the “Record video” for another session, and there I can mark the item as an upload.

    2020-10-19 08_41_57-PASS Virtual Summit 2020

    This gives me a better view of what I’ve done.

    2020-10-19 08_42_40-Conference Harvester 2.0 - PASS Virtual Summit 2020

    Pay attention to what you’re doing. This is a good set of tools in one sense, but a little incomplete, and slightly misleading. A few things to improve:

    • Details for slide uploads, consistent with the video recording
    • Upload video doesn’t properly show status
    • Status for partial completion.

    The slide details do show in in that page, but I have to walk through each section to double check. Do that. We want to look good at the event, and part of this is speakers doing a good job of checking their work.

  • Daily Coping 21 Oct 2020

    I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here.

    Today’s tip is to find the joy in completing a task you’ve put off for some time.

    I recently replaced some baseboard trim boards in a room where we had wood flooring put in this summer. I got the boards up, but they needed caulking and a bit of touch up paint to finish off those rooms. It’s been nagging at me, so I bought some caulk and spent a few hours working my way around, slowly getting the finishing touches done.