SQL Server, PASS, and other data mishaps
Posts tagged update
Please PASS the Awesomesauce
Sep 24th
Recently, the 3 of you that read this stream of (un)consciousness may have noticed a lot of posts about PASS and the Board of Directors elections. I was pleasantly surprised to see the news last Friday that I had indeed been elected to a 2 year term on the PASS board.
I’d like to start by thanking everyone who voted, even if you chose not to vote for me. We need more community involvement in all things PASS, and voting is a very important part of that!
This election was not without its fair share of controversy and while overall it was a difficult process for the community to go through, I think a lot of good can result from it. I hope that everyone who had an opinion about the “process” stays involved. Staying involved & interested is the easiest way the community can shape the future of the organization.
I’m very excited to have the opportunity to serve the SQL Server Community in a larger role than in the past. As always, if you’ve got ideas feel free to send em to me. I cant make any promises except that I will read and respond but, Im a fan of stealing borrowing others ideas for PASS and making them happen.
Other recent PASS info
Weve had a literal whirlwind of activity in the program committee leadership in the last month+ So, I thought I’d list some of the stuff thats been happening
Some highlights
- We gathered a large group of volunteers to proofread abstracts before publishing in the program guide
- Also, we hammered out all the details for 3 new session types for the Summit : Chalk talk sessions, Best of sessions, and lightning sessions
- Published a Session preferencing tool to help us build a good schedule (awesome data gathered here!!)
- We built the summit schedule – this is always fun, if you have any complaints, its on me
- We gathered a team of volunteers to review session powerpoints so I wont be doing them alone on the last day (YAY!) in doing this we updated the review guidelines to be more relevant/current
- I had hoped we would nail down the Microsoft speakers & sessions a little better (earlier) this year but, it seems like we’ve been getting more changes & cancellations than Id have liked.
- We worked on Coordinated with VC’s & pre/postconference speakers to try and setup livemeeting previews of their sessions — Marketing & free community education –thats like Bacon wrapped Bacon Win-Win!
- Lots of discussions with our Summit software vendor about availability of ppt updates, demos, etc during the summit. Updates soon
Upcoming releases
- The Summit Schedule builder *should* go live on Monday the 27th Also, realize this is an expected date but things occasionally happen so dont scream too much if its a lil late (or someone will let me know their displeasure with my tipping of the due dates)
- Community experts summit session lists – we’ve asked some experts for their opinions about which sessions to attend, I cant wait to see what these lists look like!
Other Interesting Discussions happening
- Whether we’re going to record/stream a session room at the Summit and what we’d do with those recordings
- Whether we should switch back to 2 days of Preconference sessions or stick with 1 day pre and 1 day post
- Whether we should be providing desktops in the session rooms for speakers (most don’t seem to use them)
- PASSion award & expanding PASS’s recognition of outstanding volunteers at all levels
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.
PASS Program Update #3
Apr 22nd
Its been a while since I wrote an update about whats been happening in the PASS Program Committee. I just havent had time to write about it with all of the work thats going on in addition to my regular day job. Hopefully Ill have time now to do a better job at this!
The annual content survey was sent out and the results are in, I’d like to go on record now and say, Im not a BI user/admin/developer. We took the BI questions from last year’s survey (which were obviously from 2008). Unfortunately, while going through them and updating the questions I didnt reach out to a BI person and get a gut check for the BI questions. So we wound up with some out of date info in that section. I swear we like BI @ PASS, I just goofed, there’s not some secret conspiracy, and YES to the 1 of you who asked, I do read all of the comments . The good news, for those that asked, the survey results will be released as soon as we can get them collated and readable (any day now) **UPDATE** The survey responses are here there are definitely some very interesting tidbits to be mined from this.
We are making progress in working on several projects, from redoing the speaker resources, to developing a new system to house the speaker evaluation data. As with all things volunteer driven, these tasks are taking time but thats not unexpected.
The biggest project Ive been spending my time on is the call for speakers. The call for speakers (and resulting abstract review site) is always a huge undertaking. This year it seems to be even more magnified since we’re undertaking a new vendor (the same 1 that does tech-ed). There have been quite a few bumps in the road along the way (I wont bore you to tears with all the details) A steady diet of 1-2 conference calls a week and about 50-100 emails a week and we’re closing in on a useable product in the call for speakers site. The abstract review site, well that will be the subject of a whole other blog post in the future! Ill just say that right now Im hoping to find some spare pixie dust or at least a few extra rolls of duct tape and bailing wire prior to the close of the call for abstracts
There have been many discussions about changing some of the SOP in the program committee, I have blogged about some of those previously so I wont rehash those here again. Ill just add a few more ideas Ive been kicking around.
1 of the largest things that will effect the average attendee at the Summit is that we’re exploring ways to allow 2 new session types this year.
1) Community selection – The current thought is to allow the community to choose from (pre filtered) submitted abstracts to choose a session per track (or some similar method/amt)
2) Best of the Summit– The current thought is to take the top session(s) from the first 2 days of the summit and repeat them on day #3
Both of these ideas have execution issues to overcome but, I think they should be doable for the 2010 summit.
PASS Program Update #2
Mar 11th
Here comes High Gear
Things have really started to move lately, We’ve officially started the Program Committee for 2010.![]()
We received 53 applications this year from members hoping to help out on the program committee. That’s a huge number for us, When I joined in 2007 I think I was accepted by default because we didn’t have enough volunteers. in 2008 there were approximately 20, last year we had 23. Obviously we’re gaining some attention in the process of making the education program at the annual pass summit the best year after year.
Selecting the abstract review teams
With so many applicants, selecting the teams was quite a chore this year. Its like interviewing for an open position at your company but instead of having 1 position, you have 17 open and instead of a hand-full of qualified applicants, you get a boatload. That pretty much sums up the experience every year but, this year it was twice as bad as I remember it being in the past (possibly because of the doubling in applicants). In the end, the quest to fill these teams took quite a bit of time, unfortunately just like selecting employees for your day job, there is really no best way to make the selections. I should have probably just used a dartboard for the selections but, I didn’t want to disservice those that had taken the time to apply. After quite a few iterations of making sure everyone was in the team that best leverages their skill sets, the new volunteers were notified.
Changes
The program Committee Portfolio changed hands in the PASS BOD this year, the new owner is Jeremiah Peschka. Overall my experience with Jeremiah has been the same as my experience with the prior 2 Board members I worked with on Program, they’ve all been nothing but great. We have already started batting around a couple of major changes to the Program Committee.
Thing 1
I tricked convinced Lori Edwardsto join the program committee as an adhoc project manager unfortunately we haven’t found a jazzy title that sticks yet, so she’s currently known as the task team leader, I hope we can properly anoint her later. With 17 applicants added to the abstract review teams, we moved the other 36 people who applied into a task group that Lori has the joy task of managing. Having a dedicated volunteer leader to manage the side projects that always come up should change the way we get things done and hopefully without me being the bottleneck, things will happen even faster. This year the program committee has many things we want to accomplish, in addition to the regular things that we have to do to put on the summit every year. I am hopeful this setup will prove to be one that works well, and we can refine and document the process so it can be reused in future years.
Thing 2
Abstract Committee Abstention. In the past we didn’t have a policy about the abstract review volunteers submitting abstracts in the same track as they are reviewing abstracts in. This was usually handled internally to each track and that member abstained from all discussion and ranking of their abstract. This year however, we alerted every potential abstract reviewer that they wouldn’t be allowed to submit abstracts to their review track. This rule may exclude some volunteers from reviewing abstracts in the future but, it just made sense from the transparency standpoint.
New Summit Management Software
The new summit software selection is causing some of our critical timeline dates to need to be adjusted. I’m not in a full panic defcon 5 mode yet but, If we don’t have a working environment in the new software by the end of next week, Ill be pulling the panic alarm. Configuring a site to accept abstracts, and manage the speaker experience takes an unbelievable amount of time and right now we’re still waiting for the final paperwork & approvals. Sliding the call for abstracts back doesn’t effect much of the planning for the summit except it compresses our timelines for getting the sessions selected and posted to the summitt website. Currently we’re aiming for a mid April call for speakers opening, with the actual call running approximately 30 days.
Speaker Resources
Brad started working on this years update/changes to the speaker resource pages on the sqlpass website. These sorts of changes are always interesting since they cross over a couple of portfolio’s. I’m hoping that we can collapse the 2 pages currently posted into one page that is less confusing, or potentially 2 pages that work better together and don’t overlap as much as the existing pages.
Lots of new ideas coming, expect a new blog post tomorrow outlining one of the more controversial (potentially) Ideas I’d like to get some community feedback on.