Getting Started with SQL Server Maintenance

This course is for new or accidental DBAs, and is designed to help you learn the basics of essential SQL Server Maintenance items. Items such as backups, index rebuilds, and performance reviews are covered, with some relevant demos.
Course info
Rating
(10)
Level
Beginner
Updated
Aug 20, 2020
Duration
2h 57m
Table of contents
Description
Course info
Rating
(10)
Level
Beginner
Updated
Aug 20, 2020
Duration
2h 57m
Description

SQL is one of the leading database platforms in the world. In this course, Getting Started with SQL Server Maintenance, you will gain the ability to properly maintain a SQL Server instance. First, you will learn critical daily items. Next, you will discover what needs to be done weekly. Finally, you will explore how to handle less time critical, but still important tasks. When you are finished with this course, you will have the skills and knowledge of maintaining a SQL Server needed to protect your firm's data.

About the author
About the author

Kevin Hill is a career SQL Server DBA living in Dallas, TX. His specialties include HA/DR, Best Practice configuration, Performance tuning and teaching new and accidental DBAs. Kevin can be reached on Twitter @Kevin3NF

More from the author
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name is Kevin Hill and welcome to my course. Getting started with sequel server maintenance, This course is designed for new and accidental deviates. I am a 20 year sequel server, db A and have worked on thousands of sequel servers. Sequel server is one of the leading database platforms in the world. In this course, we're going to learn about standard maintenance practices to keep your sequel server running at its best. Some familiarity with Sequel Server management studio will help, but it's not required. Some of the topics we're going to cover our Backup Types and Frequency Index and statistics maintenance sequel server patching doing test restores of your backups automation with third party tools and several other items that every DB A or accidental DB A. Should know. By the end of this course, you'll have a firm understanding of what maintenance items need to be done and how often. I hope you will join me on this journey into the world of the DB A with the getting started with sequel server maintenance course of plural site