SQL Tips - How To Use Encryption For Password For Security In SQL Serv

Security is always a pain point for any developer/client. A strong password is not enough but also we need some encryption logic as well.

Security is one of the main concerns in today's digital world. Everyone wants to secure their application and database. Using a strong password is one of the good practices but at the same time we, have to implement some other rules and regulations as well like encryption of the password.

Microsoft SQL Server also provides us a unique feature or we can say to function to make the password encrypted.

In this simple article, you will see how you can encrypt your password easily.

The magic function is PWDENCRYPT.  The syntax is super easy as you can see below,

GO
SELECT PWDENCRYPT('MY TARGETED STRING')
GO

Here you can replace your targeted password string.

To understand more see below snap,

I hope this small tip might help you to secure your data in SQL Server.

Please, provide your input on what you think about this small magical function.

Thanks