Last Saturday was the event at in Miramar, Florida. First off I have to say it was a great event with over 400 attendees! It was also my very first SQL Saturday speaking event. The speaker evaluations haven鈥檛 come back yet but I have a feeling I鈥檒l definitely should have some dings as my presentation started off well but towards the end the presentation Gods reared their ugly heads and it ended on a not-so-great note with my demo not going so well. The good news is that one attendee, Argenis Fernandez ( ), gave me some good feedback as well as told me that he got some good ideas from the presentation and was excited to go back to work and implement Policy Based Management in his environment. Honestly that kind of response makes the effort all worthwhile.
From my session I went to check out Kendal Van Dyke鈥檚 ( | ) session on . Kendal and I interact pretty frequently on Twitter so I was glad to get a chance to finally meet him as well attend his sessions. This was a good intro level talk on how to configure web application authentication methods in both classic ASP and ASP.NET. Some nice tricks come out of this session including how to properly add a user to the IIS_WPG group (hint: the proper way ISN鈥橳 to just add them to the group in computer management!). I鈥檓 no developer but this was really useful to me, especially as a DBA tasked with implementing Sharepoint in to our environment. I say this because Sharepoint has its share of permission issues especially if you run the app pools or web apps under a different account such as a custom AD account.
My next session was Andy Warren鈥檚 ( | | ) session on . I鈥檝e attended other sessions with Andy and they鈥檝e all been great. This one was no exception. Andy is an excellent presenter and makes it look so easy. One thing that was great about this, for me, is that this is the first weekend was the first time I鈥檝e gotten a chance to really meet and talk to Andy. It was funny because at the speaker dinner he asked 鈥淗ey, aren鈥檛 you that SQLChicken guy?鈥� which made me laugh. I guess my self-branding is working! Anyhow, this session was really interesting as it was more of an open discussion with the group rather than a straight forward presentation. Andy brings up important things to think about in terms of networking such as don鈥檛 start building your network only when you need something (aka job search). Networking is something that can benefit you far beyond simple job searches and opportunities. In the session some of us shared how simply being connected on social networks like Twitter have actually helped improve ourselves in our current jobs. If you ever get a chance to attend this session I highly recommend you do. In fact, if you鈥檙e attending the in Seattle in November, Don Gabor will be holding a Pre-Conference session called . Andy highly recommends anyone attending the summit to check this session out as it will help you not only build your network professionally but help you network in general at events like and .
At lunch I got to sit down and have lunch with Andy Warren, Kendal Van Dyke and a few other attendees. I only mention this in the blog because I we got a chance to talk with some people who ranged from first-timers to the SQL world as well as others who鈥檝e been doing it for awhile. Also it was interesting to get feedback on little things like how sometimes the session descriptions were a little too vague so it made it difficult to decide if the topic or level was the right one to attend. Based on this I know I鈥檒l be tweaking my abstracts for future events. The other cool thing was getting a chance to sit and pick Andy鈥檚 brain a bit about the direction of PASS. Personally I鈥檓 excited to see what PASS has in store to continue bringing the community together. So far its been fantastic to be a part of it.
Next up was another session with Kendal with topic being .聽 Honestly I鈥檓 currently not using transaction replication in my shop but after attending this session I feel like I gleaned enough knowledge to be able to tackle that task if it were asked of me. Great overview of different topologies that were clearly and easily explained, as well as going over some possible pitfalls you might encounter. Very interesting topic and presented very well. Kendal will actually be doing this presentation this year at (first time presenter, congrats to him!) so again if you鈥檒l be at PASS Summit this year I suggest you .
After that I went over to Jeffrey Garbus鈥� ( ) session on which drew quite the crowd. Packed house with a bunch of people (myself included) taking a seat on the floor along the walls to check this topic out! I鈥檝e attended Jeffrey鈥檚 session before at the last SQL Saturday in Tampa and he is a great speaker. This particular talk was actually kind of a part 2 to his earlier talk on . Even if you didn鈥檛 catch the first session this one alone is a treasure trove of great information. For instance do you know why join orders matters? Do you know the difference in performance between doing a join using the old ANSI syntax and the new? You鈥檇 be surprised. Again I highly recommend you check out any session by Jeffrey if given the opportunity.
Last, but most definitely not least, was Chad Miller鈥檚 ( | ) session on . Chad not only covers basic Powershell commands and tricks but he covers using a cool project he鈥檚 developed called . What PSX gives DBAs is a base set of functions that covers most common DBA tasks. One of the coolest demonstrations I saw during this presentation was the use of Powershell as an ETL tool. Chad shows you how you are able to copy data from table to another using only 3 lines of code! This presentation truly made me excited to really start learning Powershell and applying it at work.
Overall I thought it was a great event, as any SQL Saturday I鈥檝e attended, and I had an absolute blast presenting and meeting a bunch of folks I鈥檝e interacted with on Twitter. If you get a chance to make it to a SQL Saturday event I couldn鈥檛 recommend聽 it enough. You get top-notch education, great networking opportunities, awesome swag and all for free! If you don鈥檛 have a SQL Saturday event in a city near you, and you won鈥檛 be making it to the PASS Summit this year then don鈥檛 fret! The good folks at PASS have put together an exciting free training event called . For more details on this great event check my previous post on it.