Doug Lane

SQL Server Entertainer

  • GitHub
  • LinkedIn
  • Twitter
  • YouTube
  • Blog
  • About Doug

Book Review: Getting Things Done

July 15, 2011 by Doug Lane

This review is part one of a twelve-part series of book reviews I have committed to writing over the next twelve months (read the list and the reasons for making it here: “What Gets Measured Gets Done“). As my list of responsibilities grow at work and at home, I need to improve my organizational methods in order to keep up. Plus, honestly, I’m not a highly organized person. I tend to do what is on my mind at any one moment. I remember to do pretty much everything (and certainly everything that’s important) but I don’t have much structure to support my train-of-thought methods. Getting Things Done by David Allen aimed to do two things: make me more productive, and take the stress out of the process.

I checked out the book from the public library; I rarely purchase non-technical books anymore — most are available somewhere in the Denver metro area. I also bought the unabridged audio book to listen to during my commute. The audio book is read by the author, who has an accent I can’t quite peg. I chuckle whenever I hear him stress the ending “r” in “tickler” or “labeler”. There’s enough content in the book that to fully absorb it, I had to read it twice and listen to the audio book four or five times.

At 259 pages, it is at times a tough and tedious read, if only because there are frequently new concepts, diagrams, and systems within systems being introduced. For example, in chapter nine, he introduces three levels of thinking to go through in order to decide what action is best to take:

  1. The Four-Criteria Model for Choosing Actions in the Moment
  2. The Threefold Model for Evaluating Daily Work
  3. The Six-Level Model for Reviewing Your Own Work.

These levels are hierarchical, meaning every task you undertake will pass through each of the three models before you start it. (One exception, I think, is the tasks you can hammer out in two minutes or less. Allen advocates simply doing them is simpler than trying to plan them.)

What I got out of the book

I read this book with the willingness to completely overhaul my time management habits. I can’t say I’ve done that yet, but I have made some improvements:

  • I reorganized my office folders using manila folders, and one per hanging folder. Already I have had an easier time filing and finding papers. (Note: I went against Allen’s recommendation to do away with hanging folders. I find without them the manila folders either slouch or are too tightly stuffed inside the drawer, especially when the folders are fat.)
    (True story: I once worked with someone who called them “vanilla folders”.)
  • I use the middle strata of his six-level model to evaluate tasks. I’m a very future-oriented person, and when I project out it’s usually in increments of years or even decades. I have a good idea where I want to be in ten years, but I hadn’t been connecting tasks with, say, areas of responsibility — what Allen calls “20,000 feet”.
  • I stopped making piles. My desk was only sparsely covered, but now there’s not much beyond the usual supplies and decorations. Paper doesn’t rest comfortably in processing purgatory the way it used to. By filing papers away and trusting my lists to serve as the sole reminder of actions involving those papers, I don’t feel the mental jab I used to whenever I’d see the pile.

Am I stress-free now? Of course not, but I do feel more comfortable knowing that I’ve tracked everything on a list. One of the chief aims of the book is to create a “mind like water” by storing projects and to-do’s on paper, not in your mind. I think my mind has gone from molasses to 5W-30 — a subtle improvement. Accounting for all my tasks doesn’t preclude my concern about getting them done.

Am I closer to my goal?

I read this book to improve one of my weakest links — organization. I am definitely better off for having read it, and I suspect I’ll realize more benefits as I continue implementing Allen’s methods. Some who have adopted these methods claim it has given them a new-found freedom. I don’t find the system’s effects to be so profound, but nor was I overwhelmed by e-mail and meetings. The people most likely to gain (or likely to gain the most) are those drowning in the pool where correspondence and responsibility meet.

Whether you’re in dire need of a new system of organization or merely interested in some productivity tips, give Getting Things Done a try. I suggest borrowing it from the public library; it’s a popular book and most branches will have a copy or two. You’re likely to mine a nugget or two that will make getting things done a little easier.

Filed Under: Career, SQLCruise

MCTS 70-448: Failure is a Fine Option

July 1, 2011 by Doug Lane

This was the second time I failed a certification exam, and the first time I expected to fail. It’s also the first time I’ve been perfectly content with failing.

I took the MCTS 70-448 – Business Intelligence exam yesterday morning only because I had to. I signed up for the three-exam pack offered by Microsoft and Prometric on June 22, and as a requirement I had to sit for an exam before July 1. Having only eight days to study, I put my odds of passing around fifty-fifty. I knew I’d do well at Integration Services, I’d do very well at Reporting Services, and I’d need to remember everything I’d crammed in the last three days in order to salvage the Analysis Services section.

That’s pretty much how it went.

70-448 Exam Breakdown, Doug Lane, June 2011
What almost passing looks like

While the pass/fail result met my expectations, I was surprised to learn from the test that:

  • I know more than I thought I knew about deploying Integration Services.
  • I know less than I thought I knew about developing Reporting Services.
  • Apparently, I am as proficient at deploying SSAS solutions as I am developing an SSRS solution. (Riiiiiiiiiight.)

But most importantly:

  • With a score of 610, I was dangerously close to passing (700), and I will absolutely pass this exam on my second try.

I was happy about failing for two reasons. First, I didn’t crash and burn in any one category and my overall score tells me I’m on solid ground with this material. Second, I often hear that certifications (especially the lower-level Microsoft ones) are “not worth the paper they’re printed on.” Had I passed today, armed with little book knowledge and virtually no real-world experience of Analysis Services, I would have done the certification a disservice. I didn’t deserve it this time.

Fortunately, I have two things working in my favor for re-taking the exam. First, I have a free second shot (part of the exam pack offer), which I hope to take in the next 30 days, while the material is still fresh in my head. Second, I just started prototyping an Analysis Services solution — my first ever — at work. My boss is very enthused about the potential for this project, so I can allocate plenty of time to it right away. With a little hands-on experience and more study time, I’m going to do just fine on the re-take.

In my eleven-year history of certification exams, I’m now 8-for-10. That’s okay. Failing the 70-448 this time just feels right.

Filed Under: Analysis Services, Career, Certification, Integration Services, Reporting Services

What Gets Measured Gets Done

June 11, 2011 by Doug Lane

Bing bong!

In between announcements from our cruise director Julie, Buck Woody imparted some words of wisdom to our SQL Cruise group: What gets measured gets done. In other words, the things we track are the things we make sure to do. As part of his professional development talk, he issued a challenge to us all. Find twelve books that will assist in meeting a career goal, read one per month, and blog a review of each one. In doing so, we’ll not only advance closer to our goal, but also have some material handy in case we get in a rut thinking of blog content. Having identified a one-year goal, here are the twelve-ish books I’m reading to help me achieve it:

  1. ProBlogger: Secrets for Blogging Your Way to a Six-Figure Income by Darren Rowse and Chris Garrett. This one has been on my radar for a while thanks to Brent Ozar. Better to incorporate these ideas now while my blog is still small and flexible.
  2. On Writing Well, 30th Anniversary Edition: The Classic Guide to Writing Nonfiction by William Knowlton Zinsser. The last time I wrote extensively was college. Since then, my written communication skills have slowly atrophied. Time to sharpen up again.
  3. MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® 2008 Business Intelligence Development and Maintenance (Self-Paced Training Kits) by Erik Veerman, Teo Lachev, and Dejan Sarka. Since I’m as much a BI developer as anything, I really want to pass this exam. I’ve had this book for two years. I just need to get off my can and get it done. Speaking of getting things done…
  4. Getting Things Done: The Art of Stress-Free Productivity by David Allen. One of my not-strengths is organizing a large quantity of tasks. I can do it, but not very efficiently. I’m hoping to adopt some ideas, if not the whole system, to make life less chaotic.
  5. The Exceptional Presenter: A Proven Formula to Open Up and Own the Room by Timothy J. Koegel. At the end of Kendal Van Dyke’s 2010 PASS Summit session, he gave away two books about presenting. This was one of them. I love presenting and I crave getting better at it. This seems as good a place to start as any.
  6. Confessions of a Public Speaker by Scott Berkun. The other book Kendal gave away at the PASS Summit. Between this and Koegel’s book, I should have plenty to work on.
  7. StrengthsFinder 2.0 by Tom Rath. I’ve already taken the StrengthsFinder test. I’d like to know more about what my results mean and how I can best put them to use. I expect this book will give me the answers.
  8. Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution by Erik Veerman, Jessica M. Moss, Brian Knight and Jay Hackney. At last, a technical book on the list! I work with SSIS a lot, and I like hearing how other people design their ETL solutions. I’m eager to read how they solve problems with SSIS, and learn how I might design things better.

And then there were five. Five books that, for reasons I won’t go into now, are supportive of my one-year goal. As much as I love reading about giving a professional presentation, writing well, or blogging effectively, I expect this will be the part of the list I devour. I can’t wait to get through these five books, and I can’t wait to show you why I’m reading them.

  1. The Murder of Roger Ackroyd: A Hercule Poirot Mystery (Hercule Poirot Mysteries) by Agatha Christie.
  2. Don’t Murder Your Mystery by Chris Roerden
  3. The Weekend Novelist Writes a Mystery by Robert J. Ray and Jack Remick
  4. How to Write a Damn Good Mystery: A Practical Step-by-Step Guide from Inspiration to Finished Manuscript, by James N. Frey
  5. How to Write Killer Fiction: The Funhouse of Mystery & the Roller Coaster of Suspense by Carolyn Wheat

Until then, enjoy the soothing sounds of the Norwegian Pearl, courtesy of a forum user with the handle “groo”.

Filed Under: Career, SQLCruise Tagged With: #sqlcruise, #sqlcruiseak, career

SQL Cruisin’

April 22, 2011 by Doug Lane

I’m half-Viking.  Seriously.  On one side of my family, my grandmother was 100% Finnish, my grandfather was 100% Swedish.  Which probably explains why I’m a better actor at playing a Viking than playing myself.


Thanks to Idera Software and their SQL Victory contest, I’m going on a 7-day Alaska cruise.  But it’s not just any cruise.  It’s a SQL Cruise.  I was hoping the boat would dock in Anchorage, if only so I could say, “So I wonder what there is to do around here.”

(I was born and raised in Anchorage.)

Between this, going to the PASS Summit (insert Howard Dean scream: “YEAAAARGHH!”), and good times at work, this is shaping up to be an incredible year. I can’t wait to see what’s next.

Filed Under: Career, Life

SQL Saturday #67: Priceless

March 30, 2011 by Doug Lane

Having presented at SQL Saturday #66 in Colorado Springs, I was eager to present again. I was understandably delighted then, when my “Data-Driven Subscriptions in SSIS” abstract was chosen for SQL Saturday #67 in Chicago.  A week or so before I got that news, I committed to going either as a speaker or volunteer.

The week leading up to the event was insanely busy — I had just presented a 60-minute session at the Denver SQL User’s Group meeting the previous Thursday and hadn’t addressed my Chicago presentation yet.  I spent that week frantically adapting my code from a production instance at work, making it suitable for public consumption.  Plus, my four year-old son got very sick on Wednesday night. (He caught the stomach bug that’s been hitting people hard everywhere of late.)  I debated staying home, but with my wife’s support, I headed out to Chicago instead.

The Night Before

I got to the hotel around 4:45 Friday night and my roommate, Randy Knight (blog|twitter), showed up a little while later.  From then until the speakers’ dinner at 7:00, I worked on debugging my demo.

The speakers’ dinner was hosted by SQLSentry (whose Plan Explorer I adore) at the Home Run Inn.  I’ve had their frozen pizzas before, but the restaurant version is far better.  I wish I could say I enjoyed the dinner more, but I still had my unreliable demo on my mind.  Heading into the weekend, I wanted to meet three people in particular with whom I’ve already had contact: David Stein (blog|twitter), Jes Borland (blog|twitter), and Brent Ozar(blog|twitter).  I met David and Jes that night; I’d end up meeting Brent the next day.

I also got to meet Aaron Bertrand (blog|twitter), Grant Fritchey (blog|twitter), Jose Chinchilla (blog|twitter), and many others for the first time.  I have to admit I was a little star-struck.  After all, I’m still way down the totem pole of SQL Server and they sit at or near the top.

With the dinner winding down, Randy and I went back to the hotel and I immediately set in working on my demo again.  It wasn’t until 2:44 AM I got my complete set of green boxes along with the expected output for each task.  I set the laptop aside the bed and I fell asleep within minutes.

Saturday Morning

I checked in and immediately went to the speaker’s room to iron out any last kinks with my demo.  David Stein mentored me (naturally) on one issue that, while it wasn’t a bug, was not an efficient way of executing.  I was disappointed to skip the first sessions of the day; the schedule was rich with useful content.  I had to focus on delivering a good session myself and spent the morning finalizing mine.

The speakers’ room is an incredible place.  As Nic Cain (blog|twitter) mentioned in his recap, the combined knowledge gathered in the speakers’ room is astounding.  Many of the speakers there are SQL Server MVP’s, authors of a book on my shelf, or both.  Like Nic, I can’t help but feel I’m not worthy of such company.  I’ve made it a point to tune in to the conversations there as much as I can because hearing them talk shop is very enlightening.

Though I was feeling good about my 10:45 session, around 10:15 I started to feel physically sick.  It was a familiar feeling to me.  I used to play co-ed ultimate frisbee at a national championship level, and I’d get this way before the first game of a big tournament.  While thumbing through my virtual machine, I noticed my RS unattended execution account was running as Adminstrator.  Since it felt a bit like I was cheating, I changed it to the account that should have proper permissions.  I closed my laptop and headed to my room.  It was now 10:45.  I was exhausted, had a potentially shaky demo, and felt like I had a bathroom emergency in the making.  What could possibly go wrong?

Showtime

My Presentation at SQL Saturday #67
Unstable demo, unstable bowels...what could possibly go wrong?

Much to my surprise, the room filled up near capacity.  I was opposite Grant Fritchey and Aaron Bertrand, along with five other outstanding speakers, so the full house was a delightful surprise.  I got my session underway on time, and a few minutes into the presentation I was feeling better.

The session went along pretty well until I all but invited trouble into my demo.  After about 30 minutes of explaining my solution’s prerequisites and architecture, I said the following:

“Just so we all know this won’t be a giant waste of time, let’s go ahead and run this so we know all the boxes will turn green.’

You know what happened next.

Three boxes changed to green and the fourth, a cringe-inducing blood red.  I had blown up a demo that just an hour before had worked to perfection.

Within a minute or two, I had deduced that something I changed in the last hour broke the demo.  I went back to the RS Configuration Manager and set the account back to Administrator.  I rationalized that more so than showing it runs with good security practices, I wanted to show that the solution just runs.  I was also subjected to a few “[it works] when you run it as Administrator” taunts from the audience.  I deserved a little heckling over it, so I didn’t mind.  Switching back to the demo, it was all green boxes from there.

Unfrozen Caveman Lawyer
"I'm just a Virtual Machine. Your code frightens and confuses me."

At another point, my VM slowed to a crawl, and I had to wait until it thawed.  Fortunately, someone in the audience unintentionally bailed me out with a question about the ExecutionLog view.  This was the perfect opportunity to kill time.  My presentation from the Thursday before spent a lot of time on the ExecutionLog view, so I was able to seamlessly and almost effortlessly transition into (and later back out of) that material.  Truly a life-saver to have that experience to fall back on.

I wrapped up a few minutes past 12:00 — a little over the allotted 75 minutes.  A few attendees came to me after the session to discuss the solution, as well as Reporting Services in general.  This was my favorite part of the session because I love to talk RS with similarly engaged people.

A brief note to my attendees: You deserved a more refined session than the one I gave you.  I work hard to make sure what I’m presenting is useful, clear, and well organized.  I’m glad that (judging by the evaluations) as a whole you enjoyed it.  However, I was not as well prepared as I should have been for this session, and for that I apologize.

I Can Breathe Again

I gave my wife a call to check in on my boy and let her know I survived my session.  I grabbed a sandwich and spent the next hour trying to mentally unwind in the speakers’ room.  Eventually I made my way into Jason Strate’s (blog|twitter) “Index Black Ops” for the last fifteen minutes of the session.  What little I saw made me wish I had been there the whole session.  I’ll have to catch up on his blog series of the same name.

The Other Big Reason I Came To Chicago

Pardon my lengthy digression here.

I enthusiastically support the idea of SQL Saturday: it’s a launching pad for novice speakers to learn how to present in a (generally) low-pressure environment.  It’s also a phenomenal way for attendees to get top-tier knowledge for absolutely zero cost.  Personally, the greatest benefit of SQL Saturday is the opportunity to meet people who share a passion for SQL Server.  In particular, this event offered me the chance to meet the person I credit with jump-starting my career: Brent Ozar.

Last year, I watched the video of his presentation “Top Ten Developer Mistakes That Won’t Scale“.  I loved his delivery and wanted to see more of his material.  This led me to his blog post, “Rock Stars, Normal People, and You“.  While reading the post, I realized my career was stalled just as his once was.  I didn’t necessarily want to be just like Brent, but I wanted to accelerate my skills and profile as he had.  And I absolutely had to thank him in person for that revelation.

I approached Brent briefly for a minute before his presentation (I couldn’t resist), thanked him for being a big influence, and asked to speak with him a few minutes after.  He said he was happy to do so.

Relax and Enjoy

Having met Brent, I went over to Jes Borland’s “Make Your Voice Heard!” session.  This session was not technical, and interactivity, along with Jes’ champagne bubbly enthusiasm, made for a nice break from thinking about code and internals.  We had a lot of fun discussing social media practices.  Regrettably, I had to duck out earlier because I wanted to see some of David Stein’s presentation, “Data Warehousing – How to Convince ‘The Bobs’“.  I enjoyed David’s presentation for his zest for data warehousing (he read a 500-page Kimball book cover-to-cover in two days), his plentiful Office Space references, and — if I’m not mistaken — his Logitech R800 green laser pointer which I also use.  I only caught about 20 minutes of David’s talk before ducking out to see the last few minutes of Brent’s [standing/sitting/hanging from the walls and ceiling] room-only session.

“So, Lord Helmet, at last we meet again for the first time for the last time.”

"I am your father's brother's nephew's cousin's former roommate."

Brent and I spoke after his session had let out. I thanked him for his blog post that really got my career off in the right direction, as well as his other professional development contributions.  He’s a humble and self-deprecating guy, which helps explain his broad appeal.  I was happy to get a picture with him too.  Since I’m a BI guy, I doubt we’ll cross paths often. I’m grateful I had the chance to thank him in person.

Winding Down…

At that point, I felt spent.  Rather than attend another full session, I went back to the speakers’ room and helped clean up a little bit.  I ducked in on Tim Ford’s (blog|twitter) talk, “Who needs DMV’s? You do!“, for the last fifteen minutes.  Again, what little I saw left me craving more.

In keeping with the theme other bloggers have set, I’ll briefly say that the after-party was terrific, and certain SQL Server MVP’s will now be associated with “Humpty Dance” and “Get Me To The Church On Time” as much as they will with indexing and execution plans.  If you want to know more, you’ll just have to go to an after-party yourself.

Despite Frontier Airlines’ efforts to keep me off the flight I had paid for a month ago — I don’t know why overbooking isn’t illegal, honestly — I returned home Sunday morning short on sleep and long on memories.

Finally { }

This experience lifted any doubts I may have had about my life’s purpose. I have discovered my passions are:

  1. Learning SQL Server.
  2. Presenting about SQL Server.
  3. Connecting people who are passionate about items 1 and 2.

Outside of my family, nothing means more to me right now than that.  I consider myself incredibly lucky to have found my calling at just 35 years old.  While it might seem like I have a man-crush on Brent Ozar (my wife would argue that’s true, as much as I talked about meeting him), it’s really just enormous gratitude I feel.  He’s the person most responsible for turning me on to presenting. (I just know that last sentence is going to cropped and horribly abused. Oh well. Swing away, folks.)  And I want to extend my gratitude to all the volunteers who made SQL Saturday #67 possible, most notably:

Ted Kruger (blog|twitter)
Wendy Pastrick (blog|twitter)
Norman Kelm (blog|twitter)
Jes Borland (blog|twitter)
Bob Pusateri (blog|twitter)
Aaron Lowe (blog|twitter)
Bill Lescher (twitter)
Rich Rousseau (twitter)

Thank you for wedging me in amongst the giants on your schedule, for all your assistance and hospitality, and for an experience I will always remember.

Airfare to Chicago: $300.
Hotel: $99.
Discovering your life’s purpose: Priceless.

UPDATE: My son is feeling well again, and I should have my presentation materials available here and on the SQL Saturday site no later than next Monday morning, April 4th.

Filed Under: Career, Presenting, SQL Saturday

  • « Previous Page
  • 1
  • 2
  • 3
  • Next Page »

Subscribe now!

Don't miss new posts as they publish. Enter your e-mail address to subscribe!

Your e-mail address will stay quietly between us, like that time I set the carpet on fire by accident.

Copyright © 2025 · Outreach Pro on Genesis Framework · WordPress · Log in