sql server 加密_SQL Server机密–第一部分–加密基础知识和SQL Server加密功能

sql server 加密

介绍 (Intro)

We use cryptography every day: on the internet, mobile devices, ATM machines, and in almost every aspects of our digital life. In a nutshell, cryptography is about data scrambling and hiding, depending on the implementation and user-specific needs.

我们每天使用加密技术：在互联网，移动设备，ATM机以及我们数字生活的几乎所有方面。 简而言之，密码术是关于数据加扰和隐藏的，具体取决于实现方式和特定于用户的需求。

A database is the spine of every information system and is the specific target of potential data thieves. SQL Server has one of the best cryptographic set of features that we can use to create a state of the art security and privacy “aware” systems.

数据库是每个信息系统的骨干，并且是潜在数据窃贼的特定目标。 SQL Server具有最好的加密功能集之一，可用于创建最先进的安全性和隐私“感知”系统。

Cryptology is an art and science based in mathematics theory with the purpose of creating secret codes.  It has two major components:

密码学是一门基于数学理论的艺术和科学，旨在创建密码。 它具有两个主要组成部分：

• Cryptography
  密码学
• 

  Figure 1. Cryptology scheme

  图1.密码方案

Cryptography is about creating a secret codes, while cryptanalysis is the process of breaking secret codes.

Cryptography has two major parts:

密码学是关于创建密码的，而密码分析是破解密码的过程。

密码学有两个主要部分：

• Encryption – process of creating an obfuscated message from a plain text using a key.
  加密-使用密钥从纯文本创建混淆消息的过程。
• Decryption – process of returning plain text from an obfuscated message using a key.
  解密–使用密钥从混淆后的消息中返回纯文本的过程。

• Backdoor – a cryptosystem has a backdoor for accessing plain text from encrypted messages without the regular process of decryption.
  后门–密码系统具有后门，可用于从加密消息访问纯文本，而无需常规的解密过程。
• Brute force – the only way to decrypt a message, aside from the regular decryption process, is by testing all possible combinations.
  蛮力–除常规解密过程外，解密消息的唯一方法是测试所有可能的组合。

密码学的类型 (Types of Cryptography)

加密有两种类型：

• Symmetric cryptography
  对称密码学
• Asymmetric cryptography