SQLStarter Track – Of Course It’s Back!

Seems the SQLStarter track is the only thing that brings me out of blog hiatus anymore. I keep meaning to blog but my life is triage and blogging just tends to fall off the vitals list.  One day I’ll get back into gear.  But today my friends I wanted to get the word out again for something I’m passionate, SQLStarter.  If you’re inclined you can go back and read the posts from the past they are here.

SQLFamily, I Have An Idea and I Need Your Help

SQLStarter Track Back Again In Indy

I still truly feel that these career paths are a great way to change lives.  One day I’m hoping someone will come up and say “I attended a session day that changed my life”.  I’m passionate enough that I’m willing to yearly share embarrassing pictures from my days of questionable judgment (older posts reference).

 

1990HalloweenDance

It’s hard to get your hair to poof with maid hat on but by god I did it! 

 

And what do I ask in return for this good laugh?   I am looking for speakers to fill the spots. If you’re interested in helping, can hit me up on Twitter/email/carrier pigeon. And for everyone else, helping to get the word out would be great! There’s an info page setup at site here and you can RT messages on #SQLStarter hashtag.

Advertisement

SQLFamily, I Have An Idea and I Need Your Help

Have you ever had an idea for something and it completely haunts you? Something that pops in your brain all the time and keeps you up at night? Something where it feels like the universe NEEDS you to do it? I have had this idea brewing for a long time and I now have some key pieces in place to finally get it out there so it can stop haunting me.

***

First a little history to understand a portion of the inspiration behind this. Back in middle school and early high school, I hung out with a group who got into a LOT of trouble. There are some situations I look back on where my future was sitting on the edge of a knife. If I had zigged many days, instead of zagging, my life could be completely different. I have a lot of friends who didn’t finish high school and went down paths that are hard to reverse, living paycheck to paycheck. My home town of Anderson, IN and hell my family is completely full of people I’d like to help get on a different path.

1990CokeLobby

If you can imagine, this was an era of questionable judgement.  Photo isn’t the best quality but gets across the point. 🙂

 

So with those folks in the back of my mind, I also see the greatness of the SQL community and the WEALTH of resources out there for free. I also hear over and over that we don’t have enough people to fill these data related jobs. I know that recruiters hit me up all the time. So if I can reach someone out there who is ready to go down a different path and is motivated to put in the work, we can change some lives!

 

 ***

Now SQLSaturdays are already reaching people and changing lives. They changed my life, without a doubt. But I know I have met beginners at those who are intimidated and scared when they attend. Can you imagine going into a SQL internals class when you are brand new to the scene? Hell they may give up right then and say screw it, this stuff is way over my head. So at SQLSaturday Indy I’m going to setup a total beginner track. I’ll be giving the first session of the day where it will be an easy intro into the different data related career paths you can take. Then the rest of the sessions in that track will dig a bit deeper into each one. These sessions will explain high level concepts and the kinds of work you would be doing. And of course, giving details of where they can find more information after they figure out which avenue intrigues them.

 ***

This is where I need your help SQLFamily! I need people to assist with these area focused sessions. Will need 5-6 sessions to fill out the rest of the track. These are the ones I’m thinking now but am open to suggestion (beggers can’t be choosers).

  1. Database Admin
  2. Database Development
  3. Business Intelligence
  4. Big Data/Analytics
  5. Other??

I also want to start a way to help keep in touch and connect with these people as they go out into the world after SQLSaturday Indy. Seeing how well Twitter and some hashtags work, I’m starting another one called #SQLStarter. We can use it to help answer questions, and point these beginners to new resources. I also would like to start making recruiters aware of it as well so they can post jobs appropriate for beginners.

 ***

So there…the idea is out there and hopefully the universe will stop haunting me to do this. Hoping this is the spark and the beginning of something spreads to other SQLSaturdays/User Groups/whatever. And as kumbaya froo froo as it sounds, feels great to put some good out into the world!

SQLSaturday Denver 2015

On the flight home now from the SQLSaturday in Denver. I was excited for this one! I had never been to Denver before, through it but never to it. That and there’s some wonderful #SQLFamily out there. I lucked out though, I had this SQLSaturday on my radar but didn’t know for sure when the cutoff for submissions was to end. I just happened to catch it and submit on the final day of submissions. Not sure if there were any tweet reminders for that but I didn’t catch any.  Anyway I got accepted to speak and do the new tabular session (yay more practice for Summit!).

***

I am not a hardcore road warrior like some, but I travel a decent bit. I don’t know if I have ever got a direct flight anywhere. I found one to Denver from Indy and was a good deal but it was with Frontier.  Flight was at 6:00am but for direct I was willing to sacrifice. I have never flown on Frontier before and holy cow! They charge $30 for carry on luggage! Other various odd weird charges too.  Just a little warning if you haven’t flown with them, check the crazy fees first.  So I get to Denver very early and catch up with my co-worker Meagan Longoria (Twitter | blog) who was speaking too. Working for a remote company, it’s a nice treat to be able to work with folks in person for a change.

Speaker dinner! Thanks again Carlos and Quanta Intelligence

Speaker dinner! Thanks again Carlos and Quanta Intelligence

After work we head to the speaker dinner at Citron Bistro. The restaurant was nice and was graciously sponsored by Carlos Bossy (Twitter | blog) from Quanta Intelligence.  The food was PHENOMENAL! It moved in to my top spot of speaker dinners. They had sit down menu with great choices and I went with lamb shanks. Holy moly! So good! Well done there organizers! Thank you Carlos! Very much appreciated that meal! And to top that off we got possibly my favorite speaker jacket ever as well.

Not one to post pics of food much (beer yes - food not as much). After one bite I got out my phone!

Not one to post pics of food much (beer yes – food not as much). After one bite I got out my phone!

My session on Saturday was in the next to last slot so I had intended to sleep in having such an early flight. So of course my eyes pop open at 5:15AM. Not having any excuses I get a workout in and some review on my slides/demos. Then head to the venue. It was an interesting site. I thought we were lost when we pulled into the parking lot. It was in a typical strip mall. After going inside was able to see it was very much a conference space and pretty nice. It was a bit tight in the through ways but worked out well. There wasn’t a speaker room but we found some space to congregate and worked it out.

***

Wish I could have attended more of the morning sessions but I’m always distracted by my own prep. I did sit in on some of Mike Fal’s (Twitter | blog) session as it was in my room prior to mine. He’s got a great speaking style and a definite enthusiasm for PowerShell.

***

So I get setup and start my session. I had a terrible issue with the projector. It would flash from time to time during my session. It also caused my slides to sometimes become about 3 inches wide. I have had issues with projectors in the past but this was a new one for me. Other than that it went well and demos worked for the most part. I only got 3 (of 17 attendees) to turn in feedback sheets which was a bit of a bummer but that’s the breaks.

David Klee scaring the bejeezus out of DBAs on VMs.

David Klee scaring the bejeezus out of DBAs on VMs.

After my session I sit in on David Klee’s (Twitter | blog) session. Man oh man it was a fantastic session! If you ever have a chance to see him speak, DO IT! His knowledge on virtualization is astounding. Coming from the SQL side of things, so much I never knew from the virtualization side. Really glad to see that session and learned so much! And he’s great speaker and just about the most likeable guy ever. Great job David!

Prize raffle at end of day

Prize raffle at end of day

After that wrapped up the day with a lot of great prizes. Then they had a little after party in the same venue which was different but nice. They had drinks and appetizers. After that we went to a place called Tavern Lowry which was good.  We were able to get a large table in an area on the patio on a gorgeous night. The poor waitress that had to deal with all of us!  Restaurant had a nice beer selection. By the way Denver, I think Titan IPA was my favorite that I tried while out there.

There's a whole lot of trouble (the after party).

There’s a whole lot of trouble (the after party).

After that we went to “Family Karaoke”. I was a little nervous when we pulled up as it had all blacked out windows and didn’t look, well like a place that should have “family” in the name. Going in, it was fine. It was a Korean karaoke place that had private rooms. We got one of the larger rooms. It was like few years ago in Indy, they have all these super odd Korean videos that play while you sing. Hilariously bizarre! And I even kinda/sorta sang, well just the chorus while Keith Tate (Twitter | blog) did Tupac on “Changes”.

Poor Tim

Poor Tim

Looking for songs not in Korean

Looking for songs not in Korean

Karaoke and snuggles

Karaoke and snuggles

Thanks so much organizers for having me out and doing a really great job on your event! I had a great time seeing old friends and making new ones. I hope I can work it out to come back some time!

Finally Made It To SQLSaturday Louisville!

Home now from SQLSaturday Louisville and wanted to get a blog post going while those SQLfamily good vibes are still fresh. It’s kind of a sad fact but this is the first time I have ever been to a SQLSaturday in Louisville. Being that I only live 2 hours away, it’s a bit tragic! It seemed like every year I had a commitment or it was held on my kids birthdays. Poor Mala (Twitter | blog) was probably thinking I would never make it but low and behold, it worked out this year!

They gave us personalized weapons!

They gave us personalized weapons!

So I head down around lunch on Friday to get to the speaker dinner. The ride down was fine except I still swear the Google navigation lady hates me. She took me through the boonies to get to 65 for some reason.  After finally getting there via the scenic route, I hadn’t given this session for a bit so spent some time telling the hotel walls about spatial data. After that I head over to the speaker dinner with David (Twitter|blog) and Wendy (Twitter|blog). The speaker dinner was at Boombozz pizza. The food was excellent! The room was a bit small but it worked out fine. They gave us these too (pic above) for speaker gifts! Love when can incorporate some hometown flair into speaker gifts. Wish Indy had more than race cars to work with on that note.

They really know how to take care of the speakers in Louisville!

They really know how to take care of the speakers in Louisville!

The day of the event I had hoped to sleep in but eyes bolt open at 6:00am (I’m old). Head over early and get situated at the event. The venue was walking distance from the hotels which was very nice (jealous of that). It was held at an Indiana Wesleyan as well (Indy was too). It was a nice facility and the layout was good. I normally can’t concentrate in sessions prior to mine so I just prepped and chatted it up the morning. My session was right after lunch which is nice for the extra setup time. Lunch by the way was excellent! They had barbecue that was really good. I heard there was a bit of a line but I snuck in early with the sponsors so I only heard of the lines.

***

My session went pretty well. I had a good bit of time to chat before the session started so got to yuck it up with some of the folks. I don’t know if anyone could tell but I felt the nerves a bit in the beginning. I realized while down there I hadn’t done a SQLSaturday since Cleveland! In February! Kind of shocking! The nerves worked their way out after I got going so that was good.

***

After my presentation I stayed in the same room to catch Rob Verell’s (Twitter) session on replication. I hadn’t seen him speak yet and knowing how funny he is, had to go see one of his sessions. Very much enjoyed it! I always enjoy sessions that have humor with tech content. You have to be careful to balance it though and he did that.

Replication session full of cowbell from Rob Verell

Replication session full of cowbell from Rob Verell

Next up I went to see Daniel Glenn’s (Twitter|blog) session on SharePoint. He had jokingly pouted that he wouldn’t have much of a crowd because of the topic. SharePoint and DBAs do not exactly have lovey dovey vibes. So I agreed to go to his session, even though I planned to anyway as I hadn’t seen him speak either. He is an excellent speaker and did a great job. Was nice to see some of the stuff that drives DBAs nuts (like GUIDs in db names) can be avoided if the SharePoint person knows what they are doing.

Daniel Glenn trying to bring the DBAs and SharePoints of the world together.

Daniel Glenn trying to bring the DBAs and SharePoints of the world together.

Then it was prize raffle time. Louisville had a tweet wall in the location where the raffle was held. This was a big hit and all the speakers took advantage of being goofy on Twitter and the wall during the raffle.  They also had someone speak who teaches tech to high school students.  I have always thought it would be great to expose high school students to data careers via SQLSaturdays but I haven’t had any luck making any contacts in my area yet.

Energetic tech high school teacher talking to the masses at end of day.

Energetic tech high school teacher talking to the masses at end of day.

After the raffle folks congregate to head out to dinner at the hotel out on the patio.  David Maxwell always has a guitar and plays for us while we relax a bit.

SQL chill session

SQL chill session

After that John Morehouse (Twitter|blog) leads us to potentially my favorite place for an afterparty, Ann Marie’s Bacon Bar.  I mean there may not have ever been a place that contained all the components SQLfamily enjoy: local non-chain place, bacon, great food, nice beer selection AND karaoke!  All these things in ONE PLACE!  We all had a blast!

"Friends in Low Places" going on right here.

“Friends in Low Places” going on right here.

Had a really great time in Louisville!  Thanks volunteers…you all really knocked it out of the park!  Really a top notch event and glad the planets finally aligned for me to come down.  Thanks so much for having me down to speak!  Definitely one I will add to the “must do” list!

Good times!

Good times!

Meagan has some real singing chops!

Meagan has some real singing chops!

Some of the SQL ladies having a good time at karaoke.

Some of the SQL ladies having a good time at karaoke.

SQLSaturday Indianapolis 2015 – Another Great Year!

Well I have survived another round being the lead organizer of SQLSaturday Indy. And now that I’ve had a bit of time to decompress, wanted to get a post out to detail some of my lessons learned. I always can use some good karma so hopefully will help some brave/crazy organizer soul down the line.

***

So the first lesson I learned this year is that Karla still rocks! And she deserves kudos/prizes/cash for putting up with all us organizers for ALL the SQLSaturdays held round the world. She is the PASS representation/liaison for us to PASS and it’s team of resources. They had an update to the backend system that organizers use back in May. There were some challenges from that but she always is so fast in getting us the help we need. Thank you Karla!

Some intense Jenga going on at the speaker dinner.

Some intense Jenga going on at the speaker dinner.

The second lesson is to test/workout the process to lookup a SpeedPASS to print prior to the morning of your event. I was a good girl and did as I was told to download all the SpeedPASSes the night before to a USB. I copied to 2 USBs just in case. You can never count on wifi and I had trouble with it on the laptop I was using to print SpeedPASSes.  I had to use my hotspot from my phone. Even though I was good and downloaded the SpeedPASSes, the names of the files do not contain the registered person’s name and they are pdfs. So the process I did to look them up was as follows:
1. I had to look up the person on the SQLSat admin site.
2. This then brought up the link to get to the pdf speedpass. I then right clicked and copied the link name.
3. Pasted the copied link into Notepad. This then would give you the guid-ish file name.
4. Copied the filename portion of the link.
5. Then pasted the filename into the search of the files on the USB to find the pdf for that person.

There may be a better way to do this…kind of hope so! Please let me know if there’s a better way.

***

Another thing I learned was that I need to have a plan for leftover food. I’m not sure what others do but I always feel I need to order the amount that folks paid for knowing it will be too much from dropoff.  I didn’t have a plan for it and was just forcing it on volunteers to take home but maybe we can find a group that can put some good use to it.

Team Foley at SQLSaturday Indy - LOVE YOU GUYS!

Team Foley at SQLSaturday Indy – LOVE YOU GUYS!

Next year I need to make sure to have some folks on the ready to clear/sweep the rooms after the final session is over. If you can imagine, speakers can get chatty at the end of the day *shock gasp*. I want to make sure everyone has chance at end of the day for the prizes so we try to wait till they’re all done. Also along those lines I also need to make sure to have someone ready to assist with prizes. Time REALLY stands still when you are trying to open raffle boxes with 200 people staring at you.

***

Another regret from this year is that we forgot to grab the camera when heading out very early in the morning to get to the venue.  I had it on a checklist but those only help when you look at them.  DOH! If anyone has any pictures would love to get them from you.

Wendy Pastrick doing some karaoke at the after after party.

Wendy Pastrick doing some karaoke at the after after party.

I want to thank again all my speakers who came to Indy! I hope we took good care of my sql peeps. They take away my Hoosier card if I don’t display that “Hoosier hospitality”. I want to thank my volunteers! You know who you are and you rock big time! I want to thank from the bottom of my heart, my family! You all got roped into this craziness that is SQLSaturday/SQLfamily and it’s all my fault! I am eternally grateful to you for all your help, support, and love! I get teary eyed thinking about how this event has become a family one. I hope the view you get into this event shows some of the goodness that drives my passion that takes me away from time to time.

SQLSaturday Indy 2014 – Return of the Jedi

My first SQLSaturday organizer experience blog was called “SQLSaturday Indy Episode 2: A New Hope“.  The next year I just couldn’t resist and did “SQLSaturday 242 – The Empire Strikes Back“.  I have to finish out the trilogy thus the reason for the blog post name.  I’m sorry if you were lured here in hopes that there were gals in metal bikinis or Ewoks at SQLSaturday Indy.  Sadly there was nothing Star Wars related at all but I did Game of Thrones geek out with the room names.  To tie the title in though, I am getting better at this SQLSaturday organizer role so if you want to call me a jedi, I won’t be mad at ya.

***

I was again at the helm leading the organization of SQLSaturday Indianapolis.  It was my second year fully leading the effort.  It definitely was a little different this year, going in with last year’s experience under my belt.  I was a little more calm knowing how the whole process worked and didn’t have that fear of what I didn’t know constantly getting to me.  I also made sure to keep really good notes including some of the various communications sent out.  That was helpful as I didn’t have to start from scratch on many of them.  Most importantly I also knew early on to pull in some help.  I have a saint of a mother in law, Pam/Mamaw, who last year helped me as well.  What I didn’t tell folks though was that I called her in a panic Friday morning before the event last year.  She offered (or I begged, I can’t remember) to help again this year.  She helped with so many of the logistics of prepping the many materials and various other things.  There are many things take a decent amount of time that I underestimated last year.  They aren’t difficult but are tedious/time consuming.

Saint Pam/Mamaw

Saint Pam/Mamaw

Here’s a list of such things for any new organizers:

1. Stuffing of bags/packets for attendees

2. Preparing the gift bags for speakers

3. Printing the schedules

4. Cutting speaker session evals

5. Cutting event session evals

6. Cutting SpeedPASSes for speakers and preparing lanyards

 

The Recap

Friday I take off work so Pam and I start bright and early.  She had the good idea to wait to get drinks that morning so we only have to unload them the one time at the venue.  We do that and then get those and all the various paraphernalia to Indiana Wesleyan.  We get done and have some lunch while I go through my many lists of to do items.  I was a little uneasy at how smooth it was going compared to last year.  I even had time to head home for a bit and get ready for the speaker dinner.  Last year I was so rushed I had to buy a shirt on the way to the speaker dinner as I sweat through the first one.  Classy egh?

 

We had the speaker dinner at a local restaurant called Oobatz.  I had been working with the owner, Kirk, who was absolutely great!  As great as he was I had only visited once and had drinks.  Having not ate there made me a little nervous, you know me…want to take good care of my sql peeps!  I had NOTHING to worry about though.  The food was great and the service was excellent.  I highly recommend that spot, especially if you have a large party.  Tell Kirk I sent ya.  Having 29 beers on tap doesn’t hurt either though I mostly pushed my favorite local brew, Triton Railsplitter, on everyone at the party.

Speaker dinner at Oobatz

Speaker dinner at Oobatz

So Saturday starts bright and early.  My husband, Rod, and daughter, Ashlyn, came with me again this year to help.  I was working out some last minute schedule changes (thank you Kathi (Twitter|blog) again for taking another session super late in the game).  Due to that I was a little later than I wanted to getting out the door.  Rod was so great and talked me off the ledge while on the way there.  I was a bit on edge when I was trapped in the car.  I really love it that SQLSaturday Indy has become a family affair.  It just means the world to me that my family can be a part of it.  They may feel like SQLSaturday hijacks our life a bit but they don’t let on at all and I love them even more for it!  Us in the community understand SQLfamily and we know why we do these crazy things.  My family jumps in and helps not seeing that side at all.  They do it without question, just because they love me and are awesome people.  That’s family, right there!  Thank you all again from the bottom of my heart!

Family.

Family.

Where was I?  Ah so I was like 5 minutes late and I arrive and my volunteers and Pam are already at work getting drinks in coolers and registration setup.  I love my people.  Ok, enough love fest.  It’s a bit crazy getting setup and going and ready for the masses.  We can’t get in the venue until 7:00 and folks are set to show up at 7:30 so it’s a total mad dash.  We move like a finely tuned machine.  Katie, Aaron, and their boys (another family affair) help with checking folks in with others.  Brandon was awesome setting up coolers and other vital logistics.  Ashlyn and Mamaw/Pam are getting the sponsors all set.  I’m at the SpeedPASS printing table of shame and doing the directing.  Things are crazy but it went about as well as it could have.  I had more help than tasks and stuff got DONE!  I can’t give enough props to the team that helped!  You are all amazing and wonderful and all things great!

My wonderful, fabulous volunteers

My wonderful, fabulous volunteers

The day winds down a bit and able catch our breath.  The next craziness to make it through is lunch.  It went well I think but just takes time to feed the masses.  We had some good sessions going and think the word got out better than last year to disperse to other rooms.  Day moves on really well from there.  The last hurdle then comes with the raffles.  We had such great prizes from sponsors.  And not to toot my own horn but I thought prizes were good from the SQLSaturday group too.  We took the printer idea a little further this year and bought more items we needed for the day and raffled them off.  So we raffled off a printer (only used for printing SpeedPASSes and other items used that day), a couple nice monitors (Twitter feed/sponsor slides that never got setup in chaos), and a Keurig we had setup in the speaker ready room.  I just love the use and raffle approach on prizes.

This is what the thought "there's no way I pronounced that right" looks like

This is what the thought “there’s no way I pronounced that right” looks like

Aww there's a happy winner!

Aww there’s a happy winner!

We get cleaned up and out of the venue pretty quickly and then some of us head over to Scotty’s Brewhouse for some food and de-stressing.  Next is the after party.  I had setup for karaoke to start early for us at Tilly’s Pub and Grill.  Oh those crazy kids, how they love the #sqlkaraoke.  A really nice end to a great event, full of great family, great sqlfamily, great speakers, great volunteers, great sponsors.  It was all just…great!  I am really proud to be a part of bringing SQLSaturday to Indianapolis.

David and Wendy doing up some karaoke.

David and Wendy doing up some karaoke.

Frank doing his interpretation of Janet Jackson's "Nasty". Yes it IS as good as you're thinking!

Frank doing his interpretation of Janet Jackson’s “Nasty”. Yes it IS as good as you’re thinking!

Lessons learned this year:

1.  Don’t print the schedule until you are done messing with it.  I try to send in at least one my attendee communications to registered attendees to have them use schedule builder on the site.  It helps to get an indication of how popular sessions could be and can adjust those to have larger rooms.  Every year I think I know what folks want to see, but normally I have several sessions that surprise me and I’m WAY off.  I let my knowledge of the speakers cloud my judgment time and time again.  It works better getting some indication from outside parties.  I wish there was a way to get info from Guidebook but until then Schedule Builder works.  So the problem was that I printed the schedule before doing this check/room switch.  Wasn’t major issue but had to print them again and the tree hugging hippie in me cried a bit at the wasted paper/trees.

2.  A new thing I learned this year was that a SpeedPASS for a vendor will print even if they didn’t pay.  We had a sponsor sign up for 2 levels of sponsorship.  They paid one of them naturally.  I didn’t remove the unused sponsor entry assuming that it was harmless.  It wasn’t until very late that noticed they had 2 SpeedPASS raffle tickets.  I left them with 2 as didn’t want to have some folks with 2 chances at a prize, and some with one.  Figured more fair that all had 2 chances.  Not a very common scenario no doubt, but a tidbit for my fellow organizers.

3.  Make sure in the communications to attendees to have them print AND cut out their tickets.  We had many well intentioned folks who listened to my many emails pleading to print their SpeedPASSes but did not cut the raffle tickets.  So these folks were hung up cutting out tickets.  Also make sure to let them know the process for raffle tickets at the events.  We had some at the end of the day not knowing what to do with the tickets.

Kathi looks to be having fun in her session

Kathi looks to be having fun in her session

4.  I was trying to do a New Speaker buddy system that Nic Cain (Twitter|blog) referenced here.  I had good intentions but didn’t have the best organization with that portion.  Next year I will make sure to try to formalize that a bit more.  Speakers also make sure that you READ the communications organizers send.  I had many new speakers that I didn’t find out about that were first time speakers until the speaker dinner or even later.

5.  I knew in past and from experiences at other SQLSaturdays to try to have food set out to allow for at least 2 lines.  I would always hate to see tables lined up against the wall with food as it forces only one line.  We had the table where you could do that.  If you can set food to allow more (i.e. same food 2 tables, allowing 4 lines).  We didn’t have major issues but the faster you can feed that many people, the better. Looking back now I think we could have managed to setup more lines.

6.  Make sure to put in communications that the schedule has changed or is subject to.  It is just bound to happen, it’s just part of it.

I'll let you guys caption this one of Steve.

I’ll let you guys caption this one of Steve.

7.  Make sure to touch base with your sponsors at the event on how they want to handle raffle tickets.  Some sponsors will take tickets with them and scan them.  Others may want them mailed to them.  Others accidentally leave them.  And some just don’t care to keep them at all.  I plan to put some info on that to sponsors in communications next year.

8.  Never rely only on email communications alone.  Folks don’t read email.  Sure many do, but many also don’t.

Good times getting learn on at SQLSaturday Indy

Good times getting learn on at SQLSaturday Indy

9.  Get someone else to do opening/closing remarks.  I have just come to terms that I am not good at it.  I can chat folks up informally or in a session but when it comes to remarks stuff, I am just damn terrible.  I am frazzled and just worried about getting ‘er done.  I need like a host of the Grammy’s type person to do it up right next year.

10.  Check for duplicate speakers before making any orders.  There are some in the system as similar but different names.  I know I had some with multiple sessions and seems they were in twice.

SQLSaturday Chicago 2014

Last weekend was SQLSaturday Chicago which was good timing  I was getting antsy to get to another SQLSaturday since it has been quite awhile since the one in Cleveland.  Chicago is one of my staple events.  It’s a fantastic one, ran by some wonderful folks and very much in drivable range.  I just looked back and I’ve been going every year since SQLSaturday #67 in 2011!  Just amazing that we’re now in the 300s for SQLSaturdays.

 

I head up Friday after getting some work in the morning.  I get there in time to get a run through of my presentation.  I learned a speaking lesson in Cleveland that even though I’ve given a session several times, never get too comfortable.  I didn’t do a run through prior in Cleveland and my timing was off somewhere and I lost 10 minutes.  It wasn’t a huge deal to attendees I don’t think but it drove me nuts.  I will always do a run through just before an event.  It helps the nerves too.  After giving a presentation to the walls of the hotel, head over to the speaker dinner.  This was definitely a favorite as far as speaker dinners go.  It was at a place called Schnitzel Platz and of course a German restaurant.  They brought out a feast of sausages and schnitzel.  It was wonderful!

Speaker dinner at Schnitzel Platz

Speaker dinner at Schnitzel Platz

20140425_210028_Android

Grant seems to have enjoyed the German food too!

Morning starts with breakfast with the lovely Strates, Jason (twitter|blog) & Sarah(twitter|blog) and Warner Chaves (twitter).  Then headed over to the DeVry campus where the event was being held.  My session wasn’t until noon so I had time to get situated and prepare.  They were doing an interesting new schedule where they spread lunch over a couple sessions and let those get food as they wish.  It seemed to work out for them.  The logistics of feeding that many folks are always tricky.

 ***

My session was over spatial data again and it went really well.  I had done some tweaking and with an engaged audience, it may have been my favorite with flow and timing. It also gave me a good story too.  I had a…well an interesting fellow in my session that gave the following creepy feedback.

 

Definitely the first time anyone ever mentioned Holocaust in session feedback.

Definitely the first time anyone ever mentioned Holocaust in my session feedback. *insert creepy music here*

After my session I went to see my friend, Mark Vaillancourt’s (twitter|blog) “Danger: The Art and Science of Presenting”.  I had wanted to see it for quite some time but never had the opportunity for one reason or the other.  It was very good and not what I expected.  I had been expecting a rah rah, you should all present and here’s why session.  There was only a tiny bit of that and instead gave a lot of interesting points about speaking as compared to Emotional Intelligence.  One thing that struck me was the notion that everyone attending your session is on your side or they wouldn’t be there.  It’s often thought of in the reverse and that everyone is out to get you, or “eat you” as he says.  Mark has the best sense of humor so his sessions are always entertaining.

 

Mark and his daughter, Paige. Love it when folks bring their kids.

Mark and his daughter, Paige. Love it when folks bring their kids.

Then I had to go see Meagan Longoria’s (twitter|blog) session “Choose Your Geospatial Adventure.  I was shocked to see two sessions relating to spatial on the schedule.  And even more so that it was by two ladies!  Her session was a nice one coupled with mine.  I delve into the spatial data type where she covered more the methods to visualize it.  It was a good session and showed some examples that I hadn’t seen.  It gave me some ideas for some things to try out later.

 

Meagan presenting how to visualize spatial.

Meagan presenting how to visualize spatial.

After the raffle we head back to the hotel for the after party.  Chicago has a somewhat traditional after party at the hotel with karaoke.  It’s nice to not have to worry about driving around.  One of the most memorable was Frank Gill’s (twitter|blog) version of “Unbelievable”.  He put a surprising death metal spin on it that was shocking/hilarious.  Thanks again for another wonderful time Chicago!  Organizers you did a fantastic job and really appreciate you allowing me to be a part of it again this year and for the past 3 years!

 

The masses gathering for the end of day raffle.

The masses gathering for the end of day raffle.

 

Frank Gill doing best "Unbelievable" rendition ever! And an odd setting on my phone so you see my eye. Who needs to take a pic like that??!!

Frank Gill doing best “Unbelievable” rendition ever! And an odd setting on my phone so you see my eye. Who needs to take a pic like that??!!

 

 

 

 

 

 

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).

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 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!