SQL Watchdog - find out instantly when SQL changes occur in production
DBA 1 - Intro / Intermediate
Almost everyone's seen it happen - problems due to changes, be it SPs, index rebuilds, or even configuration changes. What if you could look historically and track down what changes were made when, by who, and from where? What if you could see in realtime when changes occur? It exists, it's built into all SQL Servers from 2005-2014, and it's easy to implement. Come learn what Event Notification is and why you'll want it in your environment. This is not theory, all code provided and in production on hundreds of servers in multiple environments.