Tag Archives: security

Let NonAdmins Get Logins

Posted on February 8, 2017 by way0utwest

I saw a question recently about how to allow some users to see the logins on a server without being a sysadmin or securityadmin. This was in support of a migration effort, so users needed read rights without being able … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Let NonAdmins Get Logins

Using a DMK in TDE

Posted on February 2, 2017 by way0utwest

When you setup TDE, you need to create a DMK (Database Master Key) in the master database if one doesn’t exist. This key forms the basis of a chain of protection for your data inside of the SQL Server instance. … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Using a DMK in TDE

What’s a Database Encryption Key (DEK) in TDE

Posted on January 26, 2017 by way0utwest

The encryption mechanisms in SQL Server are interesting, and they work well, but they are somewhat poorly named. I ran across a few people struggling to understand, so I decided to cover the concepts in a series of posts. This … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

Delaying Patches is Problematic

Posted on January 17, 2017 by way0utwest

I was listening to a DevOps podcast from Josh Corman, of Rugged Software. Rugged Software aims to improve security by asking developers and sysadmins to adhere to their manifesto, which recognizes both the importance of software in the modern world, … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Delaying Patches is Problematic