AppInsight for SQL alerting

Hi good morning Thwack,

I have a request from one of our DBA's for alerting to be setup for deadlocks / blocking and SQL Server error log whose severity is greater than 16. I can't seem to figure out how best to set this up.

Has anyone out there setup alerting for deadlocks and SQL Server error log that could help out?

On a side note why aren't there more alerting for the AppInsight for SQL components?

Thank you