SQL Watchdog - find out instantly when SQL change
It happens - problems due to changes, be it ALTERed SPs, index rebuilds, or even configuration changes. But 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 in SQL Server (even standard edition) 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.
Michael Bourgon1 Recording
Michael Bourgon is the Senior Production DBA for a large healthcare company. He's always looking for a better way to be a Lazy DBA - spending far too many hours automating processes in order to accomplish that.
- Austin SQL Saturday 41 Recordings
- SQL Watchdog 1 Recording