SQL Alert when you’re low on disk space

Resources, SQL
I found this gem while troubleshooting a SQL Server with a backup drive that filled up often. It uses the WMI provider will alert when ANY drive on the server goes below 10GB. You can change the value '10000000000' below to adjust this. You'll also want to change your operator from 'Support' to your operator name.  Note that this requires Database Mail to be set up with an operator and valid email. Should work for SQL 2005 thru 2012 as is, mine was set up on SQL 2005. The ability to use WMI Provider in SQL Alerts seems very useful, I have seen uses for WMI SQL Alerts, but they involved more code than just creating the alert. If you're interested in exploring the metrics WMI exposes to you, check out…
Read More

Windows 8 is released to manufacturing

They just posted the release of Windows 8 20 minutes ago. http://blogs.msdn.com/b/b8/archive/2012/08/01/releasing-windows-8-august-1-2012.aspx I'm officially on the lookout for a reliable howto for setting up dual boot on my Win7 Ultimate laptop. I DO NOT have the time to learn by trial and error. :) Anyone?
Read More