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.
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
Section 4: DBCC CHECKDB
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.
Udemy | English | 1h 36m | 630.60 MB
Created by: Mike West