Tag Archives: encryption

A Tour of SQL Server Security Features

Posted on October 18, 2017 by

Abstract Protecting data from unauthorized access becomes more important all the time. SQL Server includes a number of features that make data protection and security easier for developers and DBAs with a framework for protecting data. Come learn how Always … Continue reading →

Posted in Presentations | Tagged , , , ,

New Solutions for Old Problems–T-SQL Tuesday #87

Posted on February 14, 2017 by

This is an interesting T-SQL Tuesday this month. For #87, we have an invitation from Matt Gordon. The topic is using new tools to solve old problems. The “new” cutoff is SQL Server 2014, so we’d looking at a way … Continue reading →

Posted in Blog | Tagged , | 1 Comment

Using a DMK in TDE

Posted on February 2, 2017 by

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 , , ,

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

Posted on January 26, 2017 by

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

What is a Database Master Key?

Posted on January 19, 2017 by

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 , , | 3 Comments

Do I have a Database Master Key in a database? #SQLNewBlogger

Posted on January 13, 2017 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. How can I tell if I have a Database Master Key in a database? It’s actually easy. I query … Continue reading →

Posted in Blog | Tagged , , ,

Checking Permissions for Keys–#SQLNewBlogger

Posted on December 29, 2016 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I got a call from someone wanted to check how permissions were stored for encryption objects. I ran a … Continue reading →

Posted in Blog | Tagged , ,

Post TDE–Getting Unencrypted Backups

Posted on December 28, 2016 by

I saw a question posted recently about someone that had disabled TDE and was still having issues restoring a backup. This doesn’t seem like that should be an issue, but it can be. A little testing shows how. Let’s assume … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

Encryption Keys Matter

Posted on September 13, 2016 by

Perhaps the importance of protecting encryption keys is even greater than we realize. It appears that the NSA and the US Government have been able to read encrypted traffic for some time on the Internet, perhaps for most of the last … Continue reading →

Posted in Editorial | Tagged , | 4 Comments

Learning All About Always Encrypted at DevConnections

Posted on September 6, 2016 by

Like the alliteration in the title? I almost removed it, but decided it had a nice ring. Maybe that should be the title of my IT/DevConnections (Oct 10-13, 2016) session other than End to End Always Encrypted in SQL Server … Continue reading →

Posted in Blog | Tagged , , ,