Skip to main content

Posts

Showing posts from February, 2015

SQL Saturday #371 Tampa - I'm speaking!

I'll be speaking at SQL Saturday #371 in Tampa on February 28, 2015. If you are interested in minimizing or possibly preventing the type of breach that happened at Anthem Inc , you will likely find my  session  " Real World SQL Server Database Administration with just a bit of sysadmin " very interesting.  It is becoming increasingly difficult to allow SQL Server database administrators to retain perpetual sysadmin access on production servers due to IT Security, Audit, and Compliance concerns.  I  will review the fundamentals needed to define a configurable permission model  currently in use at a large insurance company  that allows database administrators to do routine work without having unfettered access to business data. Several demonstrations will show that many DBA tasks can be done without sysadmin access. Attendees will also learn how to deploy a set of permissions that allows DBAs to do routine work, elevate DBA permissions quickly to respond to productio