Well, I managed to finish up my series that featured a DMV query every day during the month of April. I appreciate all of the comments and feedback I received. One suggestion I got from several readers was to recap the series in a single post at the end, which is what I am going to do here.
I also wanted to give a shout-out to fellow SQL MVP Paul Randal (blog | twitter), who also slogged through April with his own A SQL Server DBA Myth a Day series. Paul, who besides being Kimberly Tripp’s husband, is also an active and well-respected member of the SQL Server community squashed a lot of persistent myths during the course of the month.
Below is a simple listing of each post in the series, along with a hyperlink to the original blog post. I have also listed the DMV for that day, along with a hyperlink to the online SQL Server 2008 BOL entry for that DMV.
As I suspected, I did end up using some of the DMVs more than once, but I have a different query that uses the repeated DMV on the days where that happened.