SQL Server Administration Part 1/2/3合集

SQL Server Administration Part 1/2/3合集

SQL Server Administration Part 1

What is a Domain

07:12

Software to download and install

08:03

POST ADDENDUM

08:11

APPS NEEDED

07:34

CREATE VM

18:22

INSTALL SQL SERVER 2017

09:43

ADVENTUREWORKS 2017 DB

08:13

COMPARISON OF SQL 2014 VS 2017

02:38

Create Virtual Machine Domain Controller

06:00

Promote Domain Controller to Active Directory

15:06

Create Vm for SQL Server 2012 Install Part1

10:29

Create Vm for SQL Server 2012 Install Part 2

13:46

Install SQL On Separate Drive with Service Accounts Part 1

11:13

Install SQL On Separate Drive with Service Accounts Part 2

13:23

Installing Service Packs and Fixes SP2

09:20

Touring SQL Server Management Studio

10:28

Introduction to System Databases

13:32

SQL Server Data and Log Files

08:21

Detail Transaction log ATM Example

07:35

Auto Growth and sizing of transaction log

16:11

Types of Recovery Models

12:15

Function fn_dblog to view inside a transaction log

07:18

What is virtual log file VLF

11:22

Create a SQL database

14:06

The importance of Tempdb

13:24

Attach and detach a database

08:28

Introduction to Backups

13:45

Full Database Backup

10:59

Transactional Log Backups

10:56

Differential Backups

08:16

Introduction to Restore

05:19

Restore database with GUI

11:39

Restore database using differential

09:11

Recovery mode with tail log backup

11:56

Backup using Maintenance plan

11:11

Backup database using Maintenance plan

10:33

Maintenance Plan Tasks

05:45

Don’t shrink a database

15:43

The importance of using SQL Server Agent

07:58

Create a simple backup job using SQL Server Agent

05:20

The importance of DBCC CheckDB

09:38

Using SQL Server Agent with multiple steps

05:59

Setting up SQL Database Mail

10:58

Setting up SQL Database Mail Part2

05:16

Setting up alerts Severity Errors from 17 to 25

14:23

Central Management with SQL Server Agent

00:52

Central Management with SQL Server Agent

12:21

Installing free VMware Pro Player for virtualization

17:44

Introduction to SQL Server Security

13:44

Demonstration of Users Logins Roles

11:43

Managing security with T SQL

06:27

Selecting Authentication or Mixed Mode security

13:19

Accessing SQL Server using SQL Login

12:46

Understanding SQL Server Roles

11:45

Managing SQL Server Roles via TSQL

05:57

SQL Server Roles Demonstration

12:59

Managing SQL Server Permissions

14:38

Best SQL Server Practice Security

13:22

SQL ADMINISTRATION PART 2 TABLE OF CONTENT

00:53

SQL Server Administration Part 2

Introduction

06:28

Install SQL Server 214

14:40

Install SQL Suite

11:20

POST ADDENDUM

08:11

APPS NEEDED

07:34

CREATE VM

18:22

INSTALL SQL SERVER 2017

09:43

ADVENTUREWORKS 2017 DB

08:13

COMPARISON SQL SERVER 2014 VS 2017

02:38

Clustered Index

16:59

Create non cluster index

12:07

Composite Index

18:06

Use or not use indexes

11:20

Deciding factors in creating indexes

20:09

using sql profler for indexes

19:41

Reorganize and Rebuild Indexes

15:47

Into To SQL Profiler

17:57

SQL Profiler longest running query

13:37

Audit logins

12:11

SQL Profile with Index Tuning

10:40

SQL Profiler Best Practice

05:24

SQL Server Side Trace

16:31

Database Engine Tuning Advisor

12:10

Statistics

11:44

Activity Monitor

14:01

SQL Performance Monitor

16:24

SQL Performance hardware issues

12:49

SQL Performance Monitoring Hardware CPU

16:47

SQL Performance Monitoring Hardware memory

10:10

SQL Performance Monitoring Hardware disks

08:46

23 SQL Perfmon scehdule

08:51

DMV

13:53

Block and Locks

13:15

BLOCKING

10:45

Deadlock

04:45

Extended Events

18:20

Extended Events via TSQL

11:59

Database Snapshots

15:12

Import Export Data

10:01

BCP

12:59

Partition

19:51

Partition part 2

19:51

Partition 3

12:46

Contained datababase Part 1

11:47

Contained datababase Part 2

10:12

Policy Based Management

18:46

Linked Servers

08:20

SQL server and agent logs

05:24

SQL ADMINISTRATION PART 3

05:32

SQL Server Administration Part 3

Getting A SQL DBA Job

06:35

VMware Workstation 12 and Domain Controller Part 1

19:59

POST ADDENDUM

08:11

APPS NEEDED

07:34

CREATE VM

18:22

INSTALL SQL SERVER 2017

09:43

ADVENTUREWORKS 2017 DB

08:13

COMPARISON SQL 2014 VS 2017

02:38

VMware Workstation 12 and Domain Controller Part 2

19:50

Server1 installation part 1

11:15

Server1 installation part 2

09:34

Server 2 installation part 1

13:35

Server 2 installation part 2

13:25

Server 2 installation part 3

15:00

Server 2 installation part 4

15:34

Log Shipping Part 1

15:33

Log Shipping Part 2

18:32

Log Shipping Part 3

17:06

Log shipping Manual Failover part 1

12:11

Log shipping Manual Failover part 2

10:48

Orphans

18:29

Monitoring Log Shipping

14:16

Database Mirroring

18:43

Database Mirroring using GUI part 1

12:31

Database Mirroring using GUI part 2

13:11

Database Mirroring Monitoring part 1

12:40

Database Mirroring Monitoring part 2

09:55

Replication

12:43

Transactional Replication part 1

11:15

Transactional Replication part 2

12:35

Peer to Peer Replication part 1

11:14

Peer to Peer Replication part 2

12:44

Always On

17:19

Always On Requisite part 1

09:53

Always On Requisite part 2

12:16

Always On Setup Cluster

14:40

Always On Demo part 1

14:50

Always On Demo part 2

18:15

Backup Replicas

13:23