Friday SQL Nugget #1

Got tagged today by Ted Krueger (blog|twitter) in his Friday SQL Nugget.  I started this post before midnight so it counts right?  The concept for today was when to pitch it all and start over.  I had to ponder this awhile because I couldn’t think of anything I have thrown away lately related to my job.  My hubby may disagree but I will pitch stuff like crazy at home.  At work though, that’s a step back/gasp/stare in horror type moment to think of pitching things.  I hang onto links, emails, books, and whatever else makes sense in my technical hoarder type way.  And scripts…you must be out of your mind if you think I’ll get rid of a script!  There was finally something I thought of that I don’t mind letting go of without a regret at all…presentations.  I haven’t been doing presentations for a terribly long time (around a 1.5 years) but in the fall started getting antsy to get something new going.  I ended up taking the holidays off, well to just survive the holidays.  It’s a new year and kicking it into gear fast and furious on some new ones that I’m really excited to start doing.  I will admit I may have issues getting rid of some things, presentations is not one of them.  Although I may keep 2 or 3 copies of all files related to them, ok I’ll stop while I’m ahead before someone offers to get me psychiatric help.

What my hard drives feel like.

Top Ten Things Learned at my First PASS Summit Experience

Work has been crazy since I got back from my vacation after the PASS Summit.  Vacation always seems you work extra hard on front and back end.  Finally taking a little bit of time for myself to finally get a blog post out of my experience.  Even at the risk of over using the term there really is no other way to say it…PASS Summit was da bomb!  It was an uphill road trying to get myself to this event so when I was there it was like a victory on top of the normal goodness.  I got myself addicted to the SQL Server community at SQLSaturdays.  If that was the piece to create the addiction, this was the full on overdose.  Everywhere I looked were wonderful SQL folk.  I was on a whole different level of happy while I was out there.  The only bummer was when I was asked if I was presenting but there’s always next year.  Here are some of the tidbits I learned at my very first PASS Summit.

1. I have many more folks I am adding to my intellectual crushes list.  The level of training was amazing!  I got to see presentations from folks I had never seen before, especially some that I’ve followed forever in blogs and etc (i.e. Paul Randal and Steve Jones) .  I did attend a Bob Ward session which lived up to it’s reputation.  Kind of scary there are people that smart out there…I’m skeptical he’s human.  There wasn’t a bad presentation that I saw though.  I did also get to partake in a pre-con session with Adam Mechanic…fantastic!  Too many really so many good things out there that your saving grace is the DVD.  If you don’t you HAVE to get the DVD.  Makes the ones you miss not such a tragedy.

2. Must make sure to use Zoomit profusely at all future presentations.

3.  SQLKaraoke is always something that is more than that it really should be.  Always a wallflower at these…no one would want to hear me sing…I promise.  Super fun though.  Glad my bad influence for the conference, Eddie Wuerch, invited me to go.

4. The term “networking” has new meaning for me.  I had no idea that drinking more than I should and staying out way too late means “networking”.  I did a lot of networking back in college and it was a lot easier then than it is now on this older Mom version of myself.  At least next year I know that sleep is out the window, be prepared for it and accept it.

5.  They were really serious about the kilt thing.

6.  Need to rethink about animations in my slides.  It can help and be non-cheesy if done right.

7.  It was nice to see the W.I.T luncheon in person this year.  Loved all the ladies up there!  I don’t remember what it was Karen Lopez said, but I remember thinking standing up and saying “Amen” felt like an acceptable thing to do.  I go to all the WIT events that I have opportunity.  Always get this fire in my belly feeling at those, so sent the email to offer up my services and get more involved in that.

8.  There was also SQLGive going on at the Summit.  Very nice to see when someone thinks outside of themselves.  Thanks to all the folks to coordinated that.

9.  The professional development sessions are much better than I ever gave them credit.  I normally am a technical fiend at any of these events and always trying to soak up as much knowledge as I can.  These types of sessions always had gotten the axe when they were set up against something fun technically.  I ended up going to see Steve Jones do one and it was really good.  It may have been good timing too.  I ended up getting into management on accident and now that the team is bigger I’m struggling with the technical/management question it seems many have been faced.  So after his session I opened myself into going to two more.  Very good information I gathered and definitely got my wheels turning.  I love picking the brains of others to hear their experiences and I got a lot of info that relates to this internal struggle.

10.  All the cool kids ended up with longer ribbons.  There became such a thing as “ribbon envy” by the end of the summit.

I knew I would dig this PASS Summit thing I kept hearing about so much.  I talked my company (Perpetual Technologies) into sponsoring this year as well.  It’s a good thing…I think and hope it won’t be such a hard sell next year.  And who knows…maybe next year will be my year to present.  This first timer is hooked so I have to hedge my bets and make it happen to go next year and all to follow.

IndyPass Presentation (May 2011) – What Can’t PowerShell Do?

I had a great time presenting at IndyPass tonight.  I finally got to do a presentation on one of my favorite topics…PowerShell.  The presentation overall went well I think.  I had a lot of good engaging questions and some good feedback on it right away…good signs in my book anyway.  It was the first time I had done this particular presentation so a few minor things I will work on but I will put this one in the win column.  I had some folks who were anxious too for me to get info up on my blog so here I am doing just that.  If any of you guys who were there have any suggestions to make it, as I said tonight “moe betta” please let me know.  It appears I can only upload certain files so I put all the scripts into a combined word document.  Here are scripts and the slide deck.  I hope these are helpful and get everyone going down the road of using PowerShell.  It’s a great tool to have in your admin arsenal.

It’s official…SQLSaturday Chicago!

Just heard word that my PowerPivot session got picked up for SQLSaturday in Chicago in a few weeks!  Looking forward to meeting everyone involved for that one.  March is going to be pretty awesome….24 Hours of PASS and now this!  If you’re able you should come join the fun.  It’s on March 26.  Here’s the link.  And too…it’s the day after my birthday so that means I’ll get to celebrate in Chi-town…bonus!  #sqlsat67

SQL Saturday Nashville was the bomb!

Yes I see there is a pattern here but I couldn’t think of a better term to describe it.  The event itself was really impressive.  You could tell it was very well organized and seemed to go off without a hitch.  Kudos to those who helped put that together…well done!

My presentation on spatial data…well did not go off without a hitch.  I had technical difficulties with the projector.  As much as I hated to I skipped the session prior to my presentation so I could prepare.  I had everything laid out perfectly…SSMS was opened and had my scripts up and ready to go.  I had all programs opened and was like a tiger ready to pounce on that audience.  Get into the room, plug in the cord for the overhead and then see nothing but blue…*insert expletive*!  So then had to reboot my machine to get things going on overhead.  My face was starting to get that catch on fire feeling but finally my machine was up on the overhead but wasn’t showing on my laptop though.  Afraid to tempt fate or make the audience wait any longer I winged it trying to lean way right to see what was on the screen while typing.  There is a function key stroke that I am going to get very familiar with for the next presentation I can tell you that!  Other than that things went well.  I had some really great feedback from folks I admire in the community who sat in on my presentation so I was very excited about that.  Thank you very much Glenn Berry and Allen White!

My favorite part of the whole event though was the networking.  There was a pre-event BBQ hosted by Kevin Klein that was fantastic!  I was so excited to meet folks I have been following forever and put faces to twitter handles.  Thank you again for the hospitality Kevin!  Hopefully your wife is still talking to you after all that.  Then there was an after event party on the strip in Nashville.  I ate up every minute of talking to everyone at both events!  I really am amazed at how encouraging and helpful folks are within the SQL Server community.  I am very new to presenting at events and each time talking to the other presenters/peers gets me even more amp-ed up to continue doing this.  I always had doubtful voice inside saying “who wants to hear what I have to say when they have the big dawgs out there”.  But all the encouragement has helped me squash that wallflower attitude and each time it does get easier.  So any others out there thinking about getting up and trying to present…do it!  You won’t regret it!

One other thing I had to mention in here was the ladies representing at the event.  There were 3 women presenting at Nashville (Jessica Moss, Kendra Little, and me the doubting wallflower).  How cool is that?!

Here is my slide deck

Indy TechFest was the bomb!

Well it was for me anyway.  I attended some great sessions and a really interesting discussion on women in technology.  My presentation on spatial data went pretty well.  Even though it was advertised as “special data” or “spacial data” a few folks showed up.  Definitely wasn’t a packed house but got some good feedback.  The speaker dinner afterward was really great!  I ate up every minute of discussions with Jimmy May, Brad McGehee, Kevin Kline, Rob Bogue and John Magnabosco.  They were all very gracious and encouraging of this young newbie.  So I am trying to take their advice and up my game a bit.  Here I am blogging away and just submitted some sessions to Nashville SQL Saturday (http://www.sqlsaturday.com/51/eventhome.aspx).  Here are my slides for the presentation.

Sharepoint Saturday

No I have not been abducted by aliens, just really really terrible blogger and haven’t updated it in forever.  I have now been motivated to get back into the swing of things and begin posting again.  This past Saturday I had the pleasure of presenting at the SharePoint Saturday event.  I think things went pretty well in my session and I got to see a couple really good sessions from other presenters.  I met some really nice folks there as well.  I wanted to go ahead and post the slides from our session (joint session with Jim Grabinski).   Click here to get the slides.

Introduction should come first right?

I have finally caved and created a blog.  I figured before I dive in and start posting helpful things such as crazy issues I’ve encountered in SQL Server, Powershell, and etc I should first introduce myself.  My name is Hope Foley and I am a SQL Server DBA.  I work for a company called Perpetual Technologies in Indianapolis, IN (http://www.perptech.com) as a consultant.  I have been in IT for 9 years, the latter half of that in the DBA role.  I hold MCITP certification in SQL Server 2005 and 2008.