Category Speaking

What the heck are you people talking about?

The call for speakers is closed and the selection committees are about to begin reviewing the abstracts. Before they get started, here are a few little pieces of trivia about the sessions.

Keep in mind that I have done minimal cleansing on this data so it’s going to be a bit messy and unreliable for anything apart from entertainment purposes.

Raw Numbers

There were 574 sessions submitted this year by 209 speakers working for a total of 163 separate companies.

Out of a total of 127 job titles, the most common one was “Consultant”. Or, it would be until you take into account the different variations of DBA, Database Administrator, etc. Taking that into account, 20 of you are some kind of DBA.

If you want to get a bit fuzzier about the numbers:

  • 17 of you are an engineer and are probably measuring something with calipers right now
  • 12 of you identify as a manager
  • 12 of you think you’re a developer
  • 27 of you claim to be a consultant
  • 11 of you work in B.I.
  • 32 of you claim to be architects. You draw squares and arrows to represent work.

All of you work for a total of 163 different companies. Unless some of you can’t spell your company’s name right. Then you may work for fewer, I’m not sure. The data, as I said, is dirty.

The Submissions

The average length of a session abstract was 617.7 characters or 99.19 words with a standard deviation of 243 characters and 39 words. Out of all the presentations, 187 have never been presented before. They may very well be 100% fresh in November when you arrive.

Here’s the distribution between the different levels:

  • 100 Level (Novice) – 109 sessions
  • 200 Level (Intermediate) – 239 sessions
  • 300 Level (Advanced) – 178 sessions
  • 400 Level (Expert) – 44 sessions
  • 500 Level (Advanced Expert) – 2 sessions

Pre/Post Conference

42 total pre/post conference sessions were submitted. That’s a lot of competition for a few slots.

  • 14 were B.I. (9 for architecture and 5 for reporting/delivery)
  • 13 relate to DBA work
  • 12 relate to application development
  • 3 relate to professional development

The only conclusion I can draw is that very few of us are prepared to talk about our careers for a single work day. Are you playing Legend of Zelda at work all day? What’s up with that, guys? People making a living talking about this kind of stuff.

Spotlight Sessions

There were 58 spotlight sessions submitted and I’m afraid to say that your day jobs faired even worse in this section.

  • 20 were DBA related topics
  • 15 were development topics (this better not be all IronPerl … I mean PowerShell)
  • 13 were somehow related to B.I. architectural whatnot
  • 5 were related to B.I. reporting and delivery. Apparently these guys are too busy making money to talk at the PASS Summit for 8 hours.
  • 5 of you thought that you could talk about your job for 90 minutes. Good for you. That’s long enough to get to the good parts in Krull or watch any number of amazing kung fu movies.

The distribution is starting to skew a bit here. If we combined the BI tracks it would look a lot more like the pre/post conference situation.

Community Sessions

Here is where you guys clearly shine. You submitted a whopping 472 sessions. That’s an average of 2.25 per person. While not bad, you could have submitted 4. I’m just saying that maybe next year you should pick it up a little bit.

  • 137 application development topics. We’re number 1, we’re number 1
  • 135 DBA topics put this in at a close second.
  • 113 BI architecture topics
  • 48 Professional development (you can talk for 75 minutes about your job, but not 90?)
  • 39 B.I. reporting topics. I think these people really must have jobs to do, because that’s not a lot.

Submitting a Winning Abstract at PASS

For those who couldn’t make today’s presentation, or those who could but want to hear Tim Ford and Buck Woody trashing Wisconsin, I’m pleased to share with you both the slides and the recording of today’s presentation. Or rather, two recordings.

The Powerpoint

The Presentation

Submitting a session to the PASS Summit really isn’t terrifying. What’s terrifying is being accepted and being faced with the prospect of speaking… I kid, I kid. There’s nothing terrifying about it. You put together an abstract, revise it a few times, and then submit it. When you submit an abstract you’ll want to put together a list of objectives – problems that you’re going to solve for the attendees.

Well, that’s about all there is to that. If you have questions, post them in the comments. I can’t tell you what PASS is looking for because, well, I don’t know. It’s based on a number of different things and depends, in part, on your abstract itself. So, write some abstracts, give them a once over, and submit them to PASS.

Want some more ideas about writing abstracts? Look no further than Brent Ozar’s blog post How to Get Readers to Pay Attention.

Want to know more about public speaking? I would suggest Confessions of a Public Speaker.

Submit to PASS!

The call for speakers is rapidly approaching and to help everyone get ready, we’ve got a special treat for you. Chuck Heinzelman, of PASS Board of Directors fame, has agreed to put on a presentation - Intro to Speaking At PASS: Creating a Winning Abstract (If I Can Do It, Anyone Can!).

What’s the point of all of this? Well, we all have problems writing abstracts, especially when we first get started. Good abstracts are key to getting your talks accepted at events. You could have the greatest presentation in the world but nobody will know if you can’t write an effective abstract.

Tune in on Tuesday 4/27 at 12pm Central time for this LiveMeeting event. Members of the PASS Program Committee will be online to answer your questions.

Free SQL Server Training in April

I’m going to be speaking at a few events in April. I bet you want to come visit and hear the crazy sounds that I’m going to be making!

Thursday April 8th – Columbus, OH

Fundamentals of SQL Server Internals

The Abstract: Want to know what makes SQL Server tick?
Ever wonder what SQL Server is doing when you run a query?
Ever wonder which parts of SQL Server are responsible for specific functionality?

Jeremiah Peschka can’t promise answers to every question, but he can set you on the path to knowledge about the inner workings of SQL Server.

Location: Battelle for Kids – 1160 Dublin Rd Suite 500, Columbus, OH 43215

Time: 6:30 PM, but you can show up at 6:00 PM for refreshments and socializing.

The Details: This is a fun little romp around SQL Server’s internals. This isn’t intended to be an exhaustive introduction. It’s supposed to be a fun look at how SQL Server works internally and give you more information to get around.

Saturday April 10 – Richmond, VA

I’m speaking at SQL Saturday 30 in Richmond, Virginia!

Fundamentals of SQL Server Internals

This one starts at 8:30 in the morning, so bring your coffee!

A Dynamic World Demands Dynamic SQL

The Abstract: Dynamic SQL is a misunderstood and much maligned part of a DBA’s tool kit – it can be used to solve difficult business problems, respond to diverse data needs, and alleviate performance problems. Many DBAs reject dynamic SQL outright as a potential source of SQL injections, being poorly performing, or just for being a hacky solution in general. Not so! Jeremiah Peschka has been making extensive use of dynamic SQL throughout his career to solve a variety of problems. He’ll set about dispelling these misconceptions and demonstrate how dynamic SQL can become a part of every DBA’s tool kit.

The Skinny: I sometimes catch flak for this, but I use a ton of dynamic SQL on a daily basis. It’s the only way I could possibly build some of our most complex reports. Frankly, dynamic SQL can perform just as well as anything else that you’re doing so why not take advantage of the tools at your disposal? Come along and learn more.

Saturday April 17 – Chicago, IL

Double whammy! You can travel to Chi-town and see me present both of my talks again but in reverse order!

A Dynamic World Demands Dynamic SQL

Bring your dancin’ shoes we’re getting that party started at 9:00 AM right after the welcome and keynote.

Fundamentals of SQL Server Internals

Less dancing, more learning this one goes on at 3:00PM. Hopefully your brain won’t be full by this point in time. If it is, I suggest that you empty it.

How can we grow the pool of Summit speakers?

Allen Kinsel, my brother in arms for the Summit 2010 Program, posed a question about how to grow the pool of speakers for the PASS 2010 Summit. Allen has proposed that in order to bring in more speakers, we limit things to 1 session per speaker. With 168 sessions across the board, that’s a lot of potential speakers. Currently, we limit things to 2 sessions per speaker.

What are your thoughts?

This poll will close on Thursday, March 18 at 8AM EST and I’ll publish the results in a separate blog post.

[poll id="2"]

SQL Server Presenters on Twitter

I put out a call a while back for a list of SQL Server presenters who are on twitter. A fair number of people responded. I kept it quiet because I was busy doing my day job, but I was secretly plotting… Plotting to put this list together and share it worth the world! (evil laughter)

Not only did I put this list on my blog, I also put it on twitter. Behold, my SQL Server presenters twitter list.

I will be trying to maintain this list as more people come get on twitter and become willing to share their twitter info. I wish that I could give this twitter list over to the community to maintain, but I am more than willing to take list maintenance on until there’s a way to trade list ownership on twitter.

The whole point of the list is to make it easy to find presenters and presentations, both for the future needs of a user group as well as for your immediate needs (e.g. your speaker cancels at the last minute).

If you’d like to get on the list, hit me up on twitter or shoot me an email via the contact page.

Josef Richberg @sqlrunner
Brent Ozar @BrentO
Thomas LaRock @sqlrockstar
Kendal Van Dyke @sqldba
Tim Ford @sqlagentman
Lara Rubbelke @sqlgal
TJay Belt @tjaybelt
Todd McDermid @Todd_McDermid
Jack Corbett @unclebiguns
Kevin Kline @kekline
Colin Stasiuk @BenchmarkIT
Trevor Barkhouse @SQLServerSleuth
Ken Simmons @kensimmons
Aaron Nelson @sqlvariant
Jorge Segarra @SQLChicken
Joe Webb @JoeWebb
Glenn Berry @GlennAlanBerry
Pinal Dave @PinalDave
Sean McCown @MidnightDBA
Jonathan Kehayias @SQLSarg
Tim Mitchell @Tim_Mitchell
Eric Humphrey @lotsahelp
Artemakis Artemiou @artemakis
Wes Brown @WesBrownSQL
Aaron Bertrand @AaronBertrand
Adam Machanic @AdamMachanic
Jimmy May @aspiringgeek
Rob Farley @rob_farley
Brad Hurley @bradohurley
Rick Heiges @heigesr2
Chris Randall @cfrandall
Stuart Ainsworth @stuarta
Mladen Prajdic @mladenprajdic
K. Brian Kelley @kbriankelley
Arnie Rowland @Arnie1568
Buck Woody @BuckWoody
Ross Mistry @RossMistry
Grant Fritchey @GFritchey
Rod Colledge @rodcolledge
Denny Cherry @mrdenny
John Sterrett @johnsterrett

LiveMeeting Tips and Tricks

As a virtual chapter leader and presenter I end up using LiveMeeting quite a good deal. I also like to attend PASS meetings through LiveMeeting (free learning is free and learning). As I’ve presented and talked to other presenters, I’ve amassed a list of feedback, tips, and tricks for successfully using LiveMeeting.

  • Make sure you’re in a quiet place – You may not notice barking dogs, noisy cube neighbors on speakerphone, or a stereo on in the background, but these things can be distracting for the audience.
  • Lower your display resolution to 1024 x 768 – most people are watching this in a window or on their work computer or both. In my experience, work computers have low resolutions. My personal laptop has a 13 inch display at 1280 x 800 pixels.
  • Reboot your computer and only start the programs you need for your presentation – PowerPoint and SSMS, for example. Close everything you don’t need. Close all of the tray apps you don’t need. Shut down every service that you don’t need. Your computer is doing some heavy duty audio and video encoding and you don’t need anything else potentially eating up your CPU.
  • Increase your Visual Studio/SSMS font sizes to at least a 12pt font.
  • Upload your slide deck – click Content -> Upload a File. Your attendees will get much better results if you just upload the slide deck instead. This will fill their monitor, unlike your display which probably won’t match theirs. The downside: you won’t have your slide notes, so print those out ahead of time. Event when I’m presenting in person I do this, just in case I can’t get my laptop and the projector to play nicely and I have to mirror my display.
  • If you have multiple monitors and you want to share a single program, it needs to be on the primary display.
  • If you’re using the video conferencing feature, turn of any lights behind you and turn on lights in front of you. I also set my desktop background to a pure white background. This will light up your face and make you appear less like a member of the witness protection program.
  • Turn of your cell phone. Ever get a goofy galloping noise on your speakers at home? That’s the magic of GSM. That will play havoc with the audio in your LiveMeeting.
  • Speaking of phones – make sure your cellular or cordless phone is fully charged. Have a backup plan. This, of course, does not apply if you are using LiveMeeting’s audio stream.
  • Use throat lozenges to keep your voice working, especially if you are presenting or recording multiple sessions on a single day. Coffee will not do wonders for your voice.
  • Install LiveMeeting in advance. Preferably several days in advance. It takes about 10 minutes to install on a good day, so give yourself plenty of time.
  • Put a note in the slide notes every few slides that simply says “stop and ask for questions”. At that point in the presentation, click the Q&A button at the top of the screen and click Manage. You’ll see everybody’s questions. Remind the audience that they can ask questions throughout the presentation by clicking Q&A at the top of their screen.
  • If you have two computers, set them both up as presenters, but mute the audio on your secondary one. Then if all hell breaks loose, you can switch laptops and keep going.

Special thanks to Brent Ozar for collaborating on this list of tips. Do you have any LiveMeeting tips that you would like to share? Spread the love in the comments!

Bonus Tip: Use basic fonts for maximum readability – Core fonts for the Web

Dogfood

I’m a bit late on this one, but I’m very pleased to announce that I will be speaking at the local Dogfood Conference. I’ll be speaking about SQL Server 2008 R2 and will be conducting an Ask the Experts session in the afternoon, but I’m not the only person who will be at the conference. There are going to be a lot of great sessions at the conference covering the range of topics from Windows 7 to SharePoint to F#.

Check out the Thursday and Friday agendas and sign up.

Rate This!

There are a few people out there in the community who speak. You know who you are, I’ve been to your talks.

Sometimes, at a user group meeting there are forms to fill out where you circle a number and hand in the form and potentially win a prize like a license to Red Gate SQL Prompt or a copy of ReSharper. But what happens when people don’t fill them out. Or they come up with a particularly insightful comment after the fact like “ZOMG, your presentation totally saved my ass today! There was so much useful information in your presentation and I was able to use it and fix my production explosion!” Or, heaven forfend, the feedback forms are lost in someone’s car or they get recycled or whatever.

Enter speakerrate.com. I’ve known about speakerrate.com for a while now, but for some reason it’s always slipped my mind. At devLink I told Kevin Kline about it and he immediately added it to his presentation slides.

So, what’s the value? Well, it makes it a bit easier for people to rate at their convenience. Maybe I’m feeling rushed, maybe I’m in a bad mood, maybe I want to think about what the speaker said for a while before I leave a lasting mark on their speaking record. Maybe I want everyone to know that I got absolutely nothing out of this so called advanced presentation. You can do all of those things.

The point is that you’re contributing, for better or for worse, to the long term reputation of a speaker. Everyone can see what you have to say and everyone can see how the audiences respond to the speaker. All in all, everyone wins.

What does this mean for speakers?

Interestingly enough, it makes some aspects of speaking a lot easier. When you’re talking to a user group leader you can give them a link to your SpeakerRate.com page (mine is http://speakerrate.com/peschkaj). This makes it easy for user group leaders and speaker selection committees see what they’re in for. Likewise, it keeps your record public.

It’s even easier to get feedback. Rather than collecting the forms, waiting for someone to process the new email addresses and maybe go through the comments for their own purpose before typing them up and emailing them to you, you can simply put a link at the end of your presentation and ask the audience to visit the site and rate your talk. Sure, it takes a little bit more time but you can also always tell them the honest truth: your boss is going to shove you in a box and shake it up real good unless you have great ratings.

Most important to me is that it’s a constant stream of feedback on how I’m doing as a speaker. I learned that I took a lot of my knowledge for granted. Now I know what I need to do the next time I give this presentation and I’m going to make sure that I do a much better job. Why? Because one of the audience members said that they didn’t understand some concepts that I mentioned without an explanation. I can now tailor the presentation to include more background material or take out some advanced material. The point is that without the feedback, I wouldn’t have known about these comments and I might have continued to give this presentation with too little background information and too much advanced information.

Note I have not been paid for this, I just think it’s a cool idea

This site is protected with Urban Giraffe's plugin 'HTML Purified' and Edward Z. Yang's Powered by HTML Purifier. 401 items have been purified.