Learn dbatools in a Month of Lunches

24 Security and encryption

As the focus on security has grown within the IT industry, the security features supported within SQL Server have also grown, well beyond the basics of authentication, authorization, permissions, and securables. SQL Server network encryption between the instance and the client has been available since SQL Server 2000, whereas newer features such as encrypting data at rest and column encryption were introduced in SQL Server 2008 and SQL Server 2016, respectively. With modern versions of SQL Server, you can encrypt the following:

• Backups

• Network traffic between the instance and the client

• Entire databases

• Specific columns

SQL Server also supports enforcing Extended Protection and hiding your SQL Server instances, ...