Tag Archives: sql server

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

The vNext Bleeding Edge

Posted on January 28, 2017 by way0utwest

Microsoft has had early access programs for years. I worked at a few companies that were a part of the TAP (Technology Adoption Program) program, and we would get access to code early in exchange for providing feedback and working … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The vNext Bleeding Edge

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

The New SQL Server 2016 Edition Limits

Posted on January 26, 2017 by way0utwest

I was thrilled with SQL Server 2016 SP1. I’ve been asking for all features to be in all editions for a long time, and now we have most of the features available. There are still a few enterprise only items, … Continue reading →

Posted in Editorial | Tagged | Comments Off on The New SQL Server 2016 Edition Limits