Skip to main content

Posts

Showing posts from September, 2015

SQL Saturday #442

I'll be speaking at  SQL Saturday #442  in Orlando on October 10, 2015. This will be the next to last time I present this session. If you miss it, I will be presenting it for the Pinellas SQL User Group in November before it goes into the vault.  So, 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' ll review the fundamentals needed to define a configurable permission model   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