Archive for the ‘PASS’ Category

Good News for Women in Technology – Barbie Has Joined the IT Scene

Wednesday, March 10th, 2010

Notice the bluetooth ear piece fashion faux pas? Yes, she's truly a geek.

I’m happy to report that Barbie is now a cognizeti, a digerati, … yes even an IT Professional! This year’s new Barbie is Computer Engineer Barbie.

Several months back, I encouraged all my friends and followers on Twitter to vote for the IT job for Barbie in Mattel’s recent public job selection for the eponymous doll.  That encouragement was founded in an experience I’d had years earlier – becoming a dad to a very beautiful baby girl.  When I was growing up as a kid, I clearly recall how odd it was for a woman to have a career outside of a handful of “traditional feminine jobs” like teacher, nurse, telephone operator or secretary.  It wasn’t until years later, as a new dad, that I realized how asinine this preconceived notion really was (and, in fact, still is in many cultures around the world). I even wrote about this a few years ago in my personal blog, where I mentioned how I’d love to see my daughters grow up and take on an IT career.

Sadly, many IT professional societies report dramatic imbalances in gender demographics.  For example, the IEEE Computer Society reports that their membership is only 7% female. Similarly, universities in the USA shows about a 10% representation of female faculty and 14% of their students in computer-related majors.

One of the things I’d always found to be rather amazing about PASS was it’s strong emphasis on Women in Technology (WIT).  In fact, as far as database professional societies go, PASS was the first to work hard to make WIT prominent within its culture (although I believe that the International Sybase User Group had a WIT group before PASS).  I’d like to also give credit to the women within PASS who made this happen.  I can’t even begin to list them all here, but without them, WIT at PASS would not have been possible.  A few women who immediately come to mind include Rebecca Laszlo, , Kalen Delaney, Denise McInerny, Kathi Kellenberger, Stefanie Higgins, Lynda Rabb, Kimberly Tripp, and many many more.

All of these outstanding women deserve accolades for making PASS a welcoming place for women.  Don’t think that it’s a big deal?  You should attend an IT conference without a strong WIT community – you’ll see the difference in 30 seconds flat.  (I’m not going to name any names here.  But attend the top conferences for certain IT companies headquartered in Redwood City, California or Armonk, NY and you’ll see what I mean).

So, thank you ladies, for making PASS in particular and the overall Microsoft SQL Server community much better for everyone by making it better for women.  I hope to see this trend continue and for your contributions to continue to improve our community.

-Kevin

New On SQLPASS.ORG – Dealing with Micromanagers

Wednesday, February 24th, 2010

In my regular professional development column for the Professional Association for SQL Server (PASS), Plays Well With Others, check out my latest post on dealing with micromanagers.

Mad boss, Bad boss

Those TPS reports are due at 3:30 pm sharp, Mister!

If you’ve ever dealt with a manager who questioned your every move, hijacked meetings, nit-picked over inconsequential details, or made you jump through endless hoops of administrivia, then you know what I’m writing about.

This article is part one of a two part series.  Part one deals with identifying how and why managers become micro-managers.  Part two, coming in the next issue of the PASS Community Connector, gives you strategies you can use to survive and even thrive in these scenarios, and also tells you when to cut-n-run.

There are already questions showing up on the post.  So come join the fun.  Post your own questions or experiences, and help the community grow.

Enjoy,

-Kevin

Twitter @KEKline

Free Training for You, Punishing Workload for Me. Thank You for Enjoying My Misery.

Tuesday, February 9th, 2010

Everybody Needs Training

Everybody enjoys a little free training now and then.  I’ve got mountains of free training in the works.  Some of it is in-person and local while some are in webcast format.  Please join me as you’re able!

Tomorrow – Wednesday!

Wed, Feb 10, 2010 at 12 pm (noon) MST – PASS DBA Virtual Chapter; Top 10 Administration Mistakes on SQL Server

There are a short list of mistakes that, if you know of them in advance and prepare for them, will make your life much easier.  This presentation shows you these mistakes, the “low hanging fruit” of database administration.  Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before.  Quest is sponsoring this and raffling off a copy of my book, SQL in a Nutshell, and O-M-G a KINDLE!!!  (Free, but registration required.)  And if you haven’t already done it, join PASS!

Day After Tomorrow – Thursday!

Thu, Feb 11, 2010 at 11 am EST – Quest Software Pain of the Week; Understanding & Preventing SQL Injection Attacks – with Kevin Kline and K. Brian Kelley

SQL Injection attacks is the most common hacker trick used on the Web and yet, one of the easiest to prevent. Learn what they are and why you need to be concerned about them. In this webcast, I and SQL Server MVP K. Brian Kelley (blog | twitter) will demonstrate different types of SQL injection attacks. You’ll learn how to find and block them to keep your databases safe, preventing disruptions to your organization. Quest is sponsoring this as well and raffling off more goodies.  (Free, but registration required.)

Thu, Feb 11, 2010 at 6 pm CST – Nashville .NET User Group; Ten Things DBAs Want .NET Developers to Know

Stereotypes abound for different types of people in the IT world. Developers think DBAs are control freaks. DBAs think developers are unruly cowboys. How do we overcome these differences? If you’re a developer, your best strategy is to manage your DBAs’ anxieties and demonstrate your competence and credibility. Attend this session to learn about 10 techniques that developers can apply to their code which will calm your DBAs’ fears and earn their admiration. Techniques include how to analyze a query plan and how to make sure your query is taking advantage of the best available indexes.  Attendance is free although registration is encouraged so we can get a good count for the food, plus there’s free pizza and a raffle at the end.  Drinks afterwards at Chilis.

Coming Soon

Mar 03, 2010 >>>FULL DAY OF FREE TRAINING!<<< – Quest Software SQL Server vConference; Troubleshooting and Performance Tuning with Kevin Kline, Brent Ozar, and Ariel Weil

Join SQL Server MVPs, Kevin Kline and Brent Ozar (blog | twitter), along with Quest Product Manager Ari Weil —all from Quest Software—as they interactively present tips and tricks to help you monitor your SQL Server environment with ease. You’ll learn how to use Dynamic Management Views (DMVs) to simplify troubleshooting and significantly enhance SQL Server performance. The day consists of eight sessions with live Q&A – a great way to get answers to your questions straight from the source. Chat live with Quest experts. Plus, you can visit the Quest booth to download helpful resources like white papers, watch demos and more.  This virtual training day is free and you can attend the sessions that fit your needs – perfect for tight budgets and busy schedules.

Mar 06, 2010 – PASS SQL Saturday, Charlotte, SC

The SQL Server Community will experience an event like no other in the Southeast region. Renowned speakers from around the world will gather in Charlotte, NC to share their knowledge on Microsoft SQL Server. This is your opportunity to meet, network with and learn from the SQL Community leading experts such as Andrew Kelly, Rick Heiges, John Welch, Brian Knight, Geoff Hiten, Andy Warren, Jessica M. Moss, Rafael Salas, Sergey Pustovit and Tim Ford. Also scheduled to present are current SQL PASS President Rushabh Mehta and former SQL PASS Presidents Wayne Snyder and Kevin Kline.

Mar 24, 2010 – PASS DBA Virtual Chapter; SQL Internals & Architecture

Apr 08, 2010 – Quest Software Pain of the Week; The Admin’s Guide to SQL Server w/ Buck Woody

Apr 12, 2010 – PASS Chapter, Houston; topic TBD

Apr 17, 2010 – PASS SQL Saturday, Chicago; Keynoting w/ Brent Ozar

May 13, 2010 – Quest Software Pain of the Week; SQL Server for the Oracle DBA w/ Buck Woody

May 13, 2010 – PASS Chapter, Louisville; topic TBD

May 15, 2010 – PASS SQL Saturday, Louisville; topic TBD

May 22, 2010 – Indy Tech Fest; SQL Internals & Architecture

PASS 2009 Lifetime PASSion Award

Wednesday, February 3rd, 2010

A HAPPY RETIREMENT

January 1st, 2010 marked a very special day for me.  It was the first time in the past ten years in which I had no official PASS responsibility at the HQ level.  (I’m still serving in the local PASS chapter here in Nashville, along with the awesomeness that is DrSQL (blog | twitter) and the whackness that is Joe Webb (blog | twitter).  We also have the irreplaceable Shelton Dickson and Roberto Lopez helping us out).  I also intend to stay active as a speaker for PASS.  I spoke at the PASS 2009 Summit, earning a top presenter spot in the Professional Development track, and plan to speak there in the future.  And I’m also already booked for some upcoming Virtual Chapter meetings as well as local PASS chapters and SQL Saturdays.

10 Years on the Job Takes Its Toll

I have to admit that I’ve been surprised by the number of friends and acquaintances who’ve asked if I’ll miss it.  Isn’t it obvious?  Ten years of long hours with zero pay and a heavy burden on family time don’t rest easily on your shoulders.  I’m sure that PASS’ first two presidents, Pam Smith and Guy Brown, can corroborate my story – except that they’ve taken a solemn oath never to speak words that includes the letters S, Q, and L in a single sentence.  That makes it really hard to ask their opinion on much of anything these days.  The heinous nervous twitch that spasmodically attacks their left and right eye, respectively, whenever they hear the words “Micro” or  “Soft” uttered in the same conversation is also telling…

All joking aside, I’m honestly very happy to leave PASS in the hands of the next generation of leaders.  For more a much more in-depth discussion about my years on the PASS board of directors, check out Brian Moran’s interview for SQL Server Magazine here. The enthusiasm and passion demonstrated by the young turks on the board of directors will keep the organization in stead for many years to come.  I’m also very pleased with the new emphasis on community-connectedness (thank you Twitter!) and openness (thank you bloggers!) sweeping the community.  It’s already produced much goodness within PASS, which I expect to see multiplied many times over in the future.

A PARTING BOW

I was amazed and surprised when, during the keynote of Day 3, Bill Graziano called me on to the stage along with el presidente Wayne Snyder.  PASS did an online postings in a few locations. The PASS Volunteers page spotlights my award under the PASSion Awards section. Then, on the PASSion Award page, the award is the top featured article. This write-up includes a link to the interview with Brian that I mentioned earlier.  Funny story – I’d been working in the PASS ready room on Day 2 of the Summit, feverishly trying to improve my slide decks.  At the exact same time, Bill and the staff were also feverishly working on their slide deck a mere two seats away – of the presentation to come on Day 3!

I had hair when I started this job. Just sayin'...

Normally, I don’t care very much about how my slides look and would’ve caught Bill red handed in his sly surprise.  But today was different because I’d seen two ominous portents of doom – a ferret consorting with a chicken (on Cartoon Network) and a woolly caterpillar crossing the threshold of the Sheraton Hotel and Convention Center lobby.  My keen senses as an Oracle DBA kicked off an internal alarm that even 14 years of SQL Serverness could not suppress – eminent disaster at the hands of the demo gods was nigh.  So once I got to the PASS ready room, I equipped myself with several diet Mountain Dews, my favorite MP3 tunes via massive ear-buds, and a bag of mixed nuts.  Yes – I never knew, not even for a second, that they were talking about me.  Several hours later, as if waking from a daze, I realized that I didn’t have any slide decks with demos.  Clearly, Graziano had stronger juju than I.  Next time, I’ll directly divine the future using turtledove entrails – as all good Oracle DBAs are trained to do – rather than rely on those pathetic woolly caterpillars like MS-Access developers recommend.  [All elements of the preceding story concerning divination are a blatant lie.]  But I digress…

At the Day 3 keynote, Bill and Wayne surprised me by calling me to the stage and presenting me with the biggest award I’d ever personally seen.  I was gobsmacked.  On top of that, the attendees gave me a standing ovation for receiving the “Lifetime Passion Award” (no relation to Lifetime “TV for Women”).  Again, I was taken aback.  Wayne had, evidently, intended on giving me the mic to say a few words.  But because he was a bit choked up, he left the stage a bit earlier than he meant and never handed the mic to me.  Good thing too – I would’ve blubbered like a baby.

A Special Word of Thanks

Honestly, I can’t thank you enough for your kindness as a community. I never got into PASS for any form of praise or profit.  To have a hand in the making of something bigger than me which reflected my own values was all I ever hoped to achieve.  And thank you again to all the bloggers who had a kind word about the award as well:

This year was also a great year for photos like these.  If you know of any other mentions about the award that day back in November 2009, please post a comment here.

With a grateful heart to call you all friends…

-Kev

What Three Events Brought You Here?

Tuesday, January 26th, 2010

Whiners and Whingers Get Wedgies

Yes, I deserve a Wedgie

There I was, just a couple weeks back, whining that I wasn’t getting tagged by friends when a new meme comes out.  Sure enough, when my friend, Paul Randal (blog | twitter), starts a new meme with me as one of the first handful of people tagged, it’s taken me a full ten days to get a response out the door.  Yes – I deserve a wedgie.

In Paul’s initial post, I saw that he’d asked for three events that were pivotal in why I’m where I am today.  To be honest, I’ve been noodling over my response ever since Paul first tagged me.  So, in a sense, I’ve been writing this blog post for about twelve days now.  Not that I’m off the hook or anything.

What Didn’t Make the List

Still, I have to admit it’s taken me some time to get to a point where I could write about the events that have brought me where I am today.  Because, when I give a truly honest accounting of some of these major life changing events and pivotal decisions in my life, I’m not always proud of what I see.  Like item #4 on my list of life-changing decisions.  Don’t you DARE ask about #4.  I mean it.  If you do, there will be blood (see picture below)…

There are also a couple other non-events that also had a huge impact on my life’s direction. By non-event, I mean these things didn’t have a specific date and time.  But they were enormously influential about how I handled opportunities or even helped make opportunities happen.  First, I’d be remiss not to mention the impact that my personal faith has had on my life.  Countless decisions were steered by that faith.  Second, my upbringing naturally had a huge impact on shaping my personality, preferences, fears, and joys. (My mother is Italian, so I can honestly say that Parmesan cheese is one of life’s greatest joys.)  Finally, my immediate family -marrying very young and having a rather large family- also meant I made a lot of decisions in certain ways, such as opting not to move for a better job so that the kids could have greater stability. Things would be very different if I’d put my own desire and ambitions ahead of them.  With that said, let’s hit that top 3 list.

Add 1/5 Beefeater Gin + Article of Lingerie + Collegeboy Prank at a Zoo = Lifetime of Regret, a.k.a #4 on the List

Event #3

Pivotal, life-changing events shouldn’t come knocking on your door every day.  In my case, one of the first and most pivotal events for me happened about 3/4 of the way through my senior year in high school, just a few months before graduation.  Like my brother from another mother, Buck Woody (blog | twitter), money was a huge issue in my household.  (I’ll save you the sob story.  But trust me, there were many tears.)  So whatever college and career I chose had to provide the most upward mobility as quickly as was humanly possible within the boundaries of the law (that meant no drug dealing).  This is where my analytical side kicked in.  Looking over my college scholarships, I examined the undergraduate catalogs at the various universities in one hand and the salary survey about their respective careers in the other.

I came up with a two-column list.  The first column contained college majors that I would really enjoy career-wise, though not necessarily big money careers.  Column #1 contained entries like teaching, writing, farming, and being a stoner.  Notice how entries in column #1 were all among the most noble of professions and yet virtually guaranteed a life of penury?  Yeah, I noticed that too.  The second column contained college majors that I could tolerate, but had much better money prospects.  Column #2 contained entries for engineering, medicine, law, becoming Hugh Hefner’s protege, and … computers.

I’d lived with computer since before I could read or write.  My father was an analog computer engineer and, I still remember with great clarity, the desk-sized analog computer we had in our house in the 1970’s.  It had 4K of memory, used punch cards, created a flurry of discarded chads when it would write data out to a punch card.  My dad taught me about binary, octal, and hexadecimal, and the joys of vacuum tube computing.  Unfortunately, he did not teach me how to throw or catch any sort of ball, which had dramatic repercussions throughout my school year (refer to wedgie picture above) – but I digress.  Suffice it to say that by the time college rolled around, I was already well versed in 8-bit computing (I used Kaypro’s for you Osbourne and Sinclair snobs out there) and could envision that being a good career.

My Initial Career Choice - Stoner

Right about the same time I was choosing a future career, just before I graduated from high school, IBM launched an exciting new business computer called the IBM PC.  It was a hugely successful product with the ultimate killer application – a spreadsheet. (The spreadsheet was an amazing innovation in its day.  VisiCalc was the one I remembered being all the rage at the time.)  These personal computers were also hugely expensive – a nicely loaded IBM PC or XT could routinely cost $5,000 and that’s in 1983 dollars, friends.  So that’s when I started a part-time business, which I maintained all through college and a short while after, building and selling IBM PC clones.  I learned a lot from that experience – how to pay taxes like a responsible business owner, a lot about salesmanship, quite a bit about business accounting, business law, and the goodness of being an entrepreneur.  One surprisingly good outcome from all of this was that I didn’t have to sell out my love of writing and teaching.  That’s probably 40% of what I do today, just with computers.

Event #2

Another major turning point in my professional life occurred in the early 1990’s.  By that time, I’d held a couple professional jobs of the programmer/analyst variety working with Unix-based CAD/CAM tools, dBase, Fortran, and very early versions of Oracle. While my skill in these technologies was growing by leaps and bounds, this particular event isn’t about technology.  You see, my first three professional jobs (outside of my own little business) all held in common the fact that I worked for terrible bosses.  (I wonder if it’s any coincidence that these bosses, all male, were from the John Wayne school of management?)  I then had the opportunity to move from those smaller businesses to a fairly large company called Nichols Research Corporation, now a part of Computer Sciences Corporation.  I gleefully clapped my hands because my title was “Research Scientist” and, get this, I was actually working on NASA and US Army missile projects.  I was literally a rocket scientist! However, the thing that truly amazed me about this new work environment was that my bosses were women.  Great women.  Women (like Liz Kennedy, Pat Burns, and Bev Meeler) who were collaborative, consensus-driven, and encouraging.  They made me wonder why my male bosses never figured out that cussing an employee for 15 minutes at a time might not be the best way to motivate staff.  These excellent business leaders taught me my first real world lessons in the difference between the autocratic style of management versus the coaching style of management.  It was a lesson that I carried with me the rest of my life and try to instill in others whenever I get the chance.  (Blatant Plug – Attend my top-rated professional development sessions at the next PASS Summit and read my professional development column in the PASS Community Connector e-newsletter!)

Event #1

She was my sugar-mama, and I was her lovin' cabana boy. She put me through college...

The number one event that changed the course of my life came up quite accidentally.  I’d set my sights on earning a Master’s degree and, as the truly lazy know, you can complete a Master’s degree two semesters early by writing a thesis rather than sticking strictly with classes.  Laziness (or perhaps it’s creativity?) raised it’s head once again with this thought “Why not write my thesis as a dual-purpose document?  One that will earn the advanced degree and be published as a book?”  That’s when I saw a rather small advertisement in the back of one of my favorite computer magazines of the day, a now defunct mainframe-oriented publication called Datamation, calling for authors for a new IT series they were starting. I pitched my master’s thesis and was shocked that I was accepted.  I find it funny that I finished the book, Oracle’s Cooperative Development Environment, but never finished the Master’s degree.  That book helped me land a new job in Nashville, TN at a prestigious Big 3 accounting firm, which helped me get another book deal with O’Reilly & Associates, which earned me a seat as a founding board member of the Professional Association for SQL Server, which helped me land my current, wonderful job at Quest Software.  And which will eventually earn me a place in history for being the first database expert to dance on the bar at Coyote Ugly.

What Others Are Saying

Let me be honest with you.  I really enjoyed this meme.  And it’s one of the things that I’ve really enjoyed seeing happen with the SQL Server community in the last year or so – people opening up and sharing.  This is what community is all about.  One hundred years ago, I would’ve been thrilled to live in a town with as many supportive and encouraging friends who were just down the street from me.  But thanks to the technology we work with and the willingness of all of these people, it’s almost like a small, friendly (Southern!) town all over again.  I intend to read more in the meme thread, but here are just a few others that I’ve already read and enjoyed:

  • Brent Ozar (blog | twitter): I loved BBS’es too, amigo!
  • Kim Tripp (blog | twitter): She taught the first SQL Server class I ever attended!
  • Jorge Segarra (blog | twitter): He’s Mr Popular, being tagged 4 times.  But who doesn’t love chicken, I ask?
  • Scott Gleason (blog | twitter): Does Mr. Gleason watch Glee?
  • Donabel Santos (blog | twitter): She’s a ninja, but a very nice one who’s not likely to cut your arms off.
  • Andy Leonard (blog | twitter): We’ve got to Mrs Leonard and Mrs Segarra to cook a big ol’ dinner for us. Then we can all die happy.
  • Jeremiah Peschka (blog | twitter): You’d think it was a movie based on real events, with a little extra drama added in, but it was ALL real.

There are so very many other good ones that I could go on for several more paragraphs.  The reason I mention them, though, is that I somehow feel closer to all of these people.  And at the end of the day, our lives are really and truly about the people we have touched and the friendships we have made.  Everything else stands for naught.

So on the off chance that others have not yet been tagged, I’d like to loop in these folks from far-afield: Simon Sabin (UK), Henk Van Der Valk (Netherlands), Edwin Sarmiento (Philippines), and Charlie Hanania (Switzerland).

Where you can find me at the PASS Summit

Sunday, November 1st, 2009

In previous years, I hardly had time to sit down and catch a breather at a PASS Summit.  Between my duties as an officer of PASS, exhibit hall time with Quest Software (my employer), speaking in my own sessions, and meeting with PASS volunteers and community organizers, I was busy from the crack of dawn until midnight all week long.

Fortunately, those grueling marathons are fading into the past. I still have a busy slate ahead of me for next week.  But it looks like I’ll even have time to attend some sessions.  Yeah!  Here’s what I’ve currently got planned:

Monday, Nov 2

Depart for Seattle, 5:10 am.  O.M.G. – that means I have to get up before I go to bed.

Noon, arrive in Seattle

Lunch with the PASS board of directors

Networking Seminar, by Don Gabor, from 4:30 – 6:30 pm

PASS Quiz Bowl & Welcome Reception, playing in a team with the mighty BrentO, from 6:30 – 8:00 pm

SQLServerCentral Party, from 8:00 – 10:00 pm

Collapse

Tuesday, Nov 3

Keynote, 7:45 – 10:00 am

Birds of a Feather Luncheon, 11:45 – 1:00 pm, hosting the table “Moving from Technologist to Manager”

Exhibit Hall at the Quest Software booth, 11:00 – 4:00 pm

Session “The Ultimate Free SQL Server Toolkit”, 3:00 – 4:15 pm, Room 615-617

Book Signing at the Quest Software booth, 6:00 – 8:00 pm, giving away signed copies of Database Benchmarking

Microsoft MVP Insider Event, until 10:00 pm

Collapse

Wednesday, Nov 4

Quest Breakfast seminar and live webcast, Simplify Management with DMVs, 7:00 – 8:30 am, along with other SQL Server luminaries BrentO, Buck Woody, Louis Davidson, and Tim Ford.

MVP Deep Dives Book Signing, 11:30 – 12:00 pm, Come out get a book signed by all the authors!

PASS Board Q&A, 4:30 – 6:15 pm, Room 6E

I’ll also be popping out for meetings with various Microsoft PMs, a dinner with my Quest colleagues, and plenty of time in the exhibit hall at the Quest Software booth.

Collapse

Thursday, Nov 5

Session “Team Management Crash Course”, 10:45 – 12:00 pm, Room 612

Chapter Luncheon, 12:00 – 1:00 pm, Expo Hall 4b.  Come and join me, especially if you’re anywhere near the local PASS chapter in Music City – Nashville, TN.

Friday, Nov 6

Early departure back to Nashville.  In years past, I always had to stay until Saturday morning because of all of the important PASS work going on.  The important PASS work still goes on, but it’s in the able hands of a new generation of leaders.  As for me, I get to head home to be with my family one day early.  Yippee!

I hope to see you there.  Don’t forget the really awesome and cool SQL Twitter Bingo, if you’re in to Twitter.  The rules are HERE and the bingo cards are HERE.

Cheers,

-Kevin

Twitter @kekline

Starting the Travel Tips Meme

Sunday, October 25th, 2009

‘Tis the season for travel!  With the PASS Summit just around the corner and lots of other interesting events waiting in the wings, such as TechEd Europe, lots of IT people will finally be allowed to stretch their wings (and budgets) to get in some first class training.

I’ve been a very frequent flier for a long time and seldom get surprised by much these days – exasperated, yes – but surprised, no.  And I’ve certainly seem my share of fellow travelers doing it all wrong.  The one thing they all share in common is that they’re not experienced and, usually, haven’t thought much about the upcoming trip.  You know the type – they’ve packed an eighty pound carry-on and are then surprised that it neither fits in the overhead space nor is light enough to get past their waist line without a herniated disk.  They’re the type who stands at the security line, backing it up fifty deep, because they’re trying to get a 2 liter of soda or, even worse, $50 worth of hair care products past the checkpoint despite the prominently displayed signs and constantly playing recorded reminders that you can’t take any liquids or gels of more the three fluid ounces in a single quart-sized Ziploc bag.

I’ve got a few tips to share, and I know many of my fellow blogomaniacs do too.  So I thought I’d start a meme asking my colleagues to chip in their three favorite tips for successful air travel.  Just to pad the results a bit, everyone can provide three beginner tips for the infrequent traveler and three expert tips for those who might have travel a lot.  Here are my tips:

Beginner Tips

Here are some useful tips if you travel three or less times per year and aren’t too familiar with the ins and outs of air travel:

1. You’re at risk to forget some of your stuff in those bins at the X-Ray machine at the security checkpoints, especially if you’re hurrying to make a flight.  An easy way to make sure that never happens is to put everything first (keys, mobile phone, belt, laptop, carry-on bag) and send your shoes in the very last bin.  You might run off in a hurry without your laptop (I certainly have – once), but you WON’T run off without your shoes.  Putting your shoes last means you won’t forget anything else in your kit.

2. Expect annoyances and plan accordingly:

  • There’s always a chance of delays on the tarmac, sometimes a really long delay, so stock a bag or two of mixed nuts or another hearty snack.  I recommend unsalted nuts since they’re filling, fend off hunger for a long time, and won’t make you thirsty.
  • Plenty of time on the flight is “no electronics” time.  Bring magazines or books to read.  I, personally, enjoy writing letters (yes, using a real pen and real paper) especially to my older relatives who think computers are “of the Devil”.
  • There will always be screaming babies and obnoxious youngsters to make a nap just so much wishful thinking.  So get one of those nice sets of foam ear plugs (a dozen for two bucks!) and a nice sleep visor.  You’ll never see these people again, so don’t worry about how you look.

3. Packing is the novice traveler’s mine field. Don’t pack more than you need – one more shirt and pants than days you’ll be gone (in case of stains) and no more than one pair of shoes (over and above what you wear onto the plane).  Unless you’re traveling to a place without electricity and indoor plumbing, you can buy anything your lack.

Expert Tips

Here are some useful tips if you travel, or plan to travel a lot during the year and know all of the regular things to do:

1. American Airlines is the only airlines with standard “cigarette lighter” adapters under the seats.  There’s one per row in coach on their standard mid-range MD-80’s and one per seat in first class.  An adapter is one $20-30 at your standard drug store.  I prefer unlimited power, especially for long flights, which is on reason that I’m a platinum frequent flier on AA.  Delta and United have proprietary adapters that cost nearly $100.

2. Prepacking with redundancy.  It sounds a little like a level of RAID, but it’s really just a better way to travel if you have to do it often.  First, get redundant computer equipment, such as power adapters and mice for your laptop, and toiletries so that you don’t have to pack up your regular office gear for the trip.  If you don’t plan to do this, you will after a year or two of frequent travel because you’ll simply forget each of these things enough times that you’ll wind up buying doubles of most of them anyway.

3. The airline clubs are nice, really nice.  But each airline has their own club and they’re expensive, in the $500 range, even for high-level frequent fliers.  I recommend instead that you pay the $450/yr membership fee for an American Express Platinum Card.  One of the many benefits of the card is free club access to four different airline clubs, which means there’s never an airport where you can’t relax between flights.  Another less well-known perk is that if you book travel with AmEx, they’re often able to give you a “buy one get one” free deal.  It’s always unwritten and not posted on any website.  But if you call and ask, there’s a 30/70 chance that a flight between two major cities will have the deal.  (Note that this is unsolicited advice and I’m not getting any sort of remuneration in any way for this recommendation.)

Tag!

From here, I’m tagging a handful of buddies who are some of the hardest travelin’ folks I know – Paul Randal & Kimberly Tripp, Dr. Greg Low, Brent Ozar, and Brad McGehee.

I hope to see you at the PASS Summit in two weeks!

-Kev

What Direction Do You Choose?

Wednesday, October 21st, 2009
You have brains in your head. You have feet in your shoes. You can steer yourself, any direction you choose.
Dr. Seuss

Dr SeussDr Seuss makes a great point.  Only you can determine where you go in life and where those you lead in life (your significant other, your kids, your family, your business associates) will follow.  What happens when you don’t have your feet in your shoes?  What if you’re not wearing shoes?  Or what if your shoes are sandals?  Which direction do you steer?  Do you head to the beach or to the snowy mountains?  What if you’re not only steering yourself, but an entire professional association?

I’ve watched the blog posts and comments pile up throughout the community with eyes wide and mouth hanging open in consternation.  In a way, I’m thrilled to see all of the discussion.  After all, prior election were rather placid affairs.  An election with a lot of discussion should be a good thing, right?  Normally, I’d say “Absolutely!”  However, the rancor and negativity have been impossible to ignore. In response, please allow me to walk you through PASS’ history relating to elections, as well as the entire nomination and election process to give you a better understanding for this situation in its entirety.

Before I go further, I want to thank the members of the Nominations Committee (NomCom) for their steadfast dedication and self-sacrifice.  NomCom members include uber-volunteer Allen Kinsel (twitter), former board member and co-founder of SQLServerCentral Brian Knight (blog), PASS EVP Rushabh Mehta (blog), PASS executive director Judy Christianson.  PASS president Wayne Snyder also sat in the sessions (since he’ll be leading this effort next year) but did not vote.  The committee spent many hours of time on the entire process, frequently, at the cost of family and personal time.

The Context

Historically, PASS nominations were entirely committee-driven.  In many years, there were only as many candidates, good or bad, as slots.  As the years advanced, the board directed that the NomCom alter the nomination vetting process in several ways.  For example, for many years, the NomCom simply rubber-stamped existing board members if they wanted another term on the board.  After experiencing a handful of board members that were unproductive or even counterproductive, the board wanted to make sure that returning board members were subjected to the same rigors as a newcomer.  The NomCom was instructed by the board to develop a set of interview questions to assess the candidates and also to analyze the candidates’ performance as a board member or a high-level volunteer for the organization.  (An unintended consequence of this change was that some candidates without much experience within the organization didn’t pass the vetting.)

As time passed and the board seated many top technical talents, the board began to see a definite pattern of technologists who couldn’t focus on the big picture, couldn’t formulate strategies, and would derail board meetings with unending discussions of deep technical details.  Using a hypothetical example, if the board was considering a strategy around collecting information and feedback from chapters (to better advocate to our founders and vendors about the reach of the organization), some board members loved to spend huge amounts of board time building data models and noodling over what sort of client- and server-side code should be written to support the application, when in fact the board hadn’t even settled on what strategy to pursue.  That’s like spending all your time writing an application without requirements – worse practice!

After all, these other board members had all been great technologists and had willing spirits and giving hearts, but they actually obstructed PASS’ advancement rather than helping it.  There wasn’t anything intrinsically wrong with what they were doing.  They were simply playing to the skills that had made them such successful technologists and key players throughout their careers.  However, it was simply counterproductive.  PASS simply needed more business and leadership skills and less, yes LESS, technical skills in the board room.  Consequently, the board further instructed the NomCom to begin assessing incoming candidates for strategic and leadership skills.  And because strategic and leadership skills were shown through many years of experience to be at least as important as SQL Server-related skills, the NomCom was also encouraged to entertain nominations from candidates outside of the traditional applicant pool in search of those business skills.

The Process Today

As the chair for 2009’s PASS Nominations Committee, it’s my job to ensure that the candidates presented to the PASS membership for the general election meet the standards and objectives set by the board, the bylaws, and the processes and procedures currently in place.  The NomCom had very clear directives and processes (at least internally):

From Here to There, Funny things are Everywhere

From Here to There, Funny things are Everywhere

  1. Collect all of the “paper” applications that come in through the Call for Nominations.  (We received only 11 this season.)
  2. Each member of the NomCom then ranks each “paper” application on a variety of criteria, including criteria like leadership experience, volunteer experience, educational experience, performance, and much more.  Based on those scores, we looked for a clustered scores among the candidates.  There is usually a clear break of a full point or more between the top scoring candidates and the lower scoring candidates, and this year was no different.
  3. Candidates who scored strongly on the “paper” ranking then advanced to phone interviews with the entire NomCom.  (Only seven of this season’s candidates had scores strong enough to advance.)
  4. With leadership skills now as important as other overall skills and experiences, candidates needed to provide the NomCom with a vision statement for what they’d like to accomplish while on the PASS board.  Then, the candidate had to answer questions like “Describe a situation where you were able to use persuasion to convince someone with an opposing view to see things your way” and “Tell us about a time when you had to much on your plate and had to reprioritize all of your projects” and “Tell us about your biggest successes in your volunteer/board work this last year”.  (It is at this stage that a candidate can establish their leadership credentials.  It’s also worth noting that those leadership experiences and examples could come from any aspect of the candidates’ life – not just PASS, or professional work, but examples such as the local PTA, the Girl/Boy Scouts, athletic teams, civic groups, and church activities were all acceptable and encouraged.)  Each candidate was then reranked by the NomCom members with all new scores.
  5. Since the candidate’s volunteer track records was given equal weight to their interview and discussion with the NomCom, a candidate who was strong in both areas would definitely advance to the elections while a candidate who was weak in one area or the other might land on the fence or, in a couple situations, performed so poorly during the interview that they didn’t advance.  (Once again, there was a strong clustering of scores with a top four and a bottom three by a wide margin.)

While the NomCom wanted to put forward a slate large enough to have two (or more candidates) per open slot, the simple fact is that the NomCom only felt a strong confidence in four candidates.  In other words, the NomCom felt that anyone of the four would perform admirably as board members and by advancing the candidate to elections it, in effect, endorsed them.  One of the candidates, Tim Ford, who went through the tough interview process commented on it here.  Once all the candidates were notified, they were allowed to begin campaigning according to the rules set up early this year.

The Fallout

I want to point out that a lot of the criticisms of this year’s elections are, in some form or another, a declaration of what people think the elections should be rather than what they actually are. This is a lot like assessing a family sedan for racing performance, and then criticizing it when the quarter mile and zero-to-sixty numbers aren’t too strong.  The fact is, you’ll always come away disappointed. (Of course, I’m TOTALLY aware that PASS is too veiled about all of these processes.  To extend the analogy, it’s like a family sedan that you can’t tell is a sedan until you get inside of it.)

Much of the turmoil seemed to start with Brent Ozar’s blog post and interview with candidate Matt Morollo.  Be sure to read the comments!  (I’m not going to speak to the specifics of any individual candidate, btw.)  In our case, the nomination process was designed in pre-collaboration days before Web2.0 capabilities were ever conceived.  Transparency was not a strategic goal of the board or of the NomCom, vetting the best candidates was the main strategic goal of the NomCom.  Examples of this sort of criticism, and I’m not saying that the criticisms are wrong only that they target an ideal situation rather than what is currently in place, are illustrated when Geoff Hiten declares a PASS Fail, when Chuck Boyce says It’s the Transparency, Stupid, or when Andy Leonard says that only database professionals should be board members.  Again – these are not wrong per se, they’re simply personally held views about the way things should be.  Marlon Ribunal’s recent blog post seemed to reflect an awareness that NomCom policies are a reflection of directives coming from the board and attempting to help drive the board’s core strategic goals.  Stuart Ainsworth, on his blog entry, pointed out that all candidates should experience a high degree of scrutiny and questioning.  And Joe Webb pointed out that balance is extremely important for board candidates regarding not only their skills, but also who  the candidates work for, what the candidate does in their day job, and much more in his post on the PASS Board of Director elections.

Times, They Are a Changin’

Would You Eat Them Here or There?

Would You Eat Them Here or There?

Web2.0 has definitely arrived on PASS’ doorstep.  The board has, traditionally, not been motivated by transparency coupled with direct collaboration with the wider community.  The gyre of Twitter conversations and blog posts with long trailing conversations are a new experience to many with a seat at the board table.  While it’s important to one or two of the current board members, a transparent and collaborative approach hasn’t taken root with everyone on the board.  Do you want that to change?  Then I am directly calling you to action!  Meet with like-minded individuals at the Summit in two short weeks.  Identify a champion (or two) within the board who will spearhead the effort and then work cooperatively to build the proposal(s).  But beware what you wish for.  Governance changes are surprisingly draining on a board, especially if they’re expected to draft the new governance policies themselves.  In effect, by retooling the governance of the organization, you’ll also be asking the board NOT to accomplish something else among the major goals for the year.  Perhaps the very first proposal should be for the establishment of a Governance Committee that could discuss the issues openly and collaboratively, while taking the majority of the workload off of the board?

There have been so many ideas about what needs to change for the election process, many contradicting one another.  Do you want to require a director to have attended one or more past PASS Summits?  Or do you want to promote diversity between North American and other countries where Summit attendance is probably prohibitively expensive?  Do you want to allow the board to prescribe a certain ratio of consultants versus corporate IT versus vendors?  Or do you want the most experienced candidates, even if they’re all from one sort of  career path?  Or, as these multitudes of conversations have asked again and again, do you want someone who can sling some great Transact-SQL code or do you want someone who has a more diverse viewpoint with more of a general business orientation in their daily job?  Do you want direct open elections without a NomCom or only a cursory check on qualifications?  (Be prepared for a lot of candidates to come out of the woodwork from all over the globe!)  Or do you want to have a strong quality-control process in place for nominees as a prerequisite for the elections?  Would you feel good seeing a candidate conduct a train-wreck of interview in which that can’t clearly articulate why they should be a board member?  That gives us transparency, but discourages a lot of people from considering putting their hat in the ring. Or would you rather shelter them from possible embarrassments?  You get more candidates that way, though transparency declines.  The trade-offs aren’t always so easy.

Let me be direct on a second point – not enough people are answering the Call for Nominations.  If you want to see elections with multiple candidates for each open slot, PASS will need many more high-quality candidates each year.

Finally

I don’t mean to put any one on the spot or make anybody feel bad.  Everyone is entitled to their opinion, after all.  However, I hope that I’ve helped illuminate some of the dark corners of this process and why the NomCom put forward the slate of candidates that they have.  Don’t like it?  I’ve given you what you need to set about bringing change to your professional association.  Let me know what you think!

Thanks,

-Kevin

Twitter @kekline

Upcoming Seminar and SQL Saturday in Florida, Oct 13-17

Sunday, October 4th, 2009

Please join me for SQL Saturday #21 coming up on Saturday, October 17th.  There are over 50 sessions on tap with great speakers from the area and across the nation.  Some of the notable speakers include:

  • Andy Leonard (blog here)
  • Andy Warren (blog here)
  • Brian Knight (blog here)
  • Buck Woody (blog here)
  • Chad Miller (blog here)
  • Joe Celco (blog here)
  • Joe Webb (blog here)
  • Jonathan Kehayias (blog here)
  • Kendal Van Dyke (blog here)
  • Ken Simmons (blog here)

Not only do we have SQL Saturday coming up, but Andy & company put together five world class seminars the week leading up to it! Use code “KKLINE” to get a 20% discount if you register for two or more seminars!

Seminars will be held at the Embassy Suites in Altamonte Springs, FL. Each seminar is $149 and includes a full lunch. Seating is limited, register today!

Attendees of my seminar will get a free copy of my book, Database Benchmarking: A Practical Approach for Oracle and SQL Server, plus other free goodies from my employer, Quest Software. As an added note of explanation, Buck’s excellent seminar centers around detecting and troubleshooting performance problems, while my seminar focuses on writing high-performance and highly scalable SQL and Transact-SQL code.  Why not sign up for both of them to get comprehensive education on the entire process of writing great code, deploying it, and monitoring it for continued excellent performance?

Finally, I’ll be speaking at user groups in the area leading up to SQL Saturday.  If you can join me at my seminar or at SQL Saturday, maybe one of these other events better fits your schedule:

  • Tuesday, Oct 13, Tampa SQL Server User Group (http://www.tampasql.com)
  • Wednesday, Oct 14, Orlando SQL Server User Group (http://www.opass.org)
  • Friday, Oct 15, Jacksonville SQL Server User Group (http://jacksonville.sqlpass.org)

I hope to see you there!

-Kevin

Twitter @KEKline

More content at http://KevinEKline.com

24 Hours of PASS

Monday, August 3rd, 2009

Join me and many other great SQL Server gurus on September 1st for a 24-hour virtual event, 24 Hours of PASS.  I’ll be there along with many of the great SQL community speakers (and personal friends) such as Louis Davidson, Kalen Delaney, Steve Jones, Andy Kelly, Brian Knight, Brad McGahee and many more.  Each session is one hour in length with a 45 minute presentation and 15 minutes of live Q&A.  Local PASS Chapters from around the world will be hosting each hourly segment.

If you live in middle Tennessee, northern Alabama, or southern central Kentucky, be sure to check out our great Nashville PASS chapter.  The Nashville SQL Server Users Group meets on the last Friday of every month.  Hope to see you there soon!

Cheers,

-Kevin