Education

#SQLSat111 is a wrap…

I’ve tried to do these wrap-up posts over the years to give advice to the upcoming SQLSaturdays based on our experience, but I wanted to do this one a little differently.  Before I go too much further, let me do two things:

  1. State the obvious:  SQLSATURDAY 111  ROCKED!!!!
  2. Thank a whole bunch of people: Audrey Hammonds, Aaron Nelson, Tim Radney, Julie Smith, Rob Volk, Kristina Mishra, Erin Hicks, Lorra Newton, the AtlantaMDF leadership team, and a whole bunch of speakers and volunteers who helped make this show work (far too many to thank here; it was inspiring to see the people who gave their time to make this work). 

This was the second year that I served as a member of the team, rather than trying to pull it off.  Audrey did an amazing job of pulling everything together.   We may have had a few bumpy spots along the way, but from all of the feedback we got, the event ran extremely smoothly for the attendees (all 460 out of the 650 registered).  However, as I was reviewing the twitter feed, one tweet in particular stood out for me:

image

This is what it’s all about; an attendee at our event left wanting more.  It made me think about the nature of this post; I usually write up some practical advice on HOW to do something (and lessons learned).  This time I wanted to focus on WHY you should do something.  I guess this is my attempt at inspirational writing, so breathe deep, assume the lotus position, and read on.

First, it’s the people.

SQLSaturday’s are a big party, and there’s enough of them going on around the country world now that we’re starting to become a traveling band of gypsies.  Many of the people who speak at these events speak at a whole bunch of events, and this becomes a little family reunion at every event.  I love that, but what I loved even more was the fact that I got to see a bunch of my local database people “get their learn on”.  It’s really easy to get caught up in the moment of working at the event, but at the end of the day, the point of this event was that you should inspire somebody to learn something new, to change the way they approach a problem.

Second, you are people.

If you’re hosting a SQLSaturday, don’t neglect yourself.  I went into this event tired, grumpy, and a little worried because I knew there were some last minute issues that I had neglected.  Guess what; nobody cared.  The party rolled on.  I spent a great deal of time running around trying to make sure that I touched base with people, and I didn’t attend a single session (other than my own).  That was a mistake.  I should have totally taken advantage of the great training opportunities that were there, and learned something myself.

I’m pointing the finger square at myself on this: I need to invest more in me.  Not that I should neglect others, but I’ve neglected studying and learning because I’ve let other things take away my time.  When I was a kid, I used to always hear the mantra of “Faith, Family, and Work”; I still believe that, and for the most part, I’ve done that.  What I’ve forgotten is that Learning=Work!  If I’m not investing in my own education, and not investing in putting my own ideas to digital paper, I’m starving the creative process, and thus starving my own career.

To that end, I guess the person that left this event the most inspired was me.   If you’re thinking about hosting one of these events, don’t forget to learn something yourself.

#SQLSat111 “Biggish Data”

Trying not to be to obnoxious about this, but I’m presenting on “Biggish Data” at SQL Saturday 111 in Atlanta tomorrow; if you’re there, swing by and see me.  I presented this on Monday at AtlantaMDF, and am attempting to incorporate the feedback from that presentation into this one.  Should be good, but I’m still working on the slides.

However, if you attend my session, you’ll get a free koozie!

koozie

Presenting at Greenville SSIG on Tuesday, March 6, 2012

Just a quick note: I’m presenting next Tuesday at the Greenville SSIG. Kind of a last minute deal, I’m still writing the presentation in fact. Details below:

Please register at http://ssig201203.eventbrite.com/ . If you forget to register, and want to come to the meeting, please do.

6:00 – 6:30 Food and Networking Sponsored by FGP
6:30 – 6:45 Announcements
6:45 – 8:15 Stuart R Ainsworth: Agile Database Administration
8:15 – 8:30 Closing remarks and give-a-ways.

Agile Database Administration
Agile development is all the rage, but how do the principles apply to database administrators? This presentation will introduce the basics of the Agile Manifesto, and explain how they can be applied to non-development IT work, such as database administration, maintenance, and support. We’ll cover scrum (one of the most popular development methodologies) and kanban, and identify some of the common struggles with implementing them in an organization. This is an interactive discussion; please bring your tales of success and your horror stories.

Stuart R. Ainsworth is a database architect and a manager of database administration for a financial security company. He’s also a chapter leader for AtlantaMDF (the Atlanta SQL Server User Group), and blogs (infrequently, but hopes to do better) at http://codegumbo.com/.

A day with Andy (and Matt..) #SQLSAT111 #SQLPASS

I first met Andy Leonard at my first PASS Summit (2008); he was sitting at the back of the room in the Chapter Leaders meeting.  At the time, there was this newfangled social technology called Twitter (perhaps you’ve heard of it), and everybody was live tweeting during the meeting (shades of things to come).  I had been following his twitter stream for some time, and I saw a tweet of his go by.  I responded with something clever like “I’m watching you tweet @AndyLeonard”.  Immediately his head popped up, and looked around the room.  After the meeting, I walked over and introduced myself. 

Talking to Andy is probably one of the easiest things to do in the world; there have been time throughout my association with the SQL community where I’ve bumped into him at some event or another, and he always seems to remember who I am, and what’s going on with me.  I’m nowhere near the prolific writer that he is, and neither am I as plugged in to what’s going on, but yet he always seems to slide into a conversation with me like an old friend.  Andy is just a good guy to know, and I’m glad he’s a friend of mine.

Now, we haven’t always agreed on things; during the PASS elections of 2010, Andy and I looked at the process from two very different perspectives.  Some of our discussions got heated online, and going back and reading those posts today makes me a little sad.  But then I have to pause and think about the face-to-face conversations Andy and I had regarding the same subject, and it’s clear that he really does have a heart for the SQL community; even though I don’t always agree with him, I know that he’s trying to encourage people to do the right thing.  Again, he’s a good guy.

Why do I bring this up? Well, it’s because I’m on the team to bring SQL Saturday 111 to Atlanta on April 14.  We’ve invited Andy Leonard to do a precon for us on April 13; $100 to spend a day with Andy (and Matt Masson).  I know that Andy brings that same outlook to his teaching that he does to his community activities; with a certain amount of encouragement, people can do better.  If you’re not already registered for his class, you should.  You’ll learn something about SSIS, and maybe a little bit about friendship.

#sqlsat89 XML 201 Slide decks uploaded

Just a quick note to say I uploaded my slides from last weekend’s SQL Saturday 89; the event was a blast, and I hope to have my wrap up posted soon.   Thanks to all of those who attended; I felt like it was a great class, and I’m hoping to continue to improve in the future.

SQL Server XML 201

The xml datatype in SQL Server expands the potential of the relational platform to store increasingly complex forms of data, but without the use of the appropriate query language, much of that potential can remain unused. This session will cover the basics of SQL Server XQuery and FLWOR; the assumption is that attendees will have some basic exposure to XML (including the use of XML in SQL Server). Learn how to “run queries within a query”, and how to extract XML data into a tabular format. Coverage will include the five basic XML methods (.exist(), .value(), .query(), .nodes(), and .modify()) and FLWOR (for, let, where, order by, and return).

Upcoming presentations…

So, if you’ve been wondering where I’ve been, the answer is “too frikkin’ busy to write”.  Settling in to a new marriage, changes at my job(s), and volunteer work have been a little more  time-consuming than I originally planned.  I’m hoping that’s gonna change in the near future, cause I’ve some great ideas for posts brewing in the background.

One idea that I’m really excited about is a change in the monthly meetings for AtlantaMDF (our SQL Server User Group); like most user groups, we have a meet-and-greet followed by a presentation (or two).  The presentations usually cover some mid-level to advanced topic, and usually assume that the attendees have some knowledge with SQL Server.  We’re going to tackle that assumption.

Starting at our next meeting (Monday, September 12), we’re going to present short presentations before the main one that are targeted to new users of SQL Server; the goal is to a) build up our new members, and b) help grow our speaker pool.  I’m excited to present the first topic “Stuff in the FROM clause” on Monday, so if you’re in the Alpharetta area Monday night, come by and see me.

Also coming up is our fourth SQL Saturday (#89); although I haven’t been as involved with the planning on this one as I have in years past, it’s been exciting to see it unfold.  I’m looking forward to presenting a session on XQuery, and hanging out by the user group booth. If you’re gonna be there, stop by and say Hi!

#sqlpass PreCON,Baby! #sqlsat89

Just ordered my tickets to my first ever pre-con, and it’s for a SQSaturday being hosted by my chapter. I’m excited to attend John Welch’s Data Warehousing with SSIS Deep Dive on September 16, 2011 (BTW, tickets are still available).

Why this precon at this time?  Well, this year, conference funds are tight for me.  With my recent wedding, I’m really limited on both time and personal funds to attend a lot of conferences, so my own personal learning experiences are being restricted.  It was an easy sell to my employer to fund a $100 pre-con.

Second, my job is shifting, and I realized I needed to pick up some skills to finally make the transition.  I have a lot of exposure to ETL processes, but not so much SSIS.  Combine that with the fact that I haven’t done a lot of BI (most of our ETL is clickstream analysis), and there’s a big old gap in my data knowledge. 

Anyway, much longer post to follow on what I’ve been up to; just wanted to drop a quick note to say where I’m going to be before SQLSaturday 89.

#sqlpass–Last call for Community Choice

I’ve been out of pocket for the last couple of weeks (more on that later), but I was very excited to hear that two of my sessions were being considered for the Community Choice slots at PASS Summit this year.  If you haven’t voted yet, please consider voting for me; I’m looking for the opportunity to really grow this next year as a technical speaker, and I’d love to kick it off with a bang at Summit.  Voting closes TOMORROW (July 20, 2011), so vote now!

SQL Server XML 201 [Application and Database Development]
Stuart Ainsworth (Gladiator Technology Services)
 
Basic Guidelines for VLDB’s [Enterprise Database Administration and Deployment]
Stuart Ainsworth (Gladiator Technology Services)

 

VOTE HERE: http://www.sqlpass.org/summit/2011/UserLogin.aspx?returnurl=%2fsummit%2f2011%2fSummitContent%2fCommunityChoice.aspx

 

Just as an aside, I’d also like to plug a couple of other sessions by some AtlantaMDF members:

Bad SQL [Application and Database Development]
Geoff Hiten (Intellinet)
 
ETL Smackdown: PowerShell vs SSIS — with Aaron Nelson [BI Architecture, Development and Administration Topics]
Julie Smith (Key2 Consulting)
Aaron Nelson (@SQLvariant)

 

4 out of the 20 sessions being considered for Community Choice are by speakers from my local chapter, which makes me proud. Thanks for your consideration, and more posts to come soon!

distractions and other news…

Sorry for the absence from blogging for a bit; a lot on my plate.  Next week, I’ll be turning 40 on July 5th, and then getting married on July 9th.  The latter is much bigger news than the former, but both are reasons to celebrate.

Another reason to celebrate?  I got accepted to speak at SQL Saturday 64 (Baton Rouge).  I’m excited to head back home for good food and good times.  I needed a little affirmation after the disappointment over Summit.

Anyway, I may not blog much in the next few weeks; please stay tuned, because good things are happening.