(Denny Cherry) Out of the box, SQL Server will encrypt some things by default to protect you and your data. Out of the box, SQL Server will encrypt the passwords which are sent up from the client to the SQL Server.
/membership]
Read More (Community content)
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help