Presentations, SQLSaturday, Uncategorized

Let the SQLSaturdays for 2014 Begin!

After my normal holiday hiatus from speaking, nice to get out to some early SQLSaturdays to begin this year.  First up was Nashville.  The Nashville event is great for so many reasons but it holds an ooey gooey sentimental spot in my heart.  Nashville was where I gave my first presentation at a SQLSaturday.  It was also being led by my dear friend/sqlfamily, Tamera Clark (twitter|blog) so I just HAD to go.  It was about 5 hours from me so I drove down on Wednesday.  Went down little early to do some work on a project.  My BlueGranite colleague, Josh Fennessy, (twitter|blog) was also speaking so took opportunity to work with real live person, in person!

Speaker dinner in Nashville
Speaker dinner in Nashville

SQLSaturday events began with the speaker dinner was at a very funky place called Saffire.  It was in an interesting old factory.  Good food, good beer, and plenty of catch up time.

More speaker party in Nashville
More speaker party in Nashville

Event day comes early to setup the booth for BlueGranite.  So extremely proud that my company helps to support these events!  We meet great people all over for both opportunities but especially for recruiting.  I know the last 4+ people hired at least seem to have been plucked from the SQL Server community.  Just a fantastic thing!

We just have no fun at these events.
We just have no fun at these events.

After time chatting up folks at the BlueGranite booth I head to the WIT panel discussion.  Wendy Pastrick (twitter|blog) was the moderator.  The super lovely panel included Arlene Gray (twitter|LinkedIn), Rie Irish (twitter), Julie Smith (twitter|blog), and myself.  It was a nice refreshing discussion that had very little to do with gender.  The topic was just in general how to keep the young whipper snappers going into IT positions.  One of my favorite points was made by David Maxwell (twitter|blog).  He expressed that folks in IT like to complain and rant.  It’s how we bond and let off steam which is fine.  We should also be aware though if we always are stressing the negative.  We like our jobs and it drives a lot of passion in us.  We need to make sure, especially with young ones, not to let the complaints always take over the conversation.

***

After that was my session on SQL Server server performance.  It went pretty well.  I got some great ideas to tweak that presentation from Rob (twitter|blog) and Julie.  Thanks guys!

***

After my session I was able to catch Denny Cherry’s (twitter|blog) presentation on indexing internals.  He’s on the west coast so not very often outside of Summit that I am able to catch him speak so was excited about that.  Excellent stuff!

Denny going over index internals
Denny going over index internals
People streaming in for the prize drawings to wrap up Nashville.
People streaming in for the prize drawings to wrap up Nashville.

Up next was Cleveland this past weekend.  I missed Cleveland last year and pretty much made up my mind then and there that I would not miss it this year.  As I was submitting, started looking at the schedule and then began to have a bit of organizer envy.  It was really a phenomenal line up and was honored to be a part of it.  So Friday I get some work done in the morning and then drive over in time to make it to the speaker dinner.  The dinner was at an Italian restaurant and they had a nice sit down meal.

Speaker dinner in Cleveland.
Blurry but here is speaker dinner in Cleveland.

Saturday began again very early to setup the BlueGranite booth.  Again very proud for being a sponsor for this event and for such a strong presence of speakers.  Cory Stephenson (twitter|LinkedIn) also helped organize the event.  I spent most of the day at the booth having great conversations.  The booth had a nice spot right next to the curly slide.  Yes I said slide, no typo there.  Hyland Software’s building had a couple slides…how cool is that?!

Opening remarks by Tom LaRock
Opening remarks by Tom LaRock
View from the booth next to the slide.
View from the booth next to the slide.

My presentation was in the afternoon and it went pretty well.  I gave my most favorite session…spatial data.  The conversation during that session gave me a lot of great ideas for making some tweaks to it.  Thank you very much to those who came and gave feedback.  Check out my favorite feedback from David Maxwell’s 11 year old daughter below.

***

What could the speaker do differently to improve? – I saw some confused faces in the crowd.  Check to make sure everybody is on the same page before you move on to the next bit of your presentation. 

***

11 years old!  And excellent advice!  David make sure when she enters the workforce that she sends me her resume!  Also really wonderful you took her to a SQLSaturday as well.  I hope she enjoyed it!  I am hoping to take my daughter to one this summer as well.  Love seeing the little ladies being exposed to great people in the technical field.

Grant goes uni-bomber
Grant goes uni-bomber

The after party was at Dave and Busters.  It was nice to sit and relax after a long day.  Had some very interesting conversation with sqlfamily that included zombies and tilapia (don’t ask).  After that was some Cards Against Humanity.

CAH time!
CAH time!

The next morning catch some breakfast with some SQL Family before heading back home.  The snow overnight made the journey back a little stressful.  The roads were really horrendous through most of Ohio.  Just another hit from the winter without end.  I still would do it again.  Both events were top notch and thank you for having me.  Will be taking some ideas back for the next SQLSaturday in Indy (shameless plug pointer to website here).

Advertisements
Presentations, SQLSaturday, Uncategorized

SQLSaturday 256 – Kalamazoo

Last weekend was SQLSaturday Kalamazoo.  This lovely little SQLSaturday has worked it’s way onto my regular yearly list.  It’s a short little drive from me in Indy and the people involved are wonderful!  Didn’t need more reasons but is also now home base for my company, BlueGranite.  Stormy weather ended up delaying my departure up there on Friday.  Trick or treating was postponed on Thursday to Friday for the first time that I can remember.  My kids are 8 and 5 so there is no way I was going to miss trick or treating so I missed the speaker dinner.  It was at a brewery that I’ve never been to so was sad to miss it.  I had a good time running around the neighborhood with Wolverine and a ninja though.  So we get to Kalamazoo around 11:00 pm.  My husband, Rod, went with me again in further efforts to get him hooked on SQLFamily (insert evil mwa-haha laugh).

Thank you sponsors!
Thank you sponsors!
Gareth helping out at the PASS booth
Gareth helping out at the PASS booth

Get up and get a quick workout before heading over to the venue.  My session wasn’t until after lunch which is a pretty nice slot to have, late enough to get settled and time to run through demos but not super late.  I am normally distracted with my own session until it’s over so stinks a bit as I don’t normally attend sessions before mine.  They had an amazing lineup so was a little bummed to miss so many great presentations.  It gave me time to chat with many of the folks from BlueGranite though.  We had 4 speakers represented and then Josh (twitter|blog) and Amy (twitter) organizing!  We were also a sponsor so got to meet Mike Depoian (linkedin), VP of sales as he assisted at our booth.  Being a completely remote company, was a great opportunity to put faces to Lync avatars.

Ok demo, you are working now. Please work later!
Ok demo, you are working now. Please work later!
Amy at the BlueGranite booth
Amy at the BlueGranite booth

My session came after a nice taco bar lunch.  I am so jealous of those who have venues that allow outside caterers.  I just love the taco setup for a big group like that and is nice change of pace.  So nice and stuffed in a super hot room….zzzz!  No it turned out well even though I was a little nervous with this one as I hadn’t done it for several months.  I was more worried that I was on a new laptop.  I had only had the new machine for a few days and had installed the latest bits for everything I could.  Little nerve wracking but it gave me an opportunity to get folks info on some new performance counters for SQL Server 2014 which was great.  Everything seemed to go well and I got wonderful feedback.  Thank you for everyone who came to my session and especially those who gave feedback!

Talking about performance counters or describing a cheeseburger.
Talking about performance counters or describing a cheeseburger?

Then gave big sigh and decompressed a bit.  Ended up only in the last session of the day for Michael Swart’s (twitter|blog) session “5 Easy Pieces”.  I love hearing of people’s experiences, soaking up others wisdom.  He is another one of those lovely polite Canadians and had some great stories to tell.  I especially loved the one on indexed views.  He had a situation where the difference of edition to standard threw off performance in relation to an indexed view.  He had to use WITH (NOEXPAND) to resolve it.  Great session Michael!  I enjoyed it very much.

Michael sharing lessons learned
Michael sharing lessons learned

After giveaways most of the speakers went over to The Mix.  I was a little nervous as it was a bit of a young pup bar on college campus but it turned out really fun.  Josh and team had setup a KJ to perform, yes karaoke.  The KJ was a good one and won me over with a rendition of Run DMC’s “Tricky”.  I think I am going to go with the angle that I didn’t karaoke that night.  I don’t think that which may be construed as me doing karaoke counts.  Can I keep my record?  After The Mix we head back to one of the hotels for hanging out and some Cards Against Humanity.

An experts panel session
An experts panel session

The end to a really great weekend was made even better due to the graciousness of those fine Ford folks.  Tim (twitter|blog) and Amy hosted a really nice brunch for everyone at their house.  Thank you both so much for that!  It really ended the weekend perfectly!  The event was flawless from my point of view and got a nicely timed post Summit SQLFamily fix!  Oh and we got great jackets!  I didn’t think they could top the nice jackets from last year but they did!  Check those pictures…they look great!  Thanks for having me up to speak and for the super nice jacket!  Josh, you guys did a great job!  Congrats on a wonderful SQLSaturday!  Also thank you to my hubby Rod for taking all the great pictures.  If you want to see the full set of them they are uploaded to link below.

Prize giveaways at the end of SQLSaturday Kalamazoo
Prize giveaways at the end of SQLSaturday Kalamazoo

http://www.flickr.com/photos/hope_foley/sets/72157637308193364/.

SQLSaturday, Uncategorized

SQLSaturday 232 – SQLSaturday in the Land of Tourists

I was a little later than normal getting this post out since I literally got a new job the day after getting back from SQLSaturday 232 (see post).  I didn’t forget you Orlando!  This was an exciting SQLSaturday for me.  It was the first time my husband went with me to a SQLSaturday outside of my local one in Indianapolis.  That one is a whole different ballgame since it’s one I organize and I put the whole family to work for me (evil slave-driver I know).  SQLSaturdays and SQLFamily are important to me so I was determined to get him introduced to these events and folks he hears so much about all the time.

***

We flew in on Friday.  I was half tempted to come earlier for some of the fantastic precons going on but decided better not.  We were already planning on staying a couple days afterward for some tourist fun.  We made it in town with plenty of time to get to Karla’s (blog|twitter) house for the speaker dinner.  God bless her, she was the main organizer of this SQLSaturday AND was brave enough to have the party at her house!  I love parties at houses, very intimate and laid back.  No way I am that brave/crazy though.

Look at all that orange!
Look at all that orange!

Next morning up early.  Not early enough to catch the early bird sessions.  They had some sessions that started at 7:30am!  That was the first time I had seen sessions that early.  I made it in time though to get situated before Jonathan Kehayias’s (blog|twitter) session.  I was on a mission to meet him and catch his session since he’s often my reference of SQL knowledge (“well I’m no Jonathan Kehayias but…”).  I accomplished both so was a happy camper.  He had a packed room for extended events session.  He showed some great stuff like how he finds the culprit of ASYNC_NETWORK_IO waits with them.

Jonathan Kehayias session on extended events
Jonathan Kehayias session on extended events

After his session was mine on spatial data.  I was anxious to get a practice run of my upcoming PASS Summit session.  It went amazingly well!  I had a really engaged audience and many who stayed late to chat more and discuss things.  I got some good feedback and some ideas to make session better for next time.  I wanted to answer all questions I had after my session so I was late to my lunch duties.  Andy Warren (blog|twitter) and the team in Orlando have a tradition of having the presenters help serve lunch which is a nice idea.

The lead chef, Andy Warren.
The lead chef, Andy Warren.
The speakers serving up the grub
The speakers serving up the grub

After lunch I went to Mike Davis’s (blog|twitter) session, “Complex DAX Functions”.  He ended up having a fairly new to PowerPivot audience so much of the beginning he had to go over basics.  He did get to some of the advanced topics such as creating a many to many relationship.  After that I went to meet Doug at the Confio booth.  It was kind of a crazy crossing of my two worlds a couple weeks earlier.  I found out one of my best friends from college had a brother who worked at Confio!  From there it was on to Mike Hillwig’s (blog|twitter) session on VLFs.  I had seen it before but well he’s just great so I went again.  I was glad I did as saw a lot of his progress on the session from before.  Nice job Mike, flow was much improved.

Mike Davis going over PowerPivot
Mike Davis going over PowerPivot
Mike Hillwig going over VLFs
Mike Hillwig going over VLFs

The last session of the day was from Tim (blog|twitter) and Amy Ford (twitter) and their experience with telecommuting.  I had been talking with BlueGranite for quite some time so I knew that telecommuting could be in my future.  I was anxious to hear what I could be in for with working from home.  I was lucky enough to get that job with BlueGranite, so have put some of them into action from the get go like having my own work space.  Next I witnessed the other tradition of Orlando SQLSaturdays which was the tossing of giveaways and swag from a decently high balcony. I forgot to ask Karla if they get extra liability insurance for this piece.  The organizer in me was squeamish at this!

20130914_163053
Tim and Amy Ford on telecommuting
Watch out now! Flying swag!
Watch out now! Flying swag!

The after party was held at 4th Street Bar and Grill where we had a nice outside section to ourselves.  After some beer and lobster mac n cheese, Karla was crazy/brave again and invited folks to their house for the after after party.  We had such a good time!  The hubby couldn’t stop talking about playing those drums for days!  Thank you to Karla/Rodney (blog|twitter) for the hospitality of your house both nights.  Thanks to Karla and the entire Orlando team for a great event!  So glad you all invited me to come speak!

SQLSaturday, Uncategorized

SQLSaturday 242 – The Empire Strikes Back

SQLSaturday 242 wasn’t attacked by AT-ATs, I just couldn’t resist the chance to use that title.  Last year I cheesily went with “A New Hope” for my blog post title for all the lessons learned and how changed I was from the process.  It’s not that often you have an opportunity for a Star Wars reference AND a shameless previous blog post plug wrapped into one so I had to do it – please forgive me.  Besides it works if you consider I did feel a little like I was frozen in carbonite the day after SQLSaturday 242.  Alright now that I’ve got the Star Wars-ness out of my system, and I’ve had some time to recover it’s about time I got my blog post out from my experiences being the lead organizer of SQLSaturday 242.

***

This year was much different than the last couple years. Those past years I was very involved and helped in organizing but had the wonderful Caroline leading the the way.  This year I had to step out on my own and lead. Oye, I should have thanked Caroline more profusely in the past years!  There was just so much she did that I  wasn’t even aware. God bless ya Caroline! I was excited to do it though. I was anxious to right some wrongs that bothered me since last year (again see blog) and help pay forward to the SQL community some of the goodness that SQLSaturdays have brought to me over the years.

***

When I started planning this year I was determined to find a new venue. The place we had been the past years was a great venue, just located in an area where it is scarce to find good hotels for my speakers. Since the hotel was the main thing sticking in my craw from last year, hell or high water was going to rectify it this year. And I found a great place in a great location with Indiana Wesleyan on the northside. They were great to work with and good hotels were plentiful. We didn’t even have any act of god storms or issues in the hotel.  Demon exorcised – halleujah!

Registration team rockin it!
Registration team rockin it!

Honestly too it is great relief that I REALLY TRULY know the full ins and outs of what this event takes to happen. There were so many unknowns I had going into this event having not sat in the lead spot that it drove me completely nuts. I would keep myself up at night just sitting and making list after list to try to think of everything I needed to do.  I wanted with my hometown SQLSaturday more than anything to take care of my people: my speakers, my sponsors, my volunteers, my attendees. I want them all to just feel like we were taking care of them.

Have you thanked a sponsor today?
Have you thanked a sponsor today?

Friday comes and I got at it early so I could get Bill Pearson setup and going for his precon since PTI was hosting it. We had some hiccups with the projector software but Bill, being the pro he always is worked through the rough patches and we worked it out. Then I begin setting up the attendee packet stuffing station.  As I looking the table of 1000 laps and a million sponsor flier papers, I started to get a bit panicked.  I then called in the calvary…my saint of a mother in law, Pam who agreed to help out.  Then when the blessed, wonderful Chris and Gigi Bell show up they help make fairly quick work of it. Alan Dykes also shows up and helps me with the monitor setup. I had attended SharePoint Saturday and they had monitors outside the rooms to display the current and upcoming sessions. I thought it looked slick so we worked that out but it wouldn’t have happened if Alan hadn’t had stepped in to help with it.

WIT panel - wish I was able to see this one :(
WIT panel – wish I was able to see this one 😦

Later that night comes the speaker dinner. We ended up doing bowling again this year which was fun. It’s not fancy but is a great way to get folks loose and chatting. I think it went well and seems like all had a good time. I got some cupcakes to help butter folks up too just in case.  I started to loosen up a bit and some of the weight begins coming off my shoulders since by that point, if it ain’t done it just wasn’t gonna happen.

Was great to make SQLSaturday a family affair
Was great to make SQLSaturday a family affair

Then comes Saturday and we are up at the crack of dawn to get the mad dash going to get things setup. We weren’t able to get in till 7:00 and we had registration starting at 7:30 so it didn’t leave much time for things to fall into place. The morning was just nuts, it’s just the way it goes even if things run like clockwork with an event with that many people. I had to get the computer and printer setup for the SpeedPASS printing area of shame. Never fails, you will just have folks who don’t print SpeedPASSes no matter how many pleas you send.  I bought a printer that we ended up raffling off at the end of the day which worked out really well. Just make sure if you stay up the night before getting the drivers and crap setup that you plug it in and do it in the same manner you intend to on go day. Damn thing installed drivers anyway since I plugged it in instead of using the wireless.  As the morning moves on we run into more bumps. This was my first year also to administer the site for the event. It turned out I didn’t have some of the sponsors selected to be in the SpeedPASSes so I had to hurry up and make some raffle tickets really quick and get them printed them for folks to fill out (was able to scan SpeedPASSes off of computer for these sponsors after the event to help rectify this wrong). While I was doing super fast design work, I didn’t have time to think over what I needed to say for opening remarks. I think I may have sounded like a stressed out Elmer Fudd yammering thank you and that was about it.  I meant to say more so folks were aware of little details.

Elmer Fudd in action
Elmer Fudd in action

The rest of the day moves on and things start to settle down from morning craziness. We had some more minor hiccups that had us bobbing and weaving but we came out of it without much damage. Lunch came and went and things went as smooth as I think lunch for 191 people can go and it didn’t take terribly long to get folks through the line. We didn’t have a large area for people to eat so we needed to have folks disperse into the various rooms. Something I think I could have gotten across again in opening comments. Rest of day goes well and we were very lucky to have great sponsorship so were able to get a lot of great prizes to give away. We were needed to get out of the venue fairly quickly so we tried to move through them at a quick clip.  Sometimes that portion can drag along if you let it.  I let out a large sigh of relief and it was over.  We cleaned up really quickly thanks to all the volunteers on deck.  We then get a good size group headed out to Scotty’s Brewhouse for a much needed beer and some food. I got a bit misty eyed when I got a good amount of applause when I arrived (I love my SQL peeps).  From there some found a Korean place that had private karaoke rooms so some brave souls headed over. We had a blast but it was a tad bit interesting/disturbing with the Korean dramas going on the screens while you (not me) sang. Who knew you could possibly add weirdness to SQLkaraoke but by god we did.

This was needed desperately at the end of the day!
This was needed desperately at the end of the day!

Thank you so much to everyone who helped me with SQLSaturday 242! Thank you so much to my family, Rod, the kids, and my saint of a mother in law Pam. You put up with my distraction, picked up my slack, and even helped with the event.  I was so glad you all could be a part of one of these.  It means a lot that you got to see a little glimpse into these crazy SQLSaturday things you hear so much about and got to see this side of my life.  Thank you to Sally at PTI who helped me get so many things together and cut more paper than a human should!  Thank you to everyone at PTI for helping me, allowing me the time and resources to organize this event.  And thank you to Alan for your help all along the way and handling those damn monitors! And my registration crew: Gigi, Katie, Courtney, and Stephanie!  You ladies just killed it at registration and all through the day! I can’t thank you all enough!  Brandon Lukes thank you for your help!  Thank you Eddie for handling the precons.  And countless others who helped me, thank you! From every fiber of my being, thank you! It meant the world to me to have so many help make this event a success.

***

And since I am selfish and figure I need all the good SQLSaturday karma I can get, here are some recapped lessons and a few more thoughts on SQLSaturday 242 Indy.

1. Make sure you keep a good list of sponsors and the raffle prizes they intend to give away. You need to keep good track of the ones they are bringing themselves and those they give to you, the organizer. Then PRIOR to sending out word on the SpeedPASS check to make sure all who intend to give prizes are included in the SpeedPASS. The system will only auto print for silver and above sponsorship levels. Double check since bronze/swag sponsors sometimes have giveaway prizes but are not selected by default.  Make sure that you have good details on how attendees will need to claim prizes prior to the event.  Print out certificates if necessary just to help you keep track and have something easy to hand over to winner.

Great sponsors, great prizes
Great sponsors, great prizes

2.  Make sure if you intend to have speakers give away books to get them the details on what they need to do.  Sorry speakers.

***

3.  Make sure to be prepared before the morning comes with different items that should be addressed during the opening comments and PRINT it out.  I had a OneNote list that I assumed would have time to review before it was time to speak.  Yeah that assumption was wrong.  Make sure to get information on logistics throughout the day such as plans for lunch.  Also make sure to give an overview of what SQLSaturday is and that it is a mix of experienced speakers as well an opportunity to encourage new speakers.  We had some comments to the effect that we should “vet speakers as some were inexperienced”.

***

4.  Make sure to check with businesses and city ordinances that it is ok to put up your SQLSaturday directional signs.  I had 5 signs of which I got back 1.  Maybe it was hoodlum Oracle teenagers or something but our signs went missing.  I love it when the signs are up when I go to a SQLSaturday.  Sorry to those who came later when they were gone.

***

5.  Get the session levels on the printed schedule.  We had some really nice clear envelopes for sponsor swag and the schedule.  On one side we had a nice color, printed schedule that was visible through the envelope that I think was very handy for attendees.  I did not have the session level on it though which would have been helpful.  Also would like next year to get colors for tracks on it as well.

***

6.  Make sure to have some committed help to stuff packets.  Just a few hands can make all the difference.

***

7.  Check very early on the catering situation of any potential venues.  Many venues will have exclusive contracts with caterers which means extra $$.  This can be a huge expense that your $10 charge for lunch won’t cover.  Also make sure you account for the cost of speakers and sponsors to eat.  Make sure you know how much money you may need to cover the costs before you sign up for the venue.  We didn’t have any issues with that but just could see that helping potential SQLSaturday organizers.

***

8.  If you need printers, monitors or other items during the day see if it makes sense to buy those items to raffle off at the end of the day for prizes.

***

9.  Make sure to have coffee setup for the entire day.  We had several folks wanting for coffee in the afternoon.

***

10.  Make sure you have some food items at breakfast that do not contain nuts.  We had coffee cakes but I didn’t realize they had nuts and didn’t even consider those with allergies.

Karla embarrassing me giving me props at the end of the day.
Karla embarrassing me giving me props at the end of the day.

So I survived organizing a SQLSaturday again and feel like I came out of this one with less battle wounds.  It was a lot of work but there really is a great feeling of accomplishment at the end of the day.  I helped bring some more SQL community to Indy and THAT is a great thing.

Presentations, SQLSaturday, Uncategorized

SQLSaturday 200 Philly

The other weekend I had the great pleasure of heading over to Philadelphia again this year to speak for the 200th SQLSaturday.  200?!  Just amazing!  This event was great!  So great it got me very amped up about my local SQLSaturday.  So much so that I’m a little later than normal getting this post out due to kicking my planning of SQLSaturday 242 into high gear.  But wanted to make sure to get this post out to document another really great event.
***
Travels over to Philly were pretty uneventful.  My fellow Indy compadre, Eddie Wuerch (blog|twitter) was speaking as well and was on the same flight.  He was even kind enough to drive Miss Daisy Miss Hope to all the events!  Thanks again Eddie…many good SQLSaturday karma points to you!  The speaker dinner was really great!  The weather was good again this year so allowed us to sit out in a very nice patio area at the restaurant.  It was held at McKenzie Brew House which had excellent selection of beers which you know wins points in my book.  AND they had great food!  Excellent choice organizers and thank you again!
SQLfamily congregates at the speaker dinner
SQLfamily congregates at the speaker dinner
So the morning of the event I get up extra early to do one more run through of my presentation since I had added some new things and it had been awhile since I had done this session.  Then head over to the event and catch Brian Moran’s (twitter|blog) session, “Awesome coaching questions every geek, analyst, leader, and consultant must know”.  Being a consultant, I was interested and the title even told me I HAD to know these questions so I went.  It was a really good engaging conversational session.  One of my favorite questions was “What does success look like with this project?”.
"Can't ask good questions if you are not listening well."
“Can’t ask good questions if you are not listening well.”
My session, “My SQL Server is Not Slow for Pete’s Sake! – Server Side Performance Analysis”, went well and got some good constructive feedback.  I made a huge presenter mistake though and I’m still kicking myself!  I have in the past forgotten to plug my laptop in before getting started.  I’m normally very antsy to get hooked up to the overhead and make the words come up on the screen.  Normally I keep talking while I’m getting my power cord situated and it’s not a big deal.  Well remember how I did a run through that morning?  I forget to put my laptop power cord in my backpack!!  Thank the heavens Josh Lynn (twitter|blog) had a Dell as well and was even sitting in a prime location to where he took care of plugging it in while I kept talking!  Josh…my hero!  Thank you so much again!
***
After that was the WIT panel discussion.  The panel included myself, Melissa Demsak (twitter), Kevin Boles (twitter), and Kevin Goff (twitter|blog).  It was led by Sharon Dooley.  We had some great conversation.  I love it when we have someone speak up in the discussion and I feel myself wanting to say “Amen” at end of their statements.  It’s the whole reason I am involved in PASSWIT, for those moments.  I had one in there when one woman stated how she isn’t a “woman architect, she’s a professional”.
The audience at the WIT discussion
The audience at the WIT discussion
Next I caught the wonderful, Mike Hillwig’s (twitter|blog) session on VLFs.  He’s one of those great to talk to folks and his sessions are that way too.  He had some slight bumps in his demos due to last minute change of hardware.  The brave soul was until a few minutes before planning to present from his Surface Pro.  I love his section of disclaimers including “assume I am an idiot” in reference to not trusting content and slapping it into production.
Mike telling us what the VLF
Mike telling us what the VLF
After that session I went to Wayne Sheffield’s (twitter|blog) session, “Table Vars & Temp Tables – What you NEED to Know!”.  This was my absolute favorite session of the day!  Wayne is an MCM and eww buddy it shows! I was so into the content I forgot to get a picture and I don’t think I’ve ever done that.  Normally my ADD kicks in and distracts me enough to snap a picture.  There was so much great information on table variables and temp tables, I was really blown away!  He even cracked open a hex editor!  So with such good content I was able to forgive him when he bout gave me a heart attack when there was an unexpected “boom” sound effect in his slides.  Very well done Wayne!  If you have a chance to see this session, highly recommend it!
***
The last session of the day I caught a little bit of Dominic Falso’s “Introduction to Spatial Data in SQL Server”.  I couldn’t resist a session on spatial data since I have one as well.  The intrigue of seeing how someone else presents the material was too much.  He did a good job as many of the conceptual pieces can be a bit dry.
Dominic Falso going over spatial data
Dominic Falso going over spatial data
Then after the prize raffle headed to Joey’s house for the after party.  Bravo to your bravery again this year hosting the party at your house, Joey!  It was a very nice shindig again this year and thank you again!  Thanks to all the organizers and volunteers for well done event!  Appreciate you all having me out again this year!
Presentations, SQLSaturday, Uncategorized

SQLSaturday 211 Chicago – Finally A SQLSaturday Fix

Hard to believe but this was my first SQLSaturday of the year! Lately I have done a decent amount of user group presentations which are great, but there’s something special about a SQLSaturday.  Chicago’s was right after the PASS BA Conference so became an extension of some really great SQL goodness. I left straight from the last session to head over to Addison to get to the speaker dinner.  The dinner was at La Hacienda so caught up with friends over margaritas and good food.  We got a really nice, unique speaker gift: a solar powered phone charger.  The tree hugging hippie in me loves that!  Thank you again organizers!

***

Morning comes and I get to the venue at the DeVry campus just a hair before the first sessions start.  I head over to the speaker room and chat for just a few minutes.  Just then an attendee comes in to let us know that they had no speaker show up!  Ross LoForte and Ted Krueger (blog|twitter) rush over to the room to save the day.  Luke Jian (blog|twitter) and myself quickly follow to assist them.  It turned into a really good discussion with the attendees over different aspects of being a DBA.  The session evals were all very good so it worked out and very nice of everyone to jump in and assist.

Ted and Ross stepping in for a surprise spontaneous discussion on being a DBA.
Ted and Ross stepping in for a surprise spontaneous discussion on being a DBA.

From there I head to Erin Stellato’s (blog|twitter) session “Making the Leap from Profiler to Extended Events”.  She is such a stellar speaker and this was a fantastic topic.  I was a bit jealous of the topic that I didn’t think of it since it is a super common issue.  Extended events is one of those features that are great but just is taking the masses a long time to come around to using.  She did a good job showing it’s not such a beast anymore and some great things from Jonathan Keyhayias (blog|twitter) to make it even more helpful like his script to take a trace and convert to extended events.  Bravo Erin!

Erin showing folks there's nothing to be afraid of with extended events.
Erin showing folks there’s nothing to be afraid of with extended events.

After that I caught some lunch with a unicorn!

Who doesn't love lunch with a unicorn.
Lunch with a unicorn is supposed to be magical…not disturbing right?

Next I caught Josh Fennessy’s (blog|twitter) “Demystifying BISM and Tabular Mode SSAS” session.  I was caught off guard right away when he started as he said he had no slides.  Say what now?!  He did full session just talking and writing things out on the whiteboard.  I was really surprised and impressed at how well it worked too.  He had some of the best interaction with the audience I have seen maybe ever.  I feel like I would flounder like a fish doing something like that unless I practiced it like a fiend.  You rebel you, Mr. Fennessy!

Slides?! Josh don't need no stinking slides!
Slides?! Josh don’t need no stinking slides!

For the next session I head to Neil Hambly’s (blog|twitter), “SQL Server 2012 Memory Management”.  I am always surprised at how little presentations there are on memory within SQL Server, at least that I have seen.  He did a good job though there were some quirks in demos.  I knew talking to him earlier he had laptop issues plague him.  Still was a great amount of info given and majority of demos went fine.

Neil going over memory management in SQL Server 2012.
Neil going over memory management in SQL Server 2012.

And last session of the day was when Ted and I gave our session on consulting.  It is always fun to do this one!  I was especially excited after hearing from someone who saw it in Minnesota a few months ago.  He immediately went from our session to a consulting booth who had sponsored the event and began talking to them.  They ended up hiring him and he’s enjoying the change.  How cool is that?!  Someone’s life was made better by a session I gave…there will never be better feedback than that!  Session went really well and we had a lot of interaction.  Always great too when other consultants come and participate.  Thank you Allan Hirt (blog|twitter) and Rick Krueger (blog|twitter) for adding the perspective and experiences of a independent consultant!  And thanks again Ted!

***

Thank you to the SQLSaturday Chicago team for having me as a speaker again and putting on a fantastic event!  Thanks also to my friends and SQLfamily for just being splendiferously (make sure I get credit for that new word) wonderful!

SQLSaturday

How great was this email? Confirmation of successful SQLSaturday

I have been wanting for awhile to share a really great email I received from someone after they attended the SQLSaturday in Indy.  I literally got a bit misty eyed reading this one.  I figured folks out there who are involved in the SQL community, who present and/or organize SQLSaturdays would really appreciate this as well.  You always hope that the events/presentations you do will reach people and help them.  I am always hopeful that it will give them the glimmer or spark of that passion that drives so many of us.  It was really great that I got confirmation that I was successful on that day.

***

Original email:

Hope,

I wanted to let you know how amazing SQL Saturday was for me.

***

As you know I come from a smaller community, there are no SQL user groups there and very few SQL connections to be found (or so I thought). I gained my SQL knowledge by learning from my boss, in class, or by reading stuff from the internet. (Information overload) My job was less than 3 miles from my house. Needless to say, I lived and worked in a vacuum.

***

 I was introduced to PASS/IndyPASS and SQL Saturday. I joined, signed up and impatiently awaited my first SQL Saturday. I arrived at SQL Saturday not really knowing what to expect. I’ve attended numerous seminars but never any specifically related to SQL. I was impressed and overwhelmed. There were all these SQL people in one spot. They were real people; they were no longer abstract user ID’s, or online personas. They had varying levels of expertise, and were freely discussing anything and everything related to SQL. Being passionate about SQL was not only ok, it was encouraged and shared. There was even a SQL expert who is also a Tribal Fusion Dancer/Instructor! WOOHOO!! I didn’t have to explain my job as “DBA” was it own explanation. I knew that there were thousands of SQL peeps but seeing a bunch of them in the same building really put things in context for me. They were no longer just a component of a virtual world, they were tangible. I felt an instant connection with a building full of strangers. I assure you that doesn’t normally happen for me. It’s like I’ve been living in the wrong world.

***

I realized many things on Saturday; a) I’m a rookie DBA that has soooooooo much to learn about SQL. b) that my level of professional social networking skills are virtually non-existent. c) I’m definitely hooked and will do everything I can to attend IndyPASS and SQL Saturday events whenever finances allow. Yea, I got the bug.