Alaska has a SQL Server User Group!

Alaska is on the PASS map!

Alaska is on the PASS map!

I’m really stoked to share the news: Alaska (my home state) finally has a PASS Chapter of its own! The group just got started last December, and officially welcomed into the PASS organization at the end of January. While they don’t have a Facebook or Twitter account yet, they do have a website and a YouTube channel.

The group meets every month and draws about twenty attendees, according to Chapter Leader Greg Burns. (Greg also runs the local SharePoint user group, which has about eighty members.) The audience is a mix of DBAs and developers, mostly.

Curious. Why would I mention the audience?

Because Greg is running a PASS Chapter for the first time, he could use a lot of help. He’s looking for speakers — remote or in-person — to present at upcoming meetings. If you’re interested in presenting to the group remotely, or just looking for an excuse to visit by far the largest state in the union…[prolonged eye contact with Texas]…just drop Greg a line at AlaskaSQL(at)

But wait, there’s more! If you’re a current or former PASS Chapter leader, you probably have some great tips on how to structure meetings, build membership, advertise your group, line up sponsors, and other things it takes to grow a user group. Rather than flood Greg’s inbox with your collective wisdom, let’s assemble them here in the comments so they’re all in one place. I can think of no better way to welcome Alaska to the SQL Server community than to show them how much we help each other.

51 Questions About Your Conference Session Submission

Jeremiah and I presenting in Atlanta

Jeremiah and I presenting in Atlanta

This weekend, emails went out to folks who’d submitted their sessions for the PASS Summit 2013 in Charlotte.

If you’re bummed, listen up. I know what it feels like to get turned down because I got turned down the first couple of times I submitted, too. The blessing and the curse of the SQL Server community is that there’s so many people who want to help others – but of course this makes it harder to get your place up on the stage. It’s only going to get worse/better as more people continue to discover the community.

Whether you got a good email or a bad one, your work is just beginning. Either you’re prepping for this October, or you need to start prepping for the next conference. In either case, here’s 51 questions you need to ask yourself about your abstract, your material, and your delivery.

  1. What pain is bringing the attendee to this session?
  2. How are they going to relieve that pain when they get back to the office?
  3. What does the attendee know already coming in?
  4. Who should not attend this session?
  5. Reading your abstract, are the answers to the above four questions crystal clear?
  6. What did you learn from Adam Machanic’s post Capturing Attention?
  7. Did your abstract take one thing off before it left the house?
  8. If you search the web for your abstract title, what comes up?
  9. Who else do you expect will submit on a similar topic?
  10. How will you show your own personality and expertise in the abstract?
  11. Of ProBlogger’s 52 Types of Blog Posts, which one matches your planned sessions?
  12. What other types of sessions from that list could you use to surprise and delight attendees?
  13. Are you teaching why or how?
  14. How would a handout make it easier for attendees to learn your lessons?
  15. What visualization would bring your session to life?
  16. Could you contract out a local design student or company to build it for you?
  17. Are you presenting to teach or to impress?
  18. Have you gotten feedback on your abstract from a proven speaker you trust?
  19. If a teacher graded your presentation, would you get an A?
  20. On that 24-point scale, what would it take to succeed at a national conference?
  21. What topics are you going to avoid entirely in order to save time?
  22. How often have you rehearsed this presentation before giving it to a local user group?
  23. Have you given this presentation before at local user groups and SQLSaturdays?
  24. Did you record the session (either video or audio)?
  25. Did you watch the recording to see where you can improve the material and your delivery?
  26. What questions did the attendees ask at those sessions?
  27. What feedback did the attendees give at the user group or SQLSaturday?
  28. How will you use that feedback to improve your session?
  29. If you gave attendees a test at the end of your session, what questions would be on it?
  30. If your session was a movie, what genre would it be?
  31. What other movies would be sitting next to it in the store?
  32. Who would play the leading role?
  33. What are three words you want attendees to use to describe your session?
  34. How do your abstract, material, and delivery inspire those three words?
  35. Have you clearly attributed ownership to the code and pictures in your session?
  36. If nobody asks any questions at all, will you still be able to fill the time slot?
  37. If you get many questions, which slides/sections can you skip without losing meaning?
  38. Where will you post all of the resources for your session?
  39. If people have a question while reading those resources, how will they contact you?
  40. If this session was a module in an all-day training class, what would the other modules be?
  41. What’s the worst thing that could happen in your session?
  42. How will you recover if that thing happens?
  43. Can you form an instant community of your attendees using a Twitter hash tag or chat room?
  44. What would your session look like with no demos whatsoever?
  45. What would your session look like as 100% demos and no slides?
  46. If you started the session with a question, what would that question be?
  47. What’s the easiest, simplest way for the attendee to learn the lessons?
  48. Could you get the presentation’s learning lessons across with a blog post or series?
  49. When you ask people why they linked to your post, what do they say they found compelling?
  50. What questions did readers ask in the comments?
  51. What’s stopping you from writing that blog post right now to gauge reader interest?

No, really. What’s stopping you? Don’t think for one moment that attendees will skip your session because they’ve read your work. It’s the exact opposite: readers come to your session because they like your work. Whether PASS told you yes or no, start writing your blog posts right now to find out what works and what doesn’t.

Write a Note and Shoot Yourself Today

When I’m writing a presentation or blog post, I often start here:

Yep, still the same smile.

2004 Brent

It’s a photo of me in my office in Dallas, Texas in 2004. When I look at that picture, I remember everything like it was yesterday. I can talk at length about everything on the bookshelf, on my desk, in my drawers (the desk drawers, that is).

I can tell you what technology problems I was struggling with, plus what problems my manager was concerned about. I remember what I knew, and what I didn’t know yet. I can recite the web sites I frequented.

Next, I can turn the mental camera around and see exactly what’s outside my office door: my developers and my support team. I can tell you what they rocked at and what they wanted training on. I can remember how we decorated their cubes for their birthdays – covering Julian’s stuff in aluminum foil, building a princess’ castle for Hima.

The funniest thing, though, is that I didn’t remember any of this until I rediscovered this photo several years ago. All of a sudden, everything was clear to me.

And I realized who I was writing for.

Now, it’s really easy for me to scope my presentations and blog posts because I’m writing for 2004 Brent. 2004 Brent hadn’t studied databases and tried to turn them inside out – he just needed to store data and get it back out quickly. He wasn’t on a first name basis with book authors and MVPs – he didn’t even know what an MVP was.

You need to take this picture today.

Set up your camera with a self-timer or get a colleague to shoot a few pictures of yourself sitting in your work environment. Get pictures of the books on your shelf, the stuff on your desk, and maybe take a screenshot of your task list. Write yourself a one-page note covering:

  • The stuff you’re comfortable with
  • The stuff you’re uncomfortable with
  • The things you want to learn this year
  • The things you learned recently that surprised you

Stash these pictures and words away in a time capsule folder somewhere. A few years from now, when you’re writing a presentation covering something you’ve learned, get these back out. Think about what you knew and didn’t know, and that’s your target audience. Before you use a term or acronym, think back and ask, “Did 2013 Me know that? If not, lemme introduce the topic.”

When you’re writing, remember that you’re never writing for your current self. You’re writing for the past version of you. Having these pictures and words will help you define your audience.

Choosing a Presentation Tool

If your New Year’s resolution is to start presenting at user groups and conferences, congratulations! You’re about to embark on a fulfilling journey that will enrich the lives of thousands of people. It’s a blast. Now let’s put some thought into the tool you’re going to use.

You’re going to be working on these same sessions for years – growing them, expanding them, building them into all-day training. Don’t pick a flash-in-the-pan presentation technology that might not be here in a couple of years. Pick the most reliable technology you can find.

If you’re lucky, you can turn your presentations into an entire company. When that happens, you want your employees to be able to give your presentations to clients when possible. Don’t use a hard-to-understand technology – use the simplest, most straightforward way to get your point across.

If you’re unlucky, your laptop will fail right before you walk onstage. Save all your presentations on a USB drive (mine’s on my keychain) so that when disaster strikes, you can turn to the nearest attendee and say, “Mind if I borrow your laptop to present? You’ve got (technology x) on it, right?” Attendees love to say yes, but you’re not going to have the time or bandwidth to download & install new software, and you shouldn’t be installing anything on a stranger’s laptop anyway. I present about Microsoft technologies, so my audience usually has PowerPoint installed. I’ve presented from attendee laptops more than once.

My presentation gear at work. Photo by Michael Kappel.

Use a technology that allows you to move around the stage while advancing slides. When you just get started presenting, you’ll probably stand behind the podium, gripping it tightly, fearing that you’ll fall over if you let go. After a few sessions, you’ll gain the confidence to move around the stage and use positioning just like actors do. You’ll want a technology that lets you use a remote control. I use the $60 Logitech R800 because it’s also got a built-in countdown timer. I can glance down to see how much time I’ve got left, and it vibrates when I start running out of time.

Use a technology that allows for easily exportable, not-easily-editable content. I export my sessions to PDF and give ‘em away to attendees. If you give away the native format, some attendees will take your session, edit out your name, and re-present it as their own. Of course, if you’re okay with that (and I am for some of my sessions), then take the other tack – use a technology that your attendees will all have, and will be able to quickly edit and re-present.

The export needs to stand on its own, including in a printed version. If your technology relies on animations to get the point across, and the export doesn’t include the animations, it won’t work. Personally, I do all my animations by having a separate slide for each step. That way even if you’re reading along in a printed handout, you can follow what I’m doing. At all-day training sessions, I’m amazed at how many attendees love following along in a printed copy and writing notes on it. Many attendees don’t have laptops/tablets that can last all day on battery for note-taking, and many conferences don’t have power outlets for every attendee during all-day training sessions.

A couple/few years into your journey, you’re going to be so proud of your chosen technology. You’ll have polished that knife to a sharp edge. At that point, it’s time to step back and pick up a new knife. Try a new tool, and start sharpening that too. The more knives you have, the better chef you’ll be, because different knives work better for different foods.

Every knife technology will fail on you. The slides, the demo code, the services, the remote, the laptop, the projector, the microphone, all of it. If you’ve polished multiple knives, you’ll be completely comfortable when one tool fails. I’ll never forget the time when I was presenting slides via projector about disaster recovery for databases, and midway through my session, the entire conference center’s power went out. I grabbed the whiteboard markers, eager to sketch out the concepts for the rest of the session. Those moments make your reputation as a presenter.

Having said all that, here’s the tools I use:

Text editor – I storyboard my sessions in a text editor first, using one line per slide. I write down the things I need to teach during the presentation, then I start adding and arranging, turning it into a story. When I’m done arranging the story, then I decide which portions need demos, diagrams, pictures, etc. If there’s an overwhelming theme, I try to pick just that one method of delivery. For example, if your session is 80% demos, dump the slides and just put comments in the code. Zoom in onscreen to show those comments in large text. If I can get the entire session delivered in just one tool, it makes the session easier for attendees to digest. If I do have to use two tools (like slides & demos, or slides & whiteboard) then I want to minimize the number of transitions back & forth.

Microsoft PowerPoint – I’m not a big fan of it, but it’s the de facto standard in the MS database world. Many MS conferences require me to use a PowerPoint template, plus I have to upload my slides to them for approval, and they’ll make edits and send it back. This just comes down to knowing your audience and picking a tool all the attendees will have. At our company, we’ve started breaking up our slides into mini-decks that our employees can reuse and present to clients. For example, I might have a 1-hour session on tuning databases, and then rip out two 15-minute sections of that to turn into mini-decks. When a client has a question and there’s a minideck to answer it, the employee can whip it out and give the client the best answer possible.

Demo code – think of this as a standalone presentation tool. If you can do a whole session in here (including the title, about-me slide, and resource slide), do it.

Whiteboard – I’ve always casually used this knife to handle attendee Q&A live, but I’m starting to polish it. I’m picking between iPad teaching tools to find one that lets me zoom in & out, record the session, write with a keyboard, etc. I want to get to the point where I can deliver a 1-hour session entirely via iPad whiteboard projected onscreen, and get good feedback from the attendees that it was the best way to learn a particular concept.

Want more tips like this? Check out our past presenting posts.

How We Write

The four of us were talking about the writing tricks we use, and we thought you might enjoy hearing our styles.

How Brent Writes

I use to track my blog post ideas.  I can use it from anywhere via a web browser, phone app, whatever.  I can tell when I’m in the mood to write because I’ll come up with 4-5-6 blog post ideas in a row in a matter of minutes.  When that happens – and it’s almost always in the morning – I look at the day’s schedule and figure out if there’s a way I can spend a few hours writing.  Seems like it strikes in spurts, too – weeks will go by without me producing a single blog post, and then suddenly I’ll have several days in a row where I just can’t stop sneaking away to write.

I can write anywhere, but I can’t be around people I know, because then I feel guilty for not spending time with them.  (This also means no email and no Twitter.)  This usually means that I grab my laptop or iPad and head to a coffee shop or pub that doesn’t mind me sitting there for hours, banging away.  Right now, my favorite writing place is Kroll’s Bar and Grill in Chicago.

I can only write with music playing on headphones – almost always with just one song on endless repeat.  The music affects the tone of what I write.  Bubbly pop music like Lady Gaga and LMFAO produces fun, relaxed posts like my SQL Server 2008R2 Review and my AlwaysOn Availability Groups introduction.  Client findings seem to work best while listening to Tokyo Police Club’s manic upbeat stuff like Your English is Good and Wait Up.  I wrote all of my chapters for 2008 Internals and Troubleshooting while listening to the long version of Death Cab for Cutie’s I Will Possess Your Heart.  Over.  And over.  And over.

I write in a text editor first.  I stopped using WYSIWYG stuff a long time ago because I got too caught up in presentation rather than content.  The words themselves have to seduce me on the screen, just by themselves, without any makeup.  When I’m pretty happy with what I’ve got, I move it into the final production tool (WordPress, Word, PowerPoint) and then start applying the makeup.

How Jes Writes

Sometimes, I think that I could write non-stop, all day, every day. It wouldn’t always be good writing, and it wouldn’t always have a point, but I can put words down all day long.

I have a list of blog ideas – technical and non-technical – in a OneNote notebook. I put down the topic or the title as soon as it comes to me, and a couple sentences if I have more. The next step is to fire up a Word document and put together an outline. Sometimes, that’s as simple as two or three bullet points. Sometimes, it’s a lot more complicated.

The act of writing requires discipline, mixed with a little inspiration. I try to block off specific times to write – that way, I can’t always put it off until I “feel” like it. Of course, if inspiration hits, I will sit down and bang out as much as I can when it happens. If I’m away from my computer, I usually have a notebook with me (I love Moleskine), and I’ve been known to scribble away and then type it up later.

My environment is very different depending on whether I have a technical or non-technical blog. As I write this, I’m in my office, door open, dog running amok around the house, music playing, laundry going, drinking coffee. If I have a technical topic to write about – especially if it involves code or examples – things are very different. Silence rules. I go in my office, I close the door, I turn on the light, I turn off music, close email and Twitter, open Word and whatever tools I need, and go. I don’t want to be bothered – at all, about anything. I’ll hack away for an hour or two, take a break for a snack, and go back at it. I like to finish technical blogs in as few sittings as possible, so I try to start these on a weekend, or during a week I don’t have a lot of stuff happening in the evenings.

When I’m done, every piece of writing gets set aside for at least a day. Then I re-read and edit it, sometimes a couple of times, and schedule it!

How Jeremiah Writes

As much as it pains me to say it: haphazardly. My process isn’t as disciplined as it used to be (or as disciplined as I’d like it to be). That being said, I’ll outline what I do right now and where I want to be.

I keep track of rough blog post ideas in Remember the Milk. As I flesh out the ideas, I add notes and links to references that will help me flesh out the article. Remember the Milk is critical for my workflow because I can get to it anywhere – ideas don’t happen when you’re sitting in front of the computer. They often strike when you’re at work, on the bus, or stuck in traffic. Being prepared with a lot of different ways to record a good idea is critical to saving that idea for later.

I’ve tried using any number of WYSIWYG editors – they help me agonize over font choice. I’ve tried distraction free editors – they get in the way of working with reference material. When I want to write, I use a text editor. Sublime Text 2 works for me; it has tools for writing prose and tools for writing code. Once I’m in the editor, I draw up a rough title and introductory paragraph – the first paragraph works as an outline. After putting together an outline, I write slugs to draw the reader through the article. It’s after I’ve outlined that I start writing.

I’m a big believer in revision. The first time through an article, I write down my thoughts as quickly as possible while trying to stick to the outline I’ve put together. If there are interesting diversions, I make a note of them and carry on. After the first draft, I let it sit and work on something else.

Clutter is the disease of American writing.

William Zinsser said that. He’s right. During my editing process, I distill my writing. Once I reach minimalism, I build it back up; carefully adding words where they’re needed. I repeat this process several times until I’m as happy as I’m going to be with the results. Whether I’m writing prose or code samples, I use this approach.

Unfortunately, I don’t succeed every time. My least favorite writing is something I produce quickly. I feel that a moment of genius or art has struck and that I can happily push “Publish” and move on to something else. The discipline of revision isn’t there and it shows in the quality of the work – it’s sloppy, jumbled, and dissatisfying. In a perfect world, I could revise each piece three or four times.

My writing process takes time and discipline and is a piece of habit. Great writing doesn’t come from a burst of inspiration, it comes from daily exercise. Relentlessly tuning my prose makes it easier to write something better the next time through.

How Kendra Writes

I admit it: I hate writing sometimes. Writing is very difficult for me. Here’s how I cope.

Mainly, I try to play to my strengths. I have some good skills that I value. I’m really good at a few types of writing, and I’m also a really fast typist. When I’m working in a form of writing I’m good at, I’m much more productive than when I work in a form where I struggle.

Here’s where I shine: I’m great at describing a problem and creating an action plan to solve the problem. I’m a star at documentation and writing up recommendations. I love the balance of trying to add just enough detail and links so that the nuances are clear, without getting so bogged down in detail that the meaning is hidden.

I practice this type of writing a lot in my work. When I write this way, I don’t really need much of anything except my laptop– it’s pretty easy for me to “get lost” in the writing. I tend to stop noticing things around me. I try to remember to stop and drink water or stand up and move around periodically.

Here’s where I struggle: more creative forms of writing. Blog posts are incredibly hard for me. We try to be very thoughtful about blog posts on this site and have a lot of internal discussions about how we can write the best posts possible. It’s just not as simple and straightforward as business writing where you’re out to slay a specific dragon. It’s more about connection and humor and finding meaningful things to share with a much bigger audience.

Here’s what I’ve done to try to make myself better at writing things where it’s hard for me:

  • I don’t force myself to write creatively at very busy or stressful times.
  • I encourage myself to write creatively when I’ve finished my task list for the week or had a great night’s sleep on a weekend morning.
  • I remind myself that I am good at writing, even if some forms are hard for me. (There’s no worse thing for you as a writer than to tell yourself that you’re a bad writer.)
  • I encourage myself to let writing flow creatively in one session, then use another session to go in and edit furiously.
  • I stop writing when I’m still feeling good about it.
  • I save off content in Evernote and periodically pull out older content and work on it again– I don’t set myself a quota for finishing.

I also sometimes get to integrate the forms of writing where I’m strong into the website, too! I created most of the sp_BlitzIndex® documentation in one long afternoon of thinking and writing about indexes– and I’m so proud of it. Those pages would not have made a good blog post, but they’re a way I was able to contribute sharing information in a meaningful and helpful way.

To me, becoming a better writer is all about mindset and strategy. Observe where you’re strong, appreciate what you’re good at, and build from there. Don’t try to write like anyone else, just always strive to write as well as you can.

Our PASS Summit 2012 Schedule

Next week, the Brent Ozar Unlimited® crew will be attending PASS Summit in Seattle, WA. It’s a busy week, full of networking, learning, and teaching. Here are a few of our highlights.

Want to add our sessions to your schedule, and view more information at your fingertips? PASS Summit has gone mobile with Guidebook! It’s available for iOS, Android, Blackberry and web-enabled devices.


8:30 am – 5:30 pm: Brent and Jeremiah will be presenting at Red Gate’s SQL in the City event in Seattle. This is not a SQL PASS event, but if you’re in Seattle on Monday, find out if you can swing by– the event is totally free. Brent will be talking about “Six Scary SQL Surprises” at 10 am. Jeremiah will be talking about code quality in “Red Gate Tools- The Complete Life Cycle” at 11:30 am. Register here.


5:15 pm: We’ll be meeting our First Timers at the Orientation & Networking Session. This is a valuable program from PASS. A first-time attendee at a conference of this size could be overwhelmed. Then we’ll be attending the Welcome Reception, saying hello to old and new friends. What fun and games does Tim Ford have planned for us this year?


6:30 am: Jes will kick off the morning with the second annual #sqlrun, a 5K run along the waterfront. Get info and sign up here.

10:15 am: Jes presents The What, Why, and How of Filegroups. .

11:30 am: Jes is attending the PASS Chapters Luncheon!

1:30 pm: Bob Dylan, er, Brent will give his Lightning Talk, Bob Dylan Explains Tempdb!

3:00 pm: Brent is on deck again, this time with Real-Life SQL Server 2012 Availability Groups: Lessons Learned.

4:30 pm: Jes will be at the PASS Community Zone. This is a new area that will introduce people to all the great community events available. We’ll even have games and prizes! Please stop by, say hi, pick up a game card, and get to know the members of the community!


11:30 am: Kendra is a panelist on the Women in Technology lunch. This great event also features panelists Stefanie Higgins, Kevin Kline, Denise McInerney, and Jen Stirrup. Jes will be sitting at the blogger’s table, capturing the discussion of “Women in Technology: Where Have We Been and Where Are We Going?”

1:30 pm: Jes is presenting “Lights! Camera! Piecemeal Restore!” as one of the Lightning Talks. Come to room 307-308 to watch us.

3:00 pm: Jes will again be in the Community Zone that afternoon.

5:00 pm: We hope you can be in three places at once! Brent will Diagnose T-SQL Performance Problems Fast with sp_Blitz®. Jeremiah is guiding the audience through A Developer’s Guide to Dangerous Queries. And Kendra will have on her lab coat as she presents Index Psychiatry: Diagnose and Treat the Top 5 Disorders.

7:00 pm: Microsoft and PASS are sponsoring the Community Appreciation Party at Seattle’s Experience Music Project!


Friday will wrap up an incredibly exciting week.

11:30 am: Jes will be hosting a table at the Birds of a Feather lunch – the dining hall will be organized into areas of interest, and you’ll be able to network with MVPs, MCMs, speakers, and more. This is a great opportunity to meet other people interested in the same field you are!

1:00 pm: Kendra has a Spotlight Session, SQL Server First Responder Kit.

If you’re attending PASS Summit, enjoy! It’s a great experience, with many hours of learning and many great people to meet. If you can’t attend (this year!), make sure to follow the #sqlpass hashtag on Twitter, and catch the live stream of two rooms from!

Conference Speakers – Check Your Room Size

When you’re speaking at a conference, try to get the room schedules long before the event day.  Right now, the PASS Summit conference schedule is available, and each speaker’s room is listed.

Then, check out the building’s floorplan – in this case, the Washington State Convention Center’s floorplans page.  Check out the seating capacity for your room.

My audience (right before they walked out)

My audience (right before they walked out)

You don’t have to think about filling the room or imagining the audience in their underwear, but knowing the size of the room can help you mentally prepare yourself for what you’ll be facing.  I take different approaches in different room sizes.

In small rooms (for under 30 people), I look every single person in the eye and make sure they’re following along.  When I’m losing somebody, I’ll prompt them for questions and change my presentation pace.  I can make faces to illustrate my disbelief or happiness with a particular point, and I know everyone will see it.

In mid-size rooms (for 30-100 people), I’ll try to take the pulse of the audience by looking around.  I’m less able to change the presentation pace based on facial expressions – and I’m less able to use my own facial expressions as a presentation tool.  Repeating audience questions becomes critical here because people on one side of the room can’t hear questions from the other side.

In rooms designed for over a hundred people, I have to be more animated.  People farther back can’t see my facial expressions at all, and I need to convey more things via audible cues.  My visual cues have to consist of giant hand waving and pointing.

When I know the room size ahead of time, I can even adapt the presentation to work better.  For example, in large rooms, I’ll use visual punch lines on the slides rather than trying to tell a story with my facial expressions.  In addition, the bigger the room, the bigger the font – I can’t rely on projectors to convey small bullet points in a 500-person room.

Note that the room size – not the number of attendees – dictates your approach.  If you’re in a giant room, it doesn’t matter if less than 30 people show up – you still have to use the big-room delivery style.  And don’t judge your success based on the percentage of empty seats – that’s the success of the meeting planner, not you.  It’s their job to pick the right room size for each presentation.  Jeremiah and I are both in the monster 6E ballroom that holds over a thousand people.  They’re betting that a whole lot of people want to hear me talk about AlwaysOn Availability Groups and him talk about A Developer’s Guide to Dangerous Queries!

You Can Give A Technical Presentation (Video)

In your dream, you’re standing in front of a room full of dozens of people, presentation mouse in hand, about to present to them on (insert SQL Server feature here). You wake up in a cold sweat. You’re either terrified, or excited and terrified.

Are you ready to start presenting? Join Jes as she shares her secrets to building and giving successful technical presentations!

Become a Presenter, Change Your Life

I began presenting on SQL Server two years ago. At the time I was a Senior Database Administrator. My workdays were spent getting ahead of the next big performance problem in an environment where software changes rolled into production like gangbusters. I was under a lot of pressure to be super-technical, stay on top of the latest software changes, and anticipate problems at every turn. It was tempting to spend all my technical efforts on my job. Instead, I decided to interact more with the outside world.

Getting ready to present at 24 Hours of PASS

Looking back, becoming a speaker is the single most important career decision I ever made.

There’s No Obvious ROI on Technical Speaking

Deciding to get up and present on technical topics wasn’t easy. I knew that investment costs came out of my personal life. It was clear that I would spend a lot of free time working on presentations and building my speaking skills.

Risk was obvious, too. Presenters get asked all sorts of random questions from the audience. I knew that I could prepare like crazy and there would still be things outside of my control. Before you start speaking, the risk of embarrassment seems HUGE.

And what do you get in return? When you begin speaking, engagements are unpaid. You’re speaking at night or on the weekend, and “Thank Yous” are your payment in the short term. These are great, but you might wonder if they’re worth all the investment and the risk.

What You Get from Becoming a Technical Presenter

When you get into the habit of giving talks on a technical topic, it changes you. You become a presenter.

Presenting isn’t just a set of skills. It’s like playing a sport— you learn the techniques, but you use them in the process of becoming an athlete. Presenting develops a specific side to your personality and skills. As you continue presenting you customize your techniques and find a style of delivering and interpreting information that’s genuinely your own.

This personal transformation is your return on investment. It may not sound like much, but it’s a very big deal.

Speaking with Confidence and Clarity

Most technical speakers don’t begin with great confidence OR great clarity. Most of us begin speaking just as best we can— we’re trying to share how to do something. As you gain experience speaking you learn to handle the unexpected: odd questions, equipment failures, power outages. You start to feel at home working with people and you identify ways to explain concepts better. Most people who keep going learn to be better communicators.

Soon, standing up and guiding a room full of people through a set of concepts is no big deal. Do it enough, and you begin to enjoy a challenge.

Picture yourself being this confident presenter who can handle any curveball. Now picture that confident presenter speaking for you in your next performance review. Imagine them in an interview for a new job. Imagine them helping train their team to do something new and exciting. That “speaking athlete” finds it easy to use their presentation skills to advance their career and lead their team.

This is where I started

That person isn’t more talented than you. They aren’t smarter or better. They just worked hard to become a great speaker.

Three Simple Steps to Becoming a Technical Presenter

  1. Start speaking
  2. Keep going
  3. Listen to feedback

That’s it.

This list requires hard work, no doubt about it. You’ll need to design a talk, write it, submit it, and then actually give it. This is a very big deal for many people and seems huge. It’s OK— remember that topics which seem obvious to you are likely completely new to many people. Teach what you know.

I’ve placed “listening to feedback” as number three for a reason. Feedback is incredibly valuable and helpful, but don’t kill yourself with criticism after your first speaking adventure. Understand that you’re doing something new and appreciate that you’re actually doing it! Just by itself, that’s great! Once you find your sea legs, actively ask for feedback on where you can make yourself stronger, and listen carefully.

Where to Get Started

The SQL Server community is full of friendly and supportive audiences. These folks love to share and exchange information, and they’d love to have you join the ranks of speakers. They also want to help you succeed!

Your best bet is to find a SQL PASS User Group in your area. Frequently, user group leaders have options for new speakers: you might be able to do a shorter session for your first try, if you want. Talk to the chapter leaders and ask what works for them.

Sometimes people start giving presentations at their workplace to smaller groups. Some people start submitting sessions to free SQLSaturday conferences.

Whatever your path, the hardest part is deciding to get started. It’s time to get out there.

How to Pick a SQL Server Conference

As a consultant and speaker, I’m lucky enough to go to a crazy number of SQL Server conferences. Here’s what I think of each mainstream conference out there – who they’re for, and who they’re not for.

PASS Summit

  • Length: 3 days
  • Pre-Cons Available: Yes, many
  • Videos Available Online: Yes, but only for paid attendees
  • Tracks: SQL Server only
  • Typical Location: Seattle, WA

Just one of the PASS Summit after-hours options

For Attendees: The Summit is a mid-size (thousands of people) conference dedicated to all SQL Server, nothin’ but SQL Server. A dozen or more sessions run simultaneously at all times, so no matter what niche topic you’re interested in, somebody’s running a presentation about it.  The “somebody” is a key here – the presenters are from all walks of the SQL Server life, some professional presenters and some people presenting in front of a crowd for their very first time.  Quality is all over the map here, but the community is forgiving: this feels like a big family event.  Twitter is lively with attendee chat during the day, and the fun continues after hours with several big parties to choose from on any given night.

For Speakers: The conference doesn’t pay any expenses or speaking fees, but competition’s still tough for slots here just because so many community members are encouraged to submit abstracts.  Along with the lack of payment comes a lack of work, though – presenters aren’t required to spend time in various booths or attend a bunch of pre-conference meetings.  PASS seems beholden to Microsoft to keep this event near Seattle as often as they can, and like TechEd, this doesn’t make for good vacation time.  I’m sick and tired of rainy, gloomy, Novembers in Seattle, but I put up with it because it’s like a family reunion.

Microsoft TechEd North America And Europe

  • Length: 4 days
  • Pre-Cons Available: Yes, but only one for SQL Server
  • Videos Available Online: Yes, free
  • Tracks: SQL Server, Sharepoint, Windows, Development, Cloud, Exchange, basically anything Microsoft
  • Locations: various US and EU cities

TechEd Europe Keynote

For Attendees: This large (~10,000 person) conference has multiple tracks for almost all Microsoft technologies. If you wear multiple hats like developer AND database pro, sysadmin AND accidental DBA, or DBA and SharePoint admin, then this is the biggest conference for you. Biggest doesn’t necessarily mean best, though: I sat through a few painful vendor sessions and Microsoft marketing sessions. (The keynotes are simply awful.) Microsoft and the sponsors clearly run this event, and it shows – they’re pushing their own messages here. This is the conference to hit during release years because tons of Microsoft staff are readily available to answer detailed questions about new products. The vendor expo is huuuuuge, too, so if you need to compare multiple vendor products quickly, this is the place to go.  If you can’t go, though, you can watch any of the session videos for free.

For Speakers: Microsoft pays for speaker airfare, hotel, and a speaking fee, and there’s some prestige involved with speaking at Microsoft’s own event, so competition is extremely fierce for speaking slots. However, because the conference is run by Microsoft, the competition doesn’t necessarily mean the sessions are the best. Sessions have to conform to Microsoft’s speaking (marketing) standards, and presentations are vetted by Microsoft employees. You won’t see a lot of anti-Microsoft sentiment in the slide decks here. Many attendees even believe that all presenters are Microsoft staff, so I start my sessions by explaining that I’m an independent consultant.  Speaking at this conference involves a lot of meetings, red tape, and mandatory duties at various get-togethers and booths.  Worse, the conference isn’t always when and where you want to be – New Orleans in June is not my idea of a good time.


Connections in Vegas. Because, y’know, Vegas.

  • Length: 3 days
  • Pre-cons Available: Yes, multiple dedicated to SQL Server
  • Videos Available Online: No
  • Tracks: SQL Server, Sharepoint, Windows, Development, Cloud, Exchange
  • Locations: Twice a year in Las Vegas

For Attendees: This small conference run by Paul Randal and Kimberly Tripp (SQLskills) feels very much like a professional training event. There’s just a few simultaneous sessions per track, but they’re absolutely top notch sessions. Even though there’s only a few sessions, they’re ALL sessions I want to attend – really good expert-level speakers that do a lot of presenting for a living. There’s no filler here.

For Speakers: The conference pays for speaker airfare, hotel, and a speaking fee, so competition’s pretty tough for the few speaking slots. As a result, the sessions tend to be more curated and fairly high quality. This is my favorite conference as a speaker because the organizers work hard to make it as easy as possible for you.  I get one email with my contracts and travel details, and that’s it.  I show up onsite, pick up my backpack with my logistics stuff, and I get to work.

DevConnections and SQLConnections

Connections in Vegas. Because, y’know, Vegas.

  • Length: 3 days, one of which is dedicated to Microsoft presenters
  • Pre-cons Available: Yes, usually one SQL Server pre-con per day
  • Videos Available Online: No
  • Tracks: SQL Server, Sharepoint, Windows, Development, Cloud, Exchange
  • Locations: Twice a year in Las Vegas

For Attendees: Like DevIntersection, this is a small conference focused on training. It used to be run by Paul Randal and Kimberly Tripp (who now run Intersection), so it’s easy to get confused as to which one is which. Connections is now mostly community-driven, though. Between Intersection and Connections, I’d pick the former. (And I do as a speaker.)

Microsoft MVP Summit

Jeremiah acting out SQL Server through interpretive dance at the MVP Summit

  • Length: 2-4 days depending on your interests
  • Pre-Cons Available: No
  • Videos Available Online: No
  • Tracks: All Microsoft technologies
  • Location: Microsoft campus in the Seattle area

For Attendees: This invite-only conference is the biggest benefit to being a Microsoft MVP.  Microsoft trots out developers and managers to talk about what they’re working on.  MVPs get to interact with the people building their favorite products, plus interact with other MVPs – and that’s a killer benefit by itself.

I include this conference in my list just because it’s an event away from home that I need to schedule time for, so it’s part of my decision-making process.


  • Length: 1 pre-con day, 1 deep dive day, 1 free day
  • Pre-Cons Available: Yes, several
  • Videos Available Online: Yes, but only for the free days
  • Tracks: SQL Server only
  • Location: Moves around the UK

For Attendees: Maybe it’s just because of their accents, but I think the presenters at SQLbits are some of the best ones out there.  I’ve been consistently impressed by the SQLbits sessions I’ve seen, and the sense of community at this event is just outstanding.  It’s held in fun places at fun times of the year.  Even the format is unique: if you just attend the free day, it’s much like a SQLSaturday, but if your budget allows then you can get much more in-depth training too.

For Speakers: SQLbits does pay presenters for doing pre-cons, but not for the free days.  It has an interesting mix between a professional-feeling conference and a community one, and I think it strikes a really good balance.  If you can get a pre-conference session approved, then this conference can pay for itself – they offer some of the best revenue sharing of any of the conferences.


  • Length: One week
  • Pre-Cons Available: No
  • Videos Available Online: No
  • Tracks: SQL Server only
  • Location: Cruise ships, typically out of Florida

SQLCruise #1

For Attendees: This very intimate (15-attendee) conference is a chance to build close personal relationships.  Yes, there’s SQL Server training, but the really valuable part is the one-on-one time you get to spend with MCMs, MVPs, and experts.  There are much less presenters (and attendees) than any other conference, but you get tons of time with them.  At larger conferences like the PASS Summit, you’re not likely to get hours of time to have drinks and talk directly to the presenters – there’s just too much of a crowd at any given time.

For Speakers: Presenting on a cruise ship comes with some drawbacks.  Attendees expect plenty of time to build those relationships, which means you’re now required to attend every single session, group event, party, dinner, etc – and there’s a lot of ‘em.  The cruise room is paid for, but the airfare and pre-cruise hotel is not.  If you see this as an easy vacation, you’re going to be in for a shock – I found it to be more work than any other conference.  The benefit is that the attendees are sincerely thankful for the work you put into making the event a success.

How I Choose Which Conferences to Attend

If you’re an attendee, I’d recommend basing your decision on:

  • Is it more important to you to learn, or to build relationships? (And are you sure?  You can watch a lot of the conference videos for free online right now – so what’s holding you back?)
  • Is it important to you to have conversations with Microsoft employees?
  • Is it important to you to meet peers who have similar problems?
  • Do you want a conference located somewhere that you can do sightseeing before and after?

When I’m an attendee, the most valuable things are conversations and relationships.  I want to be able to talk to experts who have solved the same problems I’m facing, hear how they worked past it, and get their contact information so I can ask them questions later.  That’s why I prefer conferences with plenty of time for side talks – if everyone’s rushing from session to session, I don’t get as much value as an attendee.

I try to budget some money for lunch and dinner because food at these conferences is frankly horrendous.  The presenters don’t want to eat that stuff either, so when I needed help, I tempted presenters by saying, “Hey, can I take you out to lunch or dinner and pick your brain about something?”  You’d be surprised by how often that works.

Me at the PASS Summit Bloggers’ Table

I also care about the conference’s tracks.  I have to do more than just SQL Server, so sometimes I need to talk to experts from other fields.

This is going to sound crazy, but I don’t really care about the sessions or the keynotes.  If I want sessions, I can watch free videos from SQLbits or TechEd anytime I want.  I don’t have to wait for the conference to fix problems I’m having right now.  I also don’t care about product announcements because Microsoft doesn’t really do them at conferences anymore.  Take the recent Surface announcement: we had TechEd North America one week, then the Surface announcement the next week, then TechEd Europe the week after – but not a single bit of information to be had about Surface at either TechEd conference.  Given that the audience consisted of developers, and that developer support is absolutely critical for launching a new tablet, I don’t get why Microsoft would ignore these conferences – but they do.  If tech news is important to you, get it from blogs and news sites rather than conferences, because the Microsoft conference scene has stale news.  (That’s not to say these conferences don’t have good information about new features – you just won’t find it at the keynote sessions, which have turned into a boring rehash of old news and marketing demos.)

If you’re a presenter, here’s what I think about when choosing my conference calendar:

  • Where I can help the most people
  • How I can bring in business in the future
  • How I can minimize expenses (after all, as a consultant, I’m not getting paid when I do this stuff)

Each conference has its own pros and cons, and it sucks to decide, because I wish I could attend conferences all year!  I have to cut back to honor my family commitments, though.