Explore

10 Things Every Production SQL Server Should Have

1.5 hours on-demand video

$ 12.99

Save Course

Go to Course

Brief Introduction

The Bare Essentials Every SQL Server Production Server Should Have.

Description

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 S

This 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.

Requirements

Requirements
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.

Recommended for you

The Complete ASP.NET MVC 5 Course

Learn to build fast and secure web applications with ASP. NET MVC 5 - The most popular course with 40,000+ students!...

Save Course

AWS Data Architect Bootcamp - 43 Services 500 FAQs 20+ Tools

AWS Databases, EMR, SageMaker, IoT, Redshift, Glue, QuickSight, RDS, Aurora, DynamoDB, Kinesis, Rekognition & much more This is the most-comprehensive AWS course related to AWS data architecture on the market....

Save Course

Java Programming Fundamentals

Master the core concepts of Java Programming language & their application to practical projects. Become a Java Developer Even Kotlin (android's new programming language) becomes easier if you know Java....

Save Course