One thing I learned early on in my former life as a production DBA was the old motto “trust but verify”. Such is the case when it comes to relying on system information in order for your tools to work properly. An example that comes to mind immediately is the use of the sysdepends system [...]
PBM
Policy Based Management Podcast – Part 3
Brent and I sum up the podcast in this final piece. Trust us: PBM is awesome. It is a nice complement to your existing monitoring solutions. With a little T-SQL you can easily create your own policies on demand. Plus we also suggest that it might be time for others to join us in the [...]
Policy Based Management Podcast – Part 2
Continuing from yesterday we have part two of our podcast where Brent and I continue our discussion of PBM.
In this part we discuss how to use Central Management Server to deploy one policy against multiple servers, show a major usability FAIL in the SSMS GUI, hear Brent say he will edit something out that he [...]
Policy Based Management Podcast – Part 1
Brent Ozar (@BrentO) and I got together for a quick podcast on SQL 2008 Policy Based Management. In part one we discuss how to import the sample policies that are included with SQL 2008 by default (but not enabled), find some databases that Brent has placed the data and logs on the same drive, and [...]