In this article we look at ways to generate secure and easy to recall passwords in SQL Server
Almost all of the important information worldwide is often secured using passwords, pin codes or scanners (finger print scans / facial scans). In case of scanning, there is nothing the user needs to remember, for pin, there are only numbers, but in case of passwords, it is always a difficult combination. A lot of people have problems remembering their passwords, for this reason they end up using similar passwords for different accounts or note down their passwords somewhere. These are very insecure methods, having a similar password is risky for all your accounts, and noting it down is even riskier! That paper might go out of your hands and reach someone else.
For SQL users, securing the database is of utmost priority, and they cannot rely on easy or weak passwords. Therefore it is suggested to opt for unconventional and strong passwords, so that the data is secure at all times. But unconventional passwords, which are a mix of letters, numbers and special characters, are often difficult to remember. To make it easier, we are listing these few techniques to generate secure passwords that are easy to remember in SQL Server:
- Password Generator – This helps generate passwords using a series of vowels and consonants commonly used together. These passwords do not make sense but can be pronounced easily, and hence be remembered. This uses the ‘Standard Random Number Functionality’ encompassed by the .NET framework to create passwords that are easily pronounceable.
- Generate Method – The password generating method uses a single parameter for accepting final passwords. This includes double the amount of syllables that will be generated; this will be the minimum length of password. In this method the passwords can vary on the basis of sequence which is chosen to create the password. It might be in a different order. What was earlier starting with a vowel will now probably start with a consonant.
- Testing – After using password generator to generate passwords, the user can also use it to test passwords. You need to enter the right code and it will provide you with 10 different passwords as samples, you might use a password from those samples or might enter the code again to create a new password. These passwords are words with no meanings but sound good. The user can always attach a meaning to these words, to make them more meaningful, and easy to recall.
- Improvements – Passwords created through this method are not the strongest of passwords, since they do not contain any special character or letters from different case. They would however be comparatively difficult to crack but easily breakable using ‘Brute Force Attack’. The user should opt for adding a few numbers and special characters to add on to the strength of the password. However it is also important to be careful while adding these, as this might affect the pronunciation which will again make it difficult to remember. So it is better to add them at the end or the beginning to retain the pronunciation.
It is tough to prevent SQL crashes but it is easy to plan for such contingencies
Preventing a SQL crash is a tall order. Despite your best maintenance process in place, the SQL Server database file may still crash. However you can prepare for such contingencies by procuring a sql recovery software like DataNumen SQL Recovery. Whenever you encounter a SQL crash, just run this software to recover all the data stored in the compromised SQL file in a jiffy. The tool can effortlessly handle gigantic files and can deal with nearly every other storage media format.
Alan Chen is President & Chairman of DataNumen, Inc., which is the world leader in data recovery technologies, including access recovery and sql recovery software products. For more information visit https://www.datanumen.com/