Archive for the ‘Security’ Category

SQL Server Auditing – Getting started

In my organization, one of my jobs is auditing our database environment.В  I’ve been tasked with this responsibility for several years now, and it hasn’t always been easy.В  In fact, I used to despise the entire process.В  Why?В  Because I wasn’t using the right tool for the job.В  I didn’t know what options were available [...]

July 3, 2012  Tags: ,   Posted in: Security  5 Comments

Pitching Pebbles – Using Certificates to Grant Privileges

I’m sure you’ve heard the story by Stephen Covey about the professor that fills a jar with rocks, pebbles, and sand as a metaphor for time management and prioritization. I’d relate it here, but I think this video is much more fun. Obviously this metaphor applies to all aspects of our lives, but we can [...]

December 19, 2011  Tags: , ,   Posted in: Security, T-SQL, Uncategorized  No Comments

SQL Server A to Z – Kerberos

Some letters get all the love. Take ‘C’ for example. You’ve got collation, clustering, compression, constraints, change data capture… Colleen. And what about ‘A’? Atomnicity, authentication, automation, auditing, Azure, and so on. But not ‘K’. What does poor little ‘K’ get? Kill? Keywords? Meh. So today I’m talking about Kerberos. I’ll tell you a little [...]

August 18, 2011  Tags: , ,   Posted in: General, Security  2 Comments