SQL Watchdog - find out instantly when SQL change

Abstract:

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.

Speakers:

  • Michael Bourgon

    1 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.

Recorded At:

Recorded on:

Jan 31, 2015

More Info:

https://www.sqlsaturday.com/viewsession.aspx?sat=362&sessionid=25219

Tags: