One very useful usage of Extended Events is the ability to trap SQL Server error without the need to have a server trace running (which, btw, is deprecated), with the additional feature of being able to query the data as soon as it comes in. This means that we a solution to monitor and trap errors as soon as they happen can be easily created, in ...

This is a very simple script - but it's one I run each morning. It searches the Windows System Event Log for an error condition. You can replace ''System'' here with ''Application'' or ''Security'', or any of the other logs that are created on your Windows Server. This is run at the server, since I have each server check itself and make a file of ...