This weekend was SQL Saturday #33 in Charlotte NC and also the first one I attended. It’s been a long weekend, but I wanted to get my thoughts down while they’re still fresh. Be warned, it’s been a long weekend, so my grammar and attempts to reign in my propensity for verbosity have both gone out the window.
Sorry SQL Saturday? Tarwn and SQL? We have questions and we know how painful it is for you to write short blog posts…
SQL Saturday is the name for a series of 40+ SQL events that occur throughout the US. Each event is managed locally by SQL user groups and PASS chapters and sticks to a few guidelines set down by Andy Warren (twitter), Steve Jones (blog | Twitter), and Brian Knight (blog | twitter), the creators of SQL Saturday. This year the reins for SQL Saturday are being passed to PASS in order to help manage the logistics of the growth of the events. There is a lot more information available on the SQLSaturday website, including upcoming dates and locations for more events.
So obviously I am not a SQL guy and you may be wondering what I was doing at a SQL Saturday. As you know, LessThanDot has some really good SQL people that frequently write articles, offer support in multiple forums, and support their respective communities. This year we have decided to begin supporting the community in a more active role by supporting SQL Saturday #31 in Chicago. As we continue to grow we hope we will be able to extend our support in other ways, but that’s less relevant at the moment. I’ll be present at SQL Saturday #31 to help show support “(and hopefully sneak into a few sessions as well).
When the local call went out for attendees to SQL Saturday in Charlotte, I jumped on the opportunity to not only meet some of the local(-ish) community, but also to take advantage of the learning opportunities from the sessions and from the event itself. While I was able to dive deeper into a number of topics that interest me I was also able to ask some questions about the logistics of the event and planning.
I made it to the following sessions:
An excellent session using DMVs to manage, maintain, and locate unused indexes or potential targets for tuning. This was a good session because I had already used everything he pointed out, but he gave me more depth (as well as a number of tricks) that I didn’t previously have.
**Is Virtualization a Good Choice for SQL Server?
Having previous virtualized servers (as well as managed the random set of SQL servers), I was eager to start filling a gap in my education, namely putting the two together. Denny did an excellent introduction into virtualization of SQL Server, critical points that need to be determined when considering virtualization, and a live view into his own, very large environments.
I went into Aaron’s session with almost no knowledge of powershell and came out with some ideas and practical examples of where it could be used to manage environments and automate work. While some of the concepts clicked quickly for me (‘piping’ output is common in Unix-like systems), others were new to me and his examples hit a good balance between brevity in code length and breadth of functionality. He also pointed out a number of good follow-up resources and reading recommendations.
**Maximizing Plan Re-Use
The concept of executions plans is still fairly new to me, something I had little knowledge on prior to Andrew’s session. Andrew presented a good mix of knowledge about plans, recompilation of plans, reasons, etc. and active examples to help us tie the concepts to the code. While I’m by no means an expert after one session, he filled in some critical gaps in my own learning and helped connect some dots from past tuning experiences.
**Storage for the DBA
As Denny put it in the beginning, often there is a disconnect between DBA’s and Storage Admins that comes down to some fundamental differences in terminology. This session was a ‘How to Speak Storage Admin’ class that walked us trough the basics of terminology, tools and methods to help size your environment, and some advanced tools he uses in his own environment. And excellent session, even if I am a developer and not a DBA 🙂
An excellent session from Kevin on the top 10 DBA mistakes he has seen in his experiences. From lack of troubleshooting methodology to not testing backups, he covered a number of assumptions and bad practices that we have probably all been guilty of, at one time or another.
Note: The linked slides page above has the 2005 version of this Top 10… slides, but not the newer 2008 one he presented yesterday. I assume that will be posted soon, though
The community was probably the best part of the event. Beyond getting to learn from so many people (for free!) it was great to actually meet them face to face. Someone repeated the “Our rockstars are not the same as your rockstars” comment at one point during the day, and I couldn’t agree more. It was just downright cool to meet people that previously I had only talked with on twitter and forums, or seen as names on book covers and faces in webinars. The down-to-earth, we’re-all-part-of-the-same-community feeling was a great change from the larger conferences that (not that I don’t appreciate those as well). Instead of being a conference event, the day had a more fun, get-together feel to it.
And the fact that Greg (SQLSensei) picked up my bar tab and I got a raffle drawing prize from Kevin (kekline) definitely didn’t hurt. Peter (Peter_Shire), Greg (SQLSensei), and the rest of the group at Charlotte put together an excellent event.
The event was a resounding success. This was my first SQL Saturday and already I’m looking forward to my next one, and the one after that. The SQL community is amazing and I think that these events really drive it home. I urge everyone to support your local SQL Server user groups and events like SQL Saturday, as this will only help the community continue growing and continue to be a close-knit and fun community to be a part of.
I have also, after urging from a number of people, started giving thought to offering to speak at few events myself. While I’m not nearly the SQL guru that the other speakers are, I’ve been in the trenches for a while, broken my fair share of servers, and could probably find one or two things to pass on.