SQL Server, PASS, and other data mishaps
Posts tagged Community
What I’m doing to evolve the Program Committee next
Aug 27th
Since I wrote about how we’ve been evolving the Program Committee in the past, I thought Id write about some of the ways we’re trying to change the Program Committee in the future.
But first, I want to clarify something that someone else pointed out to me. When I write about the Program Committee, I always say “We”. When working on something as complex as the program for the summit, it is necessary to work as a very cohesive team. This leadership team I am a part of is who makes all of the tactical decisions about the way we manage the education at the Summit. I always refer to “us” as “we” because I cannot (and will not) take all of the credit for putting the Summit education together. Without the team, the committee wouldn’t be half of what it is. While I have been the overarching member of this team (the 1 they cant seem to run off) , the others are always there when we have work to do. Well, except Jeremiah, He’s got this new gig where he’s a turtle hunter or something….
We’ve been working hard over the last 2 years to bring some exciting (well, exciting to me anyway) changes to the program committee. A couple of these changes you should start seeing official announcements about any day now but, I decided to be a tease…
- We’re going to be opening another limited call for speakers for a new session type
- There are 2 new session types coming (well, 1 is a bit old but, its new & shiney)
Some additional thoughts I have about evolving this process are in no particular order
- Expand the use of Community Choice Sessions to include pre/post conferences(1 or maybe more), Id love to even be able to give those who vote for the precon that is selected a discount code to use on that precon.
- have a separate speaker review team that will rate/rank speakers across all tracks and sessions, so we can cut down on the differing ratings per speaker.
- Allow that team to reject speakers without considering abstracts if they dont meet some predefined criteria (no exact ideas on those criteria yet)
- Have a Virtual Chapter sponsored session category. The initial idea is if a VC is active, (say has XX events a year) we allot them 1 speaker slot that they can then award to one of their best speakers (as they see fit within some reasonable framework).
- Use the session evaluation tool for all PASS events (local, chapter, sqlsat, summit, rally)
- Expand the feedback for speakers when we dont accept their presentation at the Summit. Allow the review teams to leave free form comments, as well as a standardized reasons we’re using now
If you believe in these changes and you like how I communicate them, consider voting for me. I’m running for the PASS Board of Directors, and I need your help to make a difference. Click here to read about why I’m running.
The long evolution of the PASS Program Committee
Aug 23rd
It all had to begin somewhere
I joined the Program Committee in late 2006; I spent the first 2 years working on the DBA track teams selecting abstracts. I have spent a good deal of time working on the technology (vendors) of the Summit (the software we use to manage speakers, room assignments, itinerary planner, etc.). After going through several demo’s and actually attempting to use two different software packages, I started pushing for PASS to build our own software. We are paying a (small) fortune for what we use now, the only reason I can figure is that its much more robust than what we need for PASS. Last year I worked with PASSHQ to put together a project plan for PASS to build a new technology platform to manage the Summit. This year David with PASS HQ has started delivering on parts of the software. Once this is in place and we’re not changing software every year/other year, we should be able to focus more on the process, and less on the new software.
Prior to last year, Pre/post conference sessions (AKA precons) and Spotlight sessions were 100% invite only, and the guidelines for who was allowed to present these sessions was never published outside of the committee. Beginning with last year, we worked to publish guidelines for who was eligible to present precon sessions. In publishing the requirements list for who could present an all day precon session we opened up the call for precons to include anyone who met the requirements. At the same time we opened up spotlight invitations to competition, where we invited more speakers than we had slots for in hopes of raising the caliber of these sessions. We also began using an easy to understand formula for who gets invited to present spotlight sessions.
In this same time frame we reached out to many experts and asked for help developing a speaker resource page. Prior to this there was no real information on PASS’s website documenting what it takes to write good abstracts, or get selected as a speaker. We have pulled together quite a few resources to help develop speakers, including webcasts and sample abstracts, etc.
Growing bigger better speakers
I have blogged quite a bit about growing the pool of speakers and we have made some very good steps in the right direction in this space. There were two fundamental changes I worked into the program committee. The first was adding a “speaker bureau” option to the speakers contract. This will allow PASS (where the speakers agreed) to hand off speaker info and abstracts to the local chapters that the speakers are near, which will hopefully facilitate some interaction between the chapter leaders and some local aspiring speakers they may not know about. There is still work to do to build and enrich the process around this sharing of information back out to the chapters but the first (most important) step has been taken. I also worked it into the summit speaker contracts that we would release aggregate scores to the other speakers presenting so they could know where they stood compared to their peers. This was decided as a good first step in open conversations generated by the discussion in this post
Lots of internal Changes
This year a few things changed internally within the program committee, I separated the BI tracks review teams to match the fact that we now have 2 BI tracks, I also added an extra person to the DBA track team because, well, their workload increases every year and they could use some additional help. I created a true team of 3 to review precons and spotlights instead of the mgmt group doing that work. But, by far for me the largest change was getting Lori Edwards involved in the leadership of the program committee. Initially the idea was for her to get a team of task based volunteers who could work on some of the extra technology that the Program committee needed in order to work more effectively. The first thing I handed her was to take the monstrosity of an excel spreadsheet I had containing every speakers session evaluation since 2005 (when I first got a copy) and make it into a proper database, and get some reporting from it. After some discussions, we decided to build this as a system to hold ALL speaker evals for PASS or SQL Saturday, or actually ANY SQL presentation, the idea is when its finished if you have a speaker at any SQL event you can accept online evaluations and the speakers will get better feedback in one place. In addition, the organizers of PASS events will have better information as well. This task is still in process, but the first deliverable was a standard report of speakers and their evaluation scores and this was available for this years Program committee. Somewhere along the way, Lori became more and more involved with all of the bits and pieces of what it takes to run the program committee. Her involvement in these things has enabled me to reach out and not just do the same old thing for the Summit this year.
More evolution
This year I continued to push to evolve the program committee in several ways. One of the changes most visible to PASS membership was the Community Choice Sessions. Like all great ideas I’m not exactly sure where this idea was born, but I worked with people across the PASS organization to get this done. I wrote about the process a couple of times as it was coming into being. After involving over 1100 members, I would say this was a great success for PASS, myself and the Program group.
We are planning on taking the evaluation system that Lori and her team are working on and put it into use for the first time at this years Summit. In doing so we have planned to offer a new type of session that I’ve written about before. This will be what we’re tentatively calling “best of sessions” where we take the session with the highest evaluation on Tuesday and ask that speaker to present the same session on Wednesday, repeating the same process for those who speak on Wednesday, asking them to present the same session again on Thursday. This should allow the BEST content at the summit to be seen by the most attendees.
It hasn’t been all fun and games
This evolution and opening of the program process hasn’t been all BACON and index seeks, there has been more than one change on this list that have caused many questions, and in some cases very involved discussions. We haven’t always gotten everything right, but heck I’m happy that I can say I think we got it mostly right. There is always room for improvement and more to do to continue to evolve these processes,
If you believe in these changes and you like how I communicate them, consider voting for me. I’m running for the PASS Board of Directors, and I need your help to make a difference. Click here to read about why I’m running.
More on PASS Summit Community Choice sessions & a general PASS update
Jul 30th
More on PASS Summit Community Choice sessions
Last week I posted about letting the PASS membership select 4 of the Community sessions to be presented at this year’s North American Summit. As with most things I’ve touched lately, the devil is in the details. I have been working with PASS HQ quite a lot to get this process all ironed out. As of today, We are expecting the emails with all of the details to go out in the first part of next week. One of the last minute *details* we’ve had to account for is related to asking community members to vote in the 4 different categories, it turns out we aren’t able to require it to work that way. The short reason why is because of the way the PASS voting solution is designed (remember, its actually designed for voting in the upcoming BOD election) We cant have 4 separate categories and allow you to vote only in 1 each. While we are still separating the sessions into categories and asking you to vote on each one separately, we wont be able to enforce it. As it turns out, its not that big of a change and even if our members choose to cast their votes all in the same category, their votes will simply be cancelled out since we are going to choose the highest vote getter in each of the categories. So start watching those email boxes for more detailed information!
Other PASS goodness
Summit Selection Process follow-up meetings, since shortly after the community selection process finished, I have been on phone conferences with the selection teams for feedback about the entire selection process. These meetings have been going great, and overall the feedback was extremely positive, both about the process and the volunteer experience in general. That’s not to say the team members weren’t critical of a few hiccups we experienced but overall it was good. In these meetings nothing was off-limits, and I got some GREAT new ideas that should really improve a few of the key procedural pieces of the process. Many of the technological limitations and issues we knew about going into the selection but, with all the timelines, we just couldn’t get changes made quick enough. Since PASS is building a summit management tool for 2011, we should have many of those technology issues behind us for the start of next year’s selection process. All in all, It always helps us to get feedback about the selection as soon as its over while its still fresh in everyone’s minds. the #1 piece of feedback that kept recurring is: Communication is key. What I have taken from this is that even if you think everyone’s on the same page, its often ok to ask again if there are any questions, better safe than sorry.
Microsoft Speaker selections, Ive been doing this for the last 4 years and this year was the first year where I felt like we (the community team) have been actively engaged with the Microsoft Selection process, we’re still trying to figure out how all the different pieces fit together and where we can add value and community feedback into their processes. So far things are working better than I expected but not as good as I’d like. Seems to be the story of my life these days!!! All of this is great news for the community since it will produce a better Summit but, its been bad news for myself and the other volunteers working on it. For me, being the pseudo ring leader, Its just 1 more thing added to an already full plate this time of year. From the day the call to speakers is announced to the date the summit actually starts, is when things get pretty hectic with the Program Committee, there are always a few “regularly scheduled items” that have to be completed by certain deadlines not to mention the things that go BOOM. The regular scheduled stuff isnt a big deal, the BOOM’s on the other hand, lets just say Disaster Recovery planning isn’t just for Databases or Computers, it is valuable in most any important process.
SQL Saturday 35 Recap
May 26th
I made my way to Dallas to take part in the SQL Saturday #35 that the NTSSUG was sponsoring. After reading the excellent reviews from Jonathan Gardner, AJ Mendo, and Bill Fellows. I thought Id keep this very short and say “I concur!” –Profound aint it?
Ok, Ill dig a little deeper–
I saw some great Sessions, met some great people, and caught up with some old friends. All In all a great way to spend a Saturday!
Having had more than a little experience with putting on large SQL events, I think the volunteers and organizers of the event really need to pat themselves on the back, they pulled off a wonderful event and did it with style. In my opinion, one of the best measures of success when trying to tell how well an event “worked” is to gauge what the event looked like to a normal attendee. By that measure Id say the even the toughest critic would say it was a resounding success. Everything looked buttery smooth, and this “normal attendee” didnt see any obvious distractions. It looks like the SQL Saturday model appears to be maturing at a very rapid pace, and this is excellent news! In talking with the organizers at the after party, they were relaying some of their more interesting challenges, I’m not sure I said it at the time (maybe too many beers??) so Ill repeat it here for posterity: I hope the organizers aren’t too hard on themselves because no matter what level of prep, thought, or organization you put into an event, something is ALWAYS going to slip through the cracks and/or not work quite as expected. How these “challenges” opportunities are handled is what separates the avg from the great, and in this case everything was great.
1 general observation I do have –> The after party of the event was, as usual, one of the great benefits of this event and I made plenty of contact with others at Humperdinks and while it was obvious that a few of the speakers, and a most of the volunteers showed up, I suspect I was one of less than 10 “regular” attendees that attended. This is a tragic situation and something that we in the SQL Community need to figure out how to increase participation. The information&contact info gained from the social pieces of community events is an aspect that most attendees are obviously overlooking. I’ve often wondered if it was apathy or just lack of communication about these events and this time it was obviously not communication, It was pretty tough for anyone to overlook the after party event at #sqlsat35, I saw the after party mentioned in at least 3 different places in the guide book, not to mention verbally at the closing reception. I’m not sure how we can encourage people to attend these events but, they are a core part of the “connect” piece of the equation.
PASS Summit Call for Speakers Now Open or “enter now for your chance to win!”
May 14th
Hey, I bet you’ve heard by now that the PASS Call for speakers is now open.
No matter what your skill level as a public speaker, I would encourage you to submit an abstract. Even if you think you’re not good enough or don’t have enough speaking experience, go ahead and submit an abstract. It may be your lucky day and your abstract will be selected, at worst it will be practice in the art of composing a good abstract.
Why will this be good experience? After looking through thousands of abstract submissions for years I’ve decided that composing a good abstract is an art. It requires equal parts black magic and pixie dust to make a good abstract, and even when you have that it takes a bit of luck to get it accepted at a national conference.
In order to help potential speakers understand why their abstracts weren’t selected, last year I asked the review teams to tag each unaccepted abstract with a reason that it couldn’t be accepted. As you might expect this created quite a bit of extra work for the teams but, for new speakers there should be good value in knowing whether the reason for no selection was the competition, a poor abstract, lack of interest in the topic, or some other reason noted. The system isn’t perfect by any means because we don’t have the means to provide a detailed reason for no selection but, hopefully its useful.
One final reason I think everyone reading this should submit an abstract—> if during the submission process you select the “speaker bureau” checkbox, your info will be used by other PASS events needing speakers so you will have more potential exposure that will help you get the experience needed to speak at the Summit.
Important pages I would use if I were submitting an abstract to ANY SQL related event
I love examples, and learning from examples is what works for me so the currently submitted abstract list is a wonderful resource for learning how to write an abstract, not to mention scoping out the competition http://sqlpass.eventpoint.com/submittedsessions
The definition page – Obviously you cant submit a session if you don’t know the rules http://sqlpass.eventpoint.com/Definitions
Pre/Post Conference prerequisites – Already an expert? ready to present a full day and get the recognition you deserve? this one is for you http://www.sqlpass.org/Community/SpeakerResource/PrePostConferencePrerequisites.aspx
Understanding the selection process – Want to know how your abstract will be evaluated? This is the place! http://www.sqlpass.org/Community/SpeakerResource/AbstractSelectionProcess.aspx
The speaker resource page – lots of good info here, don’t be afraid to dig around http://www.sqlpass.org/Community/SpeakerResource.aspx