Yearly Archives: 2010

Goals? Where we’re going, we don’t need goals.

Denis Gobo tagged me in his post about his 2010 goals, and challenged a few of us to gauge our success for 2010 too by revealing our yearly goals and how we did. I should have seen it coming, because he tagged me on this before.

I’m all over the Getting Things Done philosophy, which involves setting some 50,000 foot goals to keep your overall life on track – but my GTD 50,000 foot goals aren’t “goals” in the way we usually think of goals. They are:

It's hard work looking this good.

Goal for 2011: Improve My Poker Face

  • Be very financially secure.
  • Be a fantastic partner for Erika.
  • Enjoy life while I can.
  • Be strong and healthy.
  • Be a good son and brother.
  • Be a good Catholic.

None of those can be crossed off, so to speak – I’m never done enjoying life or being very financially secure. These are big-picture guidelines, more of a compass direction than a map destination. Underneath each of those 50,000 foot goals, I’ve got a series of – wait for it – 40,000 foot goals, then 30k, and so on, getting more and more tactical.

I’m not so anal-retentive that all of my day-to-day tasks are mapped up all the way through the list. Because I know my 50k goals, it’s easy for me to know at a glance whether an incoming task maps up to the big picture, or whether it might not be something I should take on. Every couple of weeks, I go through my task list just to be safe (called a GTD review), and make sure nothing snuck in when I wasn’t really thinking straight. I re-prioritize things, decide to postpone things indefinitely, and so on.

My big picture (the 50k foot goals) are very static – they haven’t changed in years – but the lower you get in altitude, the more the landscape changes from month to month. Having a really solid grasp on the direction I want to go helps me be more flexible when new opportunities arise. If someone presents me with an opportunity or if I get a wacko idea, I do a quick gut check: does this match up to my 50k foot goals, and will it skew the amount of time I spend on each goal? For example, I often turn down new clients that need help RIGHT FREAKIN’ NOW because if I took it on, I would spend less time with Erika and I would enjoy life less.

Having said all that, let’s look at what I checked off under some of the big-picture goals this year.

Mad Men

My SQL MCM Rotation

Be Very Financially Secure

Life threw me a curveball when Quest asked if I’d like to pursue the Microsoft Certified Master of SQL Server program. This hadn’t been part of my life’s goals, but I said hell yes because it would make me more valuable. I busted my hump studying, so saying yes to this temporarily threw my goal system way out of whack. I sacrificed some of my other goals in order to make this happen.

After I passed, life threw me another curveball when Microsoft reworked the MCM. They decided to offer it to the public without the Microsoft-based training component, which meant that I could offer MCM training myself. I looked at this as a gold mine opportunity – if I moved fast, I could write MCM training materials and make a lot more money doing training. I had absolutely zero interest in leaving Quest initially, even after I got my MCM, but the MCM program changes meant I had to think fast. Leaving Quest was tough, and leaving the security of a full-time salary job was especially tough. If I hadn’t been working on this particular GTD goal for a few years, I wouldn’t have been able to give up the salary and health insurance.

Be a Fantastic Partner for Erika

I’ve committed to Erika that I’m only going to travel one week per month on average. I struggled to keep this in 2010, and I didn’t do as well as I’d have liked when I mixed consulting and conferences. In 2011, I’ve had to say no to some really attractive events like SQLRally because I just can’t be gone all the time, and I don’t make money at those events (or SQLSaturdays). If I have only one week away per month, and I have to decide between making money at a client or losing money at an event, I gotta take care of business. (See the first GTD goal.)

Erika’s wanted new furniture for a while, so we refurnished the whole house this year. The last bits and pieces, a pair of mirrored nightstands, arrive Friday 12/31.

I did other stuff but I’m not posting that here. Mostly involved a turkey baster, a clown suit, and a videocamera.

I'm On a Boat!

SQLCruise 2010 Leaving Miami

Enjoy Life While I Can

This one suffered a lot during my efforts to pass the MCM program and start consulting, but I managed to sneak a few boo-yahs in.

I never would have predicted that Tim Ford and I would have launched SQLCruise. It came out of nowhere – I was so sick and tired of Seattle in the winter (seriously, PASS, what the hell are you thinking?) and was desperate to go somewhere fun at the right time of year and talk SQL Server. This was one of my most fun weeks of the year.

I’ve always wanted to learn more about photography, and this year I finally broke down and bought an interchangeable-lens camera, a couple of books, and subscribed to photography magazines. I’m slowly upping my game here, and I really enjoy this as a hobby.

Be a Good Son and Brother

Mmmm, salmon

Watching Bears in Alaska

By chance, I found out Dad had always wanted to go to Alaska, so I surprised Dad & Caryl (my stepmom) with their first cruise – an Alaska one out of Seattle. We had a wonderful time, saw bears and eagles and whales, oh my.

I took Mom on her first cruise this year, a 5-day one out of Miami. She had a blast (just like I hoped she would), and in 2011 I’m taking her on another cruise for her birthday.

Again this year, I made a point of telling my parents in person how much I love them, and how thankful I am for how they raised me. I’ve learned that I need to do that every single year because I learn something new every year. This year, I found out my mom feels guilty for spanking me. No, Mom, that was not a bad thing, and yes, I deserved it, and it make me a better grown-up. (I’m a big believer in spanking, although it’s easy for me to say in public because I don’t have any kids. Your kids, though, they need a swift slap across the bottom. Especially you, the lady in Oysy the other night. For crying out loud, if you can’t control your damn kids, take them to Chuck E Cheese, not a sushi restaurant. You’re not doing any of us any favors, including your kids.)

I sucked as a brother this year. My sister and her husband are hilarious, and I gotta hang out more with them.

Summary

Looking up at this list, almost none of it was predictable on 1/1/2010. I’ve done annual goals in the past and been nothing but disappointed because life changed my plans along the way. Life kept throwing me curveballs, but because of my GTD 50k foot goals, I was able to knock some of ‘em out of the park.

I do have some things at the top of my to-do list at the moment that I’ll share, though:

  • Build more training material – I’m taking my game up a notch and writing sessions that really make me proud. This maps up to my financial security goal.
  • Get a maid – Paul & Kim have a personal assistant, and seeing her in action, I was sold. I talked Erika into letting us get a cleaning service in for starters. This maps up to me being a better partner, plus enjoying life.
  • Improve my accounting – I’ve been using a web-based accounting package, and I’m switching to Quickbooks. I hate accounting, but as an entrepreneur, you gotta do what you gotta do. Also maps up to my financial security goal.
  • Start podcasting – I’m working on a new way to share my interests with you in an easier, more enjoyable way, and that maps up to me enjoying life and financial security. Stay tuned!

To learn more about GTD, check out how I use 50,000 foot goals.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

My 2010 Blog in Review

Time to take a look back at what happened in 2010.  Turns out I was pretty busy – here’s my favorite posts:

January:

February:

March:

April:

May:

June:

  • I Joined SQLskills – I truly loved what I was doing at Quest Software, and I thought life couldn’t get any better, but as it turns out, it could.
  • Four People Won Free SQLCruises – this just blew me away.  Between the new job and the first SQLCruise, I was tied up for a while, so blogging subsided.

July:

August:

  • GTD: Why Things Have Been Quiet Around Here – when I decided to make the big switch into consulting full time, I was terrified that I’d be eating ramen noodles for the first six months.  As a result, I took every possible gig that came my way, including more travel than I would have preferred.  When I finally figured out I wasn’t going to starve to death, things got a lot better, and my work/life balance returned.
  • Jeremiah Peschka Joined Quest – and a bunch of other people started getting paid for community work in 2010 including Tom LaRock, Aaron Bertrand, Colin Stasiuk, and another player who is yet to be named.
  • Why I’m Disappointed in the PASS Election Process

September:

October:

November:

December:

In addition to the blogging, I snuck in some travel photos:

Whoa.  Looking back at this list, I’m surprised I wrote so many posts that I’m actually proud of, and the second half of the year was especially challenging.  I’m no longer paid directly to blog – as a consultant, I only get paid when I’m billing clients.  I’m blogging now because I really love doing it, and because it helps bring in new clients.  I’m tickled pink every time I get an email saying, “I liked your blog post about ___, and we were wondering if you could help us out with this problem we’re having.”

Blogging: win friends and influence customers.  Remind me again why you’re not doing it?  Oh, that’s right, you’re so busy working for that company you don’t even really like and who didn’t give you a raise again this year.  When you get tired of that, read my favorite post from this year – Rock Stars, Normal People, and You.  There’s a whole community of people who want to see you succeed, and we want to help.  Come join the community in 2011!

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

What I’ve Been Writing Lately

I’m all over the intertubes this month, people.  You can’t avoid me.  I’M ON FIRE!

Virtualization at the North Pole – I scored an interview with Santa’s Chief Information Elf who proceeded to explain why elves are into green computing.

Rob's Thongs

Rob's Thongs

Interview with Rob Farley about PASS Summit Feedback – When the speaker feedback came out, I checked for my own ratings first, and then the second person I looked for was Rob (Blog@Rob_Farley).  Rob’s one of the funniest guys I know, and he’s on my very short list of presenters that I recommend no matter what they’re talking about.  He didn’t make the top 10 – in fact, his sessions were rated in the bottom 1/4!  I talked to him about why that happened, and whether he’s going to change his presentation style.

How to Benchmark Cloud Databases – Jeremiah Peschka taunted me by betting that Oracle and PostgreSQL could outrun SQL Server, and I explain why he’s right.

The State of Virtual Database Servers 2010 – Gavin Payne took a survey of SQL Server DBAs to find out how involved they were in managing virtualization, and I analyzed the results in terms of what I’ve seen in the past.

2011 Predictions from InfoBoom “Experts” – Each of us made our predictions without knowing the others, and when I read the other predictions, I busted out laughing.  We’re all contradicting each other on the cloud.  David Vellante says “Android will continue to gain momentum and become the clear dominant mobile platform” and I completely agree – in the same way that Windows is the clear dominant desktop platform, and McDonald’s is the clear dominant roadside cheeseburger platform.  Android will own the majority of the market, and Apple will stick to the most profitable piece of the market just as they always have.

Caption Contest Results – I ran a caption contest last week for this photo:

Your caption here.

Your caption here.

Some of my favorite captions:

  • “All these Macs and no cheese!” Mike Lynn
  • “I’m going to need more wrapping paper.” HillbillyToad
  • “When the doctor recommended I have an apple a day, I’m not sure he meant THIS…” LadyRuna
  • “In the end, the Apple Patch failed to enable Mr. Ozar to wean himself off his expensive addiction.” Brian Garraty
  • “Yo dawg, I heard you like Apples, So I put apples on your Apples so you can apple while you Apple.” NotAndy (I love the Xzibit reference.)
  • “Brent blotting his lip gloss before heading in to the office Christmas party” Troy
  • “Do you think they will know I stole all the Apple stickers from the iPad’s for the iPad giveaway?” Jason LaVigne (and he’s right, because if I’d have had access to them, I probably would have.)
  • “In my head that story in Genesis had Adam looking more like Russell Crowe…” Tim Ford (see, this is why I love going on cruises with Tim. I refill my one-liner stash.)

But the winner had to be the one who combined my love of Apples with my love of memes:

“One more thing… iBrent. Bam.” Chris

This combines not one, but TWO Steve Jobs jokes – his traditional One More Thing announcement at the end of keynotes, and his use of the word boom to show how fast his products work.  Yes, technically Chris said bam instead of boom, but I couldn’t stop laughing when I read it because I knew exactly what he meant.  For this, Chris wins a swag pack of goodies from Apple and the EFF.

Twelve Days of SQL Results – early in December I kicked off a Twelve Days of SQL blog series thanking the community for all the cool blog posts this year.  Here’s what the bloggers picked:

Enjoy the reading – it’s not like you’re working hard this week.  Slacker.  And no, I won’t be blogging hard this week either, because I’ve got a sleigh-full of posts lined up for January already including how to rehearse presentations, the 3 questions you should never ask software vendors, and how to cancel your Azure subscription.  One more post coming before the end of the year, though: my ginormous 2010 recap.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Christmas Caption Contest

It’s the holidays, and you’re not working that hard anyway.  In the comments, give me your best caption for this photo by midnight GMT on Sunday, December 26th, 2010:

Your caption here.

Your caption here.

I’ll pick the winner on Monday morning and post it here.  The winner gets these stickers, SQLskills stickers, and the EFF prize pack including a t-shirt, hat, and EFF stickers that I got for donating $250 to the EFF to fight blog plagiarism.  Contest limited to US and Canada residents only because international shipping is such a pain in the rear.  If you’re abroad, you can still enter, but you won’t get the prize – I’ll designate an honorary US/Canada winner on your behalf.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

PASS Summit Speaker Feedback

The 2010 PASS Summit attendee feedback just arrived, and I’m very, very honored to have two sessions in the top 10.  Last year, I had one session in the top 10.  Based on the trends of this data, I look forward to the 2019 PASS Summit evals when I will have all 10 of the top 10 sessions.  WORLD DOMINATION, MUHAHAHA!  Well, no, that’s not really likely, because I’m up against some tough competition – my SQLskills cohorts Paul Randal and Kimberly Tripp.

This year, 5 of the top 10 highest rated sessions were by SQLskills.

Last year, SQLskills had 4 of the top 10, and this year it’s even better.  I don’t even know where to go with that.  It’s just amazing.  I’m really humbled, and it makes me want to work even harder for next year to make sure we stay up there.

I’ve already talked to a few other speakers about their feedback, and if you’re a speaker reading this, remember something: it’s an honor to even be chosen to speak at the Summit.

But enough about you – let’s talk about me again.  Here’s the scores and feedback for my sessions, along with my own feedback about the questions themselves.  I used to work for a survey company, so I’m really anal about this kind of thing.

Virtualization and SAN Basics for DBAs (DBA283S)

How would you rate the usefulness of the information presented in your day-to-day environment?

  • Average – 4.76 (out of 5)
  • 5s – 94
  • 4s – 27
  • 3s – 1

I hate this question because it’s not the speaker’s fault.  It’s up to the attendee to choose the right session, and there’s already a separate question asking about the accuracy of the abstract.  Sometimes people want to go to completely irrelevant sessions just to learn – take the cloud or future versions of SQL Server, for example – and it’s unfair to penalize the speaker for talking about futures or esoteric stuff.  I don’t pride myself on getting a high score on this question, and I don’t kick myself for low scores.  I got a really low score on this when I did a cloud session at the Summit last year, but I knew it’d be low because nobody was using the cloud back then.

How would you rate the Speaker’s presentation skills?

  • Average – 4.88
  • 5s – 107
  • 4s – 15

I have a rather goofy presentation style – fast, loose, and casual – and I know it can generate extreme reactions on surveys.  If you sit through a Paul Randal session, a Kimberly Tripp session, and then a session from me back-to-back, you’ll see completely different styles.  There is no one right style for presentations.  You have to find your own voice as a presenter, then hone the bejeezus out of that voice.  I’m proud of this score because it means I’m continuing to refine my approach.

Finding your voice is only part of this score, though – if somebody comes into my session expecting a Paul Randal style of delivery, they’re going to give me horrendous marks.  Before people sit down in my Summit sessions, it helps if they’ve already seen me speak online or at a user group.  If someone sees my session and style online and decides they don’t like my presentation methods, they won’t sit in my session at the Summit either.  The more people see you speak, the higher your scores become on this question.

How would you rate the Speaker’s knowledge of the subject?

  • Average – 4.91
  • 5s – 111
  • 4s – 11

Jeez, I hope so.  I’m a Microsoft Certified Master and I specialize in virtualization and SANs.

But seriously, I think getting a high score here means showing the audience something they didn’t already know.  In the future, I’d like to surprise every attendee in every session with at least one slide.  That’s insanely difficult in the age of blogs, but that’s what it takes to ace this question.

How would you rate the accuracy of the session title, description and experience level to the actual session?

  • Average – 4.79
  • 5s – 74
  • 4s – 41
  • 3s – 5
  • 2s – 2

This is all on me, and it sucks.  I’m completely dissatisfied with this score.  I have to do a better job of crafting my abstracts.  My problem has been that I start by writing an abstract, then I write the deck, then I deliver the deck several times at different places, and I gradually refine the deck over time.  Unfortunately, the abstract reflects the original session because I had to write it so far in advance to get approved for the Summit!  I have to make this work better.

How would you rate the amount of time allocated to cover the topic/session?

  • Average – 4.53
  • 5s – 74
  • 4s – 41
  • 3s – 5
  • 2s – 2

This is where the marketing guy in me comes out: this score is too high.  I have a full-day session on this exact same topic, and I’ve got around 12 hours of material on it.  In my 1-2 hour session on this topic, I go out of my way to emphasize this to the audience by saying things like, “I wish I had a whole day to cover this, but because we’ve only got an hour, I’m going to give you some of the most important topics.”  I want them to walk away saying, “Wow, I wish I could have heard him talk more about this.”

Why?  Because that’s how you sell training.

I want the audience to give horrendous marks on this question and leave comments like, “I wish this session was four hours long.”  For me, that’s a win, because they can pay to hear me talk all day on these topics.  The trick is to get low scores on this question, yet get high enough scores on the other questions to make it into the top ten.  This is one of the reasons I’m amazed I made it into the top 10 this year.

How would you rate the quality of the presentation materials?

  • Average – 4.68
  • 5s – 90
  • 4s – 26
  • 3s – 5
  • 2s – 1

I think the attendees were being generous here.  The only way I can justify this score is because of my resources page approach – I put all of the links on a single page on my site, and keep referring to it throughout the presentation.  Otherwise, I don’t think the deck itself was as good as I’d like, and I don’t have demos for this one.

Attendee Comments:

  • Ran out of copies of handout. – (From Brent: errr, I don’t have handouts.)
  • There wasn’t a question he couldn’t answer.
  • This could have been a 90 minute session. - (From Brent: good answer!)
  • This guy knows how to present and keep presentation topic entertaining and interesting.
  • This was great, thanks!
  • Very direct, personable and funny! Time flew by.
  • Very good introduction with lots of useable information.
  • Very good!
  • Very informitive session and best practicle tips.
  • Very interesting, keeps your attention, very amusing.
  • virtualization isn’t all vnware. Would like to hear a bit on hyperv. – (From Brent: This is where I need to perfect my abstracts. When I first wrote the deck, it was a mix of Hyper-V and VMware, but the attendees *overwhelmingly* tell me they only use VMware, so I gradually phased out the Hyper-V material.)
  • wish it could have been a bit longer, good info.
  • Perfect combination of basic and advanced information.
  • Wish you would have did a day session! Great work!! Really liked the tips! Your session was very useful. - (From Brent: Awesome with the day-session stuff – again, love that.)
  • Wonderful! After seeing Brent’s presentation at 24 hours of PASS I don’t want to miss another mc. He is fantastic.
  • Very informative and love the energy. Happy Birthday and Thank you! Great session.
  • Need to do it a bit louder, we had issue hearing on the last row.
  • Entertaining and educatinal.
  • Loved it. Thanks for the repeat.
  • Could’ve used a longer session on this.
  • Could use more time.- (From Brent: Woohoo! See the trend here? I’m really proud that my evil subliminal messaging worked.)
  • Brent’s sarcasm and wit always keep his presentations entertaining. Good content makes it worth it. Great links from his site also help facilitate learning after the fact.
  • Brent is very engaging and informible. Excellent speaker, very comfortable in front of a large group.
  • Excellent insights.
  • Brent – always impressive!!
  • Awesome presentation and timely as we are in progress with these issues.
  • As normal, nice job!
  • As always, good info from Brent. Thanks for helping new guys like me grow as a DBA!
  • A bit longer, more of SAN details and a longer question and answer period. Thanks!
  • Awesome presentation.
  • Excellent presentation. Best so far.
  • Excellent. Thank you!
  • Fantastic presenter, gave a lot of useful info that I will use when I’m back at work.
  • Loved it.
  • Like drinking from a firehose but in a less painful way. thanks for all the info and links. Now it’s time to go learn.
  • Informative and entertaining, as always.
  • If you can extend the session to 90 minutes that will be great. – (From Brent: Remember when reading feedback that the attendees don’t understand what’s under your control, versus what’s controlled by the conference.)
  • I will highly consider attending any presentation he does with only the topic being my final decision!
  • Have many virtualized servers and would like to understand better.
  • Great!
  • Great tips for SAN
  • Great job! Good lines and good level of detail.
  • Great job!
  • Giving me lots to go back to work and look at.
  • More time. Brent could have spoken for 2 more hours. - (From Brent: Yes, indeed I could, or even several days.)
  • Awesome! Very deep knowledge and great topics.

You’re Not Attractive – But Your Presentations Can Be (PD193S)

I co-presented this with Buck Woody, and lemme just say that he was the best co-presenter a guy could ask for.  He is the reason this session is in the top 10 – I simply couldn’t have done a good job without him.  The bantering back and forth made that session so enjoyable.

How would you rate the usefulness of the information presented in your day-to-day environment?

  • Average – 4.71 (out of 5)
  • 5s – 53
  • 4s – 12
  • 3s – 4

I think the attendees were being generous here.  Realistically, you’re not presenting day-to-day, although we did cover how to communicate things better to your managers.

How would you rate the Speaker’s presentation skills?

  • Average – 4.93
  • 5s – 67
  • 4s – 1
  • 1s – 1

I got such a laugh out of the person who said “1.”  Awesome.  But really, this score is kind of self-fulfilling: if you choose to attend a presentation about how to present, odds are you’re going because you admire the presentation skills of the presenter already.  If somebody thinks Buck and I suck at presenting, they’re not going to come to our “how to present” session because they don’t want our advice.  This is a high score, but I’m not particularly proud of it.  I’m not saying I’m not proud of the presentation we did – I had a hilariously good time with Buck – but the score isn’t an indication of our presentation skills.  The real score here is the number of people who attended, and I’m proud of that.

How would you rate the Speaker’s knowledge of the subject?

  • Average – 4.93
  • 5s – 64
  • 4s – 5

We’re really good at faking it.

How would you rate the accuracy of the session title, description and experience level to the actual session?

  • Average – 4.90
  • 5s – 62
  • 4s – 7

Compare this to my score on the virtualization & SAN presentation and you’ll see why I need to work on my abstracts.  Buck and I wrote this abstract specifically for this one presentation, and we never honed the deck.  The abstract exactly lined up with the original deck.

How would you rate the amount of time allocated to cover the topic/session?

  • Average – 4.74
  • 5s – 53
  • 4s – 15
  • 2s – 1

The funny thing is that Buck and I finished the material after 30-40 minutes, and we riffed for the rest of the time.  The only reason we scored well here is because of great attendee questions that let us elaborate.  If we didn’t have a fired-up, friendly audience, we’d have bombed here.

How would you rate the quality of the presentation materials?

  • Average – 4.72
  • 5s – 56
  • 4s – 10
  • 3s – 1
  • 2s – 1
  • 1s – 1

I think the audience is being generous here too, because our slides were just a handful of pictures.  We wanted you to focus on us, not bullet points, and we wanted the flexibility to go off on tangents.  It worked for us, but if someone else took our deck and tried to read it without attending the session, they’d be disgusted.

Attendee Comments:

  • So engaging
  • Smile :)
  • Simple, good and effective.
  • Some examples of good power point and other presentation materials.
  • ran out of time. - (From Brent: Wha? We finished early!)
  • perfect
  • not just a good show-but great content as well.
  • Not as focused on tips to improve presentations as I expected- based on title.
  • No new information-but good refresher and well presented.
  • Ppt was not very inspiring-presentaion depended the skillsof the presenter-if you’re not a charismatic speaker, not much to help you out. – (From Brent: that’s completely fair.  I would argue that there are no good speakers that don’t have charisma.  Charisma is not optional for great presenters, and that’s why we explained that you HAVE to go to something like Toastmasters.  PowerPoint slides alone can’t carry you to the top.)
  • Speakers were in shadows-lighting could be improved. - (From Brent: That’s to protect us from the snipers.)
  • Very entertaining!! Thank you!!
  • “The talk is excellent with very practical tips.
  • I wished you could include some of the info as bullets – (From Brent: I’ve got your bullet right here.  Just kidding.)
  • You answered the one nagging question I’ve had for ALL my presentations; Don’t read your bullets. Thanks :)
  • wish it could go on and on and on
  • Wasn’t sure what to exactly to expect coming into this. I have great struggles with telling a story with data (lots of data and sometimes there really isn’t a story). I think some of the referencs that you cited may deal with that. I enjoyed the presentation a great deal. Thanks! – (From Brent: Edward Tufte‘s stuff is fantastic about lots of data, and he explains that there’s always a story.  One of my favorite examples is on pages 56-57 of Envisioning Information when David Hellerstein explains the economics of health care by telling the story of just one receipt.)
  • Very polished speakers, their lifetime of presentation work shows.
  • very pleasant speaking voice.
  • Very informative session!!! Thanks.
  • more time would have been ok.
  • very entertaining and usefull at the same time.
  • Very engaging-high energy, funny.
  • trololololoooooooo!!
  • Thought it would just be funny with some good tips, but it was incredibly useful. Even for daily life. NOt fjust for when presenting. (and of course it was very funny as well).
  • Take a Bow!!!
  • I am a budding/new speaker for pass events (chapter/SQL Saturday) and trying to find my “groove” this session was really helpful.
  • “*phenominal & absolutely excellent.
  • *Ver applicable to everyone.”
  • Great tips-the wacom/draw your preso is priceless.
  • Fabulous, excellent conversational
  • Excellent ideas for improvement and ideas to get audience involved and engaged!
  • Excellent coverage of how to prepare a preso. Great tips on how to tell stories, final pics. When to use power point? Good stuff. How many times to reherse. Where does he come up with his retorts? Great!!!
  • Entertaining, lots of content. Thanks!
  • Do you think Dora the Explorer is an excellent presenter?
  • Both guys are the top of the heap.
  • Awesome!!!!
  • Awesome presentation, funny and inforative.
  • Awesome presentation – would love a longer session discussing methods and stlyes.
  • Amazing, funny
  • You guys suck. :)
  • Fun with lots of good info.
  • “Great way to end the day.
  • Good info presented quickly and to the point while still entertaining.”
  • Fun, informative and more fun on many, many levels.
  • getr the point across and entertaining also.
  • Great Team!
  • Great Presentation
  • Great Job!! Thanks
  • Great information. Appreciate the tips. Really want to someday (soon) apply them or at least pass them on. Great audience questons.
  • Great info as I start doing more demo’s/ presentations.
  • Great ideas, suggestons & links.
  • Great humor and great points.
  • Great deck.
  • Good, fun presentation, but hard to say how much information will help improve attendee’s presentation. Nice way to wrap up the day.
  • Good Stuff
  • Good Detail. Very much enjoyed the follow up as well. Looking forward to using this on my execs.
  • Funny and extremely relevant. Great job!!!!
  • You guys sucked. Thanks!!! :)

What a way to finish up the year.  Thank you so much for filling out your evaluations, and I’m humbled by your appreciation for what I do.  I have a great time doing this stuff, and I’m amazed that I get to do this stuff for a living.

Want to See More of My Presentations?

I’ve got 1-hour videos available online for free, plus links to day-long and week-long sessions I’m doing in 2011:

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Jeremiah Peschka & Buck Woody Talk Database Communities

Two of my favorite members and best speakers in the SQL Server community have made big changes – they’re refocusing their careers and their community work outside of SQL Server.  Is it the beginning of a trend?  What’s going on in the NoSQL and cloud database world that’s so attractive to these guys?  I interviewed them to find out.

Brent Ozar and Buck Woody

Me, Buck Woody, and the coolest quilt ever.

Buck Woody (Blog@BuckWoody) has worked for Microsoft since 2006, and until recently, he was our Inside Man – a fighter for the SQL Server data professional.  He switched roles over to the Azure team a couple of months ago.

Jeremiah Peschka (Blog@Peschkaj) joined Quest Software this year as a sort of technology evangelist, working with NoSQL and cloud databases.  Prior to that, he’s worked with SQL Server as a developer, database administrator, and consultant.  He just resigned from the PASS Board of Directors to spend more time working with the NoSQL communities.

Brent: Question 1. WHAT, SQL SERVER ISN’T GOOD ENOUGH FOR YOU?  Okay, well, if I’m honest, it isn’t good enough for me either, because there’s always more stuff I wish it did.  But what is it about these other database movements that excited you enough to focus more on those?  Give me your elevator pitch.

Buck: No – it isn’t good enough :) . But then, nothing ever is when you’re a curious person – and I’m one of those! I feel that utility-based computing is inevitable, and it’s all just data anyway – so Azure was a slam-dunk for me, a natural progression in my career. The tougher part was actually getting the position, since lots of really smart folks at Microsoft wanted the job. But I have those pictures….

Jeremiah: I’m excited because these new databases focus on one thing and doing it well. They each scratch a particular itch. SQL Server is a great general purpose database, but there are some things it doesn’t do very well – batch processing, massive parallelism, and scale out.   Many of these databases build on the skills that developers already have (object-oriented programming) to create complex solutions for ETL, analytics, and distributed storage – they’re good frameworks for complex tasks.

Brent: You’ve both been transitioning away from SQL Server for a few months.  What’s the state of these new database communities?  What are they like compared to the SQL Server community today?

Buck: Vague, undefined, and unordered. No, wait, that’s the cloud! So of course the audience mimics the product structure. Since Azure is essentially an online operating system that you write almost any code you want against, the users have a huge – I mean absolutely huge – range of skills, ages, interests and so on. So the community isn’t anywhere near as defined as SQL Server is. Not only that, it’s a new product, so the community hasn’t had time to define itself. I think over time we’ll get enough vertical interest groups that communities will form. It will just take time.

SQLSaturday Chicago

Me, Aaron Nelson, and Jeremiah Peschka at SQLSaturday Chicago

Jeremiah: The emerging database communities are very young right now. It’s difficult to figure out which databases will stick around for a while, but the communities are vibrant, changing, and open to new ideas. There’s a lot of energy, enthusiasm, and passion. People want to share what they know.

Brent: What can the SQL Server community learn from the NoSQL and cloud communities?

Jeremiah: The biggest thing that I’ve had to re-learn is that it’s important to look at every problem fresh and evaluate all of the options available before determining what to use. Sometimes it only needs to be a cursory glance, but other times it’s worth really examining what’s going to be happening and figuring out the best solution for the problem.

Buck: Agility and adoption, and focus on solving a problem, regardless of the technology. I don’t see nearly the stratification of the developers as data professionals, and the developers seem very willing to try anything new, as long as it solves their problem. They are also ready to move to the latest technologies.

Brent: How far away are we from the time when European or financial customers can adopt these new technologies?

Jeremiah: A number of European and financial customers are already using a variety of NoSQL databases. Booz Allen Hamilton are providing consulting services around Hadoop and Bank of America is also using Hadoop. a number of companies are using other NoSQL databases – ComCast are using Riak, and the New York Times and Intuit are using MongoDB. There are a bunch of NoSQL conferences happening in Europe – NoSQL:EU and Business Cloud 9.  I think that some aspects of cloud computing are further away in Europe due to EU regulations, but I could be wrong. I’m not as familiar with cloud databases as I am with the NoSQL space.

Buck: They are doing it now. In fact, after I type this I’m off to meet with a financial firm on their latest Azure application. It’s moving faster than most people realize, to Azure, Google, and Amazon.

Brent: If I wanted to keep an eye on the databases you’re working with, what are the top few blogs I should check out?

Jeremiah: I’d keep your eye on the NoSQLPedia blog aggregator, for starters. We’re adding more people on a weekly basis. Outside of that site specifically, things are still pretty fragmented at the moment.   In general, I watch Lars George for Hadoop and HBase news, the Basho blog for Riak, MongoTips and Snail in a Turtleneck for MongoDB news, Planet CouchDB for CouchDB, antirez.com for Redis, and http://facility9.com (of course) for my take on the entire thing.

Buck: I tend to like http://blogs.msdn.com/buckwoody :) , but anything Wayne Walter Berry writes is tres-awesome.

Brent: If – okay, when – I talk to you again in a year about you’re doing, what do you hope to have pulled off?

Buck: A significant growth in the “Azure Marketplace” – a site where you can sell your Azure “Apps” to other devs or even end-users. I’d like to see that thing eventually become the iTunes of the cloud.

Jeremiah: I want to see people actively using hybrid database solutions in their production environments. If I hear about someone using SQL Server for their RDBMS, Hadoop for batch processing, Hive for analytics, and Riak for caching and data distribution, I’ll be a very happy guy.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Who Won an iPad and @RedGate SQL Monitor?

And now, the moment we’ve all been waiting for.  The select statement, please:

I See Angry Birds In Your Future

I See Angry Birds In Your Future

Congratulations to the lucky winners, who will each get an Apple iPad 16GB with 3G and Red Gate SQL Monitor!

I’d like to thank Red Gate Software for making this contest possible and making our holiday spirits bright.  Reading everybody’s thoughts about where they’d go if they didn’t have to worry about their SQL Servers gave me a lot of laughs.  The holidays help us refocus on what really matters: our friends and family.  We work hard so that we can enjoy our time with them, and anything that can help me relax and let go of my 9-5 work, I’m all over it.

Grant Fritchey picked 10 winners who identified their most common causes of server outages, and Steve Jones picked 10 winners who talked about things they could do better with a tablet.  Happy Holidays everybody, and enjoy your new iPads and SQL Monitor.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Happy One Year Anniversary, #SQLHelp!

One year ago today, #SQLHelp was born. Aaron Nelson (Blog@SQLVariant) had the brilliant idea to set up a hash tag on Twitter that anyone could use whenever they had a question.  I thought it was sheer genius, so I explained how to use #SQLhelp on my blog, and it took off.

These days, I love watching questions – and answers – trickle through #SQLHelp at all hours of the day.  It’s just another example of how the SQL Server community is vibrant, helpful, and everywhere.

If you’re on Twitter, join me in thanking @SQLVariant not just for #SQLHelp, but for everything he does for the SQL Server, PowerShell, and SQLSaturday communities.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

SQLskills MCM Videos: Behind the Scenes

A few weeks ago, Microsoft unveiled changes to the Microsoft Certified Master (MCM) of SQL Server program and showed off new free video training materials by SQLskills.  I was curious to hear what the community would think about the new certification and our training materials.

Jason Strate (Blog@StrateSQL) was the first to blog about trying to pass the MCM.  There’s two parts to the MCM test now: a written multiple-choice exam, and after passing that, a six-hour hands-on lab exam.  Jason didn’t pass the written exam the first time, and I applaud his honesty in blogging about that.  It’s valuable for readers because you need to look at Jason’s credentials before making a run at the exam yourself.  I usually recommend that senior DBAs just “Iron Man” the MCITP exams – take the exams without studying, then decide what areas of your knowledge need some improvement.  I don’t recommend that at all for the MCM exam; spend some time – or a lot of time – going through the training material first.

The easiest way to get started is by watching the free training videos we recorded.  I shamelessly copied (plagiarized?) Paul’s opening line of his videos: “(These videos) are not a replacement for the experience you’ll need, but they will show you the breadth of material you’ll need to know, and the depth to which you should know it.”  Candidates can watch all 40 hours of training videos and still not be ready for the exam.

For example, my SQLOS video is 30 minutes long.  I just can’t teach SQLOS concepts in 30 minutes – Gert Draper’s SQLOS talk consumed 4 hours when I was at the MCM – so I had to pick specific areas to cover.  Rather than trying to do justice to CPU scheduling, memory management, and SQLOS’s services, I focused just on CPU scheduling. If you watch the video, you’ll see how deep you need to go on CPU scheduling, and you’ll see the other parts of SQLOS that you need to research on your own.

Recording those free training videos proved way more challenging than I’d expected.  How much could I assume that the audience already knows?  If I only had 30 minutes to cover a particular topic, I didn’t want to waste time on something most senior DBAs already knew.  The MCITP DBA and MCITP Database Developer are prerequisites for the Microsoft Certified Master program, so I assumed anything MCITP-testable was too basic.  However, the MCM requires knowledge of things outside of the MCITP, like virtualization.  How much should I assume that the viewer already knows about virtualization?  Should I define the terms “guest” and “host” or just skip right past that?  I found myself thinking about my SQLcruise attendees.  I thought, “Would Dave Levy know this?  Would Crys Manson know it?  Is this something Yanni Robel has talked about?”

After the first round of videos went live, I gritted my teeth and braced for the feedback.

Nothing came.

The silence reminded me of what happened when we published our book.  I had expected a furious roar of people pointing at various lines in the book, yelling, “THIS IS BOGUS!  THIS IS ALL WRONG!”  Only one or two bug reports trickled in over time, and in the quiet, I wasn’t sure if people were getting any value out of the book, or if maybe, just maybe, we got everything right.  In the year since we published the book, I’ve gradually heard good things from readers, so I know it worked out well.

We slowly started getting feedback.  Andre Kamman sent me an email questioning something I’d said in the Baselining & Benchmarking video.  I’d said Page Life Expectancy can drop during backups.  I’ve seen that happen time and again during my career, and it’s why I discard memory statistics from times when backups are running.  Unfortunately for me, Andre is one smart fella (and a gentleman, one of the many great people I love seeing at SQLbits) and he also included a link to a Paul Randal blog post saying PLE isn’t affected by backups.  Uh oh!  So now I have to do some rigorous testing to prove that out – I’ve got a hunch that it’s caused by the third party backup software I use, which consumes memory during backups, and might be putting SQL Server under memory pressure.  It shouldn’t, but…

From that point on, as I recorded MCM videos, I kept rerecording the same slides trying to make sure I didn’t misstate anything.  My regular speaking style is very fast, loose, and animated.  I jump into impromptu soliloquies on a topic, thinking of new ways to explain stale topics, and this carries a huge risk with recorded videos – especially those with a big audience.  The PLE quote was a great example, because I spoke off the cuff trying to explain reasons why PLE usually drops.

Turns out that even just mentioning Page Life Expectancy and possible thresholds for it is fraught with peril.  Someone posted a completely misleading blog entry about why PLE should be exactly 300 – which is wildly incorrect – and that led Paul to imply that there’s no such thing as a threshold for PLE.  I agree that there’s no black-and-white good/bad number, but the lower PLE gets, the more turnover you’re experiencing in memory.  That doesn’t necessarily mean your server needs more memory, and in fact, buying more memory may not be the best way to improve performance.  The classic example is a query doing huge table scans because someone added an additional field to a commonly used report, and the query no longer uses just a covering index.  Adding the new field to the index (or removing the field from the report, ha ha ho ho) might improve performance more than adding memory.

At the MCM level, there’s even religious wars about which terms to use.  The term active/active clustering refers to a SQL Server cluster where multiple nodes are running active instances of SQL Server on each node – but so does the term multi-instance clustering. The term multi-instance is more technically correct, but it’s not a commonly used term – the market standardized on active/active clustering a long, long time ago.  I used the more common wording in my clustering video, but I took pains to explain why that term (as well as the term shared-nothing clustering) is misleading.  Geoff Hiten, a clustering MVP that I very highly respect, took me to task for using the misleading term.  He’s totally right in that multi-instance is better, but that wasn’t an objective I wanted to pursue in the MCM videos.

You know the drill with SQL Server answers – it depends.  As much as we try to clarify points in the videos, there’s always going to be contentious points that people will debate.  To help facilitate that, Microsoft is putting together a forum where viewers can discuss questions and MCMs can offer guidance.  In the meantime, feel free to email the presenter of each video directly with your questions.  Please email us, rather than tweeting, because the 140-character Twitter limit doesn’t do justice to questions or answers.  If you’d like to crowd-source your question before the forum goes up, feel free to post programming questions on StackOverflow and admin questions on ServerFault.  That way, you can elaborate in detail on your question, and we can get lots of brains involved.  You can then tweet a link to your question with the #SQLhelp hash tag to get the Twitterati’s attention.

Finally, I’d like to give you one more point of contact.  Joe Sack (@JosephSack) leads the SQL MCM program.  He’s put in endless hours to help craft the entire experience.  He listens patiently to feedback, takes action, and believes in doing the right thing for everybody involved.  He’s been the driving force between getting the tests right, getting the testing facilities to obey the rules, and what might even be my favorite thing of all, getting freely available MP4 versions of these videos available for download from Microsoft.  No matter what kind of device you use, there’s free SQL Server training videos available for you right now.

Happy learning, and good luck with your exams!  If you pass the written test (and even better, the lab), please let me know – I’d like to congratulate you personally and interview you.  I know the rest of my readers would love to hear your MCM story.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Giving Away 10 Apple iPads and Red Gate SQL Monitor!

You need to relax and get out more.

We SQL Server DBAs are constantly checking that cell phone, worried about that email from a user saying, “The server is borked.”  When it comes in, we drop everything, run to the nearest laptop, and try to figure out just how bad things are and if they’ve gone back to normal.

You’ll be more relaxed on the weekends if you can do these two things:

  • Find out before the users find out
  • Be able to check health from anywhere

There’s a web app for that – Red Gate SQL Monitor.  It sends you emails when things start to go pear-shaped, and then you can whip out your trusty iPad to check your server’s health and stats from anywhere.  You can see it live now by going to http://monitor.red-gate.com, which shows SQLServerCentral’s database servers.  (You don’t have to log in, but of course you’d use the built-in username/password security for your own SQL Monitor web site.)  A few screenshots:

Red Gate SQL Monitor Dashboard

Red Gate SQL Monitor Dashboard

Host Machine Stats

Host Machine Stats

SQL Server Instance Statistics

SQL Server Instance Statistics

SQL Server Error Log

SQL Server Error Log

All from your iPad, anytime you’re within range of WiFi or a 3G cellular signal.  You can stop worrying about what your server’s doing, and start being present with your family, your friends, and your hobbies.

What’s that?  You don’t have an iPad?

Red Gate wants to fix that.  They’re giving away 30 prize packages, each with a 16GB 3G iPad and a license to Red Gate SQL Monitor!  I got 10 to give away, Steve Jones is giving away 10, and Grant Fritchey is giving away 10, but you can only enter in one of our contests.  To enter for mine, all you have to do is post a blog comment below and tell me where you’d go if you didn’t have to worry about what your servers are doing.  The deadline for entry is Friday, December 17th, 2010, and then we’ll pick 10 random lucky winners to be announced on Monday, December 20th, 2010.  (And if you win, you owe me a picture of yourself monitoring your SQL Servers with your new iPad!)

Here’s the fine print:

  1. The contest is open to professionals with SQL Server monitoring responsibility. Entrants must be 18 years old or over.
  2. Entries must be received by Friday, December 17, 2010. The contest organizers accept no responsibility for corrupted or delayed entries.
  3. Employees of Red Gate, the contest organizers and their family members are not eligible to participate in the contest.
  4. Entries are limited to one per person across the three simultaneous contests hosted on www.SQLServerCentral.com, www.BrentOzar.com, and www.ScaryDBA.com.
  5. The organizers reserve the right, within their sole discretion, to disqualify nominations.
  6. The organizers’ decisions are final.
  7. Red Gate Software and those involved in the organization, promotion, and operation of the contest and in the awarding of prizes explicitly make no representations or warranties whatsoever as to the quality, suitability, merchantability, or fitness for a particular purpose of the prizes awarded and they hereby disclaim all liability for any loss or damage of any kind, including personal injury, suffered while participating in the contest or utilizing any prizes awarded.

So whatcha waiting for?  Leave a comment for your chance to win or check out the contests on Steve Jones’ blog and Grant Fritchey’s blog!

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube