Category Archives: Personal

Personal

Snowpocalypse Webcams in Chicago (Now offline)

For the folks from out of town, I’ve set up public access for my webcam.  Here’s a live shot of Snowpocalypse 2011:

Where's BrentO?

Live Snowpocalypse Webcam

Just kidding.  Here’s the real webcams:

(Update Feb 3 – now offline since the snowpocalypse is over.)

The username is operator, password operator.  Here’s shots as of 1PM so you can see if visibility drops:

Office Webcam

Office Webcam

Living Room Webcam

Living Room Webcam

I really like these little webcams for the price – under $100 from Amazon.  They’ve served me well over the last year.  We originally bought ‘em to watch our dog Ernie when we went on vacation and to make sure our dogsitter was coming at the right times.  The features include:

  • WiFi or wired Ethernet support
  • Motorized pan & tilt
  • Automatically switches to infrared at night (and the night vision, though black & white, works surprisingly well)
  • Streams live video AND works with iPhones & iPads!  We watched Ernie from the cruise ship in Alaska.
  • Motion detection – can automatically upload images to an FTP server when things move in the frame

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.

Website - Twitter - Facebook - More Posts

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.

Website - Twitter - Facebook - More Posts

My Bucket List

Bob Pusateri (Blog@SQLBob) just posted his Bucket List – the list of things he wants to do before he kicks the bucket.  Aaron Bertrand followed up with his. If you haven’t seen the movie The Bucket List starring Morgan Freeman and Jack Nicholson, I’d highly recommend it.  Immediately after seeing that movie, I started assembling my own bucket list, and I’ve been gradually crossing off items ever since.

Here’s the uncompleted items on my bucket list:

Take a road racing class – I’ve always been fascinated by race cars.  Ironically, I drive really slowly on public roads, rarely getting a speeding ticket, but I still love going fast.  I want to take a multi-day course by Skip Barber or Bob Bondurant.

Crossing the Chicago Mac Sailboat Race off my bucket list

Crossing the Chicago Mac Sailboat Race off my bucket list

Drive a Porsche 911 on a twisty road – I don’t really wanna own a 911 because the maintenance costs are crazy, I’d rarely use the performance, and downtown Chicago parking is expensive.  Another parking spot would cost me $300-$400 per month.  I’d like to just have a great driving experience with a 911, though, and only after taking the road racing class.

Visit Tokyo – I’ve traveled the world and seen almost every city I’ve ever wanted to see, but Tokyo still calls to me.  I like the density, the strange cultural differences, and everything else I’ve learned about Tokyo.

Take everyone in our family on a cruise – not all at once, but individually.  I’ve taken Mom, Dad, and Caryl (my stepmom) so far.  Next up – my sister & crew (her husband, their son), then it’s over to Erika’s side of the family.

Have the #1 highest rated session at a conference – I’m not competitive.  It’s not about being better than anybody else – it’s just about being as good as I can possibly be.  I made the Best of the 2009 PASS Summit list with my high availability & disaster recovery session at #8, but something in me really wants to be el numero uno.

Retire while I’m young enough to enjoy it – after all, that’s what this is all about, right?  I don’t want to work until I’m dead.  I love what I do – and I mean, I really, really love it – but I could stay busy for the rest of my life doing things that aren’t on this list (but *are* on my GTD list).  I’d like to learn more about architecture, engineering, wine, writing, snorkeling, photography, and boats.  I don’t want to change the world, but I want to appreciate more of the wonderful, amazing things happening around me every day.

If you haven’t built a bucket list, go rent the movie, and start making your list.  Work can wait.  It’ll be there when you get back.

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.

Website - Twitter - Facebook - More Posts

The Beer Trials Review

In high school, my dad’s side of the family had a restaurant and bar in Whitehall, Michigan.  The Galleon was a high-end (well, for the local price range, anyway) seafood and steak restaurant on the shores of White Lake, and we catered to the tourists and well-off locals with a taste for the finer things.  Between the restaurant’s target market and my family’s penchant for alcohol, I just bypassed the whole beer thing and went straight for the hard stuff.

Ayinger Celebrator and The Beer Trials

Ayinger Celebrator and The Beer Trials

I never tasted a beer until the ripe old age of eighteen; I went to the University of Houston and someone handed me a Shiner Bock.  I said to myself, “Hey, this beer thing isn’t bad at all!  I’ve been missing out.”

So I tried a few other beers, and … wow, was I disappointed.  In the early 90s, everybody in Houston drank Corona, and more often than not, that beer left a really bad taste in my mouth.  Literally.  I couldn’t understand why sometimes it was great, but most of the time it tasted skunky.  How could there really be so much variation in the same brand of beer?

For a decade, I stuck with Shiner Bock, venturing out only when a restaurant didn’t have it or when they offered a flight of beers.  I discovered a few other good beers in different styles, and I built up a little repertoire of favorites.  I enjoyed Dogfish Head 90 Minute IPA (thanks to Houston beer guru, IT guru, and all around nice guy Sean Stoner, aka @MaslowBeer), Guinness, a few hefeweizens, and preferred Kirin Ichiban with my sushi.

When Alexis Herschkowitsch, one of the authors of The Wine Trials (see my review), shipped me a review copy of their new book, I gotta confess that I wasn’t expecting much.  I figured they did a file-save-as, called it The Beer Trials, and had tried – and failed – to reproduce the awesome parts of The Wine Trials.  I was very, very, very pleasantly surprised to be wrong.

Thanks to page 52 of The Beer Trials, I now know why Corona is usually skunky. The clear glass lets in unfiltered light in a way that harms the beer.  If I want to find better Corona, it’s just a matter of finding places that know how to store beer properly.  Even better, I can simply glance at a beer bottle and rule it out because it’s got clear or green glass, thereby making it more likely to be skunky.  Presto – book price saved.

Thanks to the categories on page 59, I discovered that Ayinger Celebrator is even better than Dogfish Head 90 Minute IPA.  I’d been trying to figure out what kinds of beers were most like 90minIPA, and I hadn’t been very successful.  I never would have gambled on Ayinger because of its fancypants packaging – I mean, really, a plastic thingamabob hanging around the beer’s neck?  What kind of jerkface drinks something like that?  Well, now, I do, because it’s unbelievably smooth, very rich and complex, and it tastes like I’m drinking warm brown velvet.  That may not sound appetizing, I admit, but that’s why I write about databases instead of beer.

I tried several 9-rated beers out of the book before etching the pixels in stone for this review.  I wanted to know that the book was more reliable than a typical bartender.  I can report that I’m completely satisfied, and the only complaint I have is that the book doesn’t come with a companion iPhone app – at least, not yet.  In the meantime, I’ve typed the list of 9 and 8 rated beers into RememberTheMilk by category so I can access ‘em from anywhere.

Authors Seamus Campbell and Robin Goldstein have pulled off a winner.  Thanks to them, I’ve found several new beers that have surprised me in a good way and made me interested in trying new beers again.  I would wholeheartedly recommend trying any beer rated highly in their trials, and because of that, the book is a downright steal at under $15.  The $15 you spend on this book will pay for itself in the first beer you try.

A few links:

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.

Website - Twitter - Facebook - More Posts

What Skill Should I Learn Next?

Last week I posted a picture on Twitter of the two books I’m reviewing right now: Tom LaRock’s DBA Survivor and Bert Scalzo’s Introduction to Oracle.  They’re both 100-level books.  People didn’t seem to question the former (perhaps because Tom’s a friend of mine) but I got a lot of comments about the latter.  Why on earth would I start picking up Oracle, especially after becoming a Microsoft Certified Master in SQL Server?

Books I'm Reading

Books I'm Reading

Over the last ~20 years, I’ve reinvented myself a few times.  My “Managing People Sucks” post talked about the decisions I made along the way.  I’ve tried hotel management, network administration, programming, virtualization administration, SAN administration, and database administration.  I’ve learned more and more about myself each time, and I like to think I’m building speed.

I like to think of myself as a carpenter, and each skillset I’ve picked up has given me another tool in my mental shop.  I’m able to work with more and more complex projects over the years.

Whenever I choose to pick up a new tool, I look at it in relation to the other tools I’ve already got, and in relation to the types of projects I want to accomplish down the road.  When I got the chance to pick up virtualization, I grabbed it, because I believe all SQL Servers will be virtual in one way or another down the road.  I chose to pursue SAN administration for similar reasons.  These two skills enhanced my toolbox well.

So how do I go about picking the next tool?

Should I pick up Business Intelligence? I firmly believe in the power of BI to justify suitcases of cash and armies of resources.  The problem is that it’s not a tool that fits well with the rest of the tools in my mental shop.  It doesn’t smoothly and directly extend the knowledge I already have.  It’s like a woodworker who wants to buy a plasma cutter – the plasma cutter will only come in handy when he decides to work with metal.  The rest of his tools don’t work with metal.  He might be able to build some projects that have both wood and metal, or switch to metal, but it’s not quite that good of a fit.

Should I pick up Parallel Data Warehouse Edition? This new niche version of SQL Server is BI-focused, but the engine itself is a very close match for my skillset.  It combines high-end hardware, storage, and SQL Server to deliver decisionmaking information.  I like its future odds, but it’s not really mainstream.  I’ve been trying to extend my skills in a way that let me help more people outside of databases – for example, virtualization and storage were above-and-beyond SQL Server, wide-ranging appeal stuff.  PDWE plays to a very small audience.

Should I pick up Oracle? Companies that have SQL Server often have Oracle too.  Oracle runs on SANs and in virtualization, and it would extend my audience.  Almost every skillset I have applies to Oracle, with one big exception – big Oracle shops don’t run it on Windows.  I would need to pick up Linux skills to really be effective as an Oracle DBA.  Oracle’s a great investment for my career, though – it’s a solid database with a great future.  Even if the cloud emerges as a roaring success for private, secure data warehouses, you can bet your bottom dollar that Larry Ellison will figure out a way to take that dollar.

Should I pick up NoSQL? Stop laughing, dammit.  It really does have the potential to solve problems, and it makes for a surprisingly natural extension to SQL Server.  When someone needs transactional integrity at the cost of some scalability, I can help them with SQL Server.  When they’re willing to deal with eventual consistency in order to get crazy fast scalability, I can go the NoSQL route.  The challenge is that the tooling sucks – the databases are being compiled as we speak, so forget about nice GUI tools to help you learn.  Time to bust out the programming.  They don’t live on Windows either, so now we’re talking about picking up multiple skillsets simultaneously.  This is one of those cases where I don’t have quite enough other tools to really know how to use this one yet.

So should I revisit coding? I gave it up around 2002-2003 when I realized I would have to keep relearning languages every few years as new ones came into style.  C# looks like it’s got staying power, and Windows Azure means I can develop C# apps that scale.  Ruby on Rails calls to me for its ease of use, and people I respect are using it to build cool stuff.  The drawback is that you wouldn’t normally build a Ruby app to interface with SQL Server, so that loses a little appeal.  It might take me quite a while to get good at C#.  (No, I’m not learning PowerShell – if I can’t build web apps with it, it’s not as sexy to me.)

Should I dive deeper into social media? I’ve had some success with blogs and Twitter, and I do technically work in the marketing department.  Quest is willing to let me jump around into other departments and help them with social media.  This might actually be the toughest challenge out of all of ‘em, and it doesn’t leverage any of my technical skills.  It’s attractive to me because it’s new and shiny and different.

Should I hone my writing and storytelling? I’d like to think I’m okay at these, but not great.  I could directly leverage the rest of my skills right away.  I think I know a lot of things I haven’t passed on to others yet, and maybe I could do it in a more effective way.  I’m not convinced that this is a good long-term investment, though, because frankly writing and storytelling doesn’t pay well.  Note that you’re reading this blog for free.  Think about your very favorite blog and how good it is – and yep, it’s free too.  There’s a reason I don’t run ads here – they don’t pay jack.  I make more in an hour of consulting than I do on a month of ads.

So should I focus on training & consulting? I love helping people fix problems and teaching them new tricks.  Maybe I should just stop the skill train here for a while and coast.  There’s something to be said for making money, and Quest is generous enough to let me consult and train on the side.  That’s one heck of an opportunity.

I don’t have the right answer yet, but I’ve resolved to spend the next couple of months dabbling in different areas to find out.  I’ll play with Ruby on Rails, Oracle, NoSQL, and a few other things to figure things out.  My recent Twitter e-book was a part of that – I wanted to throw something social-media-ish against the wall just to get it out of my system.

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.

Website - Twitter - Facebook - More Posts

You may ask yourself, How did I get here?

Paul Randal (Blog@PaulRandal) tagged me in a post about the three events that brought him here.  I had to think about this one for a while, and I even talked it over with Erika.

Discovering BBSes

Typical BBS Menu

Typical BBS Menu

Long before the public got access to the Internet, I was logging onto Bulletin Board Systems (BBSes) with my Commodore 64. I first got started using Quantum Link, a commercial service, and then started asking around if there was anything similar but free and more grassroots-oriented.  (Being a high school kid, I doubt I used the words “grassroots-oriented,” but you know what I mean.)  When I discovered that local people were running their own online services with a bank of modems and a bunch of phone lines, I was awestruck.  These little communities were springing up all over the US, and anybody could meet other likeminded geeks anytime, anywhere.

I was hooked, and I never gave up.  When I got an IBM PS/2 in high school, IBM sent out a message to their customers notifying them of self-support in the IBM forums on some online service (might have been Prodigy, I can’t recall.)  IBM ran a contest that the user who answered the most support questions in a month would win a piece of hardware – some months it was a monitor, other months it was a hard drive.  I woke up early every day, answered questions like crazy, and raced home from school to answer more.  I won a color monitor, and I remember being really bummed out that it wasn’t the monster 20mb hard drive.

When it came time to pick a college, I chose the University of Houston in part because of its excellent Internet labs.  Any student could stroll into the labs at any time, around the clock, and get unmetered access to the Internet.  Hubba hubba!  I could have majored in MUDs and IRC.  My IRC nick was TomServo, and I played a cross between the MST3K character and a helpful bartender.  As people entered the chat room, I would do things like:

  • /me slides a beer down the long wooden bar towards the new guy in the room.
  • /me tosses a bag of quarters towards the newcomer and points her at the jukebox.
  • /me cheers and hollers, “NORM!”

I lived for that stuff.  Sadly, I was not quite as excited about the rest of the university experience, which leads me to my next life-defining event.

Dropping Out of College

UH Melcher Hall

UH Melcher Hall

I did pretty well in high school and was recognized as a National Merit Finalist.  I could attend almost any school I wanted for free (but not the University of California Berkeley, which was my first choice.)  I picked the University of Houston (go Coogs!) and lived it up.  Full ride, free housing, free books, even free food and drinks.

I just didn’t like college.

I did really well in the courses I enjoyed, like literature, political science, and psychology, but anything I didn’t like, I dang near failed.  I couldn’t get motivated to slave away over courses that had zero real-life use, like calculus, but I couldn’t avoid those courses if I wanted to graduate.  Since I found myself less and less interested in the irrelevant stuff, I decided I could do without the diploma, and I dropped out.

I know I would have been a totally, completely different person if I’d have finished college.  I’d have gotten a white collar job right after graduating.  In a perfect world, I would have connected the dots between my passion for computers and my disinterest in mathematics, and figured out a way to motivate myself to get a degree in computer science.  The early 90s was an awesome time to get an education in computers, and who knows?  Maybe I would have ended up in a dot-com – or at least, a more successful one.  That didn’t happen, though, so I wound my way through the hospitality industry instead.

Taking Control of My Career

In 1999, I worked for a hotel management company.  Because of my odd background, I did a mix of jobs – I ran the financial auditing, and I managed the computer networks.  By then, I’d already tried and given up on managing hotels – I hated depending on an army of minimum-wage workers who were all striving to get out of their jobs.  I traveled around from hotel to hotel, auditing their books and their day-to-day operations, and also set up computers, servers, and networks.  When I was in the home office in Memphis, I managed that network as well.

I started getting burned out, and I asked my manager to pick one of the two jobs – either internal audit or IT – so I could focus on that one.  Due to the small size of the company (around 25 hotels), they didn’t really have enough need for one person to do either job full time.  He tried picking one, but I kept getting sucked back into doing both.  I worked ridiculously heroic hours, 10-12 hours a day, 7 days a week, for months on end trying to keep everything under control.  After repeatedly asking for help for several months straight, I suddenly had a Eureka moment.

In my boss’s mind, I was a complete success.  He had no reason to fix anything.

All of a sudden, I realized that I shouldn’t be striving for the company’s definition of a successful employee.  I had to make my own definition and strive for that.  It isn’t always in the company’s best interest to see employees blossom to their fullest potential.  At the time, I thought it might be a limitation of small companies, but I’ve since seen that same problem pop up at big companies too.

From that point forward, I was a different employee.  I want to be a successful employee in my employer’s eyes, but when I take a job, one of the questions is, “One year after someone’s taken this position, what does success look like?  What is the best employee doing?  How are you rewarding them for what they’ve done?”  In IT, this question takes people by surprise, but the answers reveal a lot.

Who I’m Tagging

I’m going to tag different people than I usually tag, and in my mind, they’ve got something in common.  Let’s see how Andy Leonard, Jonathan Kehayias, and K. Brian Kelley answer the call.

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.

Website - Twitter - Facebook - More Posts

How I Use GTD 50,000 Foot Goals

David Allen’s productivity book, Getting Things Done, has made me a better person.

Getting Things Done

After using its methods for years, I’m even more convinced it can help anybody in IT. Today, I’m going to explain how I worked before GTD, and how I work with it now.

How I Handled Tasks Before GTD

Years ago, I tracked my to-do list in a text file. I broke the file up into two sections, Work and Home. My Work section looked something like this:

ASAP:
 - Make nightly sales import job faster
 - Help Sharepoint team install new SQL cluster

ASAP Done:
 + Fix the backups on SQLPROD1

Other:
 - Call Microsoft to schedule data warehouse health check
 - Test email notification setups on all servers
 - Find out why SQL users can't log in when any DC reboots
 - Move remaining applications off SQL 2000

Other Done:
 + Install maintenance scripts on new 3rd party vendor server
 + Retrofit IBM x346s with remote administration card
 + Inventory RSA IP addresses

Everything I did was tactical – it was all about putting out fires. I arranged tasks in order of priority, with the first tasks being the most urgent. When someone walked into my cube with a new task, I would open my text file and say, “Where does this new task fit in with my priorities?” We would agree upon a position, and I’d add their task to my list.

I used this same approach with all incoming tasks – whether email, phone calls, or in person. Sometimes I’d send my actual text file, and sometimes I’d just walk them through it verbally over the phone. Upon seeing my task list, more often than not their eyes would bug out and they’d shake their heads. “Sorry – I need it fast, but it looks like you’re pretty busy. I’ll go bother someone else,” they’d say. That worked really well for me!

As I completed tasks, I changed the minus sign to a plus and moved it to the top of the “Done” section. Every now and then, when my manager asked what I’d been up to lately, I could whip out my trusty text file and copy/paste the appropriate sections into an email.

While that helped keep unimportant new tasks out of my way, it didn’t stop me from spending my time firefighting. My tasks were determined by what other people wanted from me. There’s nothing wrong with pleasing your customers, but – well, actually, there is something wrong with it. It’s the cliched movie character who focuses on making everybody else happy, yet never stops to take care of themselves.

GTD and the Big Picture

Unlike productivity methods like Franklin Covey that revolve around your ability to shell out big bucks for paper day planners, GTD is system-agnostic. If you’d like to track your GTD tasks with a text file, and if it works for you, that’s totally fine. There’s a bunch of ways you can accomplish GTD.

GTD wants you to get from Point A to Point B. It doesn’t dwell on whether you drive a Maserati, take a bus, or hoof it. Instead, it just focuses you on Point B.

GTD separates the means from the end, because you’ve probably lost focus on the end already.  GTD asks you to build a set of 50,000 foot goals for yourself – things that you ultimately want to accomplish before you die. Preferably, long then. The best way to illustrate it is to share my own 50k goals, which aren’t in any particular order because they’re all equally important:

  • 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.

The more ambitious GTD practitioners create a set of 40,000 foot goals that map up to the 50k ones, and then a set of 30k foot goals. For example, under my “Be very financially secure” goal, my 40k foot goals are:

  • Increase my income. These are tasks that, when performed, result in money in my bank account shortly thereafter. 30k goals under here might include taking on side consulting work, but during the day, being a good employee matters here. I have to make my managers and internal customers happy if I want to get a raise. If I was really anal, I could map out a set of 20k goals like keeping my manager updated, staying abreast of the company’s overall goals, and so forth, but I’m not quite that serious about GTD (yet).
  • Increase my marketability. These are tasks that might not pay off tomorrow, but they have a high likelihood of putting me in a good position down the road. Blogging falls into this category, as does helping other people.
  • Reduce my expenses. Budgeting, rereading Dave Ramsey’s books, avoiding gadget purchases, and improving my credit rating all come into play here.
  • Improve my financial position. Tasks here might include increasing my savings, being properly insured, and meeting with a financial advisor.

That’s just the financial one. It might seem common-sense, but here’s where it gets interesting.

When I get a new idea or an assigned task, I line it up to one (or more) of these goals. If something doesn’t line up with these goals, it doesn’t get into my task list. If something conflicts with these goals, it doesn’t get into my task list. The rejected tasks are either delegated to someone else or politely refused.

That’s the theory, anyway.

Periodically Revisiting Goals and Tasks

In practice, I get distracted by bright shiny things. Some sexy new technology comes out, or I think somebody’s got a brilliant idea, or I don’t want to let somebody down, and next thing you know it I’ve got a couple of bad tasks in my list. I don’t realize it right away because I’m so enchanted with the idea itself, and I’m perfectly content to let it sit in the list.

I confuse “I can” with “I should.”

David Allen instructs GTD practitioners to periodically revisit their 50k goals and their task list to make sure everything lines up. I do this once per quarter on a long plane flight, and sure enough, I come up with things that have weaseled into my task list despite my best intentions. For example, this quarter I built a Twitter bot account to randomly spout off random jokes every couple of hours just because it was an interesting technical exercise. I don’t pull my hair out and wail about the time I put into it, but it’s just an example of how I got sidetracked by something fun. All work and no play does make Brent a dull guy, but it’s not like I don’t have enough fun stuff planned in the pipeline.

I use a hybrid of systems to manage my GTD goals and tasks. I track my 50k and 40k goals in a text file, and I keep my day-to-day tactical to-dos in RememberTheMilk.com. RememberTheMilk’s Pro level ($25/year) has a slick iPhone app that syncs over the air, and it works when disconnected too, like on planes. I can review my tasks on the plane, make changes to them, and RTM automatically syncs them when I’m back on the ground.

To do my quarterly review, I pull up my 50k/40k text file and save it with a new name for the new quarter, like GTD2009Q4.txt. I review these big-picture goals and make very small tweaks where necessary. After a few quarters, I’m surprised that these still adapt and evolve over time as I learn more about myself and what I want from life. After updating my goals, I leave those up on the screen and get out the iPhone. I scan through my tasks in RememberTheMilk and make sure they each line up to one of my 50k/40k goals, and that they’re in the right priority order.

I only prioritize things that I think I’m going to accomplish in the next couple of weeks. Generally I find that I get enough incoming fires to keep me pretty busy, and I don’t need to prioritize more than a dozen or so tasks at a time. The rest just stay in a murky pool at the bottom – I’ll get to ‘em when I’ll get to ‘em.

The Result: Peaceful Focus and Productivity

When I step off the plane, I know where I’m going – and I don’t mean baggage claim. I know what I need to do, and I’m perfectly comfortable with the volume of tasks. I know I can only accomplish a limited amount of things in the time I have each day, and I believe I’ve made the best choices possible given my long-term priorities.

GTD helps me to do a better job of saying no. I’m acutely aware of the opportunity cost of taking on new tasks, and I know what’s most important to me. For example, I can’t take on more work if it means spending less time with the ones I love, or if it causes me to sacrifice my health. Because I’m freshly aware of my big-picture goals, it’s that much easier for me to explain to myself why I wouldn’t take on a particular task.

GTD helps me to do a better job of saying yes, too. When something is truly important and lines up with my priorities, I’m more able to push things around in order to accomplish it. When someone comes up with an emergency task, I can do a much better job of being the guy to fix it, because I know exactly what I have to push aside in order to do it. For example, I can more easily say, “I’ll help you fix this, but I need you to get Sam to handle these three tasks for me right now.” When managers see someone so on top of their priority lists and make great tradeoff decisions, they’re more likely to give you the backup you need. If you just say, “But boss, I don’t want to work late again!” they’re more likely to tell you to suck it up.

I don’t think I’m a better employee due to Getting Things Done, but overall, I’m a much better person.

I’m certainly not done with my 50k tasks – I have one hell of a lot of work to do. However, every time I do a quarterly review, I’m pleasantly happy with any progress I’ve made. After all, before GTD, I didn’t even SEE those 50k 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.

Website - Twitter - Facebook - More Posts

Just Say No

In the 1980s, Nancy Reagan attempted to solve our nation’s drug problem by encouraging kids to “Just Say No” if they were offered drugs.

The Moment We Won the War on Drugs

The Moment We Won the War on Drugs

According to my research performed while watching popular television shows like Burn Notice, CSI:Miami, Law & Order, and Spongebob Squarepants, it appears that people are still saying yes to drugs.

However, I’ve had more success managing my own personal task list with Nancy’s timeless catchphrase.  A friend of mine was asking me how I found the time to do so many things, and I answered, “I just say no.”  I started rattling off the things I’ve said no to – just this week alone – and I realized it’d make an interesting blog post.

In one week, I’ve said no to:

  • Other departments at Quest – in a company of over 3,000 employees, there’s always somebody who needs SQL Server help.
  • Mentoring more people – I get a huge feeling of satisfaction by helping people grow their careers, and I’d love to help everybody, but at some point I’ve gotta draw a line and work on my own career.
  • Writing book chapters – a friend’s writing a book, and I’d love to help by contributing material.
  • Consulting clients – every now and then, somebody asks me to help their company optimize their SQL Server infrastructure.  I love helping, especially when I’m getting paid for it, but all work and no play makes Brent a dull guy.
  • Traveling to see family – in theory, I could fly to Mom or Grandma & Grandpa’s place, stay with them for a week, work on my laptop during the day, and spend quality time with them after work.  In reality, it doesn’t work out well.  I get too distracted, so I have to schedule this only when I’ve got a bare minimum of stuff going on.
  • Helping foreign language bloggers – we’ve had requests from foreign-language bloggers who want to syndicate at SQLServerPedia, but they need an English-speaking editor to clean up their stuff.  Coordinating those efforts takes time.
  • Blogging for SQL University – Jorge Segarra’s SQL University series is a brilliant idea, and I’d love to contribute posts and info.
  • Writing PASS Quiz Bowl questions – I was asked to write virtualization questions for the Quiz Bowl event.  I passed this off to the PASS Virtualization Virtual Chapter members.
  • Speaking at events – I’m on the road for 5 of the next 8 weeks.  In order to be a good partner for Erika, I have to be here at least half of the time.  (At least!)
  • Getting Microsoft certifications – if I’m going to make a run for the MCM, I have to pass the prerequisite tests, and I have to study for those.  I definitely wanna do it.
  • Side ventures – I’ve got a dozen ideas for things I want to build, like the Pheathr thing I’ve had half-baked for months now.
  • Podcasting – I’m supposed to be cranking out 2 podcasts a week at SQLServerPedia, and I’ve got no shortage of topic ideas.  Just a shortage of time.

The longer your career plays out, the more people will ask you for help.  You can either say yes and get frustrated because there’s not enough time, or learn to say no.  The key to knowing when to say yes and when to say no is having a perfectly organized task list.

How I Organize My Tasks

I use RememberTheMilk.com because it’s web-based, plus accessible over my iPhone. I divide my tasks into groups, which show up as different tabs in RTM. (The task list goes on WAY longer than this screenshot, trust me.)

My Remember the Milk Task List

My Remember the Milk Task List

When I first started using RTM, I just had task groups for Work, Personal, and Blog, but I’ve since really expanded ‘em out:

  • Blog – topics I want to blog about.  I could start draft entries in WordPress for these, but I’ve got several dozen entries in here, and I like to keep WordPress clean.
  • Book – writing & editing work for my books.
  • Budget – long-term things I want to buy.
  • Dream Home – not tasks, but RTM is so gosh-darned efficient that I use it to keep notes on things.  I mentioned my Dream Home task list in my blog post about What I Want vs What I Can Afford.
  • Indie Label – tasks for my side consulting company clients.
  • PASS VVC – the PASS Virtualization Virtual Chapter.
  • Personal – things I need to do for Erika, my family, or my friends.
  • Quest Development – I work in the marketing department, but when folks in other departments like dev ask me to do stuff, it goes into here.
  • Quest Marketing – my 8am-5pm task list.
  • Quest SSP Ideas – long-term things I’d like to add to SQLServerPedia.
  • Recurring – tasks that RTM automatically regenerates.  For example, I owe my boss a status report every Monday morning, but I don’t want that to clutter up my to-do list, because I only do it on a specific day.  Another example – get a haircut.  I never go into my Recurring list to see what I need to do, because RTM just sends me reminders when these tasks are due.
  • Shopping – stuff I need to pick up when I’m out and around.  Whenever I find myself out shopping, I double-check this list to see if there’s anything else I need to grab at that same store.
  • Training – things I’d like to learn.  I try to dedicate a set amount of time per month to keeping my skills up-to-date.
  • Wines – like the Dream Home group, this isn’t really a to-do list.  Although it kind of is – I must drink more of these tasty beverages.  I’m horrible at remembering wine vintages that I liked, so whenever I’m at a restaurant I can add to or check this list.

I can grant other people (like my boss) access to specific groups, like Quest Development or Quest Marketing, without them seeing all of my personal tasks.  That way, when we’re working together to prioritize my work, we can both see the same list of tasks.

I can’t say enough good things about RememberTheMilk.com and the Getting Things Done productivity philosophy.  The book is subtitled “The Art of Stress-Free Productivity”, and it really delivers what it says on the label.

Managing Incoming Work Requests

When someone asks me to do something, I ask what the deadline is.  I use that deadline to decide right away whether I’ll be able to deliver the task on time, keeping in mind the other stuff that’s already in my RTM task list.

If the task doesn’t have a deadline, then I make it clear to the requester that they’re in the list, and they can contact me anytime to request an update on what’s ahead of them in priorities.  However, the onus is on them – not me – to manage the task deadline.  If the task suddenly becomes urgent, they don’t get a shortcut to the top of my task list just because the task suddenly has a new deadline.  They still have to compete with everything else.

If the task has a deadline I can’t meet, then I say no.  Nothing personal – I just point to the list of tasks I have to do.  Since every single one of my to-dos is documented in RTM, I can instantly say, “I’d love to do ____, but unfortunately I’ve got ___, ____, and ___ on my plate already, and those will keep me busy past your deadline.”  If the requester demands a higher priority – and it happens all the time – I export the list of higher-priority tasks from RTM, email it to them and my manager, and ask for them to work together to sort out the priorities.  I truly don’t care what I work on first – I’ll be busy until the day I retire – so I just want to do what my manager needs first.

If the task has a deadline and I believe I can meet it, then I take ownership of the status updates.  I agree to meet the deadline, and I give them regular updates on whether I’m meeting that goal.

This simple process lets me deliver on time – but it also means breaking a lot of hearts by saying no.

You can either break hearts at the beginning by saying no, or break hearts later by not making your deadlines.  People will only forgive you for one of those two options.

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.

Website - Twitter - Facebook - More Posts

We’re Moving to Chicago

Erika and I have moved a lot lately!

Chicago Skyline

Chicago Skyline

In 2005, we left Houston, Texas and moved to Miami Beach, Florida so Erika could pursue her education as an air traffic controller.  In early 2008, when she finished her degree and got an offer from the FAA, we moved back to Houston.  Later that year, when she stopped working for the FAA, we decided to move up to Whitehall so she could see snow for the first time.

Amazingly, Erika actually liked the winter.  When we visited Chicago, she saw it as the perfect combination of big city life plus winters.  I’ve always liked Chicago, and I don’t mind winter in a city (as long as I don’t have to shovel driveways or scrape my car off).  We’d originally planned on moving back to Houston after Michigan because I wanted to plant some roots, but Chicago really called to us, and we could see ourselves spending several years there.

So in late September, we’ll be moving into a loft in downtown Chicago’s South Loop.  (I’m still learning the terminology – it’s a couple of blocks from the Mayor’s townhouse on Michigan, if you know that area.)  I’m really excited at getting back into a big city and checking out the museums, deep dish pizza, and the Chicago SQL Server user group scene.

But mostly the pizza and museums!

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.

Website - Twitter - Facebook - More Posts

We Finished the Chicago-Mac Race (Last)

The good news: in the official press release announcing the winners of the Chicago-Mac sailing race, the Hannah Frances was included along with the winners.

Hannah Frances Skipper Mike Cook Receiving the Pickle Boat Trophy

Hannah Frances Skipper Mike Cook Receiving the Pickle Boat Trophy

The bad news was the way we got mentioned:

“While 33 boats chose to retire, most citing reasons related to the slow conditions such as lack of provisions or crew commitments elsewhere, at nearly 6:00 am Wednesday morning the last of the fleet arrived on Mackinac. The boat was the cruising division boat the Hannah Frances, who starting on Friday, raced with an elapsed time of almost 111 hours. Congratulations to the crew of the Hannah Frances for sticking it out in a very tough race.”

That’s right: we came in dead last – both on real time and corrected time.  In sailing parlance, this is known as being The Pickle Boat, and we even won an official Pickle Boat Trophy (a green Heineken DraughtKeg) from the Chicago Yacht Club. We entered the race just hoping to finish, though, so I can’t complain about the outcome.

When they say “very tough race”, they don’t mean the race was close.  Boats retired because the race was a rock-and-roller-coaster of conditions.  The first day we had 20-knot winds that shifted all over the place, especially during the start.  We almost ran into a city water intake, and we beat the bejeezus out of ourselves and the boat.  I remember holding out as long as possible before making the trip from the bunk to the bathroom due to the pain and effort involved in the ten-foot journey, and once inside the head, I received the beating of a lifetime.  Picture, if you will, your bathroom being thrown ten feet in the air like a giant pizza while you take care of your bodily functions.  Good times.  I found myself wishing the toilet had a seat belt.  And yes, it’s as unclean as you might imagine.

By day 3, we were sitting idle off the Manitous, surrounded by sailboats with sails hanging straight down.  It was so calm, I could actually hear people coughing on other boats.  We had to ration water because our slow progress meant we might be in for a week-long race.  Don’t feel bad for us, though – rationing water just meant we had to drink beer.  Mike had warned us about the possible slow speed ahead of time, so we’d all taken at least a week off for vacation in order to stick with it rather than retire from the race.

Toward the end of the race, we were back into nasty winds coming from exactly the wrong direction.  At one point, we were in 18-knot winds and 4-6 foot seas making just 2 knots of forward progress.  I think I saw a camera crew from Wipeout filming an episode in the v-berth.  Our closest competition, a slightly smaller boat from the same manufacturer, retired from the race just a few miles short of the finish line rather than continue to tack through these treacherous conditions.  Imagine doing over 300 miles in a 333-mile race, and then giving up – that’s how bad the wind and waves were.

At the Finish Line

At the Finish Line

You can view my photos of the 2009 Chicago-Mac Race, but it doesn’t really convey the difficulty.  I captured a lot of the light, fun moments like cooking, but when the seas are nasty and the boat is pitching all over the place, you need both hands to hang on to the boat.  Forget taking pictures.

Would I do it again?  Probably not, and that was the same verdict from all of the crew (save the captain, who’s still thinking it over). I saw the Northern Lights and the International Space Station, shared great stories with truly hilarious people, got a nice tan, and had some good sailing, but it was physically exhausting and dangerous.  We fought mechanical problems like dead batteries, a borked depth finder, and bilge pump valve that decided to let water into the boat rather than keep it out.  I couldn’t stay awake long enough to witness our passage under the Mackinac Bridge because I’d steered the boat for several hours prior, and needed a nap before we hit the finish line.  It took me a few days of sleep to get back to my normal schedule, and I’ve still got sea legs.  Amazing experience, but I only need to do it once to remember it for a lifetime.

I do have one nagging thought – if the losers get a trophy made out of beer, what would it be like to win?

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.

Website - Twitter - Facebook - More Posts