Tag 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

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

Making life easy with PowerShell Functions

In my last blog, I showed you how to quickly update the Log retention for SQL server, and made it look even easier by using a Profile loaded function that gets me an instance of a SQL server SMO object … Continue reading

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

Checking Alerts on remote server using PowerShell and SMO

It is common practice to configure a set of alerts across all of your servers. These alerts will cover standard Events (severity 017 – 025) and SQL Server conditions (Log space used etc. ). You can manage these alerts through … Continue reading

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

Getting Disk Sizes using WMI and PowerShell

I love the 3rd party products that are on the market for SQL Server. Idera, Redgate and Quest (the big 3) have some amazing options for helping you manage your environment, but these can come at a pretty steep cost, … Continue reading

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