| Installing and
Configuring SQL Server 2000 |
| Install SQL Server 2000.
Considerations include clustering, default collation, file
locations, number of instances, and service accounts. |
Upgrade to SQL Server
2000.
- Perform a custom upgrade.
- Upgrade to SQL Server 2000 from SQL Server 6.5.
- Upgrade to SQL Server 2000 from SQL Server 7.0.
|
| Create a linked server. |
| Configure SQL Mail and
SQLAgentMail. |
| Configure network
libraries. |
| Troubleshoot failed
installations. |
| Creating SQL Server
2000 Databases |
| Configure database
options for performance. Considerations include capacity,
network connectivity, physical drive configurations, and
storage locations. |
| Attach and detach
databases. |
Create and alter
databases.
- Add filegroups.
- Configure filegroup usage.
- Expand and shrink a database.
- Set database options by using the ALTER DATABASE or
CREATE DATABASE statements.
- Size and place the transaction log.
|
| Create and manage
objects. Objects include constraints, indexes, stored
procedures, triggers, and views. |
| Managing, Monitoring,
and Troubleshooting SQL Server 2000 Databases |
| Optimize database
performance. Considerations include indexing, locking, and
recompiling. |
Optimize data storage.
- Optimize files and filegroups.
- Manage database fragmentation.
|
| Modify the database
schema. |
Perform disaster recovery
operations.
- Perform backups.
- Recover the system state and restore data.
- Configure, maintain, and troubleshoot log shipping.
|
| Perform integrity checks.
Methods include configuring the Database Maintenance Plan
Wizard and using the Database Consistency Checker (DBCC). |
| Troubleshoot transactions
and locking by using SQL Profiler, SQL Server Enterprise
Manager, or Transact-SQL. |
| Extracting and
Transforming Data with SQL Server 2000 |
| Set up IIS virtual
directories to support XML. |
| Import and export data.
Methods include the Bulk Insert task, the bulk copy program,
Data Transformation Services (DTS), and heterogeneous
queries. |
| Develop and manage DTS
packages. |
Manage linked servers.
- Manage OLE DB Providers.
- Configure security mapping.
|
| Convert data types. |
| Configure, maintain, and
troubleshoot replication services. |
| Managing and Monitoring
SQL Server 2000 Security |
| Configure mixed security
modes or Windows Authentication. Considerations include
client connectivity, client operating system, and security
infrastructure. |
| Create and manage log ons. |
| Create and manage
database users. |
Create and manage
security roles. Roles include application, database, and
server.
- Add and remove users from roles.
- Create roles to manage database security.
|
| Enforce and manage
security by using stored procedures, triggers, views, and
user-defined functions. |
| Set permissions in a
database. Considerations include object permissions, object
ownership, and statement permissions. |
| Manage security auditing.
Methods include SQL Profiler and C2 auditing. |
| Managing, Monitoring,
and Troubleshooting SQL Server 2000 |
| Create, manage, and
troubleshoot SQL Server Agent jobs. |
| Configure alerts and
operators by using SQL Server Agent. |
Optimize hardware
resource usage. Resources include CPU, disk I/O, and memory.
- Monitor hardware resource usage by using System
Monitor.
- Resolve system bottlenecks by using System Monitor.
|
Optimize and troubleshoot
SQL Server system activity. Activities include cache hits,
connections, locks, memory allocation, recompilation, and
transactional throughput.
- Monitor SQL Server system activity by using traces.
- Monitor SQL Server system activity by using System
Monitor.
|