The second annual SQL Saturday Baton Rouge event is coming up in less than two weeks!  Have you registered?

I’m honored to be speaking at this event again this year.  I’ll be presenting an introductory SSIS class (one of the 7:30 early bird sessions).  Later in the morning I’ll be delivering a talk on expressions and configurations in SSIS, one of my favorite topics.

This event will feature a new track that has not been tried at a SQL Saturday event yet, at least as far as I know.  Patrick LeBlanc, the event organizer (and recent MVP awardee!) added a series of sessions entitled “Ask the Experts”, in which attendees can sit down with experts in a particular discipline and discuss just about anything.  Among the experts participating are Steve Jones, Denny Cherry, Kevin Boles, Bryan Smith from Microsoft, and others.  I will be cohosting the SSIS/ETL/Data Warehouse hour with Steve Simon, so please stop by if you want to talk about anything BI related, or if you just want to say hello.

Have you heard the sound of silence?  Yep, that’s been my blog.

It’s been weeks since I’ve posted anything on here, and to both of my loyal readers I offer my apologies.  It’s been a bit of a wild summer already… I sold my house, moved my large family into a small apartment, and am in the process of buying another house (resulting in, yes, another move later this month).  Add to that the task of organizing one SQL Saturday, planning another for later this year, and traveling to Florida to speak at yet another event.

Sadly, my blog has fallen victim to this overbooked summer.  The good news is, since it’s been a while since I’ve written, I’m overflowing with ideas, and I’m writing to build up my queue now, which will include a new bite-size blog series I hope some of you will enjoy.  I’m also working on some new SSIS videos for SQLShare.com.

In the meantime, you can catch recordings of a few recent presentations I’ve done.  I had the opportunity to present my tenured presentation on SSIS Scripting to the Oklahoma City SQL Server User Group earlier this month (recording here), and I delivered a presentation to the PASS AppDev Virtual Chapter on Intermediate SSIS the same week (recording here).  Coming up, I’ll be speaking at SQL Saturday Baton Rouge next month, and a little later this year I’ll be speaking at Houston TechFest and at least one other SQL Saturday event.

This weekend I flew out to Pensacola, Florida to present a session at SQL Saturday 22.  This was the second SQL Saturday that Pensacola has hosted, and I’ve been fortunate to have attended and spoken at both of them.

I got in around 5pm, travelling with my friend and fellow Dallas area speaker Tim Costello on what might be the most uncomfortable aircraft I’ve ever boarded (if you’ve ever sat on a park bench for 2 hours, it was kinda like that).  We took a ride on the complimentary hotel shuttle (I didn’t realize those still existed) to the Hampton Inn just blocks from the small Pensacola airport, where we met up with Trevor Barkhouse, another of our Dallas colleagues.  Tim and I hitched a ride with Trevor over to the Oar House for the speaker reception, where we were greeted with a brief but intense gulf storm which drove everyone inside for a half hour or so.  They had a good turnout Friday night, where I got the chance to catch up with Steve Jones, Barry Ralston, Rodney Landrum, Brad McGehee and a number of other SQL folks I only get to see a few times a year.

I arrived at the event on Saturday morning about 7:20, just minutes before Steve Jones’s opening session was set to start.  The event didn’t officially start until 9:00, but Karla Landrum and the other organizers had observed at other events that many people show up very early, so they wisely decided to offer an early bird session for the more eager attendees.  I also sat through Pragmatic Works’ Brad Schacht’s session entitled “Introduction to SSIS”, which was a well organized and effective presentation.  I did end up putting my foot in my mouth when I made a comment during the presentation and inadvertently plugged a competing product to PW’s Task Factory Community Edition, though I did catch up with Brad later and offer up my apologies.

I delivered my only presentation of the day at 10:15, entitled “Loops, Lookups and Splits: SSIS Beyond the Basics”.  I had people still coming in 15 minutes into the talk, and ended up running short of seats with 35-40 in attendance.  The presentation went well, and we had some good questions and discussion throughout the session. (Sidebar: If you attended this session, I would appreciate your feedback here.)

With my session done, I sat in on a number of other great sessions, including a Kevin Kline lunchtime presentation on SQL injection attacks, Joe Webb’s locking and blocking discussion, Patrick LeBlanc’s comedy routine / CDC discussion (which was the most entertaining hour of the day) and Ryan Duclos’s talk on managing SSRS reports.  The end of day assembly and giveaway was handled very well, and I think most people stayed around for it.

The attendee party was held again this year at Rosie O’Grady’s in Seville Quarter, an area that reminds me a lot of Bourbon Street in The Big Easy.  There wasn’t a huge turnout at the dinner, probably due in part to another nasty thunderstorm raging outside.  Karla had rented a shuttle bus to make a couple of round trips from the Hampton to Rosie’s, which was a nice touch since several of us didn’t rent a car.  I spent some time mingling with attendees and speakers, and got to meet up with a few attendees that attended my sessions at last year’s event.

Karla and Rodney Landrum and the rest of the Pensacola SQL group did an outstanding job of organizing this event.  I said last year after their inaugural event that it was one of the best run SQL Saturdays I had yet attended, and this one was even better.  Here are a few notes on what I observed:

What worked well:

• Communications from Karla leading up to the event
• Hotel very nearby airport (with a free shuttle!), within walking distance to event
• Shuttle bus to/from attendee party
• Event guide was well laid out
• Session and event evaluation forms included in attendee bags
• Attendee and volunteer shirts to help attendees identify each
• Lunch was excellent!
• The presentations scheduled during lunch were good options for those that didn’t want to have an hour of downtime

What could be better:

• Signage.  There wasn’t a lot of signage on the roads heading to the site, and few signs inside the buildings.
• Event evaluations were fairly terse.  A simple 1-5 rating for the session and an area for comments are all that were provided.  As a speaker, I like to get feedback along different axes (content, my presentation skills, etc.) so I’d like to see this expanded a bit.
• Water and/or juice with breakfast.  I didn’t find anything but coffee with breakfast, and there are a lot of people who don’t drink coffee.

The good things overwhelmingly outweighed the shortcomings, in my opinion, and I’m going to call this one a success.  Congrats to the Pensacola crew for an outstanding event, and I look forward to participating again next year.

I’d like to share a networking success story.  Last year, I blogged about my experience at the PASS Summit of 2005, where I was essentially a wallflower and didn’t really do any networking.  Since then, I’ve realized its importance and have embraced professional networking as a key component in a successful career. 

Ever since then I have carried through on the lesson I learned, spending as much time as possible getting to know my colleagues, and lending them a hand whenever possible.  At the PASS Summit this past November, I got the chance to redeem myself from the lack of initiative from my trip four years earlier, and took the opportunity to get to know as many people as I could.  During lunch on the third day of the Summit, I met a fellow Dallas-area business intelligence professional who works for a small consulting firm in my area.  He mentioned that his company was looking to hire one or two more senior BI people, and I hinted that I was considering making a move.

To make a long story short, that encounter led to a few phone calls and a series of meetings with this company, and as of next week, I will be a permanent part of their team!  My new role at Artis Consulting will be as a business intelligence consultant, solving complex business data problems alongside some very sharp coworkers.  I’ve had the opportunity to spend a little time with all of the leadership and several of the staff members, and I’m very excited about this move and the new challenges that it will bring.

So back to the success story… Looking back at the events of the past couple of months, I don’t believe things would have ended up this way without the groundwork I laid through networking.  In the last few years, I’ve spent a good deal of time working with and getting to know the folks in my local SQL Server user group, which in part led to my leadership role within that group.  That leadership position helped me to meet and develop friendships with other SQL Server group leaders, and one of those relationships led directly to a friendly introduction to my initial contact at Artis, resulting in the interviews and eventually the new career with that company.  It's important to note that my new role at this company was not openly advertised as a vacant position, so I would likely not have found this opportunity through a traditional job search.  I do believe that there was a greater comfort level on both sides of the interviewing fence after we came together through a known and trusted common contact.

My recent experience is further proof that building professional relationships through networking is a great strategy for career improvement.  If you’re like I used to be – introverted, a bit shy, perhaps doubting the value of professional networking – I encourage you to take a chance and get to know some of your peers and colleagues.  Find a local user group in your area of expertise, and set a goal to meet X number of people.  Attend a local technology event such as a product launch or a SQL Saturday, and introduce yourself to others there.  Invite a colleague you don’t know to lunch or coffee.  Volunteer to be part of a team in events such as GiveCamp.  There’s nothing to lose!  The very worst thing that can happen is that you’ll meet some people you’ll never see again.  And often, things work out such that your networking contacts work together to change your career for the better.

"Fortune favors the bold.”  -- Virgil

So for the latest database geek meme, Paul Randal started this thing off and tagged Tom LaRock, who enlisted Grant Fritchey, who finally tagged me.   This one simply asks, “What 3 things or events brought you to where you are today?”

The Eyes

Barely a year out of high school, I was working full time in retail and occasionally attending classes at the local community college.  Through my job I had befriended a local Marine Corps recruiter, SSgt. Tennant.  Doing what recruiters do best, he saw a young man who could use a little direction and discipline, and invited me to lunch to discuss my future.  After a few months of meetings with the staff sergeant, I was convinced that I was to be a United States Marine.  I would enlist and become an MP, pursuing a dream (up to that point, anyway) to be a police officer.

SSgt. Tennant was on vacation on the weekend I was to make it official, so another recruiter drove me to the enlistment station in Dallas, where I underwent a battery of physical exams, blood tests, urine tests, aptitude tests, hearing tests, and a variety of other procedures.  At the end of the second day, we had reached the point of no return – I was called into the CO’s office to put my name on the big contract.  I brought up the specifics of what I would do as a Marine, citing my intention to work as a military police officer, but it was then discovered that my poor eyesight, although corrected to 20/20, would disqualify me from serving as an MP.  I was invited to still join up, but in a different MOS (method of service).

Now in retrospect, had SSgt. Tennant been there to counsel me, I probably would have still enlisted.  But there I was, young and naive, surrounded by strangers and incredibly disappointed that my well-laid plan was not to be.  I spent a couple of hours by myself in the enlistment station, pondering whether to join up or walk away and regroup.  In the end, I chose the latter.  Was it the right choice?  I must have asked myself that a hundred times since.  Whatever the answer, it’s clear that the choice I made helped get me to where I am today.

The Boast

Twelve years ago, I had a friend who was searching for a new career.  He wasn’t quite sure what he wanted to do, and he decided to explore a couple of different options, including taking some vocational training.  Our local community college offered a computer repair course, essentially a CompTIA A+ prep course, and he seemed to enjoy learning the basics about computer hardware and software and such. 

At the end of the course, he took the A+ test and unfortunately did not pass.  I remember bragging that I had always been a computer whiz in high school and would probably excel at such an endeavor, and certainly would have passed the certification exam on the first try.  My embellished tales of brainpower and academic prowess must have reached the maximum BS threshold, and I received a good old-fashioned southern put-up-or-shut-up.  Not to be bested by a challenge, I scraped up the $500 to take the computer maintenance course – and for the record, I did excel in the course, and I did pass both A+ exams on my first try.  More importantly, the bit of experience I gained through the course and exam prep led directly to my first technical job – it wasn’t glamorous, mostly installing white box computers and deploying Ghost images, but it was the foothold I needed to get started in the business.

The Notebook

No, not the sappy chick flick.  Back in the early 2000s (Is that really what we’re going to call the first 10 years of this millennium? Bah.), I was working as part of a 3-person IT team supporting the entire technical infrastructure for a 10-campus, 6000-student school district.  We didn’t even have a ticket tracking system of our own, instead relying on the antiquated system used by our building maintenance department, and because we didn’t own enough licenses for our IT staff to directly access their ticketing system, I had to rely on printed reports to administer our workflow.  We could only open or close tickets by submitting hard-copies of the request forms, and it often took weeks for the maintenance secretary to open or close an IT ticket in the database.

I started keeping these reports and written forms in a three-ring binder that we dubbed The Notebook.  Twice a week I would print out a list of the “current” (yuk yuk) list of tickets, and had a rubber stamp that I would mark those that had been completed but not yet marked as such in the database.  Also stored in The Notebook were copies of the hand-written requests awaiting data entry.  The system worked, but was a time sink; I would often spend 15% or more of my time just keeping up with workflow issues, not to mention the wasted time and opportunity cost for the entire team for lack of having the right information at hand.

So I began quietly keeping track of wasted hours, as well as researching ticket tracking software packages.  I found a package that was affordable and relatively easy to administer, and, with an armload of research data, presented to my boss a software solution to the problem of The Notebook.  After much convincing, my request was fulfilled, with one stipulation: that I learn enough about SQL Server to maintain the back end and create a few reports.  It wasn’t long before that one SQL Server installation helped me find my true calling, and it slowly changed over from a secondary duty to a full time career.  And the rest is history.

So, to keep this little meme going, I’ll tag the following:

Aaron Bertrand (there’s likely to be an amusing story there)

Kendal Van Dyke (those Florida guys can always tell a good story)

Lee Everest (a fellow Dallas-area guy, and I’m curious to know how he got started)

I’m also going to tag Kevin Kline – I know he’s already been tagged, but he was missed during the last meme and was taking it pretty hard.