MagicPASS September 2014 Meeting
Wednesday, September 17, 2014 from 5:00 PM to 9:00 PM (EDT)
Free SQL Server Training!
Join us for the September 2014 meeting of MagicPASS, South Orlando's SQL Server User Group. Food and beverages will be served, plus we've got swag to give away!
This month we welcome Ronald Dameron to present SQL Server Security Easy Button.
After the meeting we'll head to the Celebration Town Tavern for more socializing. (You are responsible for your own drinks)
Make a difference in someone's career: Invite them to attend the meeting with you! (Heck, invite them to attend even if you can't make it)
SQL Server Security Easy Button
Speaker: Ronald Dameron
Summary: It is becoming increasingly difficult to allow SQL Server database administrators to retain sysadmin permission 24x7x365 on production servers due to IT Security, Audit, and Compliance concerns.
This session will review the fundamentals needed to define a configurable permission model that allows your company’s DBAs to do routine work without them having unfettered access to business data. Attendees will learn how to deploy a permission model that allows DBAs to do routine work, elevate DBA permissions quickly to respond to production emergencies and how to grant sysadmin permissions during disaster recovery scenarios. Scripts will be reviewed and demonstrated that secure the database server and that can undo the permission model in case of unforeseen circumstances.
Attendees will leave this session with the fundamental knowledge and a set of scripts to implement a low hassle solution that provides DBAs the minimum necessary access required to maintain a production database server.
About Ronald: Lead MSSQL DBA for largest life insurer in the USA. Current interests are: Database automation and database security.