Duration: 75 minutes
Track: Enterprise Database Administration & Deployment
Audit. The very word strikes fear in the bravest of hearts. But, as a DBA, the need to know who is doing what in your production databases is critical. In SQL Server 2008, Microsoft finally gave us a true auditing tool. But, how does it work, what exactly can it track, and how will you handle its output? In this session, we'll cover SQL Audit from the ground up. We’ll go from the basics of creating a database or server audit, all the way to using PowerShell to manage it at the enterprise level.