Instances & Storage Considerations

SQL Server 2016
  • 17 Videos | 1h 44m 35s
  • Includes Assessment
  • Earns a Badge
Likes 24 Likes 24
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

  • Playable
    1. 
    SQL Server Instances Overview
    5m 36s
    UP NEXT
  • Playable
    2. 
    Hosting a SQL Server Instance Using Azure VMs
    7m 36s
  • Locked
    3. 
    Azure Automation
    3m 41s
  • Locked
    4. 
    Azure Resource Manager
    4m 23s
  • Locked
    5. 
    Deploying SQL Server by Using Templates
    5m 25s
  • Locked
    6. 
    Data Storage Overview
    9m 49s
  • Locked
    7. 
    Storage Considerations
    6m 30s
  • Locked
    8. 
    Implementing RAID Levels
    8m 52s
  • Locked
    9. 
    SQL Server System Databases
    5m 40s
  • Locked
    10. 
    Creating User Databases
    6m 13s
  • Locked
    11. 
    Filegroups
    6m 31s
  • Locked
    12. 
    Buffer Pool Extension
    3m 23s
  • Locked
    13. 
    Configuring the Buffer Pool Extension
    6m 52s
  • Locked
    14. 
    Storage Spaces
    2m 55s
  • Locked
    15. 
    Storage Layouts for a SQL Server Virtual Machine
    4m 9s
  • Locked
    16. 
    Other Storage Options
    5m 21s
  • Locked
    17. 
    Exercise: Determining Storage Configuration
    3m 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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 16 Likes 16  
Likes 27 Likes 27  
COURSE Encryption
Likes 69 Likes 69