Books & Videos

Table of Contents

Chapter: Introduction

What Is Exam 70-462?

02m 20s

What You Should Expect From The Videos

03m 54s

Chapter: Installation And Configuration

Growing And Shrinking Databases

09m 49s

Monitoring Database Growth

07m 35s

Designing Database Storage

10m 23s

Configure An SQL Server Standby Server - Part 1

13m 52s

Configure An SQL Server Standby Server - Part 2

07m 6s

Changing Service Accounts

13m 12s

Testing Database Connectivity

10m 8s

Installing SQL Server Database Engine - Part 1

11m 37s

Installing SQL Server Database Engine - Part 2

11m 35s

Installing SQL Server Database Engine - Part 3

08m 52s

Installing SQL Server Database Engine - Part 4

05m 0s

Installing SQL Server Integration Services

07m 2s

Enabling And Disabling Features

07m 21s

Moving Databases Via Detach/Attach

07m 46s

Migrating Logins

06m 30s

Creating A Full Text Index

05m 13s

Configuring FILESTREAM

01m 29s

Configuring FILETABLE

01m 33s

Create And Manage SQL Agent Jobs - Part 1

09m 22s

Create And Manage SQL Agent Jobs - Part 2

04m 30s

Setup Multi-Server Jobs

07m 0s

Chapter: Maintain Instances And Databases

Using Multiple Files And Filegroups

07m 57s

Recovery Models

06m 7s

Adding New Filegroups

02m 24s

Moving Tables Between Filegroups

06m 5s

Enabling Contained Databases

04m 57s

Data Compression

10m 20s

Configuring TDE

06m 51s

Setting Up Table Partitioning - Part 1

09m 15s

Setting Up Table Partitioning - Part 2

10m 20s

Managing Log File Growth - Part 1

08m 32s

Managing Log File Growth - Part 2

02m 13s

DBCC CHECKDB

09m 10s

Installing Default And Named Instances - Part 1

07m 48s

Installing Default And Named Instances - Part 2

05m 42s

CPU Affinity

05m 26s

Instance Level Settings - Part 1

09m 13s

Instance Level Settings - Part 2

09m 2s

Instance Level Settings - Part 3

10m 51s

Memory Settings

05m 17s

Database Mail

08m 40s

Fillfactor

06m 44s

Installing A Clustered Instance - Part 1

07m 58s

Installing A Clustered Instance - Part 2

08m 38s

Installing A Clustered Instance - Part 3

09m 19s

Installing A Clustered Instance - Part 4

01m 48s

Multi-Instance Clustering

03m 56s

Multi-Subnet Clustering

04m 27s

Recover From A Failed Cluster Node

04m 5s

Chapter: Optimization And Troubleshooting

Replication For Reporting - Part 1

08m 22s

Replication For Reporting - Part 2

11m 54s

Replication For Reporting - Part 3

12m 23s

Replication For Reporting - Part 4

07m 36s

Diagnosing Locking And Blocking - Part 1

08m 52s

Diagnosing Locking And Blocking - Part 2

06m 14s

Diagnosing Wait Stats

11m 29s

Using SQL Profiler

10m 15s

Using Performance Monitor - Part 1

07m 33s

Using Performance Monitor - Part 2

05m 29s

Using Extended Events

08m 24s

Using SQL Server Auditing

08m 14s

Using Data Collector

05m 21s

Using Policy Based Management

06m 53s

Chapter: Manage Data

Define Recovery Models

04m 4s

Mirrored Backups

01m 39s

Stripped Backups

02m 39s

Restoring Full Backups

04m 16s

Restoring Differential Backups

05m 41s

Restoring Transaction Log Backups

04m 15s

File Group Restores

04m 11s

Testing Backups

02m 32s

Restoring Master Database

05m 23s

Restoring msdb Database

00m 48s

Restoring model Database

00m 32s

Restoring Databases Protected By TDE

03m 49s

Restoring A Single Database Page

02m 12s

Point In Time Restores

05m 33s

Index Maintenance

10m 22s

Identifying Index Fragmentation

04m 34s

Identifying Unused Indexes

06m 32s

Filtered Indexes

03m 23s

Updating Statistics

03m 38s

Full Text Indexes

15m 9s

Column Store Indexes

07m 51s

Import Export Wizard

05m 54s

BCP

08m 31s

Bulk Insert

03m 35s

Chapter: Implement Security

Logins Vs. Users

02m 57s

Creating Logins

05m 54s

Fixed Server Roles

05m 47s

User Defined Server Roles

04m 11s

Certificate Logins

02m 18s

Instance Level Permissions

03m 15s

Database Level Permissions

05m 13s

Fixed Database Roles

05m 43s

User Defined Database Roles

02m 49s

Application Roles

04m 15s

Creating Database Users

06m 6s

Managing Certificates

02m 18s

Endpoint Security

03m 35s

Chapter: Implement High Availability

Configure Database Mirroring

10m 54s

Configure AlwaysOn Availability Groups - Part 1

10m 33s

Configure AlwaysOn Availability Groups - Part 2

07m 58s

Failing Over Database Mirroring

02m 37s

Failing Over AlwaysOn Availability Groups

07m 54s

Monitoring Database Mirroring

04m 36s

Chapter: Conclusion

About The Author

01m 21s

Thank You

04m 0s