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!

http://performance.sqlpass.org

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

TSQL2sDay150x150

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:

RESOURCEFULNESS

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

Image

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!

Speaker of the Month

Posted on Updated on

Been working on my post SQL Saturday Chicago & 2nd Every Byte Counts presentation entries over this past week, but had to post a quick entry now.

I was shocked this morning when I opened TweetDeck, to find this:

Grant Fritchey @GFritchey
Speaker of the Month, May 2014: Whoa! Another month gone by already? I guess I better pick a speaker of the mo… bit.ly/1iR2HP6

That was maybe 20 minutes ago, I’d be lying if I didn’t say that I’m still on Cloud 9.

It was more than enough, just to have Grant agree to attend my session, and to receive his feedback afterwards.  But this… wow…

So thank you Grant, and thank you to everyone who attended my sessions in Madison and Chicago!

 

P.S.

Where is he speaking next? I don’t know.

Over the course of this week, I was also honored to be invited to present at MADPASS.  I should be there in August.  I’ll most likely also be submitting and crossing my fingers for SQL Saturday Indianapolis & Minneapolis.

Post SQL Saturday Madison

Posted on

It’s Thursday morning, and I’m still riding the wave after a fantastic SQL Saturday in Madison, WI. Of course, it was my very first time presenting a session, which made it all the more memorable.

We were in a new facility this year – American Family Insurance has a training facility as part of their larger campus, and it did not disappoint. The facility was beautiful! Loved the classrooms and the on-site equipment was nice and reliable.

Image

For my own presentation, I wasn’t terribly many people, since I was up against Brent Ozar. Truth be told, I was perfectly okay with this. But I was pleasantly surprised and pleased that as fellow Speakers learned that it was my first time speaking, they committed to attending. In some regards, their presence and subsequent feedback was more valuable to me as a first-timer. On the other hand, maybe 10 or so people did come out to see me – yes, see ME! What a funny feeling that is!

I’m happy to say that my presentation went very well. I did my best to watch my pacing and not speak too fast as I am sometimes apt to do.

Image

I did have one minor demo goof-up, when querying a DMV and getting 4 records back unexpectedly instead of one. I rolled with it and 30 seconds later realized my mistake – I was still in the Master DB! Oops! Some of the other more seasoned speakers commended me on handling that like a pro.

One other funny anecdote, was when Jim Drame asked if I was going to bring up Page Splitting after my Data Page segement. Why yes Jim, in fact it’s coming up in another two modules! Score! :-)

In the end, I got some fantastic feedback. What made me feel really good though, were feedback sheets from normal participants who said they’d be taking some of my tips & tricks back with them to work. I’m actually excited to tweak the presentation and give it again – that’s how much fun I had!

So yeah, I’m addicted. :-)

Gushing aside, I cannot thank the organizers of SQL Saturday Madison enough, for giving me this opportunity to try my hand at speaking. They put together a fantastic event and I look forward to attending more in years to come!

SQL Saturday #287: Madison – Slidedeck & Demo DB Backup Files

Posted on Updated on

Image

Thank you to those who attended my VERY FIRST session yesterday: Every Byte Counts!  I am grateful for the opportunity to speak, and for the awesome feedback I received from all attendees.

I have just finished posting my slidedeck and a 2012 backup of my demo database.  You may get them here:

http://www.sqlsaturday.com/viewsession.aspx?sat=287&sessionid=20892

https://onedrive.live.com/redir?resid=3151C3F6F6FB2E99!151&authkey=!ACYQDKQ7LnBe4as&ithint=file%2c.bak

I’ll have more post-event thoughts later I’m sure.

Thanks to everyone, who made yesterday a fantastic day!