TSQL Encrypt By Pass Phrase
Encrypt data with a passphrase using the TRIPLE DES algorithm with a 128 key bit length. Sources: https://docs.microsoft.com/en-us/sql/t-sql/functions/encryptbypassphrase-transact-sql?view=sql-server-2017
Password Protect File
To password protect file, use WinZip encryption.
Database Backup Encryption
Restoring encrypted database on another server (using Backup Encryption). Only works with SQL Server 2014 and later. Backup If a certificate is not backed up prior to backing up a database in T-SQL the following warning will be displayed in the results: Warning: The certificate used for encrypting the database encryption key has not been... » read more
FTPS (FTP over SSL) vs. SFTP (SSH File Transfer Protocol)
Security in FTP is provided by employing the SSL/TLS protocol for channel encryption as defined in RFC 2228. The secured version of FTP is called FTPS. The SFTP abbreviation is often mistakenly used to specify some kind of Secure FTP, by which people most often mean FTPS. Another (similar) mistake is that SFTP is thought... » read more
KeePass Password Safe
What is KeePass?Today you need to remember many passwords. You need a password for the Windows network logon, your e-mail account, your website’s FTP password, online passwords (like website member account), etc. etc. etc. The list is endless. Also, you should use different passwords for each account. Because if you use only one password everywhere... » read more
Database Backup Encryption
Database administrators go to great lengths to ensure that their SQL server instances remain secure. They’re usually physically located in a secured room and use appropriate user accounts than authentication protocols to verify permissions during network access. But if your database back-ups are stored off-site or in the cloud, then just as much care needs... » read more
Adding SSL certificate to get rid of the “Not secure” message on your web app
After you have point your custom domain to your Azure web app, user will get a “Not secure” warning every time they visit your web app. In order to get rid of this warning message, you need to register and install a valid SSL certificate. I use a vendor called SSLS.com to get a valid... » read more