Rotating Header Image

Posts under ‘Monitoring’

SQL Bacon Nugget of Excellence Award @MladenPrajdic

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 […]

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?  […]

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 […]

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.