Archive for October, 2009

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

New at SQLMag – Disk2Vhd

Friday, October 9th, 2009

I just posted a new entry on my SQLMag Tool Time blog that you might enjoy. Thanks to my friend and fellow MVP John Paul Cook for bringing Disk2Vhd to my attention on his blog. The free tool is enables migration of a physical machine (PM) to a virtual machine (VM), while the PM is running.  You can download it from Microsoft here.  John also has lots of other great information about VM migration here.  Note that John’s content relates to Hyper-V. So if you’re looking for VMWare tools, keep looking. Of course, if you find similar free tools for VMWare, let us know by posting here!

Thanks,

-Kev
Twitter @kekline
More content at http://KevinEKline.com/

Windbelts – The Next Cool Energy Technology

Tuesday, October 6th, 2009

Windbelts – The Next Cool Energy Technology

Start here to see this revolutionary new technology!  I’m not kidding – this is a huge game changer!

Whether you like it or not, our energy landscape is changing.  Our children’s energy needs will incorporate all the energy resources we’re currently used to – electricity generated by coal, natural gas, and nuclear power plants with automobiles powered by gasoline and diesel.  But their energy needs will also be met by a plethora of other sources, such as wind, wave, and solar methods of collecting energy along with cars power by electricity, fuel cells, and possibly alternative fuels like hydrogen and LNG.  Today, those energy sources contribute less than 5% of our total energy needs.  But, for the next generation, they may contribute 10-25% of the total energy needs in America. Every percentile less hydrocarbon-based fuel that we use represents billions of gallons of oil that we don’t have to import.

One of the biggest obstacles to widespread implementation of any of the alternative energy technologies is the cost of implementation, usually measured as dollars per watt.  For example, older solar panels are very costly (usually around $2/w) as are parabolic mirror systems, which also have a large number of moving parts and, thus, high maintenance costs.  And big wind turbines, while efficient, are also monumental structures built at great expense with big time maintenance costs.  Personally, I really like the promise of wave power because of its constancy.  We will always have waves and tides as long as we have the moon.  Solar and wind, though, are vexed by inconstancy – the sun sets every night on solar power plants and wind speeds must exceed 12 mph to power a turbine on a typical wind farm.  Unfortunately, wave technology is probably about 20 years behind solar in terms of development and has a lot of obstacles to overcome due to the high amount of wear and tear inflicted by the elements.

Wide implementation of any alternative energy can becomes dramatically more effective through tinkering with the equation in one of two ways.  The first way is to improve the efficiency of the technology such that it creates many more watts at the same cost.  The current record for a solar film is about 20% conversion of sunlight into energy, though commercially available solar cells are only in the low teens of efficiency.  On the other side of the equation, we can produce the same or somewhat lower watts (i.e. efficiency), but at a dramatically lower cost.  Thus, our $/w ratio is greatly improved on either the dollars-in side of the equation or the energy-out side of the equation.  Alter either one and the equation behind the technology starts to look promising.

Here’s an example – it currently costs about $20,000 to $38,000 to place enough solar panels on your home to provide 4 kilowatts of power, about what a standard middle-class American home consumes.  A German company just developed a new thin-film solar technology earlier this year which can probably produce nearly as much energy, but for only half the cost.  While it doesn’t enable a typical American family to live entirely off the grid, it is more affordable and has a payback period that’s not measured in decades.  This technology is still in the lab, so it’ll probably be a few more years before we see it commercially available.  (An irony of this scenario is that relatively sunless Germany is one of the foremost leaders in solar technology due to the generous government subsidies in the wider context of energy consumption.  IMO, that’s reason enough to consider our own subsidies so that we don’t get left behind on one of the 21st-century’s important industries.)

Now, there’s an even more exciting new breakthrough in the area of wind energy. It’s called the windbelt, invented by Shawn Frayne.  I seriously hope that Shawn makes a mint on this idea.  But he seems to be taking the even more laudable path of Dr. Jonas Salk, who never exploited his polio vaccine for personal gain.  A windbelt is essentially an aeolian harp string covered in the proper energy producing magnetic compounds which, when buffeted by the wind, wavers near conducting elements on the sides of the windbelt.  Voila!  It produces 10- to 30- times more energy than a turbine.  Plus, it’s extremely cheap and easy to make and maintain while requiring only slight winds, rather than the gusty 10+ mph required by turbines.

With proper configuration, you can build them into windfarms.  But you could also use this technology for really interesting applications.  For example, smart sensors in the HVAC ducts of many of today’s “green buildings” require you to change the batteries every couple of years.  Factoring the cost of the batteries and the cost of the maintenance staff, it’s a couple thousand bucks over the life of the sensor.  Now, with a tiny windbelt attached to the sensor, you could create recharging sensors that don’t need any light at all, using just a breath of wind from standard HVAC ventilation systems.

I’d love to hear your feedback!  Cheers,

-Kev

Twitter @KEKline

More content at http://KevinEKline.com/

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

New at SQLMag – TraceAnalyzer

Friday, October 2nd, 2009

I just posted a new entry on my SQLMag Tool Time blog that you might like to check out.

I’m a big fan of Bill Graziano’s ClearTrace tool, but perhaps you’ll like the new tool from DBSophic, called TraceAnalyzer, even better?  Compare the two and let me know here.

Cheers,

-Kevin

Twitter @kekline