undocumented features

Secure your password with HashBytes TIP #89

Dear Friends, In my last article (TIP 87) I wrote about PWDENCRYPT.  I forgot to write few details but thanks to all my talented friends & blog readers who guided me by providing there feedback on post. I respect their inputs and always interested to get more inputs. Thanks to all of you. Now I …

PWDCOMPARE–a hidden function of SQL SERVER TIP #88

  I the last tip TIP#88 we saw how to encrypt a password. Now in this tip I would like to share how to check encrypted password ? Means once you stored your encrypted password in database now next step is to compare that particular password with your input password and return results accordingly. The …

Easy way to diagnose SQL Server “sp_Who2” TIP #84

  Why the SQL Server is running slow ? What are the processes running currently on SQL SERVER instance ? Many other like the above which might help us to understand our current SQL Server instance health can be answered by a simple command “sp_who2”. “sp_Who2”  is an Undocumented command. You can utilize this command …