Sep-2011 ~ How to audit and prevent unwanted user actions ~ John Miner

Posted by admin

 

Presenter: John Miner of Sensata Technologies
Topic: How to audit and prevent unwanted user actions

 

Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. How do you prevent and audit unwanted user actions to key data?

This presentation will review techniques on how to prevent and/or audit data and schema changes.

The following topics will be presented with examples.

1. Granting correct user access is vital
2. Using DML triggers to keep an DATA audit trail.
3. Using DDL triggers to keep an SCHEMA audit trail.
4. Preventing unwanted DATA modifications
5. Preventing unwanted SCHEMA changes
6. Preventing table TRUNCATIONS
7. New Feature in 2008 – change data capture

Biography:

John Miner (www.craftydba.com) has twenty years of data processing and proven project management experience, specializing in the banking, health care, and government areas. His architecture expertise encompasses all phases of the project life cycle, including design, development, implementation, and maintenance. His credentials include a Masters degree in Computer Science from the University of Rhode Island with concentrations in database technologies and programming languages. He has Microsoft Certificates for Database Administration (MCDBA) and System Administration (MCSA).

May-2010 ~ As a DBA, where do I start? ~ Mike Walsh

Posted by admin

 

Presenter: Mike Walsh
Topic: As a DBA, where do I start?

 

Whether you are new to the role of DBA, being “forced” to take on the responsibility of one or are starting at a new company, knowing where to start can often mean the difference between success or failure. In this chat, Mike will help us wade through the noise that attacks a DBA and figure out just what our priorities should be. By focusing on the “itties” of Database Administration (Recoverability, Availability – Health & Performance – , Security and Reliability) we can see a natural priority build. Throughout this interactive discussion we will also have a look at some of the available tools and scripts to help us see where our environments rate with the “itties” of Database Administration. There is also an interesting tip on extracting information from vendors before bringing their systems live.

Biography:

Mike is an experienced SQL Server professional and has worked with SQL for over ten years. He has performed the duties of Database Administrator, Developer, Architect and Performance Team Lead but always leans on his DBA experience in each role. Most recently he is the Principal DBA and SQL Server SME for a global insurance company while consulting with interesting and challenging assignments on the side.
Mike is becoming more active in the community through his blogging, starting up a user group in NH (http://seacoastsql.sqlpass.org) and speaking at various regional events