Skip to main content


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 modelthat 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 dep…