Estimating storage requirements for encrypted columns–AE learning series part 04

As we discussed in earlier posts and as you might already be aware, AlwaysEncrypted columns require additional storage after they’re encrypted. Of course, that means that you need to plan properly as this might cause effects to your database, such as data file growth, fragmentation, etc. So, how exactly can you calculate the space, that…

0

Listing encrypted columns–AE learning series part 03

In the first two parts (part 1, part 2) we learned how to build our first application using Always Encrypted and import new or existing data in it. In the following post I want to give you some details on the available metadata for Always Encrypted. There are some changes in existing DMVs (such as…

0

Encrypting existing data – AE learning series part 02

In the first post of the series we built our first application with Always Encrypted infrastructure. Now it is time to insert some data and the options are not that many. Because the AE is only supported by ADO.NET connections, you must use a tool that supports it, therefore you can use: Use SSMS Encrypt…

0

Build your first app with SQL 2016 Always Encrypted – AE learning series part 01

Dear reader, this is the first post of a learning series I decided to compile over the Christmas Holidays. I am working on one of my first implementations on AlwaysEncrypted and as a new technology, we, as SQL guys, need to pump-up our knowledge and share what we found along the way, especially if it…

0