The PASS Summit is now behind us and it was both an exciting and exhausting week of learning from some of the best and brightest people in the SQL Server community. Not only did I pick up a number of new skills that I know will make me a better DBA, I have number of new tools to add to my toolkit and some new practices that I’m going to look into implementing into our daily operations. It was also nice bonus to learn that many of the things I already have on my TODO list are similar to what others have successfully implemented on their own work and their environments. Obviously I’ve been on right track, if not always, at least most of the time :)Unfortunately the long days (I pretty much had sessions running from 8AM to 6PM almost every day) and the time difference to back home made me hit the sack rather early every evening. Because of this I missed some of the evening networking activities and the opportunities to better explore Seattle. The only official social event I did attend to was the Community Appreciation party held in the EMP Museum and even then our groups was back at the hotel by 10PM. That museum was awesome though, especially for a nerd like me! If you’re ever in Seattle, I encourage you to check it out.
It’s been three hectic days of learning more about SQL Server in Seattle and we’re now in the first day of the main event. Both the monday and tuesday were reserved for the day long pre-conference sessions. Mine were “Performance Troubleshooting Using Waits and Latches” by Paul Randal from SQLSkills and “Everything You Never Wanted to Know about Extended Events” by Erin Stellato and Jonathan Kehayias, also from SQLSkills. Both sessions were top quality and I left them with a bunch of new ideas and added knowledge. To quickly list the best takeout from each session:
I’m lucky enough to take part in the largest SQL Server conference in the world, the PASS Summit 2014 held in Seattle. This will be my second Summit, first one being the 2013 one held in Charlotte. While I’ve had the privilege of attending quite a few training sessions during my career, none have been even close to the level of learning offered in PASS Summit. The knowledge of the speakers, many of who are renown experts in their own fields, and the quality of the sessions is nothing short of awe inspiring. In 2013 Summit I remember being quite impressed how well things were organized. I was even more impressed when I learned that the amount of volunteer work hours for it was over 500,000.
That is a lot of hours and I believe it tells about the kind of commitment the SQL Server community has for making this event a reality.
Just a quick post about the fact that Microsoft has finally released the SQL Server 2008 R2 Service Pack 3 (Build 10.50.6000.34) few days ago. This will be the last Service Pack to the SQL Server 2008 R2 version and it is mainly just a roll up of all the previously released Cumulative Updates, with few additional fixes.
I just realized that it’s been a year since I started this blog. Here are some quick statistics about where are my readers from and what they are interested about.
When I’m dealing with a problem on a Failover Cluster (not very often, but sometimes) one of the first steps I do is to run the Validation Test. It’s a great tool that’ll usually show what might be the problem, but apparently not always…
For the last couple days I’ve been busy wrecking havoc on a cluster with a Microsoft Cluster PFE on a Cluster Disaster Recovery workshop. Among the scenarios we’ve gone through causing, fixing and then documenting there was one that had a small surprise in store for both of us.
I was reading this blog post by Thomas LaRock (@SQLRockstar) about a database design mistakes and I’ll warmly recommend that anyone who is involved with database design should read it as well. It also got me into thinking about one database design issue which, in my opinion, is not taken into consideration often enough; Database Administration.