As promised in previous blog posts I am cranking out some videos to prepare for SQL Rally. If you aren’t registered for SQL Rally register now. The price jumps up after April 30th. Alright everyone its time to get Proactive.
The goal for this video is very simple. I just want to show you how easy it is to execute a query against your SQL Server farm. In this example I get proactive by finding database files that are low on space. Once, I find them I can extend them so we aren’t fragmenting our drives by depending on the autogrowth settings.
Central Management Server is a very simple but powerful tool. To get a taste check out my video below.
[UPDATE 9/14/2011]
The query used in the video above can be found here. If you liked this video checkout my tip on automating data collection with PowerShell and Central Management Server