Powershell Script for Verifying Space

PowerShell, SQLServerPedia Syndication
First let me say, I know my Powershell skills are sub-par. I'm working on it. Slowly but surely. That said, I had a problem to solve. It's one that I could have done with TSQL, but it would be very ugly TSQL, probably involving dynamic queries, and even for admin scripts, I try to avoid that. So, I went for SMO and WMI wrapped by Powershell to solve the problem. What was the problem you ask? We automate as many of our processes as we can. One process we do is resetting databases from production or other sources. Our processes work very well, but we occasionally run into a problem where the source system db has grown and the target system doesn't have the required disk space. So, we needed…
Read More