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