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.

Posted in Blog | Tagged , | 2 Comments

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.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 21 Oct 2020

Adding a Check Constraint to a Table–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I had to do this the other day, and while I guessed at the syntax, I wasn’t sure of it, so I thought this would be a good post.

The Check Constraint docs are good, and a quick search got me over there.

I was trying to add a column to a table that has a domain of values. In my case, I was aiming for something like this:

CREATE TABLE MyTable (somekey int, result tinyint)

The result value can be 0-4, and while front end validation can handle this, it’s easy to get lazy and assume they will. It’s easy for someone to forget, or use an application like SSMS or Access to edit data, or more.

Add a constraint. It will help with data quality.

My thought was to do this:

CREATE TABLE MyTable (somekey int,
result tinyint check result <= 4)

That actually is fine, and it’s almost what the docs show. After my column, I include the CHECK keyword, and then I can give the expression. The problem with this code is that I need to parenthesis added, like this:

CREATE TABLE MyTable (somekey int,
result tinyint (check result <= 4)
)

 

SQLNewBlogger

This was a 5 minute post, showing something I thought I knew, had to check, and then corrected. A good case of how I am improving skills.

Write a post like this for something you did in your job.

Posted in Blog | Tagged , , | Comments Off on Adding a Check Constraint to a Table–#SQLNewBlogger

In the Air

I’m taking the rest of the week off. I get on a plane today to go spend the week on the East Coast of the US, going to see family. I’m looking forward to the trip, and I’m not worried.

This will be an interesting time, and I’m looking forward to seeing how things go, what might have changed for flying, and how I feel, emotionally, about flying.

Posted in Blog | Tagged | 1 Comment