Questions tagged [always-encrypted]

Always Encrypted is a feature of Microsoft SQL Server 2016 and Azure SQL Database, designed to protect sensitive data. It allows client applications to encrypt sensitive data without revealing the encryption keys to the database engine, so the data cannot be accessed either in flight, in server memory, or at rest.

Filter by
Sorted by
Tagged with
3
votes
2answers
835 views

Always Encrypted - Out of Memory Exception when attempting to encrypt a column in a table

Using Always Encrypted we are attempting to encrypt one column of type varchar(50) in a table that contains 5.5 million rows with the deterministic encryption. After a while the wizard returns failure ...
0
votes
1answer
65 views

Restoring encrypted DB to SQL vNext

I wondered if anyone else may have tried restoring a copy of an encrypted database to an instance of SQL vNext. The instance I'm running has been installed on a CentOS box, but I'm not having any luck ...
4
votes
1answer
4k views

Is it possible to bulk insert data into a table that has columns encrypted with Always Encrypted?

In SSMS we are attempting to bulk insert from a csv file into a table that has a column encrypted using SQL Server 2016's Always Encrypted feature. This is the command we're using: INSERT INTO ...
2
votes
2answers
1k views

What is the MySQL equivalent of SQL Server 2016 Always Encrypted technology?

What is the MySQL equivalent of SQL Server 2016 Always Encrypted technology or is there anything similar in MySQL that can act as AE?
3
votes
1answer
655 views

Clarification on SQL Server 2016 Always Encrypted

We are planning out a move from SQL Server 2008 to SQL Server 2016. One of the key requirements for us is to have encryption at rest at a minimum. We have been considering SQL Server Enterprise as ...
2
votes
1answer
484 views

SQL 2016 Always Encrypted, options appear in one environment, not the other

We have two different environments that are replicas of each other - DEV/STG and PROD. We recently upgraded both environments to SQL Server 2016 using the same upgrade process (we're on AWS, so it ...
1
vote
1answer
270 views

Error while creating CMK(column master key) in always encrypted

I am trying to explore SQL 2016 always encrypted feature but i am getting an error while generating new column master key, after entering name and selecting 'Windows Certificate Store-Current User' as ...
4
votes
1answer
467 views

Do signed certificates from public certificate authorities add any value for always encrypted?

If I create Always Encrypted columns in Microsoft SQL Server from the SSMS gui, it makes a self signed certificate. Is there any value in making a CSR and paying a certificate authority (or using ...
41
votes
2answers
20k views

In SQL Server 2016, what is the difference between Always Encrypted and Transparent Data Encryption?

As I write this I am still awaiting the official release of SQL Server 2016 so that we can explore the usefulness of its "Always Encrypted" feature. I would just like to know what the specific ...
1
vote
1answer
505 views

AlwaysEncrypted Conversion Fails

I'm trying to encrypt a column with AlwaysEncrypted and I get the following error. Could not deploy package. Warning SQL72012: The object [AlwaysEncryptedDemo] exists in the target, but it ...
3
votes
1answer
882 views

How do I generate the ENCRYPTED_VALUE for CREATE COLUMN ENCRYPTION KEY?

I can make a certificate in the windows certificate store for the master column key easily enough with: $cert = New-SelfSignedCertificate ` -Subject "Always Encrypted Sample Cert" ` -...

1
2