4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

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.
Presented by Pieter Vanhove at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Pieter_Vanhove.png

    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.

    http://pietervanhove.azurewebsites.net
  • Video
    The video is not available to view online.