Login

Test-DbaWindowsLogin

Stephen Bennett, sqlnotesfromtheunderground.wordpress.com | Chrissy LeMaire (@cl)

Test-DbaWindowsLogin View Source Stephen Bennett, sqlnotesfromtheunderground.wordpress.com , Chrissy LeMaire (@cl) Windows, Linux, macOS Synopsis Validates Windows logins and groups in SQL Server against Active Directory to identify orphaned, disabled, or problematic accounts Description Queries SQL Server for all Windows-based logins and groups, then validates each against Active Directory to identify security issues and cleanup opportunities. The function checks whether AD accounts still exist, are enabled, and match their SQL Server SID to detect orphaned logins from domain migrations or account deletions.

Watch-DbaDbLogin

Chrissy LeMaire (@cl), netnerds.net

Watch-DbaDbLogin View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Monitors active connections across SQL Server instances and logs client details to a central tracking table Description Watch-DbaDbLogin queries sys.dm_exec_sessions and sys.dm_exec_requests DMVs to capture real-time connection activity across multiple SQL Server instances. It records login names, client hostnames, application names, database usage, and timestamps into a central monitoring table. This solves the common problem of inadequate connection documentation when planning server migrations or application updates.

← Previous

1 2 3

Page 3 of 3