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.
I'm a SQL Server Consultant (MCTS, MCITP) at Kohera in Belgium, and have been working with SQL Server since 2000. I have a lot of experience with managing large databases in telecom and finance environments. Performance tuning, SQL audits, migrations and training are also part of the job. I have also a profound knowledge in implementing high availability and disaster recovery solutions (Microsoft Failover Clustering, AlwaysOn Availability Groups, Database Mirroring, …). I'm a regular speaker at events in Belgium like SQL Server Days, 12 hours of SQL 2012, Community Day and Microsoft TechNet Live Meetings.
The video is not available to view online.