Security

How to hide my SQL Server instance in network ? TIP #99

  In TIP #70  we saw how to find all the running SQL SERVER instance in a network or a machine. to revise see below image. This tip is just opposite to tip #70 you don’t want that your co-worker see your SQL Server instance running on your machine machine. (There are several reason behind …

Kill–use this weapon carefully in SQL SERVER . TIP #90

When we heard “Kill” then first impression of this word is very bad. We always scare with this word. In real world we never want this action  from anyone but in SQL Server case it is very helpful and help us many times. This feature we can use but very carefully. It is something like …

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 …

How to Encrypt password in SQL Server ? TIP #87

Security is always a concern for every database developer. How to secure valuable information is one of the major and important aspect. The first approach toward security to have a strong username & password and the next step is to have password in encrypted form. Now this article will help you to encrypt your password …