Instances & Storage Considerations

SQL Server 2016

17 Videos | 1h 44m 35s
Includes Assessment
Earns a Badge

SQL Server uses instances to allow more than one copy of a SQL Server component to be installed on a single server. Explore SQL Server instances in IaaS and on-premises, and the various storage solutions in SQL Server 2016.

WHAT YOU WILL LEARN

describe SQL Server instances

explain how to host a SQL Server instance using Azure VMs

recognize the benefits of using Azure automation

explain how and when to use Azure resource manager

demonstrate how to deploy SQL Server using templates

provide an introduction to data storage with SQL Server

discuss considerations when planning disk storage devices

explain the different types of RAID configurations

differentiate between the five SQL Server system databases
demonstrate how to create user databases in SQL Server 2016

explain the use of filegroups in SQL Server 2016

describe how SQL Server uses the buffer pool extension

demonstrate how to configure the storage buffer pool extension

explain how storage spaces can be used in SQL Server 2016

describe storage layout considerations when using virtual machines

describe other possible storage solutions, including NAS, DAS, and SAN

determine effective disk or storage configuration for a given scenario

IN THIS COURSE

1.

SQL Server Instances Overview

5m 36s

UP NEXT
2.

Hosting a SQL Server Instance Using Azure VMs

7m 36s
3.

Azure Automation

3m 41s

FREE ACCESS
4.

Azure Resource Manager

4m 23s

FREE ACCESS
5.

Deploying SQL Server by Using Templates

5m 25s

FREE ACCESS
6.

Data Storage Overview

9m 49s

FREE ACCESS
7.

Storage Considerations

6m 30s

FREE ACCESS
8.

Implementing RAID Levels

8m 52s

FREE ACCESS
9.

SQL Server System Databases

5m 40s

FREE ACCESS
10.

Creating User Databases

6m 13s

FREE ACCESS
11.

Filegroups

6m 31s

FREE ACCESS
12.

Buffer Pool Extension

3m 23s

FREE ACCESS
13.

Configuring the Buffer Pool Extension

6m 52s

FREE ACCESS
14.

Storage Spaces

2m 55s

FREE ACCESS
15.

Storage Layouts for a SQL Server Virtual Machine

4m 9s

FREE ACCESS
16.

Other Storage Options

5m 21s

FREE ACCESS
17.

Exercise: Determining Storage Configuration

3m 40s

FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.