Tag Archives: Automation

Keep up to date with CMS and registered servers, using PowerShell

Introduction Working for a large company with multiple SQL instances can be a lot of fun, a challenge, overwhelming, a headache, a great motivator for automation. You choose. For me automation is the best answer here, working with hundreds of … Continue reading

Posted in Powershell, SQL Server | Tagged , , | Leave a comment

Automating SQL Backup verification testing with PowerShell

Introduction Talk to any person responsible for a database, no matter what platform, and ask them what is their most important responsibility, I would hope that all of them would list backups at the top of their list. Managing these … Continue reading

Posted in Powershell, SQL Server | Tagged , , , , , , | Leave a comment

Scripting Log re-sizing

I know, shrinking log files is bad, but sometimes it is also necessary. Sometimes things go wrong, queries go bad, indexes rebuilds run forever, and any of these events can cause a log file to grow beyond its usual size. … Continue reading

Posted in SQL Server | Tagged , , , , , | Leave a comment