http://www.sqlservercentral.com/Content tagged Security, SQL Server 6.5 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)As yo probably know, Brian covers security topics for us and does a great job. This week he looks at the fixed roles and points out a few things you may not have thought about. http://www.sqlservercentral.com/articles/Administering/sqlserversecurityfixedroles/1163/2007/05/04http://www.sqlservercentral.com/articles/Administering/sqlserversecurityfixedroles/1163/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/In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable. http://www.sqlservercentral.com/articles/Administering/securitypart2/593/2005/11/04http://www.sqlservercentral.com/articles/Administering/securitypart2/593/Securing your SQL Server can be an arduous task, but very rewarding. This article covers 10 steps to properly protecting your data. http://www.sqlservercentral.com/articles/Security/10securingyoursqlserver/701/2005/05/27http://www.sqlservercentral.com/articles/Security/10securingyoursqlserver/701/In this series of articles, Chris Kempster will discuss some of the finer aspects of SQL Server security and also touch on OS, physical and application security to open up this science for general discussion. http://www.sqlservercentral.com/articles/Administering/sql_server_security/578/2005/02/11http://www.sqlservercentral.com/articles/Administering/sql_server_security/578/We saw a note from Chad about a tool he wrote in the forums and asked him to write up some notes. Not only did we get notes, we got the source code! See what a DBA can do with some DMO. http://www.sqlservercentral.com/articles/Administering/dumpsqlpermissions/1314/2004/03/17http://www.sqlservercentral.com/articles/Administering/dumpsqlpermissions/1314/In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable. http://www.sqlservercentral.com/articles/Administering/securitypart2/593/2005/11/04http://www.sqlservercentral.com/articles/Administering/securitypart2/593/As yo probably know, Brian covers security topics for us and does a great job. This week he looks at the fixed roles and points out a few things you may not have thought about. http://www.sqlservercentral.com/articles/Administering/sqlserversecurityfixedroles/1163/2007/05/04http://www.sqlservercentral.com/articles/Administering/sqlserversecurityfixedroles/1163/Securing your SQL Server can be an arduous task, but very rewarding. This article covers 10 steps to properly protecting your data. http://www.sqlservercentral.com/articles/Security/10securingyoursqlserver/701/2005/05/27http://www.sqlservercentral.com/articles/Security/10securingyoursqlserver/701/How safe are your SQL passwords? Use these free tools to find out how secure your passwords are and generate more secure passwords. http://www.sqlservercentral.com/articles/Security/sqlserverpasswordauditing/869/2002/12/10http://www.sqlservercentral.com/articles/Security/sqlserverpasswordauditing/869/In this article by Neil Weicher, he talks about encryption of data and files for SQL Server. http://www.sqlservercentral.com/articles/Administering/securityworstpracticeneil/592/2002/01/30http://www.sqlservercentral.com/articles/Administering/securityworstpracticeneil/592/In this series of articles, Chris Kempster will discuss some of the finer aspects of SQL Server security and also touch on OS, physical and application security to open up this science for general discussion. http://www.sqlservercentral.com/articles/Administering/sql_server_security/578/2005/02/11http://www.sqlservercentral.com/articles/Administering/sql_server_security/578/A look at the different security modes availabe in SQL Server 6.5 http://www.sqlservercentral.com/articles/Security/sqlserver65securitymodes/318/2001/07/19http://www.sqlservercentral.com/articles/Security/sqlserver65securitymodes/318/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/Poorly managed SQL Server Security can not only leave your SQL Server vulnerable, but also leave your NT Server and network open to attacks. http://www.sqlservercentral.com/articles/Security/securitypitfalls/171/2001/05/14http://www.sqlservercentral.com/articles/Security/securitypitfalls/171/This article by Andy Warren discusses both how to use the Public Role and how using Public may cause you more problems than it's worth. Great examples! http://www.sqlservercentral.com/articles/Security/sqlpermissionspublicrole/116/2001/05/10http://www.sqlservercentral.com/articles/Security/sqlpermissionspublicrole/116/