Category Archives: Powershell

Adding an AD Security Group to remote Server Administrators with PowerShell

Finally, my team of 1 has become 2. From now on I am not the only point of contact for SQL at my company. I tell you, it is going to be nice to go away without a laptop tucked … Continue reading

Posted in Powershell | Tagged , , | Leave a comment

Collecting Current Performance Monitor Data on Remote Servers with PowerShell

As an admin of systems, people will come to me on a regular basis an ask me “so and so server is slow, what’s wrong with it??”, as if expecting me to have that information right in front of me. … Continue reading

Posted in Powershell, SQL Server | Tagged , , | 1 Comment

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

Analyzing SQL Agent job activity using PowerShell

From time to time, it is up to DBAs and sysadmin’s to prove themselves innocent of charges that ‘they’ are killing the entire [insert core infrastructure system here] with “their” system activity. Recently, we have had some serious problems on … Continue reading

Posted in Powershell, SQL Server | Tagged , , , , | 2 Comments