The show goes on…

Posted on

And on and on and on! What have I been up to? Here’s a quick list!

In August, I had the pleasure & honor of present at SQL Saturday Indianapolis and at MADPASS. This coming weekend, I’ll be presenting at SQL Saturday Minneapolis. Then the next weekend, I’ll be travelling to Seattle for PASS Summit!

Additionally, I now have two extremely successful Chicago Suburban User Group meetings under my belt! In September, we welcomed Brent Ozar for our inaugural “reboot” meeting, then had the pleasure of welcoming the SQLSkills crew in October. Both meetings were filled to capacity!

Here’s one anecdote that I want to write about here – more to remember for myself than anything else. Prior to our first meeting, we sent out a Feedback Survey, asking our membership what they wanted out of the UG. One priority was “networking.” I thought really hard about how we could facilitate this – and came up with an idea only an hour before the meeting.

During our announcements, I explained the feedback that we had received. So I asked that everyone simply turn to the person next to them, and simply introduce themselves. All I asked was that they share their name and where they work. I went on to explain that the people in attendance will become faces that we will continue to see month after month. But having names to those faces, will hopefully help people build bonds and relationships over time.

I figured this would maybe last 2 or 3 minutes, before it died down, and we’d proceed to our Q&A segment. Instead people talked… and talked… for the next half hour! It was FANTASTIC! The following month, when I did it again, Paul Randal waved me over and noted that he’d never seen a UG do this before! It really surprised me by made me feel good that my simple idea wound up working out wonderfully.

So things are really looking up right now. I’m super excited about this next SQL Saturday & PASS Summit. If you’re at Summit, do come find me and say hello!

T-SQL Tuesday #59: Pass It On

Posted on Updated on

This month’s T-SQL Tuesday is brought to you by our host Tracy McKibben (b|t).  Today is Ada Lovelace Day, and my good friend Wendy Pastrick (b|t) suggested we ride on that.  As Ada Lovelace had influenced her, we are all writing about Heroes who have influenced us.

For me, a key influence for me is a person I’ve never met, but read about.  In high school, I developed an interest in military history, particularly the exploits of various Special Forces units, including the Navy SEALs.  And this influence comes from retired Navy SEAL Richard Marcinko’s autobiography Rogue Warrior.

Early in his career, Marcinko served under a Navy Chief named Ev Barrett.  Here is an excerpt from Marcinko’s book, detailing a conversation they had before Marcinko left to enter Officer Candidate School:

(Chief Barrett): “Look,” he said, “you’ve learned a lot of stuff now. And you’re gonna learn a lot more.”
I nodded. “Yeah?”
“So I want you to promise me something. I want your word that what you learn, you’ll pass on.”
“Sure.” I wasn’t certain what he was getting at.
“You’re wondering what the fuck I’m saying, right?”
“Dick, it shouldn’t matter whether you work with a guy once or whether you serve with him for years – you gotta treat him the same. You gotta help him do his job. Like I helped you – now it’s gonna be your turn to pass it on.
. . .
“Think of it as Barrett’s First Law of the Sea… “

It’s been about 20 years since I first read that – hard for me to believe.  But even as a teenager, it made a huge impression on me.  Even then, I recognized that many had helped me directly and indirectly, and I had a responsibility and duty to do the same for others.

And now I find myself blessed to be a part of the pheonomen we know as SQLFamily.  I treasure it because we embrace Chief Barrett’s First Law of the Sea.

We pass it on.

T-SQL Tuesday #57: A #SQLFamily Story

Posted on Updated on


I’m back for another T-SQL Tuesday! Today’s is hosted by Jeffrey Verheul (b|t) and the topic is #SQLFamily.

I’ve already written another post about how SQLFamily Got Me Here.  Instead of rehashing that, I thought I’d share a different story today.

The other day, Kathi Kellenberger posted this on the #SQLFamily Facebook Group Page:

Kathi Kellenberger – August 10 at 12:16pm
I had a nice conversation with Andy Yun yesterday at #SQLSat304. We met last year in Chicago during a Cards against Humanity game. This year, Andy is a speaker and getting recognition in the community. This is why we call it family. Sometimes we fight, but mostly we lift each other up.

“We lift each other up.”

Flash back to SQL Saturday Chicago 2013 & the After-Party. Kathi needed a lift back to her hotel, which I was more than happy to provide. It was extremely late, maybe midnight? During the course of the short drive back, Kathi noted that she needed to get a cab to the airport early in the morning. Being the Chicago suburbs, I pointed out that cabs don’t simply hang out at hotels. They must be pre-scheduled, especially for airport runs. I suggested she talk to the hotel front desk to see if there was a 24 hour cab company she could call to make a last-minute arrangement.

And this is where being SQLFamily comes in. I didn’t just stop with that suggestion, because I didn’t want her to risk getting stranded. As a contingency, I offered to come back in the morning and drive her to the airport. Let’s be clear to what this would have entailed. I would be driving 30 minutes back home, crashing around 1-2AM, then getting back up around 5AM, driving 30 minutes back to Kathi’s hotel, then driving her 45 minutes to the airport, before finally being able to go back home which would have been another 45 minutes. This wasn’t a trivial amount of driving, especially on very little sleep.

Yet I never hesitated to offer. In fact, I gave her my number and said that unless she was able to successfully make other arrangements, that I’d come back in a few hours to take her. This is a person I’d only met a few hours before.

Why did I do this without hesitation?

Because that’s what SQLFamily means to me. Going above and beyond, for those who are not simply just industry colleagues and acquaintences. Embracing the ideal of SQLFamily means taking it to the next level. And that’s what I was ready to do for Kathi.

SQL PASS Performance Virtual Chapter – Performance Palooza Post-Presentation

Posted on Updated on

Whew, how’s that for a title?

Earlier today, I had the privilege of being invited to present my Every Byte Counts presentation, for the SQL PASS Perf. Virtual Chapter. This month, they held their Performance Palooza event – 8 hours of back to back presentations! As I half joked on Twitter, I said come see “7 rockstars and a rookie (me)!”

I must say, I had a very fun time presenting today. Taking some advice from Erin Stellato, I kept focused, energized, and upbeat throughout. My friend David Klee wound up being my moderator, which was also a blessing. It really helped to calm my nerves, chatting with a friend, before we got rolling.

If you attended, thank you!! I’m told that I had 118 attendees – a number that still blows me away! I hope everyone was able to come away from my presentation with at least one useful tidbit of new knowledge.

I’ve handed over a copy of my slides & demo scripts to the Perf VC, who will have it posted on their Event Archive shortly. The session was recorded, and it should be posted in about a week’s time.

Thank you Gina Meronek, who suggested me to the Perf VC staff.  Thank you Carlos Bossy, for inviting me to present and answering all of my rookie questions!  Thank you Ryan Adams and anyone else who works on the Perf VC, for this awesome opportunity!

And thanks to all of my friends who attended, and for your tweets of support and praise!

P.S. I’ll be presenting again in a few weeks, at SQL Saturday Indianapolis. I’ll also be visiting MADPASS in about a month, to present there as well. Finally, I’ve submitted to SQL Saturday Minneapolis, so if I’m lucky, you can see me there too!

T-SQL Tuesday #54: Are you Resourceful?

Posted on Updated on


I’m happy to have the opportunity to participate in another T-SQL Tuesday. This month’s is hosted by Boris Hristov (b|t), who asked the community to talk about “Interviews and Hiring.”

Over the course of my career, I’ve had the opportunity to participate in many interviews, on both sides of the table. And regardless of where I’ve sat, I’ve found that my interviews have evolved to focus around one general theme:


I’ll be honest – pure technical interviews annoy the hell out of me. Anyone can memorize a book. I’ve encountered numerous candidates who have committed a slew of SQL Server trivia to memory, but do not know how to put that knowledge into action. And a purely technical interview does nothing to prove whether a data professional can succeed in a real business environment, where book answers are simply not enough to accomplish the task at hand.

The real business world demands that a successful candidate other skills outside of technical knowledge. Strong written and verbal communication skills is an example of one. And for me, resourcefulness is king.


What is resourcefulness?

For the sake of this dialogue, I define resourcefulness as those who may not have an answer to a challenge they are facing, but know what options are open and available to them to find that answer. Not only should they know their options, they should know when to use which options, and when to escalate properly and effectively.

H.R. Giger, the brilliant mind behind the “Alien” creature from one of my favorite film franchises, passed away earlier today. As a result, my favorite film of the series, Aliens, is on my mind and I find myself drawing some amusing parallels. Hope you’ve seen Aliens… and if you haven’t, please go watch it… I’ll wait.

Here’s one of my favorite exchanges between some Colonial Maries, as they are transported to their destination:

Ripley: How many drops is this for you, Lieutenant?

Gorman: Thirty eight… simulated.

Vasquez: How many COMBAT drops?

Gorman: Uh, two. Including this one.

Drake: Shit.

Hudson: Oh, man…

Lieutenant Gorman had a good amount of training & book knowledge. But his lack of experience fails him. And instead of exhibiting resourcefulness, he locks up, which results in his team getting decimated. He did not exercise any of the options that were available to him, to properly react to the alien threat.

As data professionals, we too must prepare for events like disaster recovery scenarios. And when disaster strikes, disasters rarely go “by the book.” We get forced to think on the fly, make use of our wits, and call upon the help of our colleagues. To me, that is being resourceful.


So how does Resourcefulness manifest itself during an interview?

As an interviewer, I carefully choose questions that force a candidate to demonstrate resourcefulness. Some are anecdotal, such as asking about past challenging experiences. Others are hypothetical, such as presenting them with a scenario and walking through it together. I carefully analyze not only what they answer, but how they answer.

  • Did they ask questions of other SQL Server colleagues?
  • Did they researching known SQL Server blogs?
  • Did they mention using #SQLHelp on Twitter?

All of these example options, are options that are available to all of us.

But Andy, not everyone knows about the wealth of resources that are freely available!  That’s absolutely correct! There was a time when I was ignorant of the awesome SQL Server community & failed to make use of it. So then that begs the question, how do you react when you do learn of it?

I’ve come across candidates who were in the same boat, and no, I did not judge them for negatively for their ignorance. What I did do is take the opportunity to talk about the SQL Server community and how valuable of a resource it is. And I absolutely did judge candidates on their reactions. Were they excited? Did they ask to find out more? Or were they dismissive? Did they not care?

Resourcefulness isn’t only about knowing what options you have available, but about embracing new options when they become available to you!

So ask yourself, do you think you’re a resourceful individual?  The next time you find yourself as an interviewee, think about how you can display your resourcefulness.  Or if you find yourself as an interviewer, consider how assessing a candidate’s resourcefulness will help you make a better hiring decision.

Presenting EBC at SQL Saturday Chicago Re-Cap

Posted on Updated on

I don’t think I’ll ever forget, walking out of the Speaker room, rounding the corner, and seeing the hallway JAMMED with people. I thought to myself, why are all of these people out here?!? The rest of the classrooms are down the hall. Wait… these people are lined up to see ME?!?! WHOA!!!

Let’s flash forward a few more minutes. It’s was 3:50PM. I was exhausted, a bit nervous, but ready to rock & roll with my 2nd presentation ever. I look out at my classroom, and while it’s small, it’s PACKED! Then it hits me like a brick wall – the room is SILENT! There was no idle chatter – everyone was just sitting there staring at me. And that sure didn’t help my nerves!

I opted to throw caution to the wind and test my ability to engage in idle chatter with a room full of strangers. I asked the audience how they’ve been enjoying SQL Saturday. That nearly fell flat, but my friend & room monitor Gina Meronek helped save me & keep the chatter going. I eventually started sharing about community & SQL Family. I talked about how strong the community is, and how I value resourcefulness far above raw technical knowledge. By participating and involving yourself in this community, you gain an unbelievable resource to aid you in your career.

And to me, that’s what SQL Saturday is all about – community & SQL Family.

But back to my session. I’m pleased to say that it went really well. I made one key change from my first version I ran in Madison, adding in an audience interactive section, which went really well. I managed to successfully bait my audience into making one particular data type decision, then launched a curve ball at them. It was simple, but illustrated the need to really think about your data when choosing appropriate types.

I was also honored to have Grant Fritchey attend my session. His feedback was gold to me and I’m grateful for it. And as many of you know, he subsequently honored me.  I still don’t have words to describe how I felt about that!

I’m really excited to continue to tweak and grow this presentation, and to give it again at future events!

Am I giving it again? Where you ask?

* SAVO Group (my employer) – May
* PASS Performance Virtual ChapterJuly’s Palooza Event
* SQL Saturday Indianapolis – August; Submitted & hopefully accepted?
* MADPASS – August

Hope to see you somewhere soon!

SQL Saturday Chicago Re-Cap

Posted on Updated on


A year ago at SQL Saturday Chicago 2013, I had shown up to be a volunteer and stuff bags. Through some odd events, I wound up being in charge of all room monitors. After being drafted as a pseudo-staff member, I knew that I had to formally join the Wendy’s band of misfits to plan SQL Saturday Chicago 2014.

And boy howdy, we busted our tails getting everything together. The last few months have really been a whirlwind for me personally, as I combined SQL Saturday Chicago planning with assembling my first SQL Server presentation. But as a team, we worked really well together, and pulled off a fantastic event. I believe we clocked in with an estimated final headcount of 470 attendees! I heard lots of positive feedback all around. And as exhausted as I was at the end of the day, I’d do it all over again in a heartbeat!

Random Highlights & Memories for me:
* Scrambling on Friday, to pick up swag mugs from a freight warehouse 45 minutes south of DeVry
* Speaker Dinner at Schitzel Platz – OMG German Food!
* Tim Ford in a “large box”
* Poncho Man
* Hope Foley’s Geekiest Query Ever
* After-Party sliders catered by The Slide Ride

We’re already scheming for 2015! But until then, there’s many more SQL Saturday’s to attend! Hope to see you at one!