PowerShell – Email All Users Connected (Logged In) To A SQL Server Instance

As a DBA, when I have to do an emergency restart of a SQL Server instance or the host itself, the first thing I do is to check who is connected so that I can notify them (at least the ACTIVE users). We do have a system where we keep the app/database/owner information but notifying … Continue reading PowerShell – Email All Users Connected (Logged In) To A SQL Server Instance

Wait & Notify via email When A Process Completes – Using PowerShell

A colleague of mine was copying a large file over the network using "RoboCopy". As a good citizen, he throttled the copy using the "/IPG" switch of RoboCopy. For information sake, /ipg:n Specifies the inter-packet gap to free bandwidth on slow lines. After starting the copy he informed me that it would complete in around … Continue reading Wait & Notify via email When A Process Completes – Using PowerShell