Problem
As a SQL Server User Group Leader with Ray Barley, we are always looking for new ideas for our monthly meetings. We have tried polls on LinkedIN and Meetup. We have had some good feedback on formats, but we really want to have some fun as a group, give members more opportunities to connect and “pack the house”. Do you have any suggestions? Check out this tip to learn about SQL Server Jeopardy.
Solution
At our recent Baltimore SQL Server Users Group meeting, we tried something a little bit different and our community seemed to enjoy the change of pace. We had our first session of SQL Server Jeopardy. SQL Server Jeopardy helped us achieve a few goals:
- Change our consistent meeting formats
- Give community members more time to chat and get to know one another
- Freed up having to find a main speaker for the meeting
- Share knowledge in an entertaining and new way
- Build some teams within the group
- Collaboration among team members to solve a problem
- A few laughs here and there
- …and a $50 gift card to the winning team
So how did we do it?
- We prepared a game board via PowerPoint with 4 different categories
- Database Administration
- Database Development
- Business Intelligence
- Potpourri
- We prepared multiple questions from levels 100 to 500
- We split the group into 3 teams
- Each of the groups had to come up with a team name
- …and they were are pretty creative
- Each team had a single point of contact to respond to the questions
- I asked the questions and Ray selected which team raised their hand first in order to answer the question
- We had some pandemonium with asking and answering questions, so our lessons learned is to just follow a round robin format rather than trying to judge who raised their hand first or forgot about the rules (because they were super excited) and yelled out the answer.
- So here is how we plan on handling this the next time:
- First team has control of the board
- Ask the question
- Give the first team a finite amount of time to answer
- If they answer incorrectly award zero points then give the second team a finite amount to answer.
- Repeat for each team until the question is answered correctly or all teams do not field a correct answer.
- If a team answers correctly, then they get the points and the next team gets control of the board.
- If they answer incorrectly award zero points then give the second team a finite amount to answer.
- With each question we shared the correct answer and asked for community members to provide a brief explanation of the answer to share knowledge among the group
- Once the question was answered, we deleted the number from “the board” in PowerPoint
- In terms of recording scores, we added points for correct answers and subtracted points for incorrect answers.
- This lead to some pandemonium as well. I think our lesson learned for our next session of SQL Server Jeopardy is to just add points for correct answers and zero points for incorrect answers.
- With about 5 minutes remaining in our meeting we moved to the “Final Round” of SQL Server Jeopardy
- Here is what we did:
- We provided a general topic for the “Final Round” question
- Each team chose how many points they wanted to bet then notified the remainder of the teams
- We asked the final question
- Gave all the teams about 1 minute to formulate an answer
- Had each team present their answer
- Crowned the first SQL Server Jeopardy Champions
- Here is what we did:
SQL Server Jeopardy Board
Here is a screen shot of the starting board we had in PowerPoint:
Click here to download the sample SQL Server Jeopardy board.
SQL Server Jeopardy Questions
Our questions were all over the map in terms of the topic and the number of responses. When we started off, we were not sure what sort of responses we would get, so we wanted to be open minded. One of our lessons learned was to potentially select narrower topics to help determine the interest level. We are thinking about throwing out some topics in a previous meeting to help find out the interest level and narrow down ideas before we hold our next SQL Server Jeopardy event.
Click here to download the sample SQL Server Jeopardy questions.
Next Steps
- We hope this idea gives you some food for thought for your user group. This was fun for us and we are thinking about another session sometime soon.
- Check out all of the Professional Development tips on MSSQLTips.com.
