Use the performance and reliability monitoring tools - SQL Server Tutorial

Contents

• Introduction Introduction

  • Introduction

    2m 42s
• Lesson 1: Installing and Using SQL Server Administration and Development Tools Lesson 1: Installing and Using SQL Server Administration and Development Tools

  • Module 1 introduction

    24s
  • (Locked)
    Learning objectives

    39s
  • (Locked)
    Understand the installation center

    5m 58s
  • (Locked)
    Find the tools installed with the SQL Server

    8m 19s
  • (Locked)
    Use the performance and reliability monitoring tools

    19m 42s
  • (Locked)
    Understand SQL Server Management Studio

    8m 13s
• Lesson 2: Introducing Database Server Components Lesson 2: Introducing Database Server Components

  • Learning objectives

    33s
  • (Locked)
    Configure server memory

    8m 43s
  • (Locked)
    Setup database files

    15m 36s
  • (Locked)
    Configure network settings

    17m 10s
  • (Locked)
    Setup SQL Server security

    13m 9s
• Lesson 3: Provisioning SQL Server SQL Databases Lesson 3: Provisioning SQL Server SQL Databases

  • Module 2 introduction

    21s
  • (Locked)
    Learning objectives

    35s
  • (Locked)
    Install a new instance

    19m 39s
  • (Locked)
    Make post-installation server configuration changes

    17m 17s
  • (Locked)
    Install and configure database features

    20m 33s
  • (Locked)
    Create SQL Server databases

    12m 28s
• Lesson 4: Provisioning Azure SQL Database Lesson 4: Provisioning Azure SQL Database

  • Learning objectives

    40s
  • (Locked)
    Understand Microsoft Azure and database-as-a-service concepts

    8m 13s
  • (Locked)
    Provision a logical SQL Server

    14m 10s
  • (Locked)
    Provision a database

    11m 15s
  • (Locked)
    Setup security in Azure SQL databases

    11m 45s
• Lesson 5: Implementing and Managing SQL Server User Security and Permissions Lesson 5: Implementing and Managing SQL Server User Security and Permissions

  • Module 3 introduction

    21s
  • (Locked)
    Learning objectives

    47s
  • (Locked)
    Understand logins and users

    11m 11s
  • (Locked)
    Setup permissions in SQL Server

    34m 19s
  • (Locked)
    Migrate SQL Server logins and permissions

    12m 39s
• Lesson 6: Securing the Server and Data Lesson 6: Securing the Server and Data

  • (Locked)
    Learning objectives

    41s
  • Handle encryption in SQL Server

    10m 20s
  • (Locked)
    Setup row level security

    11m 34s
  • (Locked)
    Understand data masking

    8m 24s
  • (Locked)
    Configure SQL Server audits

    12m 49s
• Lesson 7: Understanding and Designing SQL Server Tables Lesson 7: Understanding and Designing SQL Server Tables

  • Module 4 introduction

    25s
  • (Locked)
    Learning objectives

    37s
  • (Locked)
    Review table design

    12m 38s
  • (Locked)
    Understand special table types

    7m 23s
  • (Locked)
    Create views

    12m 6s
  • (Locked)
    Use change tracking

    12m 2s
  • (Locked)
    Understand change data capture

    10m 44s
• Lesson 8: Performance Tuning and Optimizing SQL Lesson 8: Performance Tuning and Optimizing SQL

  • (Locked)
    Learning objectives

    39s
  • (Locked)
    Understand isolation levels

    24m 53s
  • (Locked)
    Use execution plans

    10m 37s
  • (Locked)
    Configure clustered indexes

    17m 35s
  • (Locked)
    Configure non-clustered indexes

    23m 46s
  • (Locked)
    Use index statistics

    10m 2s
• Lesson 9: Developing, Deploying, and Managing Data Recovery Lesson 9: Developing, Deploying, and Managing Data Recovery

  • (Locked)
    Module 5 introduction

    31s
  • (Locked)
    Learning objectives

    53s
  • (Locked)
    Understand data recovery fundamentals

    2m 18s
  • (Locked)
    Understand backup devices

    6m 27s
  • (Locked)
    Understand different types of backups

    10m 41s
  • (Locked)
    Create and verify backups

    21m 51s
  • (Locked)
    Restore a database

    18m 31s
  • (Locked)
    Define a backup and recovery strategy

    11m 1s
• Lesson 10: Implementing SQL Server High Availability and Disaster Recovery Lesson 10: Implementing SQL Server High Availability and Disaster Recovery

  • (Locked)
    Learning objectives

    46s
  • (Locked)
    Review high availability and disaster recovery technologies

    4m 43s
  • (Locked)
    Setup SQL Server Log shipping

    27m 3s
  • (Locked)
    Replication for high availability

    35m 43s
  • (Locked)
    Read secondary database copies

    10m 3s
• Lesson 11: Managing and Monitoring SQL Server Databases Lesson 11: Managing and Monitoring SQL Server Databases

  • (Locked)
    Module 6 Introduction

    28s
  • (Locked)
    Learning objectives

    40s
  • (Locked)
    Schedule and monitor database backups

    12m 7s
  • (Locked)
    Deal with database corruption

    4m 9s
  • (Locked)
    Setup index maintenance

    14m 51s
  • (Locked)
    Cleanup history

    8m 38s
  • (Locked)
    Shrink databases

    11m 36s
  • (Locked)
    Monitor database activity

    9m 44s
  • (Locked)
    Use performance monitor

    5m 57s
  • (Locked)
    Monitor database logs

    5m 8s
  • (Locked)
    Use resource governor

    10m 37s
• Lesson 12: Automating SQL Server Administration Lesson 12: Automating SQL Server Administration

  • (Locked)
    Learning objectives

    38s
  • (Locked)
    Understand the components of SQL Server automated administration

    20m 26s
  • (Locked)
    Setup database maintenance plans

    14m 56s
  • (Locked)
    Use PowerShell to automate SQL Server administration

    5m
• Summary Summary

  • (Locked)
    Summary

    2m 26s