Inside SQLSaturday – The Schedule

So in the previous post we discovered how each SQLSaturday gets sessions for their event; if you missed reading that, the short answer is that it is all up to the speakers in the #SQLCommunity.  Now we are going to figure out how schedules are made.

How many sessions do we choose?

Well, some events select every speaker and just build out a schedule from there. Some events use a different method; this is the most common way: # of predicted attendees /number of seats in a room = # of rooms needed, and then # of rooms * # of time slots = # of sessions needed. The second equation is used for smaller events that just have a set number of rooms available (this is also how events set attendance goals and registration limits for wait listing).

The selection process?

Now here is where things get tricky and different for each event. There is the goal of trying to fill a track; remember that each event picks tracks and as always they are at the mercy of speaker submissions. Some tracks like Professional Development and Other are generally not filled because we doubt attendees are spending their Saturday learning PD and other exclusively.

Some cities are fortunate and have both a regular SQLSaturday and a SQLSaturday Business Intelligence Edition. In this case, the regular event would still have BI Sessions, but it’s unlikely the BI edition would have regular sessions. An event’s attendance base will dictate the session topics and the quantity.  For instance, here in Nashville, there hasn’t yet been an big uptake on Azure, therefore we don’t go to crazy on those sessions.

Friends first?

Now, I will admit I am more than happy and very willing to pick my friends first. However it isn’t just like on the playground in grade school. This time it’s about trust and knowing someone has your back, is going to do everything they can to be there and not let you down. I’ve heard responses from several organizers that aren’t quite this bold but are very similar in sentiment. But, when you have done these events either as a speaker or an organizer for a while, how can you say everyone isn’t your friend?

Speaker Popularity

Honestly, organizer generally know which speakers are popular and they are great to have at your event. Local speakers are even on this popular list–attendees are very happy to see these folks.

Session difficulty level

Everyone wants to provide a good mix of sessions that will make everyone from beginners to seasoned professionals happy. But that isn’t always the easiest thing to do. Again, event organizers are at the mercy of speakers submitting sessions.

I’ve asked other organizers how they get through this process. Some start with a rating process with sessions or speakers and sometimes both. Some start by removing speakers that submitted even though they forgot they didn’t show up to that event in the past. Sometimes an event can’t afford to have more than x number of speakers, so to reduce the number of individual speakers, they ask some to present more than one session. Some gather the team and sit in a room until the section process is done.

Building the Schedule

First, speakers are offered a chooser for preferred time slot and most events try really hard to follow this preference. I’ll be honest, one year we had like 4 people say morning and everyone else said afternoon. When scheduling 50 sessions that doesn’t work out very well.

Venues

It sounds really odd, but venues play a big role into the schedule. Popular sessions will be well-attended so they need bigger rooms. Where the sponsors are located sometimes plays a role in where sessions are. For example, if session rooms are separated by the sponsor area it benefits the sponsors if tracks move from one side to the other during the day. This creates traffic flow through the area. Sorry for the extra steps everyone, but we need sponsors to be happy: they provide the funds that make these events happy.

Topics/Tracks

Organizers should try to spread topic/tracks out over the entire day. You shouldn’t have 4 the 5 BI sessions scheduled in the same two time slots; that just doesn’t make sense to attendees. One great option is to schedule similar topics but different difficulty levels at the same time.  Making sure that each time slot has a variety is the ultimate goal but again events are limited to sessions submitted by speakers.

Speakers

So, as a speaker who is married to another speaker, I really appreciate when we don’t speak at the same time. I mean, we are each other’s disaster recovery when it comes to hardware. Sometimes speakers can do an event but later find out they need to leave early to attend other obligations. Some speakers have work obligations so they prefer am/pm time slots. Some of us are just cranky in the morning. There were several events before we found our AWESOME dog sitter that we had to leave early to get home because we could only be gone one night. We organizers do their best to accommodate speakers and fill in a great schedule.

Lunch Sessions

This is crazy! Some events reserve lunch sessions to their topmost sponsors, and others just have sessions the whole day and serve lunch for an extended period of time (or have boxed lunch – grab and go to a session). Why so? Offering only top sponsors a lunch session increases the attendance for that session. Just handing out box lunches and sending everyone back to sessions gives attendees a greater opportunity for learning. Why have sessions during lunch at all? Well, evidence (experience of others) shows that if there isn’t a reason to stay, a lot of folks might leave for lunch and might not make it back.

About Nashville

WP_20161203_13_04_48_Rich

Sometimes I have help in selecting sessions; some years it’s just me, the basset hounds and my husband. We almost always ask for feedback on must-haves! The first round is picking speakers–local ones are nearly always in. The last several years we’ve had the sessions printed out on tabloid paper and then we cut them out. After that we sort them by track and narrow them into “IN”, “GOOD”, “MAYBE”, and 2nd/Alternate. We use last year’s schedule to prevent repeat sessions (we only consider repeat if by same speaker).  Now it’s time to play pin the session on the schedule.
Cyw-s0WWIAAmkEG.jpg large

Here are the numbers from last year’s event

# of Submissions # Selected Track
12 6 BI Analytics and Visualization
16 7 BI Architecture & Management
3 2 Cloud Database/Application Development & Deployment
45 20 Database & Application Development
51 25 Database Administration
6 2 Other
8 3 PowerShell
7 4 Professional Development
 Session Difficulty Level
54 30 Intermediate
6 3 Advanced
88 36 Beginner

Final thoughts

No matter how hard organizers try, things are never perfect. Events have to prepare the schedule early enough that speakers can make travel arrangements. But sometimes things come up and speakers need to cancel. Organizers try to fill a schedule with enough variety  to keep everyone in their community interested, but again, organizers are at the mercy of speakers! A lot of thought goes into each and every event, so remember to thank an organizer the next time you are at a SQLSaturday.

Inside SQLSaturday – Sessions

I had planned on titling this “Mommy, where do SQLSaturday Sessions come from?”; but since I already had this series going I thought I would stick to the proper format.

Speakers: Where do they come from?

Every SQLSaturday is hosted on the PASS SQLSaturday website. When an event goes live, there is generally a couple hours until some 2000+ emails are sent out to ALL folks that have ever presented at a SQLSaturday. Since these events can go live anywhere from 6 months to 180 days before the event it is hard sometimes for speakers to remember when an event is. This also means that we get emails for EVERY . . . → Read More: Inside SQLSaturday – Sessions

Inside SQLSaturday – Who and How

So it has become obvious over the years that attendees are pretty much in the dark when it comes to the inner workings of a SQLSaturday event. I am going to work on this series again only this time for attendees. We’ve started the process of organizing SQLSatNash 2018 so it’s a good time to write as we go through the process. Today I want to fill in the blanks of WHO and HOW.

WHO?

Have you ever wondered who organizes a SQLSaturday event? How they got that job? Well every event has a different who and there is no one from Pass directly involved with an event. Pass provides . . . → Read More: Inside SQLSaturday – Who and How

Lifestyle, no one is wrong

Here I am talking about beliefs again. But damn it, it is really bothering me. Everyone makes choices for their lifestyle and their work-life-balance, it’s okay we don’t have to all be the same because that would be boring. But let’s be honest everyone has an opinion, some folks do make what is considered bad choices on a regular basis and we all do make mistakes. This doesn’t make anyone better than anyone else. This doesn’t make it okay for you to dismiss what others might feel/want or need.

Children are great and many choose to have them. They might also have a lifestyle of running kids to sports, practice, . . . → Read More: Lifestyle, no one is wrong

Hearing the truth

It has become so obvious to me lately that people have a hard time getting past their beliefs. In a conversation recently someone said “No one tells the truth anymore.” For a few days I pondered this and decided that there are people who do tell the truth but their beliefs are so loud that they can’t hear it. Think about it:

“Your beliefs are so loud that you can’t hear the truth.”

After having some time to think about this even further I can see this happening all over the place. Adults who act like children when it comes to food and food choices. I was a very picky . . . → Read More: Hearing the truth

Disaster Recovery for Speakers

I have seen a few comments and remarks being thrown around about speakers doing a bad job because a demo failed or a machined crashed when getting plugged into a display adapter. I wonder why these IT professionals making said remarks still have day jobs, I mean clearly they are 100% awesome and everything always works. Surely they have more important things to do. PFFFT!

So I recently blogged about melting down and losing a machine. I had my slides & my data all backed up on OneDrive or still in email. So there was really only getting everything together and having the NEW MACHINE ready to present. That only . . . → Read More: Disaster Recovery for Speakers

Indianapolis, United States

Well here we are it’s August already. I have been slow to start on SQLSaturday events and have IMO missed some great ones. Hopefully next year will come easier.

I am traveling to my home state of Indiana to present at #SQLSatIndy on August 12. I will be doing my new presentation “Reduce your DBA (& DEV) task list by using Microsoft BI tools” just before lunch. I am evolving this session as I go along, trying to incorporate ideas the class comes up with.

Hope and John do an awesome job for this event. This year they have brought back their beginner track. This track is open to anyone . . . → Read More: Indianapolis, United States

Melting Down

I am here to tell you that it is okay to have a melt down and it’s okay to talk about it. I also want to let you know that if you ever find yourself in this position and need a shoulder to lean on, an ear to listen that I am here for you.

As some of you may know flying isn’t always easy for me, I get anxiety. I do a good job of handling it but some days anxiety is a cruel beast that wins and completely makes no sense at all. Last week I was home alone all week, this is the first time I’ve stayed . . . → Read More: Melting Down

Columbus, United States here I come

Yes folks for the second year in a row I will be traveling to COLUMBUS OHIO for #SQLSat653. I am really excited to be visiting them again this year.

If this is your first visit to Columbus I have to recommend you visit the zoo. It is an awesome zoo with a lot of walking but most of it is shaded by natural walkways. Do it!

If you are new here SQLSaturday is a one day free training event for data professionals. These events are organized by volunteers and the speakers pay their own way. It is a great opportunity to get a day full of free #sqllearning and . . . → Read More: Columbus, United States here I come

Chattanooga here I come!

I am so honored to be speaking at SQLSaturday Chattanooga again this year. This is going to be a great trip! Sadly it is my first speaking event this year, we were a little side tracked with other things. We will be traveling from Arrington with Dean, Stacia, Tess, Cricket and Mimi. In a shocking twist we are not leaving early but we are staying late! Yup not leaving till Monday morning. We need to figure something out to do Sunday, but I am sure we will manage.

So what am I presenting on? Uh….well it’s a new session. Much like my 45 minutes till your first SSRS report, this . . . → Read More: Chattanooga here I come!