Tag Archive: sqlpass

Travel Tips for Non-Frequent Flyers

If you’re traveling to one of the upcoming fall conferences, here’s a few of my favorite travel tips – as inspired by Kevin Kline’s recent travel tips post.  (If some of these familiar, it’s because I originally ran parts of it last fall before the conference season.)

Use SeatGuru.com or SeatExpert.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 awkward armrest setups.

SeatGuru and SeatExpert have maps of every plane 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 the SeatGuru or SeatExpert map.  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.

For long flights, I recommend the aisle seats because it’s easier to get up and go to the bathroom and the bar.  What?  You didn’t know about the bar?  Anytime you’re thirsty, just head to the flight attendant area, and they’ve usually got water, soda, and snacks available for self-service customers.  If you’re right-handed, get the aisle seat on the left side of the plane so that you’ve got room to maneuver; I find it easier to type, move the touchpad around, and so on when I’ve got room for my right elbow.

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 missing the first day of PASS.

Knock yourself out on long flights.

Drool Not Shown

Drool Not Shown

Forget paying extra for a first class upgrade.  Get a travel pillow for under $10.  The one shown here is an inflatable model, which is nice because you can deflate it and stick it in a laptop bag.  If you don’t want to carry one around, you can usually pick up the non-inflatable ones in airport gift shops for around $20.

Now, I know what you’re thinking – you’re thinking that wearing an inflatable toilet seat around your neck will make you look stupid.  You’re wrong.  The drool coming out of your mouth is what’s going to make you look stupid.

As you’re boarding, take a sleeping pill.  Settle into your seat.  If you want a blanket, buckle your seatbelt on the outside of your blanket so that the flight attendant won’t have to wake you up to make sure you’re wearing it.  You’ll be out like a light in no time.

Conquer time zone changes with vitamin B12.

This tip comes from Douglas McDowell of SolidQ, and it’s saved my bacon more than a few times now.  Pick up some vitamin B12 pills at your local drugstore and keep ‘em in your laptop bag.  I prefer blister-packed sublingual pills – the sublingual ones that come in a bottle break up pretty quickly if they bang around.  Take one, and you’ll be comfortably awake for a couple of hours, but not wired or jittery.

Caffeine is the wrong answer – it dehydrates you, makes you jittery, and has other side effects that you want to avoid when traveling.

Be wary of taking late flights for travel vouchers.

Those travel vouchers sometimes 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.

Oh, and whether you’re delayed by weather or you take a late flight by choice, call your hotel to let them know.  If you don’t show up by midnight, they have a tendency to give away your room to somebody else when they’re booked solid.  Don’t expect to be able to waltz in the next day thinking your room will still be held for you.  If you don’t show up on the day of your reservation, they might charge you for one night’s stay, but they won’t hold the room for your entire stay.

Leave a tip for the hotel maid on your pillow.

The Wrong Kind of Rock Star Behavior

The Wrong Kind of Rock Star Behavior

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.

Plan questions for 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.

Make a list of 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, bring a two-prong extension cord too, because not all outlets have three prongs.  A 2-prong extension cord will get you into places other people can’t go.
  • 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.)  For ultra-personal cards, check out Moo.com.

Don’t feel guilty about skipping sessions to mingle.

I make a list of sessions that I absolutely can’t miss, but the rest of the time, I wing it.  If I get the chance to have a one-on-one impromptu chat session with somebody really brilliant, I’ll go for that, because frankly, that’s worth way more than a session.

For example, I got the chance last year to sit in the hallway during a session and do some impromptu data mining with Donald Farmer, and that’s one of my favorite memories from the Summit.  Did I miss a session?  Yep.  Did I feel guilty?  Only for about the first five minutes.

Leave the support calls at home, or bring your evidence.

PASS is a great place to get access to some of the brightest minds in the database business.

It’s a really crappy place to open a support case.

If you’re struggling with a problem that you just can’t fix, and you’ve opened a support case with Microsoft (or in my case, Quest), it can be tempting to approach Microsoft employees and ask for insight.  You know how when the doctor bangs your knee, your leg jerks up?  I have a really similar reaction.  When someone says they’re having a problem, I blurt out, “I need your Windows event logs – both system and application – plus the results from sp_configure and dbcc tracestatus.”

If you’re going to ask support questions, be fair – bring along your support case number, a folder with all of the evidence you’ve gathered so far in the case, and a laptop that can access the system remotely right now.  Armed with that, you stand a great chance of getting great minds to ponder your problem and cooperate with you pronto.  Without that, you’re probably going to get a polite smile-and-nod-I-feel-your-pain.

Never eat or drink alone – tweet with #SQLPass.

If you’re going to an upcoming conference, bookmark these two links now on your phone or your PDA:

During the conference, I’ll tweet 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.

A lot of us will be roaming around downtown Seattle with our handheld gadgets, monitoring the Twittersphere for the phrase #SQLPASS in much the same way that truckers use their CB radios to monitor channel 19 looking for bears.  When you’re bored, get on Twitter and say so, but make sure to include the phrase #SQLPass.  Someone will hear your pain and tell you where the party’s at.

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 Weekly Bookmarks for October 23rd

Here’s my bookmarked links for October 17th through October 23rd:

SQL Server Links

PASS Links

Tech Links

The Junk Drawer

These bookmarks are automatically imported from my bookmarks at Delicious.com. If you’d like to get up-to-the-minute updates on what I’m bookmarking, you can subscribe to my bookmark RSS feed.

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

#SQLBingo: Meet nice people and learn their safewords.

Stuart Ainsworth (BlogTwitter) had a killer idea: what if we had a Twitter bingo at the PASS Summit?  We could print cards ahead of time, and attendees would run around the Summit trying to meet the celebritweeps.  Next thing you know, #SQLBingo was born.  Here’s how it works:

BINGO!

BINGO!

Step 1: Before you go to Seattle, print out 3 #SQLBingo cards.

Go to http://sqlserverpedia.com/bingo and print the page three times.  If you don’t like the Twitter folks pictured on your card, just hit refresh, and you’ll be greeted with another random group chosen from folks who volunteered on Stuart’s blog.

If you forget your #SQLBingo cards, you can pick up a set at the PASS booth.

Step 2: Look for your tweeps and line ‘em up.

Search out “The Squares,” as we call ‘em, as you wander around the Summit.  Each Square has a private code word.  Ask for their code word, and write it down in their #SQLBingo card space.

Just like normal bingo, you need a different pattern each day:

  • Tuesday – straight line in any direction (all 5 squares)
  • Wednesday – two straight lines in any direction (9 or 10 squares)
  • Thursday – blackout (all squares covered)

To make it easier, code words don’t change each day, so when you get someone’s code word you should fill it in on all 3 of your cards.  They don’t have to sign your card – just fill in the code word.

Step 3: Each day, turn in your card.

When you’ve got the right pattern, deposit your card in the PASS booth.  Each evening, we’ll draw winners for prizes like $50 gift cards and a free pair of bingo wings.  Winners will be notified by email, so get your name & email right on the bottom of your bingo card.

You don’t have to be on Twitter to win, but it might help.  If you’re wondering where to find these people, you can search Twitter for #SQLbingo.  The Squares are encouraged to randomly tweet their location with the #SQLBingo tag, which will make it easier for everyone else to track ‘em down.

In my PASS sessions, at the Quest breakfast session on Wednesday, and at the Virtualization Virtual Chapter breakfast on Thursday morning, I’ll ask all of the Squares in attendance to stand up, thereby making it even easier for you to throw things at them get their safe word get their code word.

That’s the part I’m most excited about – hearing everybody’s choice of code word!  I’ve already heard a couple of hilarious ones.

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

Quest PASS Breakfast Event: Dine & DMVs

What do these things have in common:

Give up?  We’re all going to be in exactly the same place at the same time: room 611 at the PASS Summit at 7:00 AM on Wednesday, November 4th!  Quest Software is sponsoring a free breakfast event called Simplify SQL Server Management with DMVs.  Each of us presenters is going to tackle a different area of the Dynamic Management Views & Functions and explain how it can be used for good, not evil.  And maybe evil too.

You can register to attend in-person, and registered attendees will be entered into a drawing for a free netbook.  Must be present to win!

If you’re not going to PASS, we’ll bring PASS to you – register to watch the webcast live.

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 Session Preview: Yes, I’m Actually Using the Cloud

In this session at the PASS Summit in Seattle, I’ll talk about the options for SQL Server in the cloud today and how I’m using them for my projects.  I’ll talk about how to choose the right cloud-based solution for your needs, and I’ll do a live demo of working with SQL Server in the cloud.

Here’s a video preview of me walking through the first several slides in the deck:

[media id=23 width=640 height=500]

I’ll be giving this session on Thursday, November 5th at 1:00pm – 2:15pm in room 201.  This is the smallest capacity room at the summit, fitting only 128 people as opposed to 300-500, and I got a huge laugh out of that.  Tells you something about the demand for SQL Server in the cloud knowledge or my presentation skills – or both!

Update: SearchSQLServer.com published an interview with me about using SQL Server in the cloud.

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 Weekly Bookmarks for October 16th

Here’s my bookmarked links for the week ending Friday, October 16th:

PASS Election Links

PASS Summit Links

SQL Server Links

IT Links

The Junk Drawer

These bookmarks are automatically imported from my bookmarks at Delicious.com. If you’d like to get up-to-the-minute updates on what I’m bookmarking, you can subscribe to my bookmark RSS feed.

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 Weekly Bookmarks for October 9th

Here’s my bookmarked links for October 2nd through October 9th:

SQL Server Links

Tech Links

The Junk Drawer

  • I Love That Game – Brilliant criminal minds at work.
  • Twitter Data Analysis: An Investor’s Perspective – A bunch of oddball stats about Twitter users and their histories.
  • Will Work for Whuffie? – Why you have to charge fees for speaking engagements when you hit a certain level of fame. (No, I’m not there yet, hahaha, but even if I was, my speaking engagements are free because I’m a service of Quest Software. No, not that kind of “service,” buddy.)

These bookmarks are automatically imported from my bookmarks at Delicious.com. If you’d like to get up-to-the-minute updates on what I’m bookmarking, you can subscribe to my bookmark RSS feed.

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

Meet PASS Board Candidate Tom LaRock

The PASS Board of Directors election starts on October 12th, and we’ve got four really well-qualified candidates to choose from:

You can read their bios at the PASS Candidate List, and they’re good, but I wanted more.  I emailed each of them with a set of interview questions to satisfy my bizarre curiosity.  Today’s response comes from Tom LaRock:

Brent: First, thanks for volunteering to dedicate your time to the community. What made you decide to run for the Board of Directors this year?

Because there is more work to be done. I have an idea where I want PASS to be, and I want to help get us there. Being on the board allows for me to help the PASS Community as a whole. In return I get board-level work experience. See, my company is not going to let me be the COO for the next two years. But on the PASS Board I get that level of work experience, which is where I want to be with regards to my own career path.

Walk us through one of your typical workdays. What do you do?

That depends on who is asking and who is reading. Let’s just say I am currently the Database Administration Manager for a global investment management firm. I am responsible for production and project support and have a team of DBA’s located in India that provide wonderful support. My day is usually filled with routine tasks, meetings, and I get to listen to some music every now and then.

What parts of your day-to-day experience will make you a better Board of Directors candidate than the other candidates?

I do not believe I can answer that question in all fairness, as I do not know enough about what the other three candidates do in their daily routines. It would be wrong for me to assume that my experiences make me any better than anyone else. I can, however, tell you what I feel makes me a strong candidate. I believe that my ability to lead a disparate team of DBA’s located in other cities and countries gives me the experience necessary to lead a global organization such as PASS. You have to juggle a lot of things when dealing with global entities and managing people all over the world. I have that experience, both here and for PASS already, and not many other people have that same level of experience.

I’ve heard that the PASS Board of Directors is a time-consuming hobby to say the least, and at this point in our careers, none of us have tons of extra time. What other projects or things do you expect to have to cut back in order to make time for the Board? (I’d just like to give the readers an idea of how tough it is to prioritize things.)

Since I am already on the board, I do not expect I will need to cut back on anything. I expect that in the next two years I will find myself saying “no” more often so that I do not overextend myself to the point that my duties for the board suffer. It seems that with each passing day I get asked to take on new projects and I do my best to keep the end game in sight.

I believe social networking and Web 2.0 tools like Twitter, Facebook, and StackOverflow are changing the way DBAs interact with each other, get training, and solve problems. Do you agree or disagree, and why?

I agree that it has changed the way a subset of DBA’s interact with each other. And for those that use the tools it works great. I also believe there are many more DBA’s that are not as involved. While serving on the PASS Board I want to make certain we do what we can to get those people engaged and get them to contribute in whatever way they feel most comfortable.

Do you blog and use social networking tools? Where can DBAs find you online?

People can find my blog at http://thomaslarock.com, and I can be found on Twitter at http://twitter.com/SQLRockstar, Facebook at http://facebook.com/thomas.larock, and LinkedIn at http://www.linkedin.com/pub/thomas-larock/0/67b/b37. I enjoying interacting with people both online and in person. I am a naturally shy person and find it difficult to network with others, but I am doing my best to get better.

Do you have any conflicts of interest that may pose a challenge?

Not at the moment. Because I am not an independent contractor or work for a consulting firm there is less of a likelihood of a conflict of interest. In other words, my motivations during board meetings are for the best interests of the community, without consideration for any possible company or personal benefits. My reward for serving is professional growth, not financial.

Of course there are other possible conflicts, such as if I have to be in two places at once. There have been times when I needed to attend a PASS function and a non-PASS function. PASS always comes first, it’s that simple. At least for me, it is. For someone that is independent they may need to take care of business before something for PASS, and I respect that very much. That’s why it is important the Board have a mixture of members; some independent and some not.

If PASS put you in charge of increasing new memberships, what specific steps would you take?

Everything PASS does is with regards to driving new membership. So, a better question would be to simply ask: how do you plan to increase membership? And what I can tell you is that I have an idea as to what I want PASS to become and it is my hope that if we get there the memberships will naturally follow.

The simple version of my vision is to get PASS recognized as the best Professional Association for database professionals. When I was in graduate school I was automatically a member of the AMS (American Mathematical Society). As such, that was the association I would belong to if and when I became a mathematician. Now, imagine if every graduate student in CS, MIS, or whatever other tech field was enrolled as a member of PASS when they entered school? Over time we would be infused with new members, younger members, members who will stay members for a long time, members that will share with us their fresh ideas on how to make things better. Before you know it, PASS will be recognized as the same level as the AMS or even the AMA.

We can get there, and I want to help make it happen.

What do you think PASS is doing right to improve the day-to-day lives of database administrators?

PASS is an organization that is dedicated to the promotion of Microsoft SQL Server. There is more to SQL Server than just administration, so PASS is doing what it can to help all database professionals. And PASS does this by keeping three things in the back of their mind with every project: Connect. Learn. Share.

What do you think PASS could do better, and how?

Because PASS is a disparate, global entity there is one area that needs improvement and that is communication. We need to be able to communicate up and down the chain. I should mention that I feel we communicate better now than we have in the past, but we could always be doing a better job.

Sum up your goals for PASS in 140 characters or less:

Connect. Learn. Share.

Thanks for your time!  Readers – you can learn more about Tom and why he’s running at his web site.

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 Session Preview: DRP 101

I’m giving a presentation on Disaster Recovery Planning 101 at the PASS Summit in Seattle.  At past summits, I’ve struggled to pick good sessions to attend.  What’s the speaker’s real agenda?  Are they a decent speaker?  Can I see a short 3-4 minute preview of the material?

This year I’m trying an experiment.  I’m recording video previews of my sessions to help attendees decide whether it’s a good match for their skillsets.  Let me know if you find this helpful, and we might think about organizing an official video preview gallery for PASS 2010.

Disaster Recovery Planning 101

In this session, I’ll cover SQL Server high availability (HA) and disaster recovery (DRP) options at a high level.  I’ll explain the differences between HA and DR, what techniques are used for each, and the pros & cons of each option.  I’ll also cover some backup best practices, since neither HA nor DR take the place of backups.  I’ll finish up with some real-life lessons-learned from ugly disasters when database outages brought down entire companies.

Here’s a video preview of me walking through the first several slides in the deck:

[media id=24 width=640 height=500]

This won’t be a hands-on session with demos – I’m covering such a large number of HA/DR options that we won’t have time to show step-by-step implementations.  Rather, this session is meant for developers and accidental DBAs who’ve never built their own cluster, replication, or log shipping solutions, and they want to understand what to learn first.

I’ll be giving this session on Wednesday, November 4th 1:30pm – 2:45pm in room 613-614.

Next Monday, I’ll follow up with another video preview & abstract – “Yes, I’m Actually Using the Cloud.”

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 Weekly Bookmarks for October 2nd

Here’s my bookmarked links for September 25th through October 2nd:

SQL Server, Cloud, and Tech Links

Writing, Blogging and Networking Links

The Junk Drawer

These bookmarks are automatically imported from my bookmarks at Delicious.com. If you’d like to get up-to-the-minute updates on what I’m bookmarking, you can subscribe to my bookmark RSS feed.

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