Hi folks. Because enabling an SSL certificate on a SQL Server Failover Cluster, thus enabling encryption for your data in-motion, is a little bit tricky, I decided to write this article in order to help you out a bit, since in the past, I encountered the same difficulties. So, please read on to learn more … Read more…
Encrypting a SQL Server database backup is necessary in many cases, especially when the database has sensitive data. SQL Server provides an easy way to encrypt database backups. Let’s further examine this functionality with a step-by-step example. In this example, we are going to backup a SQL Server 2014 database, encrypt it, and then restore … Read more…
In this article, we will be discussing about the different available options, for encrypting SQL Server databases. The Need for Data Encryption In corporate environments there is always the requirement/policy of data protection. Data is the most valuable asset in every organization, after its human resources of course, as it is with data where … Read more…
Transparent Data Encryption (TDE) is another new feature in SQL Server 2008. It performs real-time I/O encryption and decryption of the data and log files, that is the entire database. For achieving that, it uses a database encryption key stored in the database boot record. A derived benefit of TDE is that whenever a database … Read more…