I know what you did last summer... on my database
Have you ever been in a situation where suddenly all the records of a table have been deleted and everybody was playing Manuel, I know nothing! A lot of people want to know who did what and when on your SQL Server and databases. In the past, the only option that you had was activating a SQL Profiler Trace or developing your own triggers…
Since SQL Server 2008, Microsoft introduced a new feature SQL Audit. It allows you to audit your users on several actions on your databases. This session provides a detailed explanation of SQL Server Audit and the different configurations along with some practical examples. I will also show you how you can audit the audit.
Sorry, there are no downloads available for this session.
Pieter Vanhove is a SQL Server MVP and Database Consultant at
Kohera in Belgium and has been working with SQL Server since 2000. Performance
tuning, SQL audits, migrations and training are part of the job. Pieter has
also a profound knowledge in implementing high availability and disaster
recovery solutions and loves the new Azure stuff. Together with the SQLUG in
Belgium, he helps organizing SQL Server Days and is also a regular speaker at
Belgian and international events. Pieter recently won the Speaker Idol Contest at PASS Summit 2014.
The video is not available to view online.