Recently, I changed my Windows password and that started a chain of events. My account would get locked out because an invalid password was used and I started getting weird errors in various programs when using the account even after getting it unlocked several times. Restarting my own PC did not help. Then, it occurred … Continue reading PowerShell: Invoke-RDPLogoff – Logoff From Windows Servers In Parallel
If you have been working with PowerShell and SQL Server for a while now, you know that it is not difficult to capture the PRINT statement output as VERBOSE output (which can then be redirected to a variable or file). You also know that it is not too difficult to run SQL in parallel against … Continue reading PowerShell & SQL Server: Run In Parallel – Collect SQL Results With PRINT Output From Across Your SQL Farm – Fast!
I cannot imagine a life without PowerShell now. You would agreee after you find out why. This is what I had to do today. The very real problem: I have a list of about 30 servers. I need to add an AD group name to the local adminstrators group on all 30 servers Create a … Continue reading Using PowerShell – Add user or group to local Administrators group in Windows + Create SQL Server Login