 |
 |
 |
|
"An excellent class! The right level of detail at the right time. I now fully understand everything that, heretofore, I've muddled through in my application development activities at work."
"It was fantastic! Best class I've ever gone to and I've attended my share with other training companies."
"Jim is excellent at maintaining class attention throughout the highly informative sessions."
|
|
|
 |
|
 |
|
 |
 |
 |
|
|
|
SS2400: Administering SQL Server 2008
|
|
|
Registration: Click here to register for this class.
Duration: 3 days
Prerequisites:The person taking this course should have some knowledge of database systems including relational database design. It is also advisable that they have some prior working knowledge of SQL Server, or have taken our SS2300: Implementing SQL Server course.
In this hands-on, instructor-led course attendees will learn to administer a SQL Server 2008 database. They learn how to configure and monitor the server for optimum performance, perform replication, and create a strategy for security. You will also learn to use some of the maintenance wizards that can make administration of the system much easier.
Installation of SQL Server
Walk through of the installation options
Which options are critical during installation
Upgrading from a previous version of SQL Server
Multiple Instances of SQL Server
SQL Server Configuration Options
The different server configuration options
Which options effect performance
Which options are automatic
Security in SQL Server
Logins
Roles
Users
Mapping to NT accounts
Setting permissions on tables
Setting permissions on objects
Views and Security
Stored Procedures and Security
Operators, Jobs, Alerts and Mail
Creating Operators
Creating Jobs
Creating Alerts
Responding to Events
Configuring SQL-Mail
Backup and Restore
Planning and Maintenance issues
Performing a backup
Restoring a database
The Database Consistency Checker
How to run DBCC
Which options are important
Error Logs
Where error logs are stored
How to read the error logs
What is important and what it not
Replication
What is Replication
When to use Replication
Implementing Replication
Replicating to an Access database
Monitoring the Server
Using Performance Monitor
Monitoring activity with the SQL Server Profiler
Monitoring current activities
Transfer SQL Server Objects
Transferring a database from one server to another
Detaching a database
Reattaching a database
Database Scripting
What are database scripts
How to generate scripts
Loading and running scripts
Database Maintenance Plan Wizard
Setting up a database maintenance plan
Running the wizard
Viewing the scheduled jobs
Using The Web Assistant
What is the Web Assistant
How to use it
Viewing the output |
|
|
 |
|
 |
|
|