About Kendra Little

Kendra specializes in high availability and performance tuning. She is a Microsoft Certified Master in SQL Server-- the highest technical SQL Server Certification available. Kendra loves databases and software development more than long walks on the beach. Those cartoons in her blog posts? She draws 'em all. You should follow Kendra on Twitter: http://twitter.com/kendra_little
Archive by Author

Why You Should Create A Speaker Resume

Speakers and presenters of all types: do you keep a list of past and future speaking engagements online?

You should. A speaker resume is an easy tool to grow your career and get better speaking engagements.

Conferences care about your speaking history

If you submitted a presentation to the SQL PASS Summit this year, you were asked to enter your speaking history.

Why?

When you run a large conference, it’s hard to know every single speaker who applies. If speakers provide their history and a biography, it’s easier to recognize people. If speakers provide a biography that lists their blog and an online speaker history, it’s much easier to get a sense of how long the person has been speaking.

Future employers care about your speaking history

Do your future self a favor– record all the hard work you’re doing now. If you’re presenting on one or more topics at online events or conferences, that says a lot about you.

Your speaker resume helps the community get to know you

We meet a lot of people at conferences, and we read a lot about people online! It’s hard to keep people straight, especially for new people entering a community.

Keeping a public record of what you speak on and where really will help community members understand who you are and what you’re interested in.

Your speaker resume will help promote conferences

When you’re going to appear at an event, you should blog about it and link to the event. This gives a little extra search engine mojo to the event creators, and it may help out people figuring out if they should attend, as well.

Don’t have a blog? Create one just for this.

Good news: you don’t blog about other topics if you don’t want to. If you’re a presenter, you should at least have a simple blog listing where you’ll be. It’s free, it’s quick, it’s easy. You can make the title your name and the subtitle “The Presenting Adventures of a Database Addict,” or something more reasonable to let people know you’re only blogging about your speaking dates.

How to create a speaker resume

If you’ve already got a blog and you write posts on different topics, here’s how to create your speaker resume:

  • Create a page called “Events”
  • Add heading that says “Upcoming Events” and one heading that says “Past Events”
  • Enter in your upcoming events
  • After you complete events, move them down to “Past Events”.
That’s it! That’s all you need to create your speaker resume.

Optional items for your speaker resume

  • Add a summary paragraph at the top of the page explaining what topics you speak on, how long you’ve been speaking, and what groups you speak for.
  • If you have dates and locations for past events, put those in.
  • If not and you can summarize a year or a set of years with a general number of presentations, audiences, and topics, that’s great, too.

This is all icing on the cake. You’ll notice I’m a slacker and I haven’t done all this– I just started my page last year and have done my best to get things on it after that point. But you can certainly outdo me.

Don’t make maintaining your speaker resume too difficult

Use abstracts and content you’ve already written, and do your best to keep it updated— design the page so it isn’t very time consuming.

I like to remove some information from past events and just keep the title, topic, location, and some comments on the event, but this is more effort than you really have to put in.

Do you keep a speaker resume?

Do you have tips to share which I’ve missed?

Comments { 0 }

Free Session: The Mystery of Query Timeouts

I’m giving a webinar tomorrow!

(Do people still use the word webinar? Was that just incredibly uncool?)

There’s still spots open, so register today. Here’s a drawing from my slide deck and what I’ll be talking about.

Note: This is part of Triage Tuesdays, a set of free weekly sessions from Brent Ozar PLF. Look for more good stuff coming soon.

July 26 – The Mystery of Query Timeouts
Brent Ozar PLF Tuesday Tech Triage, 9:30 AM Pacific / 11:30AM Central / Noon thirty Eastern

“People are complaining about query timeouts. I don’t see anything happening in SQL Server, but they always say the database is the problem. How can I tell what’s really going on?”

When your users keep hitting timeouts in their application, they naturally think the database is killing off helpless queries. In this webinar Kendra Little will tell you how to triage treacherous timeout situations and collect hard evidence about whether or not the problem is in the database. Do the right detective work and you can turn your frustrated users and irate developers into raving fans.

This session will be 200-level – you should have familiarity with OLTP concepts and understand what DMVs and Profiler are, but you don’t have to be an expert with them.

Register for the free webcast here.

Comments { 0 }

I’m a Microsoft Certified Master in SQL Server

I've unlocked the MCM Badge on SQL Server!

I don’t typically blog individual links for each of my posts over at BrentOzar.com, but this is a special occasion.

I am thrilled to say I am now a Microsoft Certified Master for SQL Server 2008!

Read more in my post here.

Comments { 3 }
Write down your presentation ideas - you don't need PowerPoint for this.

How to Make a Presentation: Writing Versus PowerPoint

How do you make your next PowerPoint presentation great? We all know that PowerPoint presentations can be horrible.

This Isn’t a Powerpoint How To. It’s How To Make a Presentation.

 

The most common mistake in making a presentation is getting started in PowerPoint or Keynote right away.

If you dive in to PowerPoint too soon you will over complicate your slides. Your narrative will be stronger if you start by taking a larger, more strategic view of your presentation. These steps will show you how to make a logical, complete presentation.

1. Write Down Your Presentation Ideas Constantly
Pre PowerPoint / Keynote

(Time: a few minutes each day)

You get ideas a lot. Write them down in Evernote or jot them in a notebook you carry with you. Put down enough specifics so later you have some idea what the details were and why you liked it.

Write down your presentation ideas - you don't need PowerPoint for this.

You don't need spellcheck for ideas

This is the most important step in my method.

The key is to write down all your ideas. If it interests you, write it down. Maybe this is a presentation you’ll give in five years, or never– you need to write it down.

When this happens: All the time, whether or not you’re planning a presentation.
Why’s this so important? Writing down ideas helps you have more ideas. It becomes a habit to just think about “what about a talk on X?”

2. Outline Your Talking Points
Pre PowerPoint / Keynote

(Time: 5-10 minutes)

Start with an outline. Outlines don’t need to be numbered or bulleted unless you’re more comfortable that way.

Don’t do this in PowerPoint or Keynote. Use a paper and pen or an electronic notepad.

The initial outline may not look much like the finished presentation. They often don’t– and that’s fine.

If you can put a whole bunch of stuff down easily for ideas of where to go with the talk and how to get there, you know it’s likely to be a good talk. If you have real trouble getting things down in an outline then you may need to do more research. You may need to refocus the topic.

Rough out how long you will spend on each part of the talk. Don’t hold yourself to this, but use it to judge whether you picked a topic that’s too big or too small.

When this happens: Outline once at the beginning of a presentation. You may do this soon after having an idea and then not look at it for a while, until you’re ready to do the talk.
Why’s this so important? This helps make sure the topic is right for you and that the talk is at the right scale. If the subject is too big, maybe you need to pan out a bit and not focus on so much detail. If it’s too small, maybe you need to expand the surface area and cover more.

3. Write Your Presentation Abstract or Executive Summary
Pre Powerpoint / Keynote

(Time: 20-30 minutes)

If you’re submitting to a conference, you’ll usually be required to write an abstract for your presentation. Even if you’re not, it’s extremely useful to have a short overview of your talk, so don’t skip this step.

Writing an abstract or executive summary is an opportunity to really think about your audience. Write down what is interesting in your topic and why it should matter to your audience. Approaching the abstract this way helps you develop the presentation for people.

If you put the right kind of thought into your abstract it makes writing your presentation easier.

This step essentially takes the content you roughed out in the outline and focuses it toward your audience.

You’re still not in PowerPoint yet. If you’re chomping at the bit to get in there, go ahead and do this on a slide, but you’re still just fine with pen and paper or a simple electronic notepad.

When this happens: When you start thinking about submitting a talk.
Why’s this so important? This helps shape your talk to your audience.
Remember:  Have fun with the abstract. Use word association. Tell people what’s in it for them.

4. What’s Your Presentation Title?
Pre Powerpoint / Keynote

(Time: 20 minutes minimum)

This is even more important than the abstract. Lots and lots more people will read your title and need to make a quick decision about whether they want to see your presentation. Do this AFTER you write the abstract, because you can use what you’ve decided about your audience.

Get feedback on your title ideas– ask friends and other speakers what they think. Explain your audience to them.

When this happens: After writing your abstract.
Why’s this so important? This is how to sell your presentation to your audience.
Remember: Sometime the title you thought of first is really the best one. Don’t be afraid of sticking with that title. Just be open to considering others in case you find something great.

5. Submit Your Presentation Topic
Online
(Time: 3 minutes)

If you’re aiming to speak at a specific conference or meeting, this is the point you consider a presentation ready to submit. If you’ve gotten this far and like the talk then go ahead and run with it– submitting means you’re committing to deliver the presentation if it’s selected, not that it’s already complete.

When this happens: When you’re planning your schedule and figuring out what events you’d like to speak at.
Why this only takes three minutes: Unless you haven’t written a bio yet or need to drastically shorten your abstract, this is simple copy-paste.

6. Create Your PowerPoint Slide Headers and Order Your Slides
Now You’re In PowerPoint!
(Time: Varies widely: plan for at minimum 5 hours preparation for every 10 minutes of the talk)

This is where you start building the slide deck.

First, lay out concepts on individual slides by filling in only the slide title. Put one concept per slide, and get them all out there.

Next rearrange the slides and create section headers. Look at your presentation in the slide sorter and examine the flow of the slides and the story you’re telling. You want to shape your talk here, before you spend too much time on any single slide. Reorder the slides until you’re happy with the story you’re telling.

At the end of this step you should only have blank slides with headings filled in.

7. Find Pictures for Your Slides. Source and Cite Your Images Responsibly.

When the presentation has good shape and flow, start diving in and filling out individual slides with pictures, diagrams, or words.

Keep your slides simple– you want only a few words and bullets per slide, typically with only one picture. The worst thing you can do to your presentation is to over complicate your slides.

Use images from the internet responsibly. Brent Ozar tells you how to find free pictures for presentations the right way.

8. Start Your Presentation Strong and Finish BIG

After you have your presentation set up, put it away for a day or two. Then go back in and look closely at your beginning and ending.

Do you have an interesting introduction? Do you have a strong finish? Make sure your audience has the right information at the end of your presentation: are you mandating them to go out and do something? Should they contact you for more information? Are you driving them to a website?

Give your audience a place to go. Give them the information to keep in touch with you.

9. Test and Refine

An important part of making a presentation is taking it for a test drive. You can do this by yourself at first.

  • Is your presentation the right length?
  • Do you like the way your presentation flows?
  • Are there changes you would like to make?

Delivering test runs of the presentation will help you answer all these questions prior to going in front of a larger audience.

10. Be Confident

If you’ve followed these steps, you’ve made a great presentation. Your audience wants to see you and you’ve made a presentation to support you in delivering information. Breathe deeply and use the work you’ve done, and your presentation will be great.
Enjoy yourself.

Comments { 2 }

What’s It Like In Portland? Come Check it Out for SQLSaturday Oregon

I’ve been living in Portland, Oregon a couple of weeks now. I’m reporting back on what I’ve found.

What You Notice First

If you drive into Oregon you notice two things pretty quickly: there’s no sales tax and you aren’t supposed to pump your own gas.

Come As You Are

It’s OK to dress creatively in Portland– dress however you want. Really. Having tattoos is normal, but people don’t stare if you don’t have them, either. Oregonians seem to accept people as they are unless they cause a problem. It’s like Seattle with 30% more friendly-weird.

Seriously, People in Portland are Friendly

I heard about this before I moved here. People aren’t “nice” in Portland. Instead, they’re really friendly. The difference is subtle but noticeable. People say genuine things, and they take an interest in you. They’re relaxed and happy to see you. People listen and ask questions.

Our neighbors have welcomed us wholeheartedly. They ask about what we’re interested in, they’ve dropped off fresh vegetables from their gardens. Lots of people walk and bike, and it must just put them in a good mood.

It’s Nature-y!

A good friend told me a story about her niece from Southern California visiting Portland. When asked if she would be interested in coming to college here, she paused and then said, “It’s a little too nature-y.

She wasn’t kidding– it’s really NATURE-Y here. There’s a giant forested park right in town. We’re talking 5,000 acres with 70 miles of trails. I went for my first walk there last weekend and it was just perfect– a little bit hilly with rolling paths, gorgeous trees, birds, ferns. And the occasional fascinating giant slug.

Oddities You Love

The Ikea is near the airport— which I think is a great place to keep your IKEA. The airport is clean and bright, and has free wi-fi and good coffee. With this combination, I’m strangely looking forward to picking people up at the airport. Is your flight delayed? No problem, I’ll stop off and buy IKEA napkins and something with a bizarre name to put in the middle of my kitchen table.

The food in Portland is insanely good, and it’s everywhere on carts.

There’s lots and lots of bridges.

The coffee really is that good.

Your Chance to Visit: SQL Saturday Oregon

SQLSaturday Oregon will be held on October 8, 2011.

This will be directly prior to the SQL PASS Summit 2011, so if you’re attending Summit you can plan for a combo trip– or just come see us.

If you do plan for the combo, you can fly into PDX and then take the train up to Seattle. The train has wi-fi, too.

Comments { 2 }
SQL Server Expert

Are You An Expert?

SQL Server Expert

I follow this guy on Twitter.

Should you call yourself an expert? And what does it take to be an expert?

One day on SQLCruise Alaska I gave a two hour session on Isolation Levels in SQL Server– one hour was slides, one hour was demos, and over the two hours we had lots of input and questions from the cruisers.

After that session we had a breakout panel on brand building. In the course of talking branding, the question of self-description came up: who should describe themselves as experts? And how is that interpreted?

What is an Expert?

I’m pro-expert. I believe that if you have rich experience in a defined area and you’ve done the research and the legwork, there comes a time when you should step back and assess if you’ve progressed past proficiency into the realm of the expert. So if I’m at the point where I’m presenting to Senior level DBAs and database developers on a cruise ship about Isolation Levels, I’m going to call myself an expert in that area.

But the term “expert” can be off-putting to some people. Some people were more comfortable with the acronym SME, or “Subject Matter Expert”. To me, this is too jargon-y— I don’t think there’s any arrogance to simply saying, “I am an expert in this area.”

Experts Don’t Necessarily Know Everything

Saying you’re an expert means you are an authority on a topic. It doesn’t necessarily mean you’re the only authority, and it doesn’t mean you constantly generate new material that’s never been discovered before.

For example, I know experts in problem resolution. These people have mastered triage, identification, research, and troubleshooting methodology. They’re like dive masters– they’re comfortable in scary places not everyone goes, and they can help you learn to go there.

Experts learn all the time. Experts can still be humble.

Researchers can still be experts, but these days they are not the only game in town.

Where Do You Stand Out?

Here’s a thought experiment: imagine yourself in a room with 100 other smart, technical people who work as engineers across a vast range of technologies. You must describe what type of problem you most love to solve. What would you say about yourself?

Think about this problem, and understand that your skills are quite unique across a broad pool of engineers. Think about where you are in your career path– are you a beginner, are you proficient, or have you moved further in your path?

Don’t be Afraid to Be an Expert

Don’t be afraid to recognize yourself as an expert. You don’t have to put “Expert!!1!1!!!11″ in your email signature or on your business card or even describe yourself that way to anyone else. But assess yourself fairly, and put yourself out there as an authority when it’s appropriate by blogging, answering questions online, and giving presentations.

One thing you can do right now is to sign yourself up for the RedGate Exceptional DBA Awards. The contest is a chance to think through your strengths and accomplishments and write them down: that’s a great starting point to map out goals to move your career forward.

Comments { 3 }

How I Got Past Writer’s Block

I’m not Stephen King, but I enjoy posting regularly. Somewhere between SQLCruise, consulting work with BrentOzar PLF, and moving to Portland, I got stuck.

It wasn’t exactly writer’s block, it was more like blogging block. I could get down ideas and a few notes, and even big chunks of posts, but I couldn’t post anything. I couldn’t finish stuff up, I couldn’t be satisfied.

Maybe it’s that I got overwhelmed and my brain prioritized for me. Maybe I just got confused about which blog to write for. I did succeed at prioritizing my time for other things, but I didn’t schedule my time properly for blogging.

How I Got Back to Popsicles and Sunshine

I devoted some time this week to getting my writing problem fixed. Here’s what I did:

  1. I spent 10 minutes listing topics that I knew would be easy to write about. These are things I’ve already been thinking over for a long time and largely have figured out. Since I’ve been having trouble getting words down, I didn’t want to mix research into the project.
  2. I used the Pomodoro technique. I downloaded a free timer and put in some tasks, then followed the advice on the Pomodoro Cheat Sheet. I found this really helped me focus. (Thanks @BuckWoody for sharing this tip on SQLCruise!)
  3. I stayed away from Twitter and email while doing my Pomodoros, and only looked at them in my longer breaks. That’s kinda the point, after all.
  4. I listened to my “Pop That Makes You Want To Throw Up” station on Pandora. Turns out Ke$ha helps me write. Who knew?
  5. I started taking at least one long walk each day. Walking helps me think and it generally helps me feel better. And the weather’s gorgeous.

And there you have it. I’ve churned four blog posts into my queues (here and at BrentOzar.com) doing Pomodoro iterations over the last few days, and I have no visible bruises to show for it. (Editor’s note: eight total now– updated since this was drafted.)

What do I like about the Pomodoro technique? It helps me give the same focus I naturally give to client work to other projects– whatever they are. It helps me estimate my work and track how I do. It also lets me log interruptions, whether they come from my own restlessness or from things that need taking care of.

This all combines into a system where I can make good progress, then leave something for a few minutes or a few iterations. When I come back, I’m in a better position to ask, “am I done yet?”

Comments { 6 }

What Y’All All Thought of Me at SQL Rally

SQL Server Table Partitioning

Table Partitioning: It's A Very Good Thing (sometimes)

A few weeks back, I presented on SQL Server Table Partitioning at the first SQLRally conference. The event was energizing and fun– there were great conversations and I sat in on fun sessions. I particularly enjoyed Todd Robinson’s session on caching with App Fabric.

My session on Table Partitioning was in the first group on Friday morning. People got up bright and early and the room filled right up– there were people standing at the back.

I had a great time giving the talk. People asked really good questions, and their timing was great, too. I love questions that make the presentation more rich and get the audience involved. For me, the talk was a huge success: we got into the key reasons to use the features, the considerations on where to use it, and covered how it works, and we did it together.

But How Was It For You? The Ratings

54 people filled out evaluations, which was about half of the people in the room. Here is the average score I got (out of five) by the survey question asked.

  1. How would you rate the Speaker’s ability to convey information and control the presentation? 4.852
  2. How would you rate the Speaker’s knowledge of the subject? 4.944
  3. How would you rate the accuracy of the session title and description to the actual session? 4.907
  4. How would you rate the speaker’s use of the allocated time to cover the topic/session? 4.630
  5. How would you rate your ability to follow along with the speaker’s examples/demonstrations? 4.556
  6. Please rate the practicality of the information presented. 4.849

The Comments

Participants were asked, “What could the speaker do to improve for future presentations?” This is a great question to have with evaluations.

Many comments were very positive:

  • Presenter seems like a leader in table partitioning, great confidence.
  • You rock! I learned a lot and want to use partitioning now!
  • Well done. Kendra is very knowledgeable and it came across very well.
  • Excellent knowledge transfer to audience.
  • Well organized and presented.
  • Buzzed by scripts
  • Very knowledgeable

And comments also offered advice:

  • Never used table partitioning. tough to follow for new topic.
  • Have longer sessions.
  • This session could have been longer
  • Talk about log growth when split.
  • Highlight color in SSMS was difficult to read and highlighting while discussing code.
  • Talk a little fast
  • Not speak so fast
  • Watch time so not rushed at the end.

Y’all Think I’m Smart!

That’s so great. I think that means I got a lot of information across.

Where To Go From Here?

Based on your feedback, it’s clear that I’m trying to pack too much information into the live presentation. I think you’re right on: My material is top-quality, but I need to edit. I need to slow down.

With a big topic in a limited time frame, I need to focus and convey less information, but I’ll still get more across. It’s just that simple.

I can do that! And I appreciate all the positive comments, too.

Thanks for your feedback, and thanks to everyone who helped make the SQLRally conference possible.

Comments { 1 }