Next Meeting: Wed, Mar 19 2014
March user group meeting
Event Type: In-Person
Olympia Area SQL Server User group meeting
UTC : Wed, Mar 19 2014 21:30 - 23:30
Event Time : Wed, Mar 19 2014 14:30 - 16:30 (GMT-08:00) Pacific Time (US & Canada)
Your Local Time: Wed, Mar 19 2014 21:30 - 23:30
Room 153, DSHS, Point Plaza East
310 Israel Road SE
Using SQL Audit for meeting Compliance Needs
Mike Ray Microsoft
Many organizations want to know who is reading or changing their data. This has become more important in a post-Snowden world for some government customers. SQL Server introduced native auditing capabilities in SQL 2008 and it was extended in SQL 2012. Based on extended events, SQL Audit provides a way to track who is accessing your data, when, and how. This replaces the trace based audit, and provides some careful engineering to get the right information from your audit. The presentation will explain what audit is, demonstrate an audit specification, and show how to read an audit.
Mike has been with Microsoft for 13 years. Mike worked on the SQL Server Books Online team as a technical writer, at MSN and Bing as a database engineer, as a consultant in the US Public Sector organization, and most recently as a Premier Field Engineer. Mike is interested in helping companies bridge the gap between having data and knowing the state of their business. Mike also supported customers in Europe, the Middle East, and around the US. Mike is looking forward to participating in the community.