Chapter 3 Manage Storage

Managing storage and performing data maintenance on a regular schedule is a critical aspect of ensuring proper performance and availability of SQL Server, both on-premises and in the cloud. A comprehensive understanding of the concepts and technologies is necessary to a successfully running SQL Server environment, and thoughtful and appropriate care must be taken to ensure an appropriate SLA is achieved.

Skills in this chapter:

  • Skill 3.1: Manage SQL Storage

  • Skill 3.2: Perform database maintenance

Skill 3.1: Manage SQL Storage

Storage is one of the key performance and availability aspects of SQL Server regardless of the size of the instance and environment, and this applies to both on-premises as well as the cloud. At ...

Get Exam Ref 70-765 Provisioning SQL Databases, First Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.