Session Details -
Building a DDL Audit Solution using SQL Server 2005
|
|
Being able to effectively and transparently capture schema, security and configuration changes in SQL Server got a lot easier in SQL 2005 with the introduction of Event Notifications which leverage the Service Broker architecture to allow asynchronous capture of all server and database level DDL (Data Definition Language) statements. In this session I’ll cover Event Notifications in detail and demonstrate how we can leverage them to build a scalable audit application to capture changes across multiple SQL instances. A working sample application and reports are provided along with all source code.
|
|
|
Jasper Smith
|
|
|
|
Jasper is a member of the Database Services team at Nationwide Building Society focussed on High Availability, Scalability, Performance Tuning and Monitoring. He has been a SQL Server MVP since 2003 and runs www.sqldbatips.com with a focus on providing free tools for the SQL Server community including ExpressMaint, SQL 2005 Service Manager and Reporting Services Scripter.
|