http://www.sqlservercentral.com/Content tagged Security, SQL Server 7, 2000, Miscellaneous, Strategies posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Auditing, analyzing and documenting your SQL Server installation is becoming more important all the time, especially as more and more attention is being paid to the security of your environment. Chad Miller brings us a look at a framework and a sample document you can use in your environment to conduct an audit. http://www.sqlservercentral.com/articles/Administering/conductingasqlserveroperationalaudit/2079/2005/10/24http://www.sqlservercentral.com/articles/Administering/conductingasqlserveroperationalaudit/2079/In this follow up to one of our most popular articles, Andy responds to comments posted by readers and discusses how to manage SQL logins effectively in your applications. http://www.sqlservercentral.com/articles/Administering/thecaseforsqlloginsparttwo/780/2002/08/19http://www.sqlservercentral.com/articles/Administering/thecaseforsqlloginsparttwo/780/Continuing with the Worst Practices Series: Steve Jones examines why encryption in the database is a bad idea. http://www.sqlservercentral.com/articles/Security/wp_encryption/527/2002/01/08http://www.sqlservercentral.com/articles/Security/wp_encryption/527/The major part of the article, however, is dedicated to a topic that often confuses people and leads to some of the strongest disagreements among IT professionals and developers: the benefits and drawbacks of enforcing security in the middle (or business) tier versus the data tier. http://www.sqlservercentral.com/redirect/articles/558/2001/12/25http://www.sqlservercentral.com/redirect/articles/558/