I don’t get the occasion to manage SQL servers in a DBA role any longer, like MrDenny in his blog, nor have I been a true assigned DBA– I’ve only worked at places where the database servers were treated like any other server. Basically, mine to manage. Those of you in small to medium enterprises know what I’m talking about… If it plugs into the network it’s a Network/Server admin’s responsibility.
Now my role is more along the lines of Supporting the web applications that use the services that the database servers provide. Leaving the DBA role up to the folks assigned the title of DBA. Oh, how I used to think that would be so much easier! But that was when I imagined a team of folks who thought and worked like I did… Instead on occasion you get the folks on the other team who don’t believe a problem exists.
Well, I’ve recently found a site that really comes in handy in determining if SQL patches have been applied or if they may be relevant to an article you are reading that looks promising over at SQLSecurity.com that is a database of SQL Server patches that helps you determine if a patch is relevant to your installation or not.
Hopefully, this will help you out in your challenges!