Tag Archives: security

Why Devops? For Better Security

Posted on February 9, 2017 by way0utwest

The ideas of DevOps are a mixture of principles, ideas, recommendations, tools, processes, attitudes, and more. There isn’t any  one way to implement a DevOps process, and plenty of people have been working in what many would consider a DevOps … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Why Devops? For Better 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