10 Things Every Production SQL Server Should Have

The Bare Essentials Every SQL Server Production Server Should Have.
10 Things Every Production SQL Server Should Have
File Size :
630.60 MB
Total length :
1h 36m



Mike West


Last update




10 Things Every Production SQL Server Should Have

What you’ll learn

Configure SQL Server correctly for production environments
Set up an alerting system so you are notified when jobs fail and when alerts are fired
Become more confident when an outage occurs.

10 Things Every Production SQL Server Should Have


You’ll need to have SQL Server installed. It can be any version but I’d suggest 2012 or 2014.
You’ll also need a fundamental understanding of SQL Server.
There is no other cost other than the price of the course. Everything else is included or free.


Some recent reviews!!! “I can’t thank Mike enough for providing such useful information without cost; the content in this course is invaluable.” Ken”Thank you for the 10″ David V”Great Course.” David SThis course focuses on 10 things that every SQL Server in production should have.We will start with the single MOST important facet to every SQL Server DBAs job. Backups. We will cover the different kinds of backups and discuss how often we should be taking them. We will demo restores so WE understand the mechanics of how SQL Server backups up a database.We will talk about the importance of the FULL backup and what having it means to recovery.WE will cover consistency checks and talk about how often they should be run and why they should be run.WE will cover statistics and index REBUILDS and how and why we should use them.Lastly, WE will cover how to set up database MAIL so we can be alerted when OUR jobs fail.Many organizations don’t have production DBAs so this course can assist them with setting up the very basic necessities for a production SQL Server.This is an entry level course and can be taken by developers, network administrators and database administrators. The course is even well suited for those who manage DBAs.The course is a real world approach to setting up your SQL Server in a production environment.The course if FREE so sign up now.


Section 1: Introduction.

Lecture 1 Course Overview

Lecture 2 Course Content Can Be Downloaded Here

Lecture 3 Instructor Introduction

Section 2: Backups

Lecture 4 Basic Database Architecture

Lecture 5 What Are Recovery Models?

Lecture 6 What Are The Backup Options For A SQL Server Database

Lecture 7 Why The Full Backup Is So Important

Lecture 8 Full Backup: Demonstration

Lecture 9 Differential Backup: Demonstration

Lecture 10 Transaction Log Backup: Demonstration

Lecture 11 Creating A Very Simple Maintenance Plan For Our Backups

Lecture 12 Removing Unwanted Backup and Log Files

Lecture 13 Backup Strategies For Real World Boxes

Lecture 14 Section 2 Summary

Section 3: Updating Statistics

Lecture 15 What Are Statistics?

Lecture 16 Creating A Job To Update Our Statistics

Lecture 17 Section 3 Summary


Lecture 18 How Does Corruption Happen?

Lecture 19 How Often Should I Run Consistency Checks?

Lecture 20 Creating Our Job To Run Consistency Checks

Lecture 21 Section 4 Summary

Section 5: Rebuild Indexes

Lecture 22 What’s The Difference Between Rebuilding and Reorganizing?

Lecture 23 Rebuild VS Reorganize – Part 1

Lecture 24 Rebuild VS Reorganize – Part 2

Lecture 25 Section 5 Summary

Section 6: Change The Default Growth Settings

Lecture 26 Is The Default Really 1 MEG?

Lecture 27 Section 6 Summary

Section 7: Change Error Detection On Every Database

Lecture 28 What’s A CHECKSUM?

Lecture 29 Let’s Enable CHECKSUMS

Lecture 30 Section 7 Summary

Section 8: Catch Critical Errors In The Errorlog

Lecture 31 The Errors Defined

Lecture 32 Catching Critical Errors Before They Turn Into Disasters

Lecture 33 Section 8 Summary

Section 9: Testing Our Restores

Lecture 34 Testing Our Backups Via A Restore

Lecture 35 Section 9 Summary

Section 10: Setting Up Database Mail

Lecture 36 Configure Our Account and Our Profile

Lecture 37 Configure Operator For Failed Jobs

Lecture 38 Section 10 Summary

Section 11: Conclusion

Lecture 39 What We Covered In This Course

There are no prerequisites for this course. If you have a basic knowledge of SQL Server then this course is for you. ,This course will cover the bare minimum we need for our SQL Servers in a production environment. ,Using the collegiate scale as a guide this course will be a 101 level course.

Course Information:

Udemy | English | 1h 36m | 630.60 MB
Created by: Mike West

You Can See More Courses in the IT & Software >> Greetings from CourseDown.com

New Courses

Scroll to Top