Instances & Storage Considerations
SQL Server 2016
| Intermediate
- 17 Videos | 1h 36m 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 instancesexplain how to host a SQL Server instance using Azure VMsrecognize the benefits of using Azure automationexplain how and when to use Azure resource managerdemonstrate how to deploy SQL Server using templatesprovide an introduction to data storage with SQL Serverdiscuss considerations when planning disk storage devicesexplain the different types of RAID configurationsdifferentiate between the five SQL Server system databases
-
demonstrate how to create user databases in SQL Server 2016explain the use of filegroups in SQL Server 2016describe how SQL Server uses the buffer pool extensiondemonstrate how to configure the storage buffer pool extensionexplain how storage spaces can be used in SQL Server 2016describe storage layout considerations when using virtual machinesdescribe other possible storage solutions, including NAS, DAS, and SANdetermine effective disk or storage configuration for a given scenario
IN THIS COURSE
-
1.SQL Server Instances Overview5m 36sUP NEXT
-
2.Hosting a SQL Server Instance Using Azure VMs7m 36s
-
3.Azure Automation3m 41s
-
4.Azure Resource Manager4m 23s
-
5.Deploying SQL Server by Using Templates5m 25s
-
6.Data Storage Overview9m 49s
-
7.Storage Considerations6m 30s
-
8.Implementing RAID Levels8m 52s
-
9.SQL Server System Databases5m 40s
-
10.Creating User Databases6m 13s
-
11.Filegroups6m 31s
-
12.Buffer Pool Extension3m 23s
-
13.Configuring the Buffer Pool Extension6m 52s
-
14.Storage Spaces2m 55s
-
15.Storage Layouts for a SQL Server Virtual Machine4m 9s
-
16.Other Storage Options5m 21s
-
17.Exercise: Determining Storage Configuration3m 40s
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.