[Event Notifications] Changing the owner of the endpoint

So the guy who set up Event Notifications, which you now love and adore, left.  And it turns out he set it up as his user on all the boxes, so it stopped working and now you need to change the owner of the Endpoints.  How?  Simple:

--http://akawn.com/blog/2014/06/identify-and-change-a-sql-server-endpoint-owner/

USE master;

SELECT

 SUSER_NAME(principal_id) AS endpoint_owner

,name AS endpoint_name

FROM sys.endpoints;

/*

USE master;

ALTER AUTHORIZATION ON ENDPOINT::ENAudit_Endpoint TO sa;

*/

[Presenting] Overlord, my 24 Hours of PASS presentation on Event Notifications

Welcome, all!

I hate being "that guy", the one with the awesome presentation who swears he'll have it up "today or tomorrow".  So, here's my presentation for 24 Hours of PASS.  Still stunned that I was chosen, thrilled to present it, and hopeful that you'll fall in love with it like I did.  Thanks for visiting!




And everything (slides, code, my in-production repository) can be found at:

https://drive.google.com/file/d/0B3a287PS_UJITXNON2h1STlmZFE/view?usp=sharing