Instances & Storage Considerations

SQL Server 2016    |    Intermediate
  • 17 Videos | 1h 36m 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 Microsoft Azure Fundamentals: Databases & Data Analytics
Likes 229 Likes 229  
BOOK SQL Server Big Data Clusters: Data Virtualization, Data Lake, and AI Platform, Second Edition
COURSE AWS SysOps Associate: AWS SQL Solutions
Likes 14 Likes 14  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Data Access & Permissions
Likes 110 Likes 110  
COURSE Installation & Configuration
Likes 36 Likes 36  
COURSE Monitoring Queries
Likes 43 Likes 43