Archive for the ‘SQLServerPedia Syndication’ Category

New on SQLMag – Automating the Startup and Shutdown of Windows Services

Tuesday, April 27th, 2010

I just posted a new blog entry on how I automate the shutdown and startup of Windows services.

Check it out at http://www.sqlmag.com/blogs/tool-time.aspx.  Be sure to let me know what you think and if you have your own unique methods for automating the control of Windows services!

Many thanks,

-Kevin
-Twitter @kekline

Join Me May 19th for 24 Hours of PASS

Monday, April 26th, 2010

Join Us for 24 Hours of SQL Server Training

(with a special focus on SQL Server 2008 R2)

Did I mention that your Cohorts in Crime (that be me and Brent Ozar) are presenting?!?

The FREE 24 Hours of PASS event is bringing an exceptional lineup of SQL Server and BI experts to your computer starting at 12:00 GMT (UTC) on May 19.

Get an in-depth look at the hottest SQL Server and BI topics, including (but not limited to!) – the new SQL Server 2008 R2, with its business intelligence and data management innovations, and much more.

When does it start? 12:00 GMT (UTC):

New York: 08:00
Chicago: 07:00
San Francisco: 05:00
London: 13:00
Paris: 14:00
Moscow: 16:00
Mumbai: 17:30
Singapore: 20:00
Sydney: 22:00

The roster of phenomenal speakers features many MVPs and top-rated presenters, including Adam MachanicAndy Leonard, Brad McGehee, Brent OzarBrian KnightChuck HeinzelmanDean Richards, Don KielyDon VilenDonald FarmerGlenn BerryGreg LowJacob SebastianJessica MossKevin CoxKevin KlineLouis DavidsonMaciej Pilecki, Peter MyersPeter WardRushabh MehtaSean McCown, Simon SabinThomas Grosher.

Check out all the great SQL Server sessions you can attend for FREE. Share this information with a friend or colleague.

PASS is looking forward to having you join us all for this exceptional event. Please contact us at 24hrs@sqlpass.org with any questions.  You can also find lots of general details at http://www.sqlpass.org/24hours/2010/.

April Omnibus

Wednesday, April 21st, 2010

I freely admit it – I’m a sluggard.  I should be blogging a couple times per week and tweeting in between.  But, for some unknown reason, April has been a tough month to get this in gear.  Hence, I’m putting out an omnibus post to cover all of the stuff I’ve been up to, instead of the one-off’s I usually post when I’ve got something new to mention.

Isn’t it funny how life gets in the way of the stuff we want and intend to do?  As they say – “The road to hell is paved with good intentions”, or was that Detroit?  But I digress.

A New Translation!

I don’t like to toot my own horn.  [sarcasm on] You can tell that I’m completely honest when I say that since I have a couple blogs and a twitter account. [sarcasm off]  But one thing I’m really proud of is how popular SQL in a Nutshell is.  It’s now translated into approximately eight languages, with Russian being the newest language:

I'm even more proud of my lil' girl than that book!

I also had the pleasure of working with another translator and I’m looking forward to having a copy of the book in simplified Chinese soon too!

Lots of Speaking Events Coming!

There will be more details on my Events page soon, but here’s the run down on what’s just around the corner:

I also have three “Pain of the Week” webcasts schedule with Quest over the next couple months, with great co-hosts like Buck Woody and Grant Fritchey.  The sessions aren’t officially scheduled yet, but you can find them here.

Also, a big thanks to the local PASS chapter in Houston for the warm welcome they put out when I spoke there on April 12 and to the fine folks in Chicago for their awesome SQL Saturday on April 17th.

New Articles and Session Recordings

I had a couple new articles come out last month which I either wrote or added commentary too, including Master Data Services could spur SQL Server 2008 R2 migrations appearing at SearchSQLServer.com.

The PASS DBA Virtual Chapter just posted a recording of my session on SQL Server Internals and Architecture.

I made an appearance on Microsoft’s Thrive website as their IT Pro of the Month for March.  I also had the opportunity to work with Steve Wynkoop at his SSWUG.org vConference in March.

And don’t forget about the incredibly popular Quest vConference that Brent, Ari, and I did on troubleshooting and performance tuning using SQL Server DMV’s.  You can get the code samples, download the slides, and rate the presentations at http://questkb.com/live and/or http://www.vconferenceonline.com/shows/spring10/quest/conference/ondemand.asp

MacGyver Moments

Monday, March 29th, 2010

The MacGyver meme is making the rounds and I was kindly tagged by my buddy, Thomas LaRock ( blog | twitter) – that most famous SQLRockstar, who wisely chose to tag me early in the process, lest he receive another round of disciplining like the last time.  I’ve also seen several other good MacGyver Moments from Aaron Bertrand (blog), David Stein also known as Made2Mentor ( blog | twitter ), and Denny Cherry also known as MrDenny (blog).  I’m looking forward to reading the bloggers that they tagged to see what others in our community have cooked up.  In case you haven’t heard, your MacGyver Moments are those times when you improvised an excellent solution to a problem using non-traditional materials, techniques, or tools – like the time I repaired my flux capacitor using bailing wire, chewing gum, the tears of Glenn Beck, and the sweat of a master ninja.

I'm a bit more like MacGruber than MacGyver

Necessity is the Mutha of Invention

Believe it or not, I’ve got a long history of doing things MacGyver style.  To begin with, I grew up without two nickels to rub together.  That means you have to improvise – a lot. Once I hit teenage years, I was constantly tinkering with all things mechanical and electrical trying to stretch their useful lifespan beyond any conception of “reasonable use”, much like my teenage dating experiences.  For example, I once cobbled together garage workshop fan from the leftover parts of an electric pencil sharpener, a frame made of bailing wire (yes, bailing wire), solder, and handmade cardboard fan blades.  Shamefully, it did not include any duct tape.  But it worked great!  I had to do that stuff all the time out of necessity, such as with my series of malfunctioning cars and dodgy electronics.  Hey, my MacGyver experiences also taught me that admitting to owning a “Plymouth Horizon” is, when trying to impress the ladies, about the same as sporting a 4″ gravy stain on your “Howling Wolf” t-shirt.

Aaaah, the Plymouth – a vehicle truly designed somewhere between the third and fifth ring of Hades.  I can’t even count the number of jury-rigged fixes I put into that thing.  One that stands out clearly, because my friends used this to prank me on several occasions,  was the repair to the broken door handle on the driver’s side.  Since I couldn’t afford replacement parts, I used bailing wire (I could always count on you, my old friend) fixed to the inner locking mechanism and a key ring as a handle dangling invisibly from the bottom door sill.  About a year after that (around 1986 or so), I discovered junk yards and was able to rip a barely used mechanism from a Dodge of the same body style for $3.  I became pretty well known at those junk yards – I blame Chrysler.  Quality was not job 1 in those days.

Creativity and Innovation can be like that. No buck teeth in my case.

Geek Creativity

Like my friend Brent Ozar, I played a lot of Dungeons & Dragons (D&D) growing up.  I was always the “DM”, that is, the guy who administrated the game, while all my friends played characters on the adventure.  But D&D, like many good products, was designed to suck the dollars right out of your product by producing an endless stream of new adventures to play and supplements to purchase.  I, on the other hand, wasn’t gonna spend a dime of my money on that.  So I created my own adventures (called modules).  As I got better, I constructed campaigns (i.e a related sets of modules) and from that, a related set of campaigns into an entire Tolkien-like world (this is called a mileau) which I called Aquilonia.  My buddies loved it and, realizing that bragging about geekness creates an inverse coolness effect, can brag that I won some contests at regional conventions for game design.

Code Creativity

Back in the day, I remember wondering if I should stop doing things differently than my buddies and peers.  For example, we were assigned to write a program that would find the day of the week based on passing in any pre-Y2K date in one of my COBOL college courses.  (No mocking please – COBOL was big back then). Everyone in the class, and I mean everyone, wrote very large programs that delivered the day of the week through very large (and, imo, cumbersome) IF-THEN-ELSE structures.  My program had two elegant WHILE loops and thirty-eight lines of code based on the premise that our calendar repeats every 14 years and that all months contain at least 28 days and at most 31 days. I got an A+.

SQL Server Improvisation

Back when my IT shop had bragging privileges as one of the largest enterprise installations of Microsoft SQL Server (in the v6.0 and v6.5 days), we were faced with implementing some sort of way to do bi-directional replication.  The product did a good job of standard transactional replication, but bi-directional replication was only possible through a major rewrite of the application.  Instead, we cooked up a way to make it work – SQL Server would allow us do outward transactional replication as the transactions occurred.  We were able to bring the data back by also enabling sync replication (which is non-transactional) every evening.  Thus, we got bi-directional data flows without spending hundreds of thousands of dollars on third-party tools.  (I must also give kudos to the team I worked with and who made this solution work, particularly Dwayne Seiber, who is still lead DBA there.)

Summary

Creativity, innovation, and improvisation are what you make of them.  You must make the choice to pursue them.  Yes, necessity often forces to seek out MacGyver moments.  So does laziness in some cases.  How many master developers do you know who’ll work very hard to fully conceptualize their program before starting to write it, saving time in the long run.  Now that’s creative laziness!  But MacGyver moments also stretch our abilities and call us to higher achievements.

New Webcast – SQL Server Internals & Architecture

Tuesday, March 23rd, 2010

Join me tomorrow for the PASS DBA Virtual Chapter meeting SQL Server Internals & Architecture. It’s the most fun you’ll ever have learning about the inner workings of a relational database – I promise!

Click here to register.

You don’t have to register to attend.  But if you register today, you’ll be entered into the drawing to win one two copies of my bestselling reference SQL in a Nutshell, covering the ANSI standard plus Oracle 11, SQL Server 2008, MySQL 5.2, and PostgreSQL 8.3.

This is NOT the Chameleon in the Bud-Wise-ER commercials. At least I think it's not.

I’ve put the slide deck up in my Slides area of the website.  However, because it contains a lot of big images, I had to publish it as a PDF file to meet my size limits.  That means that all of the animations in the slide deck are shot – and this presentation relies heavily on animation.

Collaboration Nation Call to Action! Calling All SQL Server Bloggers and Twitterers

Friday, March 12th, 2010

The Suggestion

The Modern Language Association hasn’t made up all the new rules yet to govern how one blogger should reverence, er, reference another in their blog posts.  But they should!  Let’s get that ball rolling for them.

I’m not exactly sure who started this format, but it’s my favorite.  When writing a blog post in which you mention another person’s blog, let’s do it like this:

“blogger name (blog_hyperlink | twitter_hyperlink)”

So, we might read a blog post by my friend Kimberly Tripp (blog | twitter) that might look something like this:

“…the Scottish Terrier was so well known in early American society that as recently as the 1910′s, Manhattanite nannies instructed their young charges to be good else the “Scottish Terrier” would eat them, after a lengthy session of slobbery nuzzling and years of canine devotion.  It is for this very reason that I’ve given my Scots/English husband, Paul Randal (blog |twitter), several variations of the nickname  “Scottish terrier”, “scotty”, “snotty”, and “scotsnots” until such a time as needed for me to roll up the newspaper, give him a good spanking, and stick his nose in …”

Well, you get the point.  And didja notice that I worked in not just one, but TWO entire examples of the blog-reference syntax?!?  I can hardly believe my own craftiness.  I went to university for four years to learn that y’know – and to learn how to funnel beer – but I digress.

The Call To Action

One thing I love about the SQL Server community is our very community-ness.  (I also like the fact that you’ll let me invent stupid words on the fly without too much criticism.)  So, let’s make the glob, {ah! damned dyslexia!} , blog reference business even easier by having you (yes, YOU) post your own blog & twitter links as a comment here.

I repeat – post a comment here containing your name, blog (with embedded hyperlink to your blog), and twitter (with embedded hyperlink to my twitter, er, YOUR twitter account).

I’ll then repost a brand new shiny article with a full compendium to everyone’s blog & twitter hyperlinks (except Brent Ozar’s (blog | twitter) ) which you can save to some obscure cranny of Outlook or WordPerfect to call up at a moments notice when the urge to both blog and reference other bloggers strikes you.

Thanks and looking forward to seeing your blog reference soon!

-Kev

-Twitter @kekline

Want Spy Novel Twists in a True IT Journalism Story? Read this…

Tuesday, February 23rd, 2010

David Straithairn as the great Edward R. Murrow in the 2005 film "Good Night and Good Luck"

Journalists are important.  In my opinion, they’re very important. The best journalists, like Old Testament prophets, speak truth to power and reveal the ugly dirt behind the pretty and public veneer of society.  Their very presence foils corruption or, at least, helps reveal it, punish it, and make it dive for deeper waters else go extinct.  It was for this reason that Thomas Jefferson famously wrote:

“The basis of our governments being the opinion of the people, the very first object should be to keep that right; and were it left to me to decide whether we should have a government without newspapers or newspapers without a government, I should not hesitate a moment to prefer the latter. But I should mean that every man should receive those papers and be capable of reading them.” –Thomas Jefferson to Edward Carrington, 1787. ME 6:57

(I’m red-green color blind, so forgive me if that quote is purple or some weird color like that.  I just meant for it to be navy blue. But I digress…)

Sadly, the last couple decades have seen the blurring of journalism and entertainment.  So much so that shock jocks now get byline billing as journalists and real journalists, in the search for better ratings and higher SEO rank, debase themselves and their content by injecting shock appeal.  (This trend isn’t a new thing, btw.  Historically, journalism has had other nadirs in the past, the most prominent being the era of yellow journalism spanning the 1880′s to the early 1900′s.)  Of course, we see this every day on our television and hear it all the time on the radio – have any radio stations on your car tuner that you always skip?  But I’d hardly expect this sort of thing to insinuate itself into an industry news niche like IT journalism.  I mean, c’mon!  IT is about information after all, and any distortion should surely become apparent in due time.

(Full disclosure:  I’ve never been a journalist, but I do write a couple magazine columns – one, a technical column, for SQL Server Magazine and one, an opinion column, for Database Trends & Applications.)

The News Team the Revealed the Evils of McCarthyism in the 2005 film "Good Night and Good Luck"

So I can only begin to explain how jolted I was by this news story released by ZDNet.

The team at ZDNet has done some crackerjack investigative reporting to reveal that an often quoted “Windows Performance Expert” and CTO of a performance management and monitoring products company, Craig Barth, is in fact a fabrication by a well-known reporter and blogger, Randall Kennedy.  Both personalities frequently disparaged Microsoft (not that Microsoft isn’t an easy target, they made BOB after all) and, in some cases, evidently created their own aggregate data, which was then used to identify individuals and broach privacy standards.  Kennedy goes on to say that he did this with full endorsement of the companies he wrote for, and I quote “They didn’t want to lose 2+ million page views per year, which is what the shock jock persona they developed for me delivered.

Journalists, and the managers of journalists, should take this as a wake up call.  When you’re a trusted person, that trust is often your most valuable asset.  I know that the entire media industry is under assault and its revenues are shrinking.  But I hope that this has the positive side-effect of reminding everyone involved that quality and credibility are invaluable.  Said another way, it’s impossible to place a real dollar value on strong ethics, credibility and trustworthiness, except to know that it’s worth a lot.  (Someone remind Toyota and the Wall Street bankers of that too, while we’re at it.)

Thoughts?

Thanks for reading,

-Kev

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