Top Ten DBA task

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
Designing a Backup and Restore Strategy,
SQL Server 2000 Operations Guide,
307775 INF: Disaster Recovery Articles for Microsoft SQL Server
321836 HOW TO: Retrieve a Table or Rows from Database or Transaction Log Backups

Performance References:
Inside SQL Server 2000/7.0 by Kalen Delaney,
The Guru's Guide to Transact-SQL,
SQL Server Performance and Scalability References,
Understanding Performance Testing,
224587 INF: Troubleshooting Application Performance with SQL Server
243586 INF: Troubleshooting Stored Procedure Recompilation
298475 INF: Information Required to Successfully Troubleshoot Application
175658 How To Gather Information for Effective Troubleshooting of Performance
319942 HOW TO: Determine Proper SQL Server Configuration Settings
297864 INF: Performance Considerations for an Upgrade from SQL Server 6.5
314648 INF: Differences in STATISTICS IO, SQL Profiler and Sysprocesses IO
311826 INF: Index Tuning Wizard Best Practices
Index Tuning Wizard 2000,
Index Tuning Wizard 7.0,
Troubleshooting the Index Tuning Wizard,
195565 INF: How SQL Server 7.0 and SQL Server 2000 Autostats Work
197297 INF: Comparison of Join Techniques
150934 How to Create a Performance Monitor Log for NT Troubleshooting < "">
248345 How to Create a Log Using System Monitor in Windows 2000 275685 INF: Importing Performance Monitor Logs into SQL Server

Security Resources
10 Steps to Help Secure SQL Server 2000
322712 Microsoft SQL Server 2000 SP3 Security Features and Best Practices
SQL Server 2000 Administrator's Pocket Consultant: SQL Server 2000 Security
813944 SQL Server 2000 Security Tools
309422 INF: Consideration for a Virus Scanner on a Computer That Is Running SQL
829024 INFO: Microsoft SQL Server 2000 Operations Guide
SQL Server 2000 C2 Administrator's and User's Security Guide
SQL Server 2000 Resource Kit, Chapter 10--Implementing Security
817384 HOWTO: Use Kerberos Authentication for Microsoft SQL Server 2000
Download the latest version of books online: (303839 Updates to SQL Server Books Online for SQL Server 2000 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