Presenting EBC at SQL Saturday Chicago Re-Cap

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

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

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

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

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!

My First Presentations!!!

I’ve never put much stock in setting long-term goals for myself. I’m not a New Year’s Resolution kind of guy. But a couple of years ago, I did set a loose goal of becoming more involved in the SQL Server community.

I figured at first, I would just network with as many people I could. Then last year, I started to volunteer at SQL Saturdays & travelled out of state to attend SQL Saturdays. Finally, I made it a personal and professional goal to finally attend the PASS Summit.

I achieved all of those goals!

Through those accomplishments, I set a few new goals. For one, I started this blog.  But the bigger, more intimidating goal was to finally start speaking. I had an opportunity to get my feet wet, late last year, by giving a Lightning Talk at Chicago’s SQL Server User Group. This gave me a solid foundation upon which to build a full blown session.

I set my sights on two early 2014 SQL Saturdays in my region – Madison & Chicago. And I am honored and humbled to say that I was accepted to speak at both!

Image           Image

If you come out to one of these SQL Saturdays, you can see me present Every Byte Counts: Why Your Datatype Choices Matter!

I want to give a special thanks to Jes Borland, Eddie Wuerch, and Mark Vaillancourt. When I first started this endeavor, Jes shared some fantastic advice with me on how to structure and put a session together. Later, I attended a SQL Saturday session by Eddie, on speaking and presenting, which also influenced me greatly. He incorporated a dialogue exercise with his audience, so I volunteered my topic idea to work through. Finally, I attended another SQL Saturday session by Mark, also on speaking and presenting. Mark gave me some other fantastic insights and ideas.

So thank you everyone!  Here goes nothing!

T-SQL Tuesday #48 – Cloudy? Whose Problem Is It?

Welcome to my first T-SQL Tuesday blog post! T-SQL Tuesday is a monthly blogging event, started by Adam Machanic (Blog|@AdamMachanic), where SQL Family collectively blogs about a topic. This month’s T-SQL is being hosted by Jorge Segarra (Blog|@SQLChicken). He has asked bloggers to share our thoughts on the cloud?

Thought I’d start with a quick bit of background. At this point in my career, I have not made use of Azure yet. Quite frankly, I’m resistant to the idea of it. And that’s very funny. Why? Because I’m using “the cloud” right now! I’m writing this blog post on a WordPress account, while listening to music via Google Play. I use cloud products like Google Drive, Dropbox, and Evernote. I’ve embraced the cloud in other aspects of my life, but why not the database realm? But I find myself asking questions like what is the benefit of moving our SQL Server databases to Azure? What’s wrong with our current data centers? And most importantly, can we trust our data in the hands of others? Can those who manage “the cloud” be trusted?

The day that this topic was announced, I was having a casual discussion with two colleagues about Azure. One was making a pro-Azure argument, but not for a reason that I would normally consider. He wants to use Azure because he wants to “make it someone else’s problem.” I found myself confounded at that. He pushed that if something goes wrong in “the cloud,” it is someone else’s problem to address and one less thing he had to worry about.

I strongly question that specific argument. My current company is a SaaS company. Let’s pretend that we were to shift everything to Azure. And let’s pretend that Azure suffered a catastrophic outage that also takes us down. As my colleague posits, it is up to a 3rd party to get us back up and running. It’s not our problem. But I would counter that in the eyes of our clients, it is most certainly still our problem. And moreso, I would argue that it is an even bigger problem because our hands are tied and we are reliant upon someone else external to our personnel, to resolve the problem. And can those in control be trusted to do the right thing?

Which brings us back to the theme of trust. Perhaps I’m too much of a “do it yourself if you want it done right” kind of guy, but I’d rather not trust nameless and faceless resources to resolve a problem. Who do I trust to get it done? Myself and my colleagues. I want to keep things in-house. I don’t want problems to be someone else’s problem to resolve – I want it to be my problem to solve.

There are numerous reasons and use cases to consider Azure and cloud-based solutions. But should “making it someone else’s problem” really be one of those arguments?

PASS Summit 2013

In my prior post, I talked a bit about my career journey. I think about how attending SQLSkills’ Immersion Event 1, about 3 years ago, was a career milestone. Well, I’ve just completed another – my very first PASS Summit!

For the past week, I’ve been in Charlotte, NC, surrounded by several thousand other SQL Server professionals. I was given the opportunity to attend training sessions on a wide variety of topics. And boy did I fill my brain! Highlights include phenomenal sessions ranging from the Query Optimizer, Hekaton, Data File Internals, & Filtered Statistics.

In addition to all of the newfound technical knowledge, I grew my personal network. Wait, check that… not my “network”… my SQLFamily!

I had the opportunity to meet a number of other industry idols. I’d followed many of these folks on Twitter, and even occasionally interacted with a few. And at Summit, I was now able to shake their hand, put a face to my name. I only had 30 seconds to meet & greet some of these folks, but it was more than enough. Others, I was fortunate to interact more with throughout the week.

But arguably even more important than meeting these “big names,” I met & spent time with dozens of “regular joes” like myself. Sure, the community has some pretty big names, but for every one of those, there’s still 10 “regular joes” who are just as awesome – just “undiscovered” as I like to think. And I had a wonderful time with many of them as well.

Memories? I have many…

I enjoyed being able to wander over to the Community Zone anytime and recognize at least a handful of SQLFamily!

I enjoyed having an insanely difficult time leaving the convention center, always running into more SQLFamily to chat with.

I enjoyed sitting at a park, watching Twitter, and seeing someone tweet a photo from the other side of said park! Walked over, found and met Gina (@AmazingScotch).

I enjoyed partaking in Star Wars #SQLShenanigans, at the Community Zone (who else took photos?!?).

I enjoyed many late nights, getting to know and have fun with SQL Family.

And I enjoyed #SQLCigars with Ryan (@DBAGooner).

I have so many more, but I’ll ramble about ’em all

Back to technical topics, I’m going to list a handful of topics that I need to dive into. I figure posting it here will help to motivate me further to dedicate the time to explore them. And chances are, they’ll fuel future blog posts! 🙂 So in no particular order

  • Paul White’s Pre-Con Optimizer Demos
  • Plan Guides (Templatized)
  • Plan Guides for nHibernate queries
  • Filtered Statistics
  • Statistics Skew (Tripp)
  • Dr. DeWitt’s Hekaton Keynote
  • Rassumen’s Internals Presentation
  • Kendra Little’s demo scripts
  • Hortonworks & Hadoop
  • EQi — Emotional Intelligence for Presenting
  • Review Twitter Favorites for “links”

Time to dive in!

SQL Family Got Me Here

What a journey it’s been… and still is!  In less than 24 hours, I’ll be travelling in Charlotte, NC, to attend my very first SQL Server PASS Summit!  And what a better way to kick off my first Summit experience, than to kick off my SQL Server blog!

But how’d I get here?  Even before I started my career, I still fondly remember my Database Design class from Marquete University. Taught my Dr. Mark Barnard, little did I know how much influence it would have on my career.

I’ve worked with SQL Server since 1999. Around 2005, I specialized as a SQL Server Developer, focusing on T-SQL & performance optimization.

Then in 2011, things really changed for me. I discovered SQLSkills.com, and had the opportunity to attend IE1: Immersion Event on Internals and Performance, which changed my entire perspective on SQL Server.

I discovered the SQL Server community!  I discovered the SQL Server community on Twitter! I discovered a couple dozen SQL Server blogs!  And I discovered a new career and personal goal – to get involved in that amazing community.

I got my feet wet slowly, lurking on Twitter.  I attended a SQLFriends lunch with Brent Ozar, who gave me some fantastic advice about getting out into the community.  I attended some more SQLSkills Immersion Events, and focused on networking.  I attended SQL Saturdays and am now addicted!  And most importantly, I started meeting people.

Over the past few years, I’ve met many wonderful people.  Someone had coined the term SQL Family, and it is something that I’ve really embraced.  We are blessed, not only to be part of a community, but part of a family!  And I’ve benefited greatly from what others in this family, have given back.  Now the time has come, for me to give back, in my own way.
I’ve chatted about blogging with a handful of members of SQL Family.  Every one has encouraged me to dive in.  But I really want to thank Allen White.  I had the pleasure of meeting him and by chance, having breakfast with him at SQL Saturday Indianapolis, a few months ago.  We talked about blogging and he encouraged me to start blogging.  He encouraged me to share my own perspective.  And that chat really stuck with me.

So here we are!  SQL Family has given me a tremendous amount, and I can only hope that this blog allows me to give back even a fraction of what others have shared with me.  But I can’t give back without trying, so here goes nothing!

Onto PASS Summit!