Change Data Capture (CDC) is a method of identifying and capturing changes made to a database. It captures data changes and enables businesses to keep track of all modifications made to their data, including updates, inserts, and deletes. CDC is Read More …
Category: MSSQL
Part 3 – Encrypting an existing database with TDE
The process of setting up TDE is the same whether you’ve just set up a new database, or whether you’re working with a live database. Once you turn encryption on SQL Server will begin the process of encrypting any data Read More …
Part 2 – Setting up Transparent Data Encryption (TDE)
You can set up Transparent Data Encryption (TDE) when you first create a database, or you can apply it to an existing database. In the latter case, once TDE has been enabled it will set to work encrypting your existing Read More …
Part 1 – What is Transparent Data Encryption?
Transparent Data Encryption (TDE) was introduced in SQL 2008 as a way of protecting “at rest” data. It continues to be available in all versions of SQL right up until the present, until recently it was only available in the Read More …