Prior Winners: Lara Rubbelke – (post link | blog | @SQLGal) – Enterprise Policy Management Framework Tim Ford – (post link | blog | @SQLAgentMan) – Determine Free Space, Consumed Space, and Total Space Allocated for SQL Server databases This “award” has (unintentionally) not been handed out in a while but something that I’ve used [...]
Posts under ‘Monitoring’
Harder, Better, Faster, Stronger
OK maybe not “harder” but I just found a DMV that I didn’t know existed that is going to help me make “better, faster, stronger” an old way of doing things. I wrote a blog post back in 2009 called: Check SQL Server Agent Status on all SQL Servers This scripted used the sysprocesses table [...]
Jobs Jobs Jobs
If a job fails in production and nobody is there to see it, does it get noticed? Deep huh? Well if the job actually does something important of course it will get noticed. So the bigger question is: What can you do to make sure that YOU know about it before anyone else does? Cause [...]
Quest POW Webcast – Audits, Audits, Audits
I’m excited to announce that I’m doing my second Quest webcast coming up this Thursday (Dec 9th 8 a.m. Pacific / 11 a.m. Eastern)!! I’ll be doing a Pain-Of-The-Week webcast with Kevin Kline and Iain Kick on some of the auditing options that are available to you in SQL Server 2008. Microsoft has come a [...]
Most Recent Job Status of All Enabled Jobs
Seems easy enough… and maybe it is easy and someone is going to comment with something fantastical *hint hint hint* but until that happens… I would like… if I may… to take you on a strange journey Use Case: I want to be able (using CMS- Central Management Server) connect to all my SQL Servers (2000, [...]
