| 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.
|
