Tag Archives: security

The difference between REVOKE and DENY

Posted on June 30, 2011 by way0utwest

There was confusion recently with a poster that was moving permissions around and asked why I said they should revoke permissions and not deny them. I decided this was worth a post to explain. If I GRANT SELECT (or UPDATE/INSERT/DELETE) … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on The difference between REVOKE and DENY

New Connect Item – TDE

Posted on June 29, 2011 by way0utwest

Does the certificate matter for TDE? Apparently not as I found a number of people discussing the fact that the expiration date for certificates is not checked for TDE restores. So if your certificate expires, you can still restore the … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on New Connect Item – TDE

HASHBYTES – A T-SQL Function

Posted on June 28, 2011 by way0utwest

Someone was asking if the HASHBYTES function was a good one to use in T-SQL as far as performance goes.. I wish I had a good reference for the function, but the best one I had on SQLServerCentral was this … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Regular Audit Analysis

Posted on June 24, 2011 by way0utwest

I was reading over a digital supplement that I received from Dark Reading recently, which details some of the issues in the Epsilon, Gawker Media, and a few other data breaches. It was light on details, but there were some … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Regular Audit Analysis