[Event Notifications] Simple alert to make sure everything's working.

When I built it, I thought I'd added enough monitors to make sure it didn't break.  Nope!  Someone dropped an endpoint, so things backed up silently for a day and a half.

Add this as a job step on your repository.  For the time, YMMV - 30 is actually too short for me, but 60 should work.

	DECLARE @last_insert DATETIME
	SET @last_insert = (SELECT TOP 1 insert_datetime FROM EventNotificationRec.dbo.ENAudit_Events ORDER BY id DESC)
	SELECT @last_insert
	SELECT DATEDIFF(MINUTE,@last_insert, GETDATE())
	IF (SELECT DATEDIFF(MINUTE,@last_insert, GETDATE())) >60
	begin
	EXEC msdb.dbo.sp_send_dbmail
	@profile_name = 'me',
	@recipients = 'dev@null.com',
	@subject = '[Priority1] Alert! EN is DOWN!',
	@body = 'ALERT! The Event Notification table has not received any new messages in over an hour. Investigate immediately.'
	end

view raw EN_basic_traffic_monitor.sql hosted with ❤ by GitHub

	DECLARE @last_insert DATETIME
	SET @last_insert = (SELECT TOP 1 insert_datetime FROM EventNotificationRec.dbo.ENAudit_Events ORDER BY id DESC)
	SELECT @last_insert
	SELECT DATEDIFF(MINUTE,@last_insert, GETDATE())
	IF (SELECT DATEDIFF(MINUTE,@last_insert, GETDATE())) >60
	begin
	EXEC msdb.dbo.sp_send_dbmail
	@profile_name = 'me',
	@recipients = 'dev@null.com',
	@subject = '[Priority1] Alert! EN is DOWN!',
	@body = 'ALERT! The Event Notification table has not received any new messages in over an hour. Investigate immediately.'
	end

view raw EN_basic_traffic_monitor.sql hosted with ❤ by GitHub

[Presenting] SQL Saturday Austin 2016, here I come!

Woohoo!  Come join us on January 30th, 2016, at Wingate Round Rock, for another awesome SQL Saturday!  I presented last year on SQLWatchdog/Event Notifications, and I'm thrilled they chose me again.

This year: WMI! 


Practically?  EVENT LOGS AND MORE.  Your SQL Server runs on a machine.  Be it virtual or physical, there's stuff going on there that you should know about.  Let's collect them.  And then, since we're building this process out of it, what else can we do?  A BUNCH.  Fix your server's Power Plan!  Monitor for file changes! Check logins! SQL Server Changes! More! And it's all stuff I use in production, so set it up Monday!

There looks to be 36 different sessions, and I see some friendly faces (Tim Mitchell, John Sterrett, Amy Harold) some people I've wanted to see speak (Thomas LaRock, Robert Davis), and some sessions that just sound seriously cool (Regexp, "Analyze your query plan like a Microsoft Engineer", "Azure Data Factory"). It'll be a blast!  And it's FREE.