Encryption

Technical Article

SQL Server Transparent Data Encryption vs. NetLib Encryptionizer

  • Article

Between the legislation over the years (HIPAA, GLBA, GDPR, CCPA, etc.) and data breaches from large organizations that seem to pop-up in the news on a monthly basis, SQL Server database encryption is critical for our industry. SQL Server ships with a few options for a native encryption implementation (Column Level Encryption, Transparent Data Encryption, Data Masking, Always Encrypted), that all provide value in particular situations, but none of the options all seem to address all of the needs. What is the best way to encrypt our SQL Server data?

You rated this post out of 5. Change rating

2019-12-26

SQLServerCentral Article

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

(2)

You rated this post out of 5. Change rating

2019-10-07

9,374 reads

SQLServerCentral Article

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

(6)

You rated this post out of 5. Change rating

2021-05-21 (first published: )

13,988 reads

Blogs

Programmatic Tool Calling with the Claude SDK

By

Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...

A New Word: Mauerbauertraurigkeit

By

mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...

Methodology for dealing with bad data in production

By

Pinal Dave wrote up his methodology for what to do when you discover bad...

Read the latest Blogs

Forums

Why SQL Server Database Attach fails and how to repair it

By Nisarg Upadhyay

Comments posted to this topic are about the item Why SQL Server Database Attach...

Fixing P1 Queries

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Fixing P1 Queries

BIT_COUNT() IV

By Steve Jones - SSC Editor

Comments posted to this topic are about the item BIT_COUNT() IV

Visit the forum

Question of the Day

BIT_COUNT() IV

In SQL Server 2025, I run this code:

select bit_count('A')
What is returned?

See possible answers