So, I'm trying to update an sql script we use for dumping databases. I want to add a shrink to the script but it's not working and I don't really understand why. SQL is not a strong point for me. The ...

Last time, I discussed how to get PowerShell and SQLPS up and running on your machines. And much like my dog chasing its tail, you're probably asking yourself, "Now that I have it, what do I do with ...

I have a need to handle errors in SQL scripts that i'm working with.<BR><BR>Frequently these errors contain syntax problems and other things like create/drop constraints, not exist..

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...