Data Privacy and Protection

Principles of Data Protection

  • Article

Protecting data in SQL Server is not as simple as setting a few properties. While there are great security features in SQL Server, such as Transparent Data Encryption, production data may end up in places throughout the organization. In this article, Brian Kelley talks about the best ways to secure data using the concept of least privilege.

2018-07-12

3,100 reads

Blogs

Daily Coping 25 Sep 2020

By

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

VMworld 2020 – Top 10 Database Sessions (Part 1)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 24 Sep 2020

By

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

Read the latest Blogs

Forums

Always On - tips for running large transactions

By NicHopper

Hi all, I wanted to get a second opinion on something, this weekend I...

Encrypted column copy

By IT researcher

I am using SQL Server 2008 R2. I have encrypted some of the columns...

SQL query error help

By rocky_498

Hi Guys, I have a table, around 320 fields. I am trying to use...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers