Tag Archives: security

How Many Times Will This Happen?

Posted on July 18, 2011 by way0utwest

This editorial was originally published on Jun 6, 2006. Steve is traveling in the UK this week and we are reprinting a few pieces. Or is it a sign of the times and something that we’ll have in the news … Continue reading →

Posted in Editorial | Tagged , | Comments Off on How Many Times Will This Happen?

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