Encryption

6 steps to a more secure SQL database

  • Article

Security is often something people think about only after they have had a problem. Given that the average cost of a data breach is $3.92 million (SecurityIntelligence 2019) and ransomware attacks have increased 97% over the past 2 years (PhishMe 2019), the "if it's not broke, don't fix it" approach can clearly be catastrophic. Here […]

5 (2)

2019-10-07

3,955 reads

SQL Server 2016 - Always Encrypted

  • Article

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 […]

5 (4)

2019-09-05

5,506 reads

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: )

454 reads

Blogs

What the ???? T-SQL Tuesday #120

By

Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...

First Time Speaking at PASS Summit

By

This week, I filmed my experience as a first time speaker at PASS Summit...

Azure SQL Best Practices?

By

A way to enforce good practice and standards is by Azure Policy. As stated...

Read the latest Blogs

Forums

does WITH (NOLOCK) hint in Select statement really make a difference?

By VoldemarG

In any regular Select query joining a few tables like below, does using this...

Query

By jsshivalik

Hi Table 1 AccountId Name 1101 aaaa 1701 bbbb Table 2 TransId Account Debit...

Replication- Design Help

By RS-HOF

Hi everyone, I'm new to the forum and am helping to get a little...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers