First off, I apologize for not posting for a while. I’ve switched jobs and have been spending the time getting sorted at the new job. On the one hand, it’s exciting to move into a new environment and learn new things. However, it’s also been oddly comfortable, since it’s all SQL Server. Anyway, more on that later.
I found out yesterday that I’ll be presenting at SQL Saturday #94. Hurrah! I’m very happy the Salt Lake City folks have given me a chance to present. Unfortunately, I present opposite to Doug Lane, but at least I won’t have to worry about him heckling me.
For those wondering, I’ll be doing my security presentation again. For those curious, it’s definitely a beginner presentation, but it was well recieved at all the Colorado groups. I was even told by a DBA of 20+ years that he got something new out of it. Hopefully you will to!
Managing and Auditing SQL Server Permissions
When your boss asks you who has access to your databases, do you break out into a cold sweat? Or, instead, are you worried about those other people who might have ‘sa’ access to your server and might be causing trouble on your server? Either way, as DBAs we need to be able to audit our SQL Server security. This presentation will give you a general overview of the different types of roles that you can use to manage access, what they mean, and how we look at the security gremlins hiding under the covers of our databases.
I look forward to seeing you in Salt Lake City!