Ever have a customer request that you take a backup of a database, a restore using that backup, and then tell you that it is the wrong data?
Every now and then it happens, so I decided to put together some t-sql to display details on what was done. The script essentially details when the restored was [...]
MSSQL
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 [...]