http://www.sqlservercentral.com/Articles tagged Advanced Querying, Security posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer. http://www.sqlservercentral.com/articles/Security/encryptfunction/372/2006/05/29http://www.sqlservercentral.com/articles/Security/encryptfunction/372/Storing passwords in SQL Server for authentication by your application is a common practice. But not always a good one. Someone with access could easily see all passwords and perhaps cause mischief inside your application. Imagine the office gossip getting access to your HR application as the HR director! Not a good thing. Dinesh Asanka has written a short piece on how you can use a built in function in SQL Server to encrypt these passwords and use them with a minimum of effort. http://www.sqlservercentral.com/articles/Security/saveyourpassword/1420/2004/07/12http://www.sqlservercentral.com/articles/Security/saveyourpassword/1420/In this article by Randy Dyess he shares with you the script on how he audits his environment and outputs reports of the permissions that users have.http://www.sqlservercentral.com/articles/Security/auditingii/697/2002/05/30http://www.sqlservercentral.com/articles/Security/auditingii/697/Ever been placed into a new environment and couldn't find an ounce of documentation? This article is the first in a series that will help you make an audit of your new environment and determine if any SQL Server login does not have a password, has a password the same as the login name or a password that is only one character long.http://www.sqlservercentral.com/articles/Security/newenvironmentparti/653/2002/04/02http://www.sqlservercentral.com/articles/Security/newenvironmentparti/653/Lots of applications store user names and passwords in the database. This article presents a method for encypting this information using Java. http://www.sqlservercentral.com/articles/Security/usingjavatoencryptpasswords/357/2001/07/19http://www.sqlservercentral.com/articles/Security/usingjavatoencryptpasswords/357/One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer. http://www.sqlservercentral.com/articles/Security/encryptfunction/372/2006/05/29http://www.sqlservercentral.com/articles/Security/encryptfunction/372/