Transparent Data Encryption and Extensible Key Management – Better Together
Learn how you can secure your TDE environment by separating your key from the server using Extensible Key Management.
2019-09-30
8,677 reads
Learn how you can secure your TDE environment by separating your key from the server using Extensible Key Management.
2019-09-30
8,677 reads
Always Encrypted is a new security feature which was introduced in SQL Server 2016. Always Encrypted is a technology to ensure the data stored in a database remains encrypted at all times during SQL Server query processing. Always Encrypted allows clients to encrypt sensitive data, such as credit card numbers and national identification numbers, inside the […]
2021-05-21 (first published: 2019-09-05)
13,303 reads
2019-07-02
749 reads
2019-06-25
901 reads
Learn how to load an external certificate into SQL Server to encrypt your backups.
2019-04-25
4,002 reads
While IT security seeks to protect physical assets like networked computers, databases, and servers, encryption is a must-have element in any security strategy – it protects the data that lives on and between those assets.
2019-04-05
There may be a time when you want to turn off transparent data encryption on one of your TDE enabled databases. In this tip, Greg Larsen shows you how simple it is to remove Transparent Data Encryption.
2018-08-14
2,853 reads
The key challenge for application developers is to build a foolproof system to ensure data security. This is not only more intense, but more complex these days, as many organizations are planning to move their applications to the cloud. Read on to learn more.
2018-03-16
3,579 reads
Below script will remove database encryption key, database certificate and master key on all the user databases.
For tempdb database, you need to restart the SQL Server Instance to complete the process.
Note: It is advisable to take transaction log backup before this activity is performed.
2018-02-08 (first published: 2018-01-29)
2,047 reads
As security threats proliferate, the need for encryption will continue to rise. We who are the Guardians of the Data must be ready to make SQL Server respond and to manage the performance issues that are inherent in every data encryption solution.
2018-01-16
4,285 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers