Encryption

Remove Database Encryption Key on all user databases

  • Script

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.

4 (1)

2018-02-08 (first published: )

829 reads

Encrypting SQL Server: Dynamic Data Masking

  • Article

Dynamic Data Masking is a good way of rendering data unreadable for such purposes as user-acceptance testing, or demonstrating an application. It doesn't encrypt the data, and a knowledgeable SQL user can defeat it. However it provides a simple way to administer from the database what data the various users of a database application can and can not see, making it a useful tool for the developer.

2017-05-16

3,672 reads

Blogs

Daily Coping 21 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 18 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Optimize for Unknown for Inline Table-Valued Functions

By

I had a curious performance issue today. An inline table-valued function (iTVF) was performing...

Read the latest Blogs

Forums

Insert Trigger

By Barcelona10

Hi All, I have table A that has 2 columns(col 1,col2). I would like...

Searching for orphaned DB files on the SQL server

By martin.tydor@gmail.com

Comments posted to this topic are about the item Searching for orphaned DB files...

DEA

By ramyours2003

What is the use of DEA tool in sql ?  how can we  install...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers