Tag Archive: pass2008

PASS Board of Directors Election Update

PASS has posted the list of candidates, but there’s no bio info yet.  Fear not – the community is doing a great job of not just keeping up, but getting ahead!  I love communities in the age of social networking.

TJay Belt is doing a great job of centralizing information about the candidates for PASS Board. Check out these two posts:

Bookmark those pages and check them before you vote – I’m sure they’ll be updated as more candidates blog their answers.  Andy Warren just posted a fantastic article about why he wants to be on the PASS Board that’s really worth a read.

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

Breakfast event at PASS on Thursday – still seats available!

Repeating this post from last month because I found out there’s still room available:

This year at the PASS Summit in Seattle, Quest Software is sponsoring an expert panel event on automating SQL Server processes. Sounds boring, right? Think again – here’s when you need to check out process automation:

  • You can’t hire help (either no budget or no available people) and you can’t keep up
  • Your number of servers keeps growing
  • You don’t know if every server got backed up in the last hour
  • You don’t have an index maintenance plan for rebuilds & defrags

I’m always amazed that Microsoft SQL Server has been around for so long, but there’s very few standardized automation scripts. So many of us have our own duct-taped SQL Server backup T-SQL scripts, have disdain for the built-in maintenance plan approach, and would never think to Google for an automation script instead of rolling our own.

The experts with their fancy opinions:

  • Allen White, SQL Server MVP and Trainer for Scalability Experts (moderator)
  • Kevin Kline, SQL Server MVP and Technical Strategy Manager, Quest Software
  • Buck Woody, Program Manager, SQL Server, Microsoft
  • Dan Jones, Product Manager, SQL Server, Microsoft
  • Thomas LaRock, Database Engineering Lead, ING Investment Management
  • Charley Hanania, Production Product Owner, SQL Server, UBS
  • Brent Ozar, SQL Server Domain Expert, Quest Software

Why am I on the list? Because I, for one, welcome our new robot DBA overlords.

When: Thursday, November 20, 2008
7:00 – 8:30 a.m. (breakfast served until 7:30)

Where: Seattle Convention Center
Room 613 (6th floor)

If you want the free eats, you gotta RSVP online for the event. Afterwards, let’s track down the nearest open establishment for some Bloody Marys. (I kid, of course. They don’t have to be open. There will be enough of us to storm the doors.)

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 endorsements for the PASS Board

When I was a DBA, before I got this “rock star” job, I didn’t have the time to get involved enough with the SQL Server community to really know the people running for the PASS Board.  I had a “real job”, and when I cast my vote, I was basing my decision off a paragraph or two of information about the candidate.

Now that I have a “fake job” where I get to spend time in the SQL Server community, I have the time to get to know more people.  If I was you, and I had a “real job”, I would want to hear a personal opinion about the candidates.

So here’s who I’m voting for:

Tom LaRock, aka SQLBatman.com

Tom LaRock - Upgrade You Can Believe In

Tom LaRock - Upgrade You Can Believe In

Yes, I just outed SQLBatman on my blog, but if I was a voter, I’d want to know the man behind the mask.

Tom is funny as hell, as evidenced by his virtual campaign poster.  I first met him at a Quest event for customers, and we hit it off right away.  Everybody found it easy to talk to Tom – he’s a natural conversationalist – and to me, that’s really important in a SQL Server community leadership position.  You want a person in there who you can just walk right up to, start asking questions, and get relaxed, funny answers.

He ran into problems with one of my favorite Quest products, but he didn’t just say, “This thing is borked” and throw it back at us.  He took the time to trace the SQL the product was running, look at how it was working, and suggest a couple of indexes that would improve performance under load.  He implemented it on his own lab systems, tested it, DOCUMENTED it, and passed it on to us.  He documented it.  Think about that for a second.  How many of us write documentation on our OWN stuff, let alone a vendor’s?!?

His attitude shows in his written communications, too.  Check out Tom’s Twitter stream.  Regardless of whether or not you use Twitter, you have to appreciate how involved he is with other SQL Server professionals, and how easy he is to work with.

That right there – the Twittering and blogging – are big reasons that I’m endorsing Tom LaRock for PASS Board.  I think it’s important for the future of PASS that we bring more DBAs closer together because it gets our SQL Server questions answered faster and makes our jobs easier.  At the end of the day, that’s why I get involved with the community – to help other people get their jobs done easier – and I think Tom does too.

When Tom told me he was running, I asked him a few questions about why he was running, whether or not he’d have the time, and so on.  We had so much fun that he asked if he could combine the emails into a blog post about why he’s running for PASS Board.

Douglas McDowell, Solid Quality Mentors

Disclaimer: I’ve never met Douglas in person, only over the phone.  He may smell like a Newark telephone booth on a hot day.  I reserve the right to revoke this endorsement should I determine that to be the case.

I first interacted with Douglas only recently – when we asked him if he’d like to be the BI Editor at SQLServerPedia.  Of course we picked him for the quality of his work and his track record with the SQL Server community, but that’s not why I’m endorsing him here, because all of the nominees have awesome track records.

I’m endorsing Douglas because of a skill he’s repeatedly demonstrated in every interaction we’ve had: the ability to quickly dissect topics he doesn’t normally deal with, find the problems, and communicate them in a non-threatening way.  He really displays an analytical mind that doesn’t just try to comprehend what you’re saying, but what you’re NOT saying, and what made you come to your conclusion.

That’s important to me in a PASS Board member because board members have to deal with a lot of ideas coming from every direction.  It can be an exhausting job of taking suggestions that might be brilliant – or really crappy – and they have to figure out the right direction to take the SQL Server community.  That’s why I’m voting for Douglas.

What About The Other PASS Board Candidates?

They’re awesome.  Seriously.  There’s nothing negative I can say about the rest of the nominee list – these are all people who devote their time to educating and serving the community.  There’s other people in my circle of friends that are going to vote for other people.  I know Andy Warren’s gathered a lot of buzz, and very rightfully so – read Andy’s blog entries about the PASS process, and you have to love the transparent approach he takes with it.  There are a lot of good people who want to help others by serving as a PASS Board member, and we have the luxury of choosing from great candidates.  (Sure beats the political elections I’m used to.)

If I had something negative to say about any of the candidates, believe me, I’d say it.  Don’t believe me?  Go search the web for SQL Server 2008 sucks and see who comes up.

How to Vote for PASS Board Members

Check out this page explaining the PASS Board of Directors election process. If you get an email, vote.  If you’re in Seattle for PASS, swing by the voting kiosks.  But whatever you do, vote, because it really does make a difference – last year, the difference between winning and not was 13 votes.

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 would you ask Microsoft and PASS?

What if you could sit down with these guys and ask ‘em any questions you wanted:

  • Tom Casey, Microsoft SQL Server BI General Manager. Tom’s giving the Thursday keynote about SQL Server’s business intelligence strategy beyond SQL Server 2008.  My guess (and this is only a guess, not based on any behind-the-scenes info) is that he’ll be talking about Kilimanjaro, the next feature pack for SQL Server, that starts to really empower BI users in Excel.
  • Wayne Snider, PASS Board President. He’s written books, he’s an MVP, and he’s the head honcho for the Professional Association for SQL Server community.
  • Bill Graziano, PASS Board Vice President of Marketing. I haven’t met Bill yet, but even if he was a hobo on the street, I’d have a special home in my heart for him because of the way PASS is giving so much access to bloggers at this year’s summit.

Well, speaking of that blogger access, it happens that I’ll have a chance to sit down with these guys and talk shop during the PASS Summit in Seattle next week. Normally, my hard-hitting interview style consists of questions like “What are you drinkin’?” and “Are you ready for another one?”  For these interviews, though, I’m pulling out all the stops, so I’m asking you, dear reader, what you would like to ask them?

Not to tip my hand too much, but here’s some of the things that have popped into my head so far:

  • To Tom: “Power users love Excel spreadsheets because they have absolute control over the data.  DBAs hate Excel spreadsheets because they have zero control over the data.  Is there a roadmap to make Excel sprawl management easier?”
  • To Wayne: “If you could wave a magic wand and change something about the SQL Server community, what would it be?  What problems do you really struggle with at PASS?”
  • To Bill: “What are you drinkin’, and are you ready for another one?”  No, just kidding.  I can’t give him a free pass even if he gave me one, so I’d probably ask, “PASS’s embrace of bloggers was fantastic this year.  How else is PASS changing to embrace social media?”

Help me out – what would you ask?

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

Live-blogging the Seattle PASS Summit Keynotes

Whoa – I’ve hit the big time!  I got an email inviting me to be one of a handful of SQL Server industry bloggers who’ll get reserved seating with power and internet access during the PASS Summit keynotes.  Awesome!  That means I’ll be able to post live updates via my Twitter feed and here on the blog.  (Maybe Ustream too, but no promises.)

Last year was my first PASS summit and I did my best to convey as much information here in my blog recaps as I could for people who couldn’t attend.  I knew I was really lucky to get the expenses approved and get the week off to go to Denver, and I was in the minority.  This year, things aren’t any better for a lot of us: travel budgets have gotten slashed, and it’s even harder to get travel approved.  This year, thanks to the PASS staff, it sounds like I’ll be able to post my updates even faster live from the keynote.

I love it.  When I find out who thought of this, I’m gonna buy ‘em a beer.

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

Travel Tips for Non-Frequent-Flyers

To my readers who are traveling to one of the upcoming fall conferences, here’s a few of my favorite travel tips.

Use SeatGuru.com to get the best seat.

I’m not talking about first class versus coach – even in coach, not all seats are created equal.  Every plane has some surprise seats that have more room or different setups.

SeatGuru has maps of every airplane flown by every airline.  Call your airline or check online to find out the exact make & model of plane you’re flying and then pull up that map on SeatGuru.  The seats are color-coded by comfort level.  Hover your mouse over your seat, and you’ll see detailed notes about the comfort level of that particular seat.

Then, with that map up on your screen, call your travel agent or go to your airline’s web site to change your seat.  You can sometimes do this online even when it’s too early to check in for your flight, and the earlier you do this, the better your chances are for getting a good seat.

I’m typing this from the comfort of a Continental Embraer RJ-135, seat 12A.  It’s an exit row seat with no seat on either side of me, so I have plenty of space in front of me for my legs, and plenty of space on either side for my arms.  It didn’t cost me any extra – I just went to Continental.com and tweaked the seat on my reservation.

If you don’t find a better seat, don’t give up: check again exactly 3 days and 2 days before departure.  Airlines automatically upgrade their elite frequent fliers to first class for free at those times, and guess what – that means their seats in coach are suddenly empty.  These people are exactly the kinds of people who usually know to grab exit row seats and those “special” seats with more room, so you’ll find these seats opening up again.

No assigned seat?  Check in online ASAP.

If your airline reservation doesn’t show an exact seat number, your flight may be overbooked.  Airlines routinely overbook flights because not everybody shows up for a flight.

Go to your airline’s web site and try to check in right now.  You won’t be able to, but it will tell you when the flight checkin will open up.  Set yourself a reminder to check in at that date/time.  The earlier you check in, the more likely that you’ll get an assigned seat.  The later you check in – well, let’s just say you don’t want to get a miserable $100 air travel voucher in exchange for being late to PASS.

Thinking about taking a late flight for a voucher?

Think again.  Those travel vouchers usually have blackout dates, and the blackout dates are like “Valid only for trips with a Saturday stay on the third week of the month.”  If you really want to risk it, then talk to the airline staff before you volunteer the seat.  Ask whether the voucher has any restrictions at all, and ask them to show you one of the vouchers.  If it says anything about “Only valid for fare code X”, there’s a catch.

Not a frequent flyer?  Find someone who is.

If you only take one or two flights a year, and you’re not a member of any frequent flyer clubs, talk to people in your company who are frequent fliers.  Ask them if they want your miles for this trip.  If you’re doing a cross-country flight like Florida to Seattle, they might be willing to take you out to lunch and dinner in exchange for those free miles.  You just have to call the airline and tell them that you want to add your frequent flier number to your reservation, and give them your buddy’s account number.  There IS such a thing as a free lunch.

Leave a tip for the hotel maid on your pillow.

Hotel maids make minimum wage, and it’s common to leave them tips.  Some folks only leave the tip on the day of checkout, but I prefer to leave a tip daily because the same maid may not clean your room the entire time – they do get days off, ya know.

Also, make it as easy as possible for the maid.  Use just one trash can if you can, and dump your used towels in a single pile on the toilet seat (with the seat closed, speedy).  It’s less bending over for them.

Things to ask vendors and peers

Ahead of time, make a list of projects you’re working on, new products you want to implement, or large challenges that you’re facing.  Write this stuff down now, because you won’t remember it when somebody asks, “Do you have any questions?”  Us humans are terrible at that.

This is just my personal opinion, but I say do NOT ask tech support questions at a conference.  Tech support people aren’t usually the ones sent to conferences.  If you want support, call the support line.  If you have large architecture questions, implementation ideas, or tips and tricks, then you’ll find good answers at a conference.  If you’re getting error 0×8004005,search the web.

Things to bring to the conference

Here’s a list of things you may not think to bring along:

  • A small, light extension cord or surge strip.  There’s never enough outlets, especially at tech conferences.  If your laptop has a two-prong electric adapter, try to use a two-prong extension cord too, because not all outlets have three prongs.
  • An extra laptop battery.  It ain’t cheap, but if you want to take notes during the sessions, it’s easier if you don’t have to fight over power outlets.
  • Business cards.  If you have a personal web site you want to promote, or if you use Twitter, order business cards now.  They’re surprisingly inexpensive if you’re doing simple text with no logos – like $10 for 250-500.  I order a set just for conferences that have conference-relevant information like my work email, personal email, Twitter link, web site links, etc, but not mailing address.  (Nobody at a conference wants your snail mail address, although you can put city & state if you want an icebreaker.)

Set up your phone or PDA with my Twitter link

If you’re going to the PASS Summit 2008, bookmark these two links now on your phone or your PDA:

During the conference, I’ll Twitter whenever I find out about after-hours events, dinners, meetups, or spontaneous meetings during the day.

I remember what it was like going to PASS 2007 as an attendee who didn’t know anybody – man, it was tough to find out what was going on!  I ate lunch and dinner by myself most of the time.  Let’s face it, us DBAs aren’t always the best party people.  (Except for the PASSCamp Germany guys, they know how to put on a party!)  Now that I’m an insider (woohoo!) I’ll share the knowledge to get you folks into the action.

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