How to capture SQL login details with Extended Events

An application owner wanted to record the usage of a specific logon and assess where the connections were coming from Read more →

How to add members to the Administrators group with Powershell

An Adminstrator asked how to use Powershell for adding members to Local Administrator group Read more →

How to view the current Powershell session security permissions

How can I see the current PoSH security ? Read more →

How to get Active Directory Group Scope - Local Domain, Global Group, Universal Group with Powershell

Find the Active Directory groups scope - Local Domain, Global Group, Universal Group with Powershell Read more →

How to resolve a hostname or ip address with Powershell

How to resolve the fully qualified name of a server using Powershell Read more →

How can I execute t-sql with a Proxy account

SQL Server Agent job failures with tighter security upon server migration Read more →

AWS-RDS SQL Server limitations

On-prem to AWS RDS SQL Server has some differences. Processes need to be reviewed Read more →