What information is in your SQL Server database? Who has access to it? Should they have access to it? Can they change the data surrepitously to cover something up? These are the basic questions a whole host of regulations, standards and laws like SOX, PCI, HIPAA, and others are designed to ask. Microsoft SQL Server is smack in the middle of these questions as a repository for that information. In this webinar, we'll cover some of what Microsoft SQL Server provides to answer these questions and how best to implement them for your environment. We'll look at what works and what doesn't. And because the fine details of dealing with audits and compliance can be tedious and time consuming, we'll also look at ways to automate these things to reduce the amount of time you're required to spend on them.
Brian Kelley is an author, columnist, and Microsoft SQL Server MVP (since 2009) focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress), Professional SQL Server 2008 Administration (Wrox), and Introduction to SQL Server (Texas Publishing). Brian currently serves as a database administrator/ architect for AgFirst Farm Credit Bank where he can concentrate on his passion: SQL Server. He previously was the systems and security architect for AgFirst where he worked on Active Directory, Windows security, VMWare, and Citrix.