Questo elenco nasce da un giro di email sui ns canali interni. Alla fine i suggerimenti non sono 10, ma è un elenco troppo interessante per non essere pubblicato.
In ordine sparso....
Create a framework for change control
Understand the SQL/Windows security model
Set up backups
Get a performance baseline
Secure the server (starting with the SA password)
Read BOL, get some reference books, join some list servers or newsgroups
Don't panic when you see SQL's memory usage increasing - 321363 INF: SQL Server Memory Usage
Understand the needs of the business/users/programmers
Set up other maintenance such as upd stats, defrag, etc.
Disaster Recovery:
325257 Support WebCast: SQL Server 2000 Database Recovery: Backup and Restore http://support.microsoft.com/?id=325257
Designing a Backup and Restore Strategy, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_63eh.asp
SQL Server 2000 Operations Guide, http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx
307775 INF: Disaster Recovery Articles for Microsoft SQL Server http://support.microsoft.com/?id=307775
321836 HOW TO: Retrieve a Table or Rows from Database or Transaction Log Backups http://support.microsoft.com/?id=321836
Performance References:
Inside SQL Server 2000/7.0 by Kalen Delaney, http://www.insidesqlserver.com
The Guru's Guide to Transact-SQL, http://www.khen.com/books.htm
SQL Server Performance and Scalability References, http://www.microsoft.com/sql/evaluation/compare/performance.asp
Understanding Performance Testing, http://msdn.microsoft.com/library/techart/d5dplyover.htmhttp://msdn.microsoft.com/library/techart/d5dplyover.htm
224587 INF: Troubleshooting Application Performance with SQL Server http://support.microsoft.com/?id=224587
243586 INF: Troubleshooting Stored Procedure Recompilation http://support.microsoft.com/?id=243586
298475 INF: Information Required to Successfully Troubleshoot Application http://support.microsoft.com/?id=298475http://support.microsoft.com/?id=298475
175658 How To Gather Information for Effective Troubleshooting of Performance http://support.microsoft.com/?id=175658
319942 HOW TO: Determine Proper SQL Server Configuration Settings http://support.microsoft.com/?id=319942
297864 INF: Performance Considerations for an Upgrade from SQL Server 6.5 http://support.microsoft.com/?id=297864
314648 INF: Differences in STATISTICS IO, SQL Profiler and Sysprocesses IO http://support.microsoft.com/?id=314648
311826 INF: Index Tuning Wizard Best Practices http://support.microsoft.com/?id=311826
Index Tuning Wizard 2000, http://msdn.microsoft.com/library/techart/itwforsql.htm
Index Tuning Wizard 7.0, http://msdn.microsoft.com/library/techart/msdn_sqlindex.htm
Troubleshooting the Index Tuning Wizard, http://msdn.microsoft.com/library/psdk/sql/tr_servtools_48ro.htm
195565 INF: How SQL Server 7.0 and SQL Server 2000 Autostats Work http://support.microsoft.com/?id=195565
197297 INF: Comparison of Join Techniques http://support.microsoft.com/?id=197297
150934 How to Create a Performance Monitor Log for NT Troubleshooting <http://support.microsoft.com/?id=150934HYPERLINK "http://support.microsoft.com/?id=150934197297"http://support.microsoft.com/?id=150934>
248345 How to Create a Log Using System Monitor in Windows 2000 http://support.microsoft.com/?id=248345 275685 INF: Importing Performance Monitor Logs into SQL Server http://support.microsoft.com/?id=275685
Security:
Security Resources http://www.microsoft.com/sql/techinfo/administration/2000/security/default.asp
10 Steps to Help Secure SQL Server 2000 http://www.microsoft.com/sql/techinfo/administration/2000/security/securingsqlserver.asp
322712 Microsoft SQL Server 2000 SP3 Security Features and Best Practices http://support.microsoft.com/?id=322712
SQL Server 2000 Administrator's Pocket Consultant: SQL Server 2000 Security http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c05ppcsq.mspxhttp://www.microsoft.com/technet/prodtechnol/sql/2000/books/c05ppcsq.mspx
813944 SQL Server 2000 Security Tools http://support.microsoft.com/?id=813944
309422 INF: Consideration for a Virus Scanner on a Computer That Is Running SQL http://support.microsoft.com/?id=309422
829024 INFO: Microsoft SQL Server 2000 Operations Guide http://support.microsoft.com/?id=829024
SQL Server 2000 C2 Administrator's and User's Security Guide http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlc2.mspx
SQL Server 2000 Resource Kit, Chapter 10--Implementing Security http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1061.mspx
817384 HOWTO: Use Kerberos Authentication for Microsoft SQL Server 2000 http://support.microsoft.com/?id=817384
Download the latest version of books online: (303839 Updates to SQL Server Books Online for SQL Server 2000 http://support.microsoft.com/?id=303839). Sample topics from SQL Server 7.0/2000 Books Online (BOL): Managing Security, Planning Security, Security Architecture, Security Audit Event Classes, Password Protection, Authentication Modes, Replication Security, Security and Authentication Permissions