After tabulating over ten thousand distinct session evaluations for the 2010 PASS Summit we are pleased to release the top 10 sessions overall and the top 5 sessions per track.
Getting these session results generated and out to the speakers in a timely manner is always challenging. After taking until the second week of January 2010 to return Speaker Evaluations for the 2009 Summit we put in sweeping changes to prevent that from happening again in 2010.
Fortunately we were very successful in getting the data, We (Community Volunteers) designed and built a database to house the eval info, and designed a system that could be used to enter the evaluations quickly during and shortly after the Summit. This was a resounding success. Unfortunately where we fell short was in executing on delivering the data to the speakers and the community. When we designed these systems, the process to send out the evaluations wasnt really discussed, or possibly just wasnt finished (the perils of distributing work include less insight into exact issues). Either way, I wound up in the 23rd hour reworking last years SSIS package to fit the new database schema.
We delivered Speaker evaluations to the speakers a full 3 weeks earlier than last year. This included additional info about overall speaker scores that we had never provided in the past. I realize a success to me (3 weeks sooner) is still a failure to others (4 weeks after the summit to get the data to the speakers) We're going to be working on improving this for next years summit but for now, Ill take the wins where I can get them!
Getting the top 10 sessions posted has taken an extra 3 weeks. I take full responsibility on this one. I had the data on my laptop for the entire time, at first it was the holidays, then it was something shiny, after that I kept running into issues trying to make queries that werent just usable for this years summit, but would be able to generate similar results for any event we enter into this database. In the end though, I have a set of queries for this process that will be reused.
This database/process was one of the projects a large group of OUTSTANDING Community members chipped in and worked on under the umbrella of the program committee in 2010. I have big plans to round up another set of volunteers and put a web based front end on the db and push its use out to all SQL events that would like to use it. The information that we're gathering will be invaluable to both the speakers and to the community in the future.