How to get SQL Server Explicit Permssions for a Server Principal

Query to return the SQL Server Explicit permissions for a specific Server Principal.

Useful if you want to identify GRANT,REVOKE,DENY for server principals 

SELECT @@SERVERNAME ,spri.name, spri.type_desc, sper.permission_name, sper.state_desc 
FROM sys.server_permissions sper 
INNER JOIN sys.server_principals spri 
ON sper.grantee_principal_id = spri.principal_id 
where spri.name = 'MyLoginID'

Some other related queries for SQL Server users and permissions

SQL Server user roles and permissions query

How to get user security changes with SQL default trace