List the SQL connection authentication method. NTLM vs Kerberos

Run the following query to find out if the connections to SQL server are using NTLM or Kerberos:

SELECT  s.session_id, c.connect_time, s.login_time, s.login_name, c.protocol_type, c.auth_scheme, s.HOST_NAME, s.program_name FROM sys.dm_exec_sessions s JOIN sys.dm_exec_connections c ON s.session_id = c.session_id