• Implementing Replication

    Implementing Replication

    Overview of Replication. Implementing Replication. Configuring Replication in Some Common Scenarios.

     20 p dtu 17/10/2012 56 1

  • Automating Administrative Tasks

    Automating Administrative Tasks

    Automating Administrative Tasks in SQL Server 2005. Configuring SQL Server Agent. Creating Jobs and Operators. Creating Alerts. Managing Multiple Servers. Managing SQL Server Agent Security.

     31 p dtu 17/10/2012 62 1

  • Transferring Data

    Transferring Data

    Overview of Data Transfer . Introduction to SQL Server Integration Services. Using SQL Server Integration Services. Features of SQL Server Integration Services.

     28 p dtu 17/10/2012 135 1

  • Monitoring SQL Server

    Monitoring SQL Server

    Viewing Current Activity. Using System Monitor. Using SQL Server Profiler. Using DDL Triggers. Using Event Notifications.

     27 p dtu 17/10/2012 158 1

  • Managing Security

    Managing Security

    Overview of SQL Server Security. Protecting the Server Scope. Protecting the Database Scope. Managing Keys and Certificates in SQL Server.

     30 p dtu 17/10/2012 153 1

  • Disaster Recovery

    Disaster Recovery

    Planning a Backup Strategy. Backing Up User Databases. Restoring User Databases. Performing Online Restore Operations. Recovering Data from Database Snapshots. System Databases and Disaster Recovery.

     39 p dtu 17/10/2012 135 1

  • Managing Databases and Files

    Managing Databases and Files

    How Is Data Stored? How the Transaction Log Works. Considerations for File Placement. What Are Filegroups? Considerations for Creating Filegroups. Considerations for Capacity Planning.

     22 p dtu 17/10/2012 158 1

  • Installing and Configuring SQL Server 2005

    Installing and Configuring SQL Server 2005

    Editions of SQL Server 2005. Hardware Requirements for SQL Server 2005. Software Requirements for SQL Server 2005. What Are Instances of SQL Server? Licensing Options for SQL Server 2005. Security Considerations for SQL Server Services. Collation Considerations for SQL Server 2005. Considerations for Upgrading to SQL Server 2005. Practice: Viewing Pre-Installation Information.

     28 p dtu 17/10/2012 281 1

  • Using Notification Services (Optional)

    Using Notification Services (Optional)

    What Is Notification Services? Notification Services Architecture. How Subscription Management Works. How Event Collection Works. How Notification Generation Works. How Notification Formatting and Delivery Work. Example of a Notification Services Application.

     24 p dtu 17/10/2012 175 1

  • Managing Transactions and Locks

    Managing Transactions and Locks

    Pessimistic: Locks data when data is read in preparation for an update. users are blocked until lock is released. Use where high contention for data exists. Optimistic: Locks data when an update is performed. Error received if data was changed since initial read. Use when low contention for data exists.

     24 p dtu 17/10/2012 175 1

  • Implementing Managed Code in the Database

    Implementing Managed Code in the Database

    Run managed code within a database by using in-process assemblies. Create managed stored procedures, triggers, user-defined functions, user-defined types, and aggregates. Run managed code within a database by using in-process assemblies. Create managed stored procedures, triggers, user-defined functions, user-defined types, and aggregates.

     17 p dtu 17/10/2012 186 1

  • Creating and Tuning Indexes

    Creating and Tuning Indexes

    An index is a collection of pages associated with a table (or view) used to speed retrieval of rows from the table or enforce uniqueness. For example, without an index, you would have to go through an entire textbook one page at a time to find information about a topic. Microsoft® SQL Server™ 2005 uses indexes to point to the location of a row on a data page instead of having to look through all the data pages of a table. An index...

     42 p dtu 17/10/2012 219 1

Hướng dẫn khai thác thư viện số

Thống Kê

getDocumentFilter3 p_strSchoolCode=dtu