http://www.sqlservercentral.com/Content tagged Administering, 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/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/If your database is marked suspect, this will show you a step-by-step guide in how to fix the problem. http://www.sqlservercentral.com/articles/Administering/unmarksuspect/137/2005/10/28http://www.sqlservercentral.com/articles/Administering/unmarksuspect/137/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/This article by Andy Warren talks about using sp_addlogin to move logins from one server to another. It also points out a problem you may run into if you have a SQL 7 server that was upgraded from 6.5 http://www.sqlservercentral.com/articles/Administering/movinglogins/120/2004/05/12http://www.sqlservercentral.com/articles/Administering/movinglogins/120/If your database is marked suspect, this will show you a step-by-step guide in how to fix the problem. http://www.sqlservercentral.com/articles/Administering/unmarksuspect/137/2005/10/28http://www.sqlservercentral.com/articles/Administering/unmarksuspect/137/Nice write up on the Admin Companion. Should you add it to your bookshelf? Frank offers his frank opinion. http://www.sqlservercentral.com/articles/Administering/reviewofreviewofsqlserver2000administratorscompani/1318/2004/03/26http://www.sqlservercentral.com/articles/Administering/reviewofreviewofsqlserver2000administratorscompani/1318/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/The second part of Steve Jones's series on having SQL Server automatically report information to a DBA. http://www.sqlservercentral.com/articles/Administering/20010422115754/85/2003/12/25http://www.sqlservercentral.com/articles/Administering/20010422115754/85/One of the most handy extended stored procedures in SQL Server is xp_cmdshell. This article will show you how to use it. http://www.sqlservercentral.com/articles/Administering/xpcmdshell/141/2003/11/14http://www.sqlservercentral.com/articles/Administering/xpcmdshell/141/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/Andy takes us through a recent troubleshooting session that includes a call to PSS. Ever run agent from the command line? Have a good idea of what justifies a call to PSS? Read this to learn more. http://www.sqlservercentral.com/articles/Administering/sqlagentproblem/1045/2003/07/09http://www.sqlservercentral.com/articles/Administering/sqlagentproblem/1045/We asked Chris to put together some information on how he uses VSS, a subject that comes up a lot as we have articles and discussions that involve change management. Change management isn't easy, you definitely need a pattern to work from. This two part article gives you a pattern you can start with and customize to your needs. http://www.sqlservercentral.com/articles/Administering/examplevssframeworksourcecodemanagementpart1/1070/2003/07/07http://www.sqlservercentral.com/articles/Administering/examplevssframeworksourcecodemanagementpart1/1070/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/This article examines how index statistics are used in SQL Server 6.5 http://www.sqlservercentral.com/articles/Administering/sqlserver65indexstatisticdetails/396/2001/10/30http://www.sqlservercentral.com/articles/Administering/sqlserver65indexstatisticdetails/396/This article examines some useful undocumented stored procedures in SQL Server 6.5 http://www.sqlservercentral.com/articles/Administering/undocumentedstoredproceduresinsqlserver6.5/398/2001/09/21http://www.sqlservercentral.com/articles/Administering/undocumentedstoredproceduresinsqlserver6.5/398/This article presents the technical details of the page layout for data in SQL Server 6.5 http://www.sqlservercentral.com/articles/Administering/datapagestruct65/295/2001/07/30http://www.sqlservercentral.com/articles/Administering/datapagestruct65/295/This article examines how locking occurs in SQL Server 6.5 http://www.sqlservercentral.com/articles/Administering/lockinginsqlserver65/313/2001/07/13http://www.sqlservercentral.com/articles/Administering/lockinginsqlserver65/313/Have you ever worked with an application that forgot to close its connections? Ever run out of connections on your SQL Server and had to manually go remove the ones that are not in use? This article will present a technique for keeping the database clean. http://www.sqlservercentral.com/articles/Administering/sweepuptheslackers/158/2001/05/07http://www.sqlservercentral.com/articles/Administering/sweepuptheslackers/158/One of the most handy extended stored procedures in SQL Server is xp_cmdshell. This article will show you how to use it. http://www.sqlservercentral.com/articles/Administering/xpcmdshell/141/2003/11/14http://www.sqlservercentral.com/articles/Administering/xpcmdshell/141/This article by Andy Warren talks about using sp_addlogin to move logins from one server to another. It also points out a problem you may run into if you have a SQL 7 server that was upgraded from 6.5 http://www.sqlservercentral.com/articles/Administering/movinglogins/120/2004/05/12http://www.sqlservercentral.com/articles/Administering/movinglogins/120/How can you maintain a stable environment? Keeping track of all changes is the time-tested and proven technique. Read about it here. http://www.sqlservercentral.com/articles/Administering/20010424175746/104/2001/04/30http://www.sqlservercentral.com/articles/Administering/20010424175746/104/The eighth part of Steve Jones's series on having SQL Server automatically report information to a DBA. http://www.sqlservercentral.com/articles/Administering/20010423065956/94/2001/04/29http://www.sqlservercentral.com/articles/Administering/20010423065956/94/This article shows you in a step-by-step manner how to restore the master database. http://www.sqlservercentral.com/articles/Administering/restoremaster/131/2001/04/29http://www.sqlservercentral.com/articles/Administering/restoremaster/131/The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA. http://www.sqlservercentral.com/articles/Administering/20010422115803/89/2001/04/25http://www.sqlservercentral.com/articles/Administering/20010422115803/89/The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA. http://www.sqlservercentral.com/articles/Administering/20010422115801/88/2001/04/24http://www.sqlservercentral.com/articles/Administering/20010422115801/88/The fourth part of Steve Jones's series on having SQL Server automatically report information to a DBA. http://www.sqlservercentral.com/articles/Administering/20010422115759/87/2001/04/22http://www.sqlservercentral.com/articles/Administering/20010422115759/87/The third part of Steve Jones's series on having SQL Server automatically report information to a DBA. http://www.sqlservercentral.com/articles/Administering/20010422115756/86/2001/04/20http://www.sqlservercentral.com/articles/Administering/20010422115756/86/