Review: sp_WhoIsActive

This is definitely one of the most used tools in my toolkit. Besides being incredibly useful when you need to figure out issues like blocking and locking and what the transactions are doing, you should take a few long moments to look at the code. The code extensively commented making it easy to follow and to understand what different parameters do. Also Adam has some serious T-SQL skills so going through the code is a great way to improve your own skills as well!

(more…)

Tools of the Trade.

Most DBAs have their own favorite set of tools and utilities they like to use and so do I. In this blog series, I’ll be introducing you to my favorite tools of the trade. Most of these utilities are made by the members of SQL Server community and all of these have one thing in common, they are free. While people often turn to commercial solutions (if they have the budget to do so), I would consider the following free tools essential for anyone working with databases or database servers.

(more…)

End of PASS Summit 2014 summary.

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 :)

EMP Museum

Guitar Statue at the EMP Museum

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.

(more…)

First days of PASS Summit 2014

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:

(more…)

Going to PASS Summit 2014

PASS Summit 2014 Homepage

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.

(more…)

Microsoft releases SQL Server 2008 R2 Service Pack 3

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.

(more…)