Instances & Storage Considerations

SQL Server 2016    |    Intermediate
  • 17 Videos | 1h 44m 35s
  • Includes Assessment
  • Earns a Badge
Likes 46 Likes 46
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
    FREE ACCESS
  • Locked
    4. 
    Azure Resource Manager
    4m 23s
    FREE ACCESS
  • Locked
    5. 
    Deploying SQL Server by Using Templates
    5m 25s
    FREE ACCESS
  • Locked
    6. 
    Data Storage Overview
    9m 49s
    FREE ACCESS
  • Locked
    7. 
    Storage Considerations
    6m 30s
    FREE ACCESS
  • Locked
    8. 
    Implementing RAID Levels
    8m 52s
    FREE ACCESS
  • Locked
    9. 
    SQL Server System Databases
    5m 40s
    FREE ACCESS
  • Locked
    10. 
    Creating User Databases
    6m 13s
    FREE ACCESS
  • Locked
    11. 
    Filegroups
    6m 31s
    FREE ACCESS
  • Locked
    12. 
    Buffer Pool Extension
    3m 23s
    FREE ACCESS
  • Locked
    13. 
    Configuring the Buffer Pool Extension
    6m 52s
    FREE ACCESS
  • Locked
    14. 
    Storage Spaces
    2m 55s
    FREE ACCESS
  • Locked
    15. 
    Storage Layouts for a SQL Server Virtual Machine
    4m 9s
    FREE ACCESS
  • Locked
    16. 
    Other Storage Options
    5m 21s
    FREE ACCESS
  • Locked
    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.

YOU MIGHT ALSO LIKE

COURSE AWS SysOps Associate 2021: Database & EBS Volume Management
Likes 5 Likes 5  
BOOK SQL Server 2019 AlwaysOn: Supporting 24x7 Applications with Continuous Uptime, Third Edition
COURSE AWS SysOps Associate: AWS NoSQL & Data Warehousing

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Data Security & Azure SQL Database Options
Likes 49 Likes 49  
COURSE Architecture
Likes 17 Likes 17  
COURSE Log Shipping & High Availability
Likes 34 Likes 34