I’ve started a new series at MSSQLTips.com walking through the various Dynamic Management Objects we have available to us in SQL Server. A couple of encounters with some folks in recent months showed a need as more than one person responsible for managing SQL Servers didn’t know about these helpful telemetry resources.

This first one is targeting the logical starting points: connections into SQL Server. The link to the article is here:

Return SQL Server Connections Information Using sys.dm_exec_connections