Tag Archives: encryption

Quick Encryption with Always Encrypted

Posted on April 6, 2016 by way0utwest

What do you need to do in order to access data in a SQL Server that’s encrypted with Always Encrypted? It’s not much, and it’s really simple. The certificate used for encryption A parameter in the connection string That’s it. … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Quick Encryption with Always Encrypted

Create a Database Master Key–#SQLNewBlogger

Posted on February 29, 2016 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the first things you need in a SQL Server database in order to implement encryption is a … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on Create a Database Master Key–#SQLNewBlogger

SQL Server 2016: The Data Protection Version

Posted on February 24, 2016 by way0utwest

I’ve spent a few years working with SQL Server encryption and security, trying to educate people on the various capabilities involved. There are some nice features available in the platform that can help you run a more secure SQL Server, … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on SQL Server 2016: The Data Protection Version

Data for Ransom

Posted on February 23, 2016 by way0utwest

Imagine you come into work and all of your database columns are encrypted. You have no idea what key was used, and your application can’t access the data. You receive a message that for a $100,000 payment, the decryption key … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Data for Ransom