Encryption

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?

2019-12-26

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

4,340 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

6,469 reads

Blogs

Implementing HA on MSSQL Server (AlwaysOn Availability group)in an on-premise environment (Part 1)

By

I am very passionate about having a disaster recovery architecture, plan and strategy. This...

I Presented with Live Captioning and Sign Language Interpreters

By

I had the pleasure of presenting a full-day pre-conference session on the Friday before...

What's New in SQL 2019? at the Santa Fe SQL Server User Group

By

Hi Santa Fe! My first remote presentation for the Santa Fe SQL Server UG...

Read the latest Blogs

Forums

Convert column values into single row comma separator

By Rock

Team My requirement is to convert column values into single row comma separator along...

Running VBS Script through SQL Agent Job

By EsquireDeveloper

Hello All, Glad to have found this board. I have a VB Script that...

SELECT different rows on multiple threads

By Lambert Antonio

I have an application which will be reading from a single table, in order...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

DBCC Meaning

See possible answers